|
|
置顶的原理是pw_threads表里面有topped字段，里面会纪录1，2，3 从pw_threads取出这些topped不为空的数据，插入到pw_posttopped表中，这就是置顶表 然后后台缓存管理里面更新置顶的缓存，会把pw_posttopped表的数据，写入到pw_forumdata表中，这样前台读数据时就会读缓存。 如果置顶有问题的站点，请执行下面这个程序，他会从pw_threads取出这些topped不为空的数据，插入到pw_posttopped表中(这项操作是后台没有的) 保存成repair_top.php，放在根目录下浏览器执行就可以了。 - <?php
- /**
- *
- * phpwind75 补丁修复程序 2009/12/08
- *
- */
- error_reporting(0);
- define('P_W',1);
- define('PW_UPLOAD',1);
- define('R_P',getdirname(__FILE__));
- define('D_P',R_P);
- require_once(R_P.'require/common.php');
- //require_once(R_P.'lang/up_function.php');
- include_once(D_P.'data/bbscache/config.php');
- require_once(R_P.'admin/cache.php');
- $basename = 'http://'.$_SERVER['HTTP_HOST'].(isset($_SERVER['PHP_SELF']) ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME']);
- @header("Content-Type:text/html; charset=$db_charset");
- include_once(D_P.'data/sql_config.php');
- //if ($database=='mysqli' && Pwloaddl('mysqli')===false) {
- $database = 'mysql';
- require_once Pcv(R_P."require/db_$database.php");
- $db = new DB($dbhost,$dbuser,$dbpw,$dbname,$PW,$charset,$pconnect);
- $action = $_GET['action'];
- if (empty($action)) {
- echo '<a href="repair_top.php?action=articletopped2">开始运行置顶修复工具 PHPWind v7.5SP3 (20091216)</a>';exit;
- } elseif ($action == 'articletopped2') {
- if(!$_GET['step']){
- $db->update("UPDATE pw_forums SET f_type='forum' WHERE type='category'");
- $db->query("ALTER TABLE `pw_forumdata` CHANGE `topthreads` `topthreads` VARCHAR( 500 ) NOT NULL");
- $db->query("ALTER TABLE `pw_poststopped` CHANGE `fid` `fid` MEDIUMINT( 5 ) NOT NULL");
- $db->query("truncate table `pw_poststopped`");
- }
- require (R_P.'require/updateforum.php');
- $per = 300;
- $step = $_GET['step'];
- !$step && $step = 1;
- $start = ($step - 1) * $per;
- $end = $start + $per - 1;
- $limit = "LIMIT $start,$end";
- $flag = false;
- $query = $db->query("SELECT tid,fid,toolfield,topped FROM pw_threads WHERE topped != 0 AND fid != 0 ORDER BY tid $limit");
- while ($rt = $db->fetch_array($query)) {
- $flag = true;
- $times++;
- list($t,$e) = explode(',',$rt['toolfield']);
- if($rt['topped']==3){
- $db->update("UPDATE pw_threads set specialsort=103 where tid=".$rt['tid']);
- }elseif($rt['topped']==2){
- $db->update("UPDATE pw_threads set specialsort=102 where tid=".$rt['tid']);
- }elseif($rt['topped']==1){
- $db->update("UPDATE pw_threads set specialsort=101 where tid=".$rt['tid']);
- }
- setForumsTopped($rt['tid'],$rt['fid'],$rt['topped'],$t);
- }
- if ($flag == true) {
- $step += 1;
- echo "<meta http-equiv='refresh' content='0;url=$basename?action=articletopped2&step=$step'>";
- }else{
- updatetop();
- echo '修复置顶结束，看看置顶有没出来';exit;
- }
- }
- echo '升级中,请稍候...';exit;
- function getdirname($path=null){
- if (!empty($path)) {
- if (strpos($path,'\\')!==false) {
- return substr($path,0,strrpos($path,'\\')).'/';
- } elseif (strpos($path,'/')!==false) {
- return substr($path,0,strrpos($path,'/')).'/';
- }
- }
- return './';
- }
- function createtable($array){
- global $db,$charset;
- foreach ($array as $key => $value) {
- !$value[1] && $value[1] = 'MyISAM';
- $value[0] = "CREATE TABLE IF NOT EXISTS $key ($value[0]) ";
- if ($db->server_info() > '4.1') {
- $value[0] .= "ENGINE=$value[1]".($charset ? " DEFAULT CHARSET=$charset" : '');
- } else {
- $value[0] .= "TYPE=$value[1]";
- }
- $db->query($value[0]);
- }
- }
- ?>
使用方法：  repair_top.zip (2 K) 下载次数:57 附件下载后，解压，上传到论坛的根目录，到浏览器页面上执行：http://您的论坛域名/repair_top.php（可以不用关闭论坛，反正执行下很快就好了。）
|
