于查看IP出现错误[配图,求救]
怎么回事啊
我是2。2升级到2。5SP1的
升级一切正常的啊
错误是这一段更改引起的怎么办
12。再次打开topicadmin.php
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_threads WHERE tid='$tid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_threads WHERE tid='$tid' AND displayorder>='0'");
找到两处:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_threads WHERE tid IN($tids) ");
分别替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_threads WHERE tid IN($tids) AND displayorder>='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT fid, views, replies FROM $table_threads WHERE tid='$othertid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT fid, views, replies FROM $table_threads WHERE tid='$othertid' AND displayorder>='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT authorid ,aid FROM $table_posts WHERE tid IN ($tids)");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT authorid ,aid FROM $table_posts WHERE tid IN ($tids) AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT COUNT(*) FROM $table_posts WHERE tid='$tid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT COUNT(*) FROM $table_posts WHERE tid='$tid' AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT pid, authorid, aid FROM $table_posts WHERE tid='$tid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT pid, authorid, aid FROM $table_posts WHERE tid='$tid' AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT authorid,aid FROM $table_posts WHERE tid='$tid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT authorid,aid FROM $table_posts WHERE tid='$tid' AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT COUNT(*) FROM $table_posts WHERE tid='$tid'");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT COUNT(*) FROM $table_posts WHERE tid='$tid' AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, dateline FROM $table_posts WHERE tid='$tid' ORDER BY dateline DESC LIMIT 1");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, dateline FROM $table_posts WHERE tid='$tid' AND invisible='0' ORDER BY dateline DESC LIMIT 1");
找到:
CODE: [Copy to clipboard]
WHERE pid='$pid' AND tid='$tid'");
替换为:
CODE: [Copy to clipboard]
WHERE pid='$pid' AND tid='$tid' AND invisible='0'");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_posts WHERE tid='$tid' ORDER BY dateline");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT * FROM $table_posts WHERE tid='$tid' AND invisible='0' ORDER BY dateline");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, authorid, dateline FROM $table_posts WHERE tid='$tid' ORDER BY dateline ASC LIMIT 1");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, authorid, dateline FROM $table_posts WHERE tid='$tid' AND invisible='0' ORDER BY dateline ASC LIMIT 1");
找到:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, authorid, dateline FROM $table_posts WHERE tid='$newtid' ORDER BY dateline ASC LIMIT 1");
替换为:
CODE: [Copy to clipboard]
$query = $db->query("SELECT author, authorid, dateline FROM $table_posts WHERE tid='$newtid' AND invisible='0' ORDER BY dateline ASC LIMIT 1"); |