Discuz! info: MySQL Query Error

Time: 2025-1-21 7:35pm
Script: /viewthread.php

SQL: REPLACE INTO [Table]caches (cachename, type, dateline, data) VALUES ('settings', '1', '1737459304', '$_DCACHE[\'settings\'] = array (
\'accessemail\' => \'\',
\'activitytype\' => \'朋友聚会
出外郊游
自驾出行
公益活动
线上活动\',
\'adminipaccess\' => \'\',
\'admode\' => \'1\',
\'archiverstatus\' => \'1\',
\'attachbanperiods\' => \'\',
\'attachdir\' => \'/home/ftp/z/zh90492921/wwwroot/./attachments\',
\'attachexpire\' => \'\',
\'attachimgpost\' => \'1\',
\'attachrefcheck\' => \'0\',
\'attachsave\' => \'3\',
\'attachurl\' => \'attachments\',
\'authkey\' => \'948126bM1MneihJE\',
\'authoronleft\' => \'1\',
\'avatarmethod\' => \'0\',
\'baidusitemap\' => \'1\',
\'baidusitemap_life\' => \'12\',
\'bannedmessages\' => \'1\',
\'bbclosed\' => \'0\',
\'bbname\' => \'神龙斗士之家——魔神英雄传专题论坛\',
\'bdaystatus\' => \'0\',
\'boardlicensed\' => \'0\',
\'cacheindexlife\' => \'900\',
\'cachethreaddir\' => \'forumdata/threadcaches\',
\'cachethreadlife\' => \'0\',
\'censoremail\' => \'\',
\'censoruser\' => \'*管理员*,*版主*,*论坛警察*,*游客*,*批发*\',
\'creditnotice\' => \'1\',
\'creditsformula\' => \'$member[\\\'oltime\\\']+$member[\\\'extcredits2\\\']+$member[\\\'posts\\\']\',
\'creditsformulaexp\' => \'<u>总积分</u>=<u>在线时间(小时)</u>+<u>体力</u>+<u>发帖数</u>\',
\'creditspolicy\' =>
array (
\'post\' =>
array (
1 => 4,
2 => 2,
),
\'reply\' =>
array (
1 => 2,
),
\'digest\' =>
array (
1 => 90,
2 => 15,
3 => 5,
4 => 1,
),
\'postattach\' =>
array (
),
\'getattach\' =>
array (
),
\'sendpm\' =>
array (
),
\'search\' =>
array (
2 => 3,
),
\'promotion_visit\' =>
array (
2 => 2,
),
\'promotion_register\' =>
array (
2 => 2,
),
\'tradefinished\' =>
array (
),
\'votepoll\' =>
array (
2 => 1,
),
\'lowerlimit\' =>
array (
),
),
\'creditstax\' => \'0.05\',
\'creditstrans\' => \'1\',
\'dateconvert\' => \'1\',
\'dateformat\' => \'Y-n-j\',
\'debug\' => \'1\',
\'delayviewcount\' => \'0\',
\'deletereason\' => \'\',
\'disallowfloat\' => \'newthread|reply\',
\'doublee\' => \'1\',
\'dupkarmarate\' => \'0\',
\'dzfeed_limit\' =>
array (
\'thread_replies\' =>
array (
0 => \'100\',
1 => \'1000\',
2 => \'2000\',
3 => \'10000\',
),
\'thread_views\' =>
array (
0 => \'500\',
1 => \'5000\',
2 => \'10000\',
),
\'thread_rate\' =>
array (
0 => \'50\',
1 => \'200\',
2 => \'500\',
),
\'post_rate\' =>
array (
0 => \'20\',
1 => \'100\',
2 => \'300\',
),
\'user_usergroup\' =>
array (
0 => \'12\',
1 => \'13\',
2 => \'14\',
3 => \'15\',
),
\'user_credit\' =>
array (
0 => \'1000\',
1 => \'10000\',
2 => \'100000\',
),
\'user_threads\' =>
array (
0 => \'100\',
1 => \'500\',
2 => \'1000\',
3 => \'5000\',
4 => \'10000\',
),
\'user_posts\' =>
array (
0 => \'500\',
1 => \'1000\',
2 => \'5000\',
3 => \'10000\',
),
\'user_digest\' =>
array (
0 => \'50\',
1 => \'100\',
2 => \'500\',
3 => \'1000\',
),
),
\'ec_account\' => \'\',
\'ec_credit\' =>
array (
\'maxcreditspermonth\' => 6,
\'rank\' =>
array (
1 => 4,
2 => 11,
3 => 41,
4 => 91,
5 => 151,
6 => 251,
7 => 501,
8 => 1001,
9 => 2001,
10 => 5001,
11 => 10001,
12 => 20001,
13 => 50001,
14 => 100001,
15 => 200001,
),
),
\'ec_maxcredits\' => \'1000\',
\'ec_maxcreditspermonth\' => \'0\',
\'ec_mincredits\' => \'0\',
\'ec_ratio\' => \'0\',
\'ec_tenpay_bargainor\' => \'\',
\'ec_tenpay_key\' => \'\',
\'editedby\' => \'1\',
\'editoroptions\' => \'3\',
\'edittimelimit\' => \'\',
\'exchangemincredits\' => \'100\',
\'extcredits\' =>
array (
0 =>
array (
\'img\' => \'\',
),
),
\'fastpost\' => \'1\',
\'floodctrl\' => \'2\',
\'forumjump\' => \'0\',
\'forumlinkstatus\' => \'1\',
\'frameon\' => \'0\',
\'framewidth\' => \'180\',
\'ftp\' =>
array (
\'on\' => \'0\',
\'ssl\' => \'0\',
\'host\' => \'\',
\'port\' => \'21\',
\'username\' => \'\',
\'password\' => \'\',
\'pasv\' => \'0\',
\'attachdir\' => \'.\',
\'attachurl\' => \'\',
\'timeout\' => \'0\',
\'mirror\' => \'0\',
\'allowedexts\' => \'\',
\'disallowedexts\' => \'\',
\'minsize\' => \'\',
\'hideurl\' => \'0\',
\'connid\' => 0,
),
\'globalstick\' => \'1\',
\'google\' => \'1\',
\'gzipcompress\' => \'0\',
\'heatthread\' =>
array (
\'reply\' => 5,
\'recommend\' => 3,
\'iconlevels\' =>
array (
),
\'hottopic\' => \'50,100,200\',
),
\'hideprivate\' => \'1\',
\'historyposts\' => \'0 16824\',
\'hottopic\' => \'10\',
\'icp\' => \'\',
\'imagelib\' => \'0\',
\'indexhot\' =>
array (
\'status\' => \'0\',
\'limit\' => \'10\',
\'days\' => \'7\',
\'expiration\' => \'900\',
\'messagecut\' => \'200\',
\'width\' => 100,
\'height\' => 70,
),
\'indexname\' => \'index.php\',
\'indextype\' => \'classics\',
\'infosidestatus\' =>
array (
\'allow\' => \'0\',
),
\'initcredits\' => \'0,100,0,0,0,0,0,0,0\',
\'ipaccess\' => \'\',
\'jscachelife\' => \'1800\',
\'jsdateformat\' => \'\',
\'jspath\' => \'forumdata/cache/\',
\'jsrefdomains\' => \'\',
\'jsstatus\' => \'0\',
\'karmaratelimit\' => \'0\',
\'loadctrl\' => \'0\',
\'losslessdel\' => \'365\',
\'magicdiscount\' => \'85\',
\'magicmarket\' => \'1\',
\'magicstatus\' => \'1\',
\'mail\' => \'a:10:{s:8:\"mailsend\";s:1:\"1\";s:6:\"server\";s:13:\"smtp.21cn.com\";s:4:\"port\";s:2:\"25\";s:4:\"auth\";s:1:\"1\";s:4:\"from\";s:26:\"Discuz <username@21cn.com>\";s:13:\"auth_username\";s:17:\"username@21cn.com\";s:13:\"auth_password\";s:8:\"password\";s:13:\"maildelimiter\";s:1:\"0\";s:12:\"mailusername\";s:1:\"1\";s:15:\"sendmail_silent\";s:1:\"1\";}\',
\'maxavatarpixel\' => \'120\',
\'maxavatarsize\' => \'20000\',
\'maxbdays\' => \'0\',
\'maxchargespan\' => \'0\',
\'maxfavorites\' => \'100\',
\'maxincperthread\' => \'0\',
\'maxmagicprice\' => \'50\',
\'maxmodworksmonths\' => \'3\',
\'maxonlinelist\' => \'0\',
\'maxpolloptions\' => \'20\',
\'maxpostsize\' => \'50000\',
\'maxsearchresults\' => \'500\',
\'maxsigrows\' => \'500\',
\'maxsmilies\' => \'10\',
\'maxspm\' => \'0\',
\'membermaxpages\' => \'100\',
\'memberperpage\' => \'25\',
\'memliststatus\' => \'0\',
\'minpostsize\' => \'0\',
\'moddisplay\' => \'flat\',
\'modratelimit\' => \'1\',
\'modworkstatus\' => \'1\',
\'msgforward\' => \'a:3:{s:11:\"refreshtime\";i:3;s:5:\"quick\";i:1;s:8:\"messages\";a:13:{i:0;s:19:\"thread_poll_succeed\";i:1;s:19:\"thread_rate_succeed\";i:2;s:23:\"usergroups_join_succeed\";i:3;s:23:\"usergroups_exit_succeed\";i:4;s:25:\"usergroups_update_succeed\";i:5;s:20:\"buddy_update_succeed\";i:6;s:17:\"post_edit_succeed\";i:7;s:18:\"post_reply_succeed\";i:8;s:24:\"post_edit_delete_succeed\";i:9;s:22:\"post_newthread_succeed\";i:10;s:13:\"admin_succeed\";i:11;s:17:\"pm_delete_succeed\";i:12;s:15:\"search_redirect\";}}\',
\'msn\' =>
array (
\'on\' => 0,
\'domain\' => \'discuz.org\',
),
\'newbiespan\' => \'0\',
\'newbietasks\' =>
array (
),
\'newbietaskupdate\' => \'\',
\'nocacheheaders\' => \'0\',
\'oltimespan\' => \'10\',
\'onlinehold\' => 900,
\'onlinerecord\' => \'3060 1737437132\',
\'outextcredits\' =>
array (
\'|\' =>
array (
\'title\' => NULL,
\'unit\' => NULL,
\'ratiosrc\' =>
array (
\'\' => NULL,
),
\'ratiodesc\' =>
array (
\'\' => NULL,
),
\'creditsrc\' =>
array (
\'\' => NULL,
),
),
),
\'postbanperiods\' => \'\',
\'postmodperiods\' => \'\',
\'postperpage\' => \'10\',
\'pvfrequence\' => \'60\',
\'pwdsafety\' => \'0\',
\'qihoo\' =>
array (
),
\'ratelogrecord\' => \'5\',
\'recommendthread\' =>
array (
\'allow\' => 0,
),
\'regctrl\' => \'0\',
\'regfloodctrl\' => \'0\',
\'reglinkname\' => \'注册\',
\'regname\' => \'register.php\',
\'regstatus\' => \'1\',
\'regverify\' => \'2\',
\'relatedtag\' => false,
\'reportpost\' => \'1\',
\'rewritecompatible\' => \'0\',
\'rewritestatus\' => \'0\',
\'rssstatus\' => \'1\',
\'rssttl\' => \'60\',
\'searchbanperiods\' => \'\',
\'searchctrl\' => \'30\',
\'seccodedata\' =>
array (
\'minposts\' => \'10\',
\'loginfailedcount\' => 0,
\'type\' => \'0\',
\'width\' => 150,
\'height\' => 60,
\'background\' => \'1\',
\'adulterate\' => \'1\',
\'ttf\' => \'0\',
\'angle\' => \'0\',
\'color\' => \'1\',
\'size\' => \'0\',
\'shadow\' => \'1\',
\'animator\' => \'0\',
),
\'seccodestatus\' => \'1\',
\'seclevel\' => \'1\',
\'secqaa\' =>
array (
\'status\' =>
array (
1 => \'1\',
2 => \'0\',
3 => \'0\',
),
),
\'seodescription\' => \'神龙斗士之家——中国最大的魔神英雄传专题论坛,为您提供最详尽的魔神动画、音乐、广播剧、游戏等下载,以及交流最详尽的魔神资料。这里是魔神迷的家。\',
\'seohead\' => \'\',
\'seokeywords\' => \'魔神英雄传|魔神英雄坛|神龙斗士|魔神英雄伝ワタル\',
\'seotitle\' => \'魔神英雄传|魔神英雄坛|神龙斗士|魔神英雄伝ワタル\',
\'showemail\' => \'\',
\'showimages\' => \'1\',
\'showsettings\' => \'7\',
\'sigviewcond\' => \'0\',
\'sitemessage\' =>
array (
\'time\' => 0,
\'register\' => \'\',
\'login\' => \'\',
\'newthread\' => \'\',
\'reply\' => \'\',
),
\'sitename\' => \'神龙QQ群暂停申请,请随时关注我们的微博\',
\'siteurl\' => \'http://www.slwataru.com/\',
\'smcols\' => \'8\',
\'smrows\' => \'5\',
\'smthumb\' => \'20\',
\'spacedata\' =>
array (
\'cachelife\' => \'900\',
\'limitmythreads\' => \'5\',
\'limitmyreplies\' => \'5\',
\'limitmyrewards\' => \'5\',
\'limitmytrades\' => \'5\',
\'limitmyvideos\' => \'0\',
\'limitmyblogs\' => \'8\',
\'limitmyfriends\' => \'0\',
\'limitmyfavforums\' => \'5\',
\'limitmyfavthreads\' => \'0\',
\'textlength\' => \'300\',
),
\'spacestatus\' => \'1\',
\'starthreshold\' => \'2\',
\'statcode\' => \'\',
\'statscachelife\' => \'180\',
\'statstatus\' => \'0\',
\'styleid\' => \'8\',
\'stylejump\' => \'1\',
\'subforumsindex\' => \'1\',
\'swfupload\' => \'1\',
\'tagstatus\' => \'1\',
\'taskon\' => \'0\',
\'threadmaxpages\' => \'1000\',
\'threadsticky\' =>
array (
0 => \'全局置顶\',
1 => \'分类置顶\',
2 => \'本版置顶\',
),
\'thumbheight\' => \'300\',
\'thumbquality\' => \'100\',
\'thumbstatus\' => \'0\',
\'thumbwidth\' => \'400\',
\'timeformat\' => \'H:i\',
\'timeoffset\' => \'8\',
\'topicperpage\' => \'20\',
\'tradetypes\' =>
array (
),
\'transfermincredits\' => \'1000\',
\'transsidstatus\' => \'0\',
\'uc\' => false,
\'ucactivation\' => \'1\',
\'upgradeurl\' => \'http://localhost/develop/dzhead/develop/upgrade.php\',
\'userdateformat\' =>
array (
0 => \'Y-n-j\',
1 => \'Y/n/j\',
2 => \'j-n-Y\',
3 => \'j/n/Y\',
),
\'userstatusby\' => \'1\',
\'viewthreadtags\' => \'10\',
\'visitbanperiods\' => \'\',
\'visitedforums\' => \'10\',
\'vtonlinestatus\' => \'1\',
\'wapcharset\' => \'2\',
\'wapdateformat\' => \'n/j\',
\'wapmps\' => \'500\',
\'wapppp\' => \'5\',
\'wapregister\' => \'1\',
\'wapstatus\' => \'1\',
\'waptpp\' => \'10\',
\'warningexpiration\' => \'3\',
\'warninglimit\' => \'3\',
\'watermarkminheight\' => \'0\',
\'watermarkminwidth\' => \'0\',
\'watermarkquality\' => \'80\',
\'watermarkstatus\' => \'0\',
\'watermarktext\' =>
array (
),
\'watermarktrans\' => \'65\',
\'watermarktype\' => \'0\',
\'welcomemsgtitle\' => \'亲爱的魔神粉丝,您好,感谢您的注册,请阅读以下内容。\',
\'whosonlinestatus\' => \'3\',
\'whosonline_contract\' => \'1\',
\'zoomstatus\' => \'1\',
\'ratelogon\' => \'0\',
\'forumseparator\' => \'1\',
\'allowattachurl\' => \'1\',
\'allowviewuserthread\' => \'\',
\'tasktypes\' => \'a:3:{s:9:\"promotion\";a:2:{s:4:\"name\";s:12:\"论坛推广任务\";s:7:\"version\";s:3:\"1.0\";}s:4:\"gift\";a:2:{s:4:\"name\";s:10:\"红包类任务\";s:7:\"version\";s:3:\"1.0\";}s:6:\"avatar\";a:2:{s:4:\"name\";s:10:\"头像类任务\";s:7:\"version\";s:3:\"1.0\";}}\',
\'founder_contact\' => \'a:3:{s:2:\"qq\";s:8:\"70347239\";s:3:\"msn\";s:0:\"\";s:5:\"email\";s:0:\"\";}\',
\'forumdomains\' => false,
\'binddomains\' =>
array (
),
\'my_siteid\' => \'25591486\',
\'my_sitekey\' => \'164a9ab717925d947c14db3a2a7ae35c\',
\'cloud_status\' => \'1\',
\'connectappid\' => \'310503461\',
\'connectappkey\' => \'bok3Sz0H28YzbDbq\',
\'connect\' => \'a:19:{s:5:\"allow\";i:0;s:4:\"feed\";s:5:\"Array\";s:1:\"t\";s:5:\"Array\";s:10:\"like_allow\";s:1:\"1\";s:7:\"like_qq\";s:0:\"\";s:10:\"turl_allow\";s:1:\"1\";s:7:\"turl_qq\";s:0:\"\";s:8:\"like_url\";s:0:\"\";s:17:\"register_birthday\";s:1:\"0\";s:15:\"register_gender\";s:1:\"0\";s:17:\"register_uinlimit\";s:1:\"0\";s:21:\"register_rewardcredit\";s:1:\"1\";s:18:\"register_addcredit\";s:0:\"\";s:16:\"register_groupid\";s:1:\"0\";s:18:\"register_regverify\";s:1:\"1\";s:15:\"register_invite\";s:1:\"1\";s:10:\"newbiespan\";s:0:\"\";s:9:\"turl_code\";s:0:\"\";s:13:\"mblog_app_key\";s:0:\"\";}\',
\'regconnect\' => \'1\',
\'cloud_apps\' => \'a:4:{s:7:\"connect\";a:2:{s:4:\"name\";s:7:\"connect\";s:6:\"status\";s:5:\"close\";}s:6:\"search\";a:2:{s:4:\"name\";s:6:\"search\";s:6:\"status\";s:6:\"normal\";}s:5:\"stats\";a:2:{s:4:\"name\";s:5:\"stats\";s:6:\"status\";s:6:\"normal\";}s:6:\"manyou\";a:2:{s:4:\"name\";s:6:\"manyou\";s:6:\"status\";s:6:\"normal\";}}\',
\'my_status\' => \'1\',
\'my_extcredit\' => \'1\',
\'my_feedpp\' => \'50\',
\'my_search_data\' => \'a:3:{s:6:\"domain\";s:0:\"\";s:6:\"status\";s:1:\"0\";s:16:\"showDiscuzSearch\";s:1:\"0\";}\',
\'version\' => \'7.2\',
\'totalmembers\' => \'887\',
\'lastmember\' => \'鬼鲛\',
\'cachethreadon\' => 1,
\'cronnextrun\' => \'1737475200\',
\'styles\' =>
array (
1 => \'默认风格\',
2 => \'uchome\',
3 => \'christmas\',
7 => \'夏\',
8 => \'秋色\',
12 => \'新年\',
19 => \'2009\',
),
\'stylejumpstatus\' => true,
\'globaladvs\' =>
array (
),
\'redirectadvs\' =>
array (
),
\'invitecredit\' => NULL,
\'creditnames\' => \'0||\',
\'creditstransextra\' =>
array (
1 => \'1\',
2 => \'2\',
3 => \'2\',
4 => \'1\',
5 => \'1\',
),
\'exchangestatus\' => false,
\'transferstatus\' => false,
\'imagemaxwidth\' => \'600\',
\'promptpmids\' =>
array (
0 => \'4\',
1 => \'5\',
2 => \'6\',
),
\'promptkeys\' =>
array (
1 => \'pm\',
2 => \'announcepm\',
4 => \'systempm\',
5 => \'friend\',
6 => \'threads\',
7 => \'mynotice\',
8 => \'myinvite\',
),
\'prompts\' =>
array (
\'pm\' =>
array (
\'name\' => \'私人消息\',
\'script\' => \'pm.php?filter=newpm\',
\'id\' => \'1\',
\'new\' => 0,
),
\'announcepm\' =>
array (
\'name\' => \'公共消息\',
\'script\' => \'pm.php?filter=announcepm\',
\'id\' => \'2\',
\'new\' => 0,
),
\'systempm\' =>
array (
\'name\' => \'系统消息\',
\'script\' => \'\',
\'id\' => \'4\',
\'new\' => 0,
),
\'friend\' =>
array (
\'name\' => \'好友消息\',
\'script\' => \'\',
\'id\' => \'5\',
\'new\' => 0,
),
\'threads\' =>
array (
\'name\' => \'帖子消息\',
\'script\' => \'\',
\'id\' => \'6\',
\'new\' => 0,
),
\'mynotice\' =>
array (
\'name\' => \'应用通知\',
\'script\' => \'userapp.php?script=notice\',
\'id\' => \'7\',
\'new\' => 0,
),
\'myinvite\' =>
array (
\'name\' => \'应用邀请\',
\'script\' => \'userapp.php?script=notice&action=invite\',
\'id\' => \'8\',
\'new\' => 0,
),
),
\'announcepm\' => \'0\',
\'specialicon\' =>
array (
),
\'threadplugins\' =>
array (
),
\'hookscript\' =>
array (
),
\'pluginlinks\' =>
array (
),
\'templatelangs\' =>
array (
),
\'pluginlangs\' =>
array (
),
\'plugins\' =>
array (
\'available\' =>
array (
0 => \'qqconnect\',
1 => \'search\',
2 => \'cloudstats\',
3 => \'manyou\',
),
\'include\' =>
array (
0 =>
array (
\'adminid\' => \'0\',
\'script\' => \'cloudstats/setting\',
),
),
),
\'tradeopen\' => 1,
\'hooks\' =>
array (
\'search_admin_forum_log\' => \'if ($operation == \\\'delete\\\' && $ajax) {
$fId = intval($_GET[\\\'fid\\\']);
// $total = intval($total);
$pp = intval($pp);
// $currow = intval($currow);
//$query = $db->query(\"SELECT tid, fid FROM {$tablepre}threads WHERE fid=\\\'$fId\\\' LIMIT $pp\");
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_forum($fId);

} else if($operation == \\\'merge\\\' ) {
if (submitcheck(\\\'mergesubmit\\\') && $source != $target) {
$db->query(\"REPLACE INTO {$tablepre}threadlogs (fid, otherid, action, dateline) VALUES (\\\'$source\\\', \\\'$target\\\', \\\'mergeforum\\\', \\\'$timestamp\\\')\");
}
}\',
\'search_admin_thread_log\' => \'$logtids = $_POST[\\\'tidarray\\\'];
if ($operation && $logtids) {
$operations = array(\\\'stick\\\', \\\'adddigest\\\', \\\'addstatus\\\', \\\'delete\\\', \\\'moveforum\\\', \\\'movetype\\\', \\\'movesort\\\', \\\'deleteattach\\\', \\\'forumstick\\\');
$operations = array(\\\'stick\\\' => \\\'sticky\\\',
\\\'adddigest\\\' => \\\'digest\\\',
\\\'moveforum\\\' => \\\'move\\\',
\\\'delete\\\' => \\\'delete\\\',
\\\'deleteattach\\\' => \\\'attachment\\\',
);
$logtoforum = 0;

if (array_key_exists($operation, $operations)) {
if ($operation == \\\'moveforum\\\') {
$logtoforum = $_POST[\\\'toforum\\\'];
}
$act = $operations[$operation];
$_logtids = implode(\",\", $logtids);
$query = $db->query(\"SELECT tid, fid, authorid FROM {$tablepre}threads WHERE tid IN($_logtids)\");
$logsql = \\\'\\\';
$_threads = array();
while($thread = $db->fetch_array($query)) {
$logsql .= \"(\\\'\" . $thread[\\\'tid\\\'] . \"\\\', \\\'\" . $thread[\\\'fid\\\'] . \"\\\', \\\'$logtoforum\\\', \\\'thread[authorid]\\\', \\\'$act\\\', \\\'$timestamp\\\'), \";
$_threads[$thread[tid]] = array(\\\'tid\\\' => $thread[\\\'tid\\\'],
\\\'fid\\\' => $thread[\\\'fid\\\'],
);
}

if ($operation == \\\'delete\\\') {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_threads($_threads);
} elseif ($logsql) {
$db->query(\"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \" . trim($logsql, \\\', \\\'));
}
}
}\',
\'search_cron_thread_log\' => \'if ($actionarray) {
$tIds = array();
foreach ($actionarray as $act => $ids) {
foreach($ids as $id) {
$tIds[$id] = $id;
}
}
$logsql = \"SELECT tid, fid, authorid FROM {$tablepre}threads WHERE tid IN (\" . join(\\\', \\\', $tIds) . \\\')\\\';
$query = $db->query($logsql);
$logsql = \"REPLACE INTO {$tablepre}threadlogs (tid, fid, uid, action, dateline) VALUES \";
while($thread = $db->fetch_array($query)) {
$logsql .= \\\'(\\\' . $thread[\\\'tid\\\'] . \\\', \\\' . $thread[\\\'fid\\\'] . \", \\\'$thread[authorid]\\\', \\\'cron\\\', \\\'$timestamp\\\'), \";
}
$db->query(trim($logsql, \\\', \\\'));
}\',
\'search_admin_member_log\' => \'if ($operation == \\\'ban\\\') {
if (submitcheck(\\\'bansubmit\\\')) {
if($adminid == 1) {
if ($uid || $username) {
$member = $db->fetch_first(\"SELECT m.*, mf.*, u.type AS grouptype, u.allowsigbbcode, u.allowsigimgcode FROM {$tablepre}members m
LEFT JOIN {$tablepre}memberfields mf ON mf.uid=m.uid
LEFT JOIN {$tablepre}usergroups u ON u.groupid=m.groupid
WHERE \".($uid ? \"m.uid=\\\'$uid\\\'\" : \"m.username=\\\'$username\\\'\"));
}
if ($member[\\\'uid\\\'] && isset($bannew)) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
$expiry = 0;
if ($banexpirynew) {
$expiry = time() + 86400 * $banexpirynew;
}
plugin_search_ban_user($member[\\\'uid\\\'], $expiry, $delpost, $bannew ? false : true);
}
}
}
} elseif ($operation == \\\'clean\\\') {
if (submitcheck(\\\'submit\\\', 1)) {
$uids = 0;
$extra = \\\'\\\';

if(empty($uidarray)) {
if (!$conditions) {
$conditions = 1;
}
$query = $db->query(\"SELECT uid, groupid, adminid FROM {$tablepre}members WHERE $conditions AND adminid<>1 AND groupid<>1\");
} else {
$uids = is_array($uidarray) ? \\\'\\\\\\\'\\\'.implode(\\\'\\\\\\\', \\\\\\\'\\\', $uidarray).\\\'\\\\\\\'\\\' : \\\'0\\\';
$query = $db->query(\"SELECT uid, groupid, adminid FROM {$tablepre}members WHERE uid IN($uids) AND adminid<>1 AND groupid<>1\");
}

$membernum = $db->num_rows($query);

$uids = $comma = \\\'\\\';
$uidsarr = array();
while($member = $db->fetch_array($query)) {
if($membernum < 2000 || !empty($uidarray)) {
$extra .= \\\'<input type=\"hidden\" name=\"uidarray[]\" value=\"\\\'.$member[\\\'uid\\\'].\\\'\" />\\\';
}
$uids .= $comma.$member[\\\'uid\\\'];
$comma = \\\',\\\';
$uidsarr[] = $member[\\\'uid\\\'];
}
if ($membernum && $uids && $confirmed) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
foreach($uidsarr as $uid) {
plugin_search_delete_user($uid, 0, $includepost);
}
}
}
} elseif ($operation == \\\'group\\\') {
if($uid || $username) {
$condition = !empty($uid) ? \"m.uid=\\\'$uid\\\'\" : \"m.username=\\\'$username\\\'\";
}
$member = $db->fetch_first(\"SELECT m.uid, m.username, m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.credits,
mf.groupterms, u.type AS grouptype, u.grouptitle, u.radminid
FROM {$tablepre}members m
LEFT JOIN {$tablepre}memberfields mf ON mf.uid=m.uid
LEFT JOIN {$tablepre}usergroups u ON u.groupid=m.groupid
WHERE $condition\");
if ($member) {
if(submitcheck(\\\'editsubmit\\\')) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
$expiry = 0;
if ($expirydatenew) {
$expiry = strtotime($expirydatenew);
}
if ($groupidnew == 4 || $groupidnew == 5) {
plugin_search_ban_user($member[\\\'uid\\\'], $expiry);
} elseif ($member[\\\'groupid\\\'] == 4 || $member[\\\'groupid\\\'] == 5) {
plugin_search_ban_user($member[\\\'uid\\\'], $expiry, false, true);
}
}
}
}\',
\'search_admin_recyclebin_log\' => \'if (!$operation) {
if(submitcheck(\\\'undelsubmit\\\')) {
if ($threadlist) {
$tids = implode(\\\',\\\', $threadlist);
$sql = \"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \";
$query = $db->query(\"SELECT fid, tid, authorid FROM {$tablepre}threads WHERE tid IN ($tids)\");
while($thread = $db->fetch_array($query)) {
$sql .= sprintf(\"(\\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'restore\\\', \\\'%d\\\'), \", $thread[\\\'tid\\\'], $thread[\\\'fid\\\'], 0, $thread[\\\'authorid\\\'], $timestamp);
}
$sql = trim($sql, \\\', \\\');
$db->query($sql, \\\'UNBUFFERED\\\');
}
}
} elseif ($operation == \\\'search\\\') {
if (submitcheck(\\\'rbsubmit\\\')) {

$moderation = array(\\\'delete\\\' => array(), \\\'undelete\\\' => array(), \\\'ignore\\\' => array());

if(is_array($mod)) {
foreach($mod as $tid => $action) {
$moderation[$action][] = intval($tid);
}
}

if ($moderation[\\\'undelete\\\']) {
$tids = implode(\\\',\\\', $moderation[\\\'undelete\\\']);
$sql = \"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \";
$query = $db->query(\"SELECT fid, tid, authorid FROM {$tablepre}threads WHERE tid IN ($tid)\");
while($thread = $db->fetch_array($query)) {
$sql .= sprintf(\"(\\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'restore\\\', \\\'%d\\\'), \", $thread[\\\'tid\\\'], $thread[\\\'fid\\\'], 0, $thread[\\\'authorid\\\'], $timestamp);
}
$sql = trim($sql, \\\', \\\');
$db->query($sql, \\\'UNBUFFERED\\\');
}
}
}\',
\'search_admin_moderate_log\' => \'if ($operation == \\\'threads\\\') {
if (submitcheck(\\\'modsubmit\\\')) {
$validates = $ignores = $recycles = $deletes = 0;
$validatedthreads = $pmlist = array();
$moderation = array(\\\'validate\\\' => array(), \\\'delete\\\' => array(), \\\'ignore\\\' => array());

if(is_array($mod)) {
foreach($mod as $tid => $act) {
$moderation[$act][] = intval($tid);
}
}
if($moderation[\\\'validate\\\']) {
$threads = array();
$validatetids = \\\'\\\\\\\'\\\'.implode(\\\'\\\\\\\',\\\\\\\'\\\', $moderation[\\\'validate\\\']).\\\'\\\\\\\'\\\';
$query = $db->query(\"SELECT fid, tid, authorid FROM {$tablepre}threads WHERE tid IN ($validatetids)\");
while($thread = $db->fetch_array($query)) {
$threads[] = array( \\\'fid\\\' => $thread[\\\'fid\\\'],
\\\'tid\\\' => $thread[\\\'tid\\\'],
\\\'authorid\\\' => $thread[\\\'authorid\\\'],
);
}
if ($threads) {
$sql = \"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \";
foreach ($threads as $thread) {
$sql .= sprintf(\"(\\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'validate\\\', \\\'%d\\\'), \", $thread[\\\'tid\\\'], $thread[\\\'fid\\\'], 0, $thread[\\\'authorid\\\'], $timestamp);
}
$sql = trim($sql, \\\', \\\');
$db->query($sql, \\\'UNBUFFERED\\\');
}
}
}
}

if ($operation == \\\'replies\\\') {
if (submitcheck(\\\'modsubmit\\\')) {

$moderation = array(\\\'validate\\\' => array(), \\\'delete\\\' => array(), \\\'ignore\\\' => array());
$pmlist = array();
$validates = $ignores = $deletes = 0;

if(is_array($mod)) {
foreach($mod as $pid => $act) {
$moderation[$act][] = intval($pid);
}
}
if($validatepids = implodeids($moderation[\\\'validate\\\'])) {
$forums = $threads = $lastpost = $attachments = $pidarray = $authoridarray = array();
$query = $db->query(\"SELECT pid, tid, fid, authorid
FROM {$tablepre}posts
WHERE pid IN ($validatepids) AND first=\\\'0\\\'\");

$posts = array();
while($post = $db->fetch_array($query)) {
$posts[] = $post;
}

if ($posts) {
$sql = \"REPLACE INTO {$tablepre}postlogs (pid, fid, tid, uid, action, dateline) VALUES \";
foreach ($posts as $post) {
$sql .= sprintf(\"(\\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'validate\\\', \\\'%d\\\'), \", $post[\\\'pid\\\'], $post[\\\'fid\\\'], $post[\\\'tid\\\'], $post[\\\'authorid\\\'], $timestamp);
}
$sql = trim($sql, \\\', \\\');
$db->query($sql, \\\'UNBUFFERED\\\');
}
}
}
}\',
\'search_admin_prune_log\' => \'if (submitcheck(\\\'prunesubmit\\\')) {

$_posts = $_posts = array();
$pids = authcode($pids, \\\'DECODE\\\');
$pidsadd = $pids ? \\\'pid IN (\\\'.$pids.\\\')\\\' : \\\'pid IN (\\\'.implodeids($pidarray).\\\')\\\';

$query = $db->query(\"SELECT fid, tid, pid, first, authorid FROM {$tablepre}posts WHERE $pidsadd\");
while($post = $db->fetch_array($query)) {
if($post[\\\'first\\\']) {
$_threads[$post[tid]] = array(\\\'tid\\\' => $post[\\\'tid\\\'],
\\\'fid\\\' => $post[\\\'fid\\\'],
);
} else {
$_posts[$post[\\\'pid\\\']] = array(\\\'pid\\\' => $post[\\\'pid\\\'],
\\\'fid\\\' => $post[\\\'fid\\\'],
\\\'tid\\\' => $post[\\\'tid\\\'],
);
}
}
if ($_posts) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_posts($_posts);
}
if ($_threads) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_threads($_threads);
}
}\',
\'search_modcp_thread_log\' => \'if($op == \\\'posts\\\') {
$error = 0;
if($do == \\\'delete\\\' && submitcheck(\\\'deletesubmit\\\')) {
if(!$allowmassprune) {
$error = 4;
return;
}

$tidsdelete = $pidsdelete = \\\'0\\\';
$prune = array();

if($pids = implodeids($delete)) {
$tidsdelete = $pidsdelete = \\\'0\\\';
$query = $db->query(\"SELECT fid, tid, pid, first, authorid FROM {$tablepre}posts WHERE pid IN ($pids) $fidadd\");
while($post = $db->fetch_array($query)) {
if($post[\\\'first\\\']) {
$_threads[$post[tid]] = array(\\\'tid\\\' => $post[\\\'tid\\\'],
\\\'fid\\\' => $post[\\\'fid\\\'],
);
} else {
$_posts[$post[\\\'pid\\\']] = array(\\\'pid\\\' => $post[\\\'pid\\\'],
\\\'fid\\\' => $post[\\\'fid\\\'],
\\\'tid\\\' => $post[\\\'tid\\\'],
);
}
}
if ($_posts) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_posts($_posts);
}
if ($_threads) {
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_delete_threads($_threads);
}
}
}
}\',
\'search_modcp_recyclebin_log\' => \'$op = !in_array($op , array(\\\'list\\\', \\\'delete\\\', \\\'search\\\', \\\'restore\\\')) ? \\\'list\\\' : $op;
if($fid && $forum[\\\'ismoderator\\\'] && $modforums[\\\'recyclebins\\\'][$fid]) {
$srchupdate = false;

if($adminid == 1 && $op == \\\'restore\\\' && submitcheck(\\\'dosubmit\\\')) {
if($ids = implodeids($moderate)) {
$query = $db->query(\"SELECT tid, authorid FROM {$tablepre}threads WHERE tid IN($ids) AND fid=\\\'$fid\\\' AND displayorder=\\\'-1\\\'\");
$sql = \"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \";
while ($tid = $db->fetch_array($query)) {
$sql .= sprintf(\"(\\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'%d\\\', \\\'restore\\\', \\\'%d\\\'), \", $tid[\\\'tid\\\'], $fid, 0, $tid[\\\'authorid\\\'], $timestamp);
}
$sql = trim($sql, \\\', \\\');
$db->query($sql, \\\'UNBUFFERED\\\');
}
}
}\',
\'search_modcp_moderate_log\' => \'$op = !in_array($op , array(\\\'replies\\\', \\\'threads\\\')) ? \\\'threads\\\' : $op;
$mod = !in_array($mod , array(\\\'delete\\\', \\\'ignore\\\', \\\'validate\\\')) ? \\\'ignore\\\' : $mod;

if(submitcheck(\\\'dosubmit\\\', 1) || submitcheck(\\\'modsubmit\\\')) {
$list = array();
if($moderate && is_array($moderate)) {
foreach($moderate as $val) {
if(is_numeric($val) && $val) {
$moderation[$mod][] = $val;
}
}
}
}

if ($op == \\\'replies\\\') {
if(submitcheck(\\\'modsubmit\\\')) {
if($_ids = implodeids($moderation[\\\'validate\\\'])) {
$query = $db->query(\"SELECT pid, tid, fid, authorid FROM {$tablepre}posts WHERE pid IN($_ids)\");
$logsql = \\\'\\\';
while($post = $db->fetch_array($query)) {
$logsql .= sprintf(\\\'(%d, %d, %d, %d, \"validate\", %d), \\\', $post[\\\'pid\\\'], $post[\\\'tid\\\'], $post[\\\'fid\\\'], $post[\\\'authorid\\\'], $timestamp);
}

if ($logsql) {
$db->query(\"REPLACE INTO {$tablepre}postlogs (pid, tid, fid, uid, action, dateline) VALUES \" . trim($logsql, \\\', \\\'));
}
}
}

} elseif ($op == \\\'threads\\\') {
if(submitcheck(\\\'modsubmit\\\')) {
if($_ids = implodeids($moderation[\\\'validate\\\'])) {
$query = $db->query(\"SELECT tid, fid, authorid FROM {$tablepre}threads WHERE tid IN($_ids)\");
$logsql = \\\'\\\';
while($thread = $db->fetch_array($query)) {
$logsql .= \"(\\\'\" . $thread[\\\'tid\\\'] . \"\\\', \\\'\" . $thread[\\\'fid\\\'] . \"\\\', \\\'\\\', \\\'\" . $thread[\\\'authorid\\\'] . \"\\\', \\\'validate\\\', \\\'$timestamp\\\'), \";
}

if ($logsql) {
$db->query(\"REPLACE INTO {$tablepre}threadlogs (tid, fid, otherid, uid, action, dateline) VALUES \" . trim($logsql, \\\', \\\'));
}
}
}
}\',
\'search_modcp_member_log\' => \'if($op == \\\'ban\\\' && $allowbanuser) {
$member = loadmember($uid, $username, $error);
$usernameenc = rawurlencode($member[\\\'username\\\']);

if($member && submitcheck(\\\'bansubmit\\\') && !$error) {
if($bannew == 4 || $bannew == 5) {
$_my_banexpirynew = !empty($banexpirynew) ? $timestamp + $banexpirynew * 86400 : 0;
$_my_banexpirynew = $_my_banexpirynew > $timestamp ? $_my_banexpirynew : 0;
$isrestore = false;
} elseif($member[\\\'groupid\\\'] == 4 || $member[\\\'groupid\\\'] == 5) {
$isrestore = true;
$_my_banexpirynew = 0;
}
include_once DISCUZ_ROOT . \\\'./plugins/search/common.php\\\';
plugin_search_ban_user($member[\\\'uid\\\'], $_my_banexpirynew, false, $isrestore);
}
}\',
),
\'navmns\' =>
array (
0 => \'index\',
1 => \'index\',
2 => \'search\',
),
\'subnavs\' =>
array (
),
\'navs\' =>
array (
1 =>
array (
\'nav\' => \'<li class=\"menu_1\"><a href=\"index.php\" hidefocus=\"true\" id=\"mn_index\">论坛</a></li>\',
\'level\' => \'0\',
),
2 =>
array (
\'nav\' => \'<li class=\"menu_2\"><a href=\"search.php\" hidefocus=\"true\" id=\"mn_search\">搜索</a></li>\',
\'level\' => \'0\',
),
3 =>
array (
\'nav\' => \'\',
\'level\' => \'0\',
),
5 =>
array (
\'nav\' => \'<li class=\"menu_5\"><a href=\"misc.php?action=nav\" hidefocus=\"true\" onclick=\"showWindow(\\\'nav\\\', this.href);return false;\">导航</a></li>\',
\'level\' => \'0\',
),
),
\'allowsynlogin\' => 0,
\'ucappopen\' =>
array (
),
\'ucapp\' =>
array (
),
\'uchomeurl\' => \'\',
\'homeshow\' => \'0\',
\'medalstatus\' => 0,
\'dlang\' =>
array (
\'nextpage\' => \'下一页\',
\'date\' =>
array (
0 => \'前\',
1 => \'天\',
2 => \'昨天\',
3 => \'前天\',
4 => \'小时\',
5 => \'半\',
6 => \'分钟\',
7 => \'秒\',
8 => \'刚才\',
),
),
);

')
Error: Table './zh90492921/[Table]caches' is marked as crashed and should be repaired
Errno.: 145

到 http://faq.comsenz.com 搜索此错误的解决方案