LEADBBS几条很有用的SQL语句

钉子
这句是删除所有阅读过的短消息:
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='维尼'

删除制定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='紫水晶')

历史评论

cndgm

删除指定用户发送的短消息:delete * from leadbbs_infobox where fromuser='用户名' 删除指定标题的短消息:delete * from leadbbs_infobox where title='短信息标题'删除指定用户发表的帖子和回复:delete * from leadbbs_announce where username='用户名'

评论为旧站历史记录，本站不再接受新评论。