事情是这样啊,我看到我的wordpress日志ID猛然飙升到1K3了,我靠,虽然我比较勤快的更新,但是这个ID比我还勤快啊,囧,通过查阅资料得知是自动保存在作怪,于是下载了这个“禁用WordPress自动保存的插件”,启用后同禁用了WP_POST_REVISIONS(我也不想做wiki啊)
def[......]
事情是这样啊,我看到我的wordpress日志ID猛然飙升到1K3了,我靠,虽然我比较勤快的更新,但是这个ID比我还勤快啊,囧,通过查阅资料得知是自动保存在作怪,于是下载了这个“禁用WordPress自动保存的插件”,启用后同禁用了WP_POST_REVISIONS(我也不想做wiki啊)
def[......]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
<?php //读取数据 include('./common.php'); $old_username = 'Jiay';//旧用户名 $new_username = 'JJAY';//新用户名 $_SGLOBAL['db']->query("UPDATE ".tname('member')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('thread')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('tagspace')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('space')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('session')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('post')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('poke')." SET fromusername='$new_username' WHERE fromusername='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('notification')." SET author='$new_username' WHERE author='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('friend')." SET fusername='$new_username' WHERE fusername='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('feed')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('doing')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('comment')." SET author='$new_username' WHERE author='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('blog')." SET username='$new_username' WHERE username='$old_username'"); $_SGLOBAL['db']->query("UPDATE ".tname('album')." SET username='$new_username' WHERE username='$old_username'"); ?> |
[......]