getMessage());
}
date_default_timezone_set("PRC");
$date = date("Y-m-d");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
$db->exec("set sql_mode = ''");
$db->exec("set names utf8");
$version = 0;
if($rs = $db->query("SELECT v FROM pay_config WHERE k='version'")){
$version = $rs->fetchColumn();
}
if($version<2036){
$sqls = file_get_contents('update2.sql');
$sqls=explode(';', $sqls);
$sqls[]="UPDATE `pre_config` SET `v` = '2036' where `k` = 'version'";
}elseif($version<2001){
$sqls = file_get_contents('update.sql');
$sqls=explode(';', $sqls);
$sqls[]="INSERT INTO `pay_config` VALUES ('syskey', '".random(32)."')";
$sqls[]="INSERT INTO `pay_config` VALUES ('build', '".$date."')";
$sqls[]="INSERT INTO `pay_config` VALUES ('cronkey', '".rand(111111,999999)."')";
$sqls[]="UPDATE `pay_config` SET `v` = '2001' where `k` = 'version'";
}else{
exit('你的网站已经升级到最新版本了');
}
$sqls[]="UPDATE `pre_cache` SET `v` = '' where `k` = 'config'";
$success=0;$error=0;$errorMsg=null;
foreach ($sqls as $value) {
$value=trim($value);
if(empty($value))continue;
$value = str_replace('pre_',$dbconfig['dbqz'].'_',$value);
if($db->exec($value)===false){
$error++;
$dberror=$db->errorInfo();
$errorMsg.=$dberror[2]."
";
}else{
$success++;
}
}
echo '成功执行SQL语句'.$success.'条！
';
if($errorMsg){
//echo ''.$errorMsg.'
';
}
echo '
点此返回首页';
?>