KingCMS 常用 SQL 语句
本文来自KingCMS论坛,原出处
清理访问统计
delete from kinglog 删除系统日志
delete from kingbot 删除爬虫记录
delete from kingbrow 删除浏览器统计
delete from kingrefer 删除来路统计
delete from kingkey 删除关键字统计
delete from kingmonth 删除月统计
delete from kingday 删除日访问
变更文章存储状态
update kingsystem set systemnamed=0 不带日期目录
update kingsystem set systemnamed=1 带日期目录
批量设置文章访问权限
update kingart set artgrade=2 where menuid in (1,2,3) VIP
update kingart set artgrade=2 where menuid in (0) 开放任何人都可以访问
update kingart set artgrade=2 where menuid in (1,2) 只有会员才可以访问
文件名按ID生成(只是暂时性的修改)
update kingart set artpath=artid
执行SQL方法见附图
本文转载自『网络文摘精粹!』
http://www.2hand.cn/
更多精彩内容,欢迎访问网络文摘精粹!