[常用修复工具]勋章修复工具 for 8.7 [复制链接]

上一主题下一主题查看指定楼层

离线太史慈

荣誉会员

发帖: 766

金币: 626

威望: 556

只看楼主倒序阅读使用道具楼主发表于: 2012-04-05

勋章修复工具，保存成repair_medal.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');
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'];
$start = $_GET['start'];
!$start && $start = 0;
$percount = 1000;
if (empty($action)) {
echo '<a href="'.$basename.'?action=pw_medal_apply">开始运行修复medal工具</a>';exit;
} elseif ($action == 'pw_medal_apply') {
$query = $db->query("SELECT * FROM pw_medal_apply WHERE apply_id>$start ORDER BY apply_id LIMIT $percount");
while ($rt = $db->fetch_array($query)) {
//print_r($rt);exit;
ADD_S($rt);
$lastid = $rt['apply_id'];
$now = $db->get_value("SELECT medals FROM pw_members WHERE uid='".$rt['uid']."'");
if($now){
$medal_arr = explode(",",$now);
if(!in_array($rt['medal_id'],$medal_arr)){
$newmedal = $now.','.$rt['medal_id'];
$db->update("UPDATE pw_members SET medals ='".$newmedal."' WHERE uid='".$rt['uid']."'");
}
}else{
$db->update("UPDATE pw_members SET medals ='".$rt['medal_id']."' WHERE uid='".$rt['uid']."'");
}
}
$maxid = $db->get_value("SELECT max(apply_id) FROM pw_medal_apply");
if ($lastid < $maxid) {
echo "<meta http-equiv='refresh' content='1;url=$basename?action=pw_medal_apply&start=$lastid'>";
}else{
echo "<meta http-equiv='refresh' content='1;url=$basename?action=pw_medal_award'>";
}
} elseif ($action == 'pw_medal_award') {
$query = $db->query("SELECT * FROM pw_medal_award WHERE award_id>$start ORDER BY award_id LIMIT $percount");
while ($rt = $db->fetch_array($query)) {
ADD_S($rt);
$lastid = $rt['award_id'];
$now = $db->get_value("SELECT medals FROM pw_members WHERE uid='".$rt['uid']."'");
if($now){
$medal_arr = explode(",",$now);
if(!in_array($rt['medal_id'],$medal_arr)){
$newmedal = $now.','.$rt['medal_id'];
$db->update("UPDATE pw_members SET medals ='".$newmedal."' WHERE uid='".$rt['uid']."'");
}
}else{
$db->update("UPDATE pw_members SET medals ='".$rt['medal_id']."' WHERE uid='".$rt['uid']."'");
}
}
$maxid = $db->get_value("SELECT max(award_id) FROM pw_medal_award");
if ($lastid < $maxid) {
echo "<meta http-equiv='refresh' content='1;url=$basename?action=pw_medal_award&start=$lastid'>";
}else{
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]);
}
}
?>