--勉励自己努力以钉子的“挤”劲和“钻”劲提升自己
 :: Blog List ::
LEADBBS几条很有用的SQL语句
钉子 发表于 2005-6-29 14:48:25
这句是删除所有阅读过的短消息:
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='紫水晶')
阅读全文 | 回复(1) | 引用通告 | 编辑
Re:LEADBBS几条很有用的SQL语句
cndgm发表评论于2006-4-4 13:27:23

删除指定用户发送的短消息:
delete * from leadbbs_infobox where fromuser='用户名'

删除指定标题的短消息:
delete * from leadbbs_infobox where title='短信息标题'

删除指定用户发表的帖子和回复:
delete * from leadbbs_announce where username='用户名'

个人主页 | 引用 | 返回 | 删除 | 回复

发表评论：

    昵称：
    密码： (游客无须输入密码)
    主页：
    标题：
Best view with 1024 x 768 pixel & IE 6.0.
About Me
Archives Categories
Replies List
My FriendLinks
Blog Info

Powered by Oblog.