这句是删除所有阅读过的短消息:
delete * from leadbbs_infobox where readflag=1

给所有发过帖的用户加积分:
update leadbbs_user set points=points+积分数 where announcenum>0

删除1个月以上未登陆的用户:
Delete From LeadBBS_User Where LastWriteTime < 20040429000000

删除制定用户的主题帖:
Delete From LeadBBS_Topic Where UserName='username'

删除制定ID帖子:
Delete From LeadBBS_Topic Where ID=

删除待激活用户：
Delete From LeadBBS_User Where UserLimit=1
Delete From LeadBBS_User Where UserLimit=129
Delete From LeadBBS_SpecialUser where Assort=6

给版主增加10点威望：
update LeadBBS_User set CachetValue=CachetValue+10 where ID in (select UserID from LeadBBS_SpecialUser where Assort=1)

给指定会员增加10点威望：
update LeadBBS_User set CachetValue=CachetValue+10 where ID in (select UserID from LeadBBS_SpecialUser where UserName='username')