Joekoe 4.0常用SQL语句

温柔幻刀

Joekoe 4.0常用SQL语句
1:批量修改自动分页
update db_article set a_prepage=0[不分页]
update db_article set a_prepage=1[手动分页]
update db_article set a_prepage=2[自动分页]
2:贴子标题加粗加色恢复为普通显示
update db_bbs_topic set t_bb=0
3:给指定用户加经验
update db_user set u_exp=u_exp+你要加的分数 where username in ('用户名1','用户名2','用户名3')
4:修改用户名
update db_user set username='旧会员名' where username='新会员名'
update db_bbs_topic set username='旧会员名' where username='新会员名'
update db_bbs_topic set t_re_username='旧会员名' where t_re_username='新会员名'
update db_bbs_data set username='旧会员名' where username='新会员名'
update db_bbs_event set username='旧会员名' where username='新会员名'
update db_bbs_event set e_username='旧会员名' where e_username='新会员名'
update db_user_mail set username='旧会员名' where username='新会员名'
update db_user_mail set m_username='旧会员名' where m_username='新会员名'
update db_sys_review set r_username='旧会员名' where r_username='新会员名'
update db_ask_user set u_nickname='旧会员名' where u_nickname='新会员名'
update db_ask_question set username='旧会员名' where username='新会员名'
update db_user_friend set username='旧会员名' where username='新会员名'
update db_user_friend set f_username='旧会员名' where f_username='新会员名'
5:批量修改下载软件所需的积分或者金币
金币:update db_down set sp_emoney=0
积分:update db_down set sp_integral=0
6:用户组所有发贴数低于100时，降为为另一个用户组
update db_user set u_groupid="新用户组别ID"，u_power="新用户组权限值" where u_bbs_counter<100 and u_groupid="原用户组别ID"
7:改变用户组别
update db_user set u_groupid="旧用户组别ID" where u_groupid="新用户组别ID"