PHP dbstuff::query方法代码示例

 public function update_user_credit($mobile, $credit)
 {
     //$mobile = '18782963909';
     //$credit = 1;
     $db = new dbstuff();
     $db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, 0);
     $sql = "SELECT `uid` FROM " . DZ_DBTABLEPRE . "common_member WHERE `username`={$mobile}";
     $result = $db->query($sql);
     if ($db->num_rows($result) == 0) {
         return false;
     } else {
         $row = $db->fetch_array($result);
         $uid = $row['uid'];
         $sql = "SELECT * FROM " . DZ_DBTABLEPRE . "common_member_count WHERE `uid`={$uid}";
         $result = $db->query($sql);
         if ($db->num_rows($result) == 0) {
             return false;
         } else {
             $row = $db->fetch_array($result);
             if ($row['extcredits2'] < $credit) {
                 return false;
             } else {
                 //print_r($row);$row['extcredits2'] = 376;
                 $new_credit = $row['extcredits2'] - $credit;
                 $sql = 'UPDATE ' . DZ_DBTABLEPRE . "common_member_count SET extcredits2='{$new_credit}' WHERE uid='{$uid}'";
                 $re = $db->query($sql);
                 if ($db->num_rows($re) == 0) {
                     return false;
                 } else {
                     return true;
                 }
             }
         }
     }
 }

function check_authority()
{
    require GAME_ROOT . './include/modules/core/sys/config/server.config.php';
    $_COOKIE = gstrfilter($_COOKIE);
    $cuser = $_COOKIE[$gtablepre . 'user'];
    $cpass = $_COOKIE[$gtablepre . 'pass'];
    require GAME_ROOT . './include/db_' . $database . '.class.php';
    $db = new dbstuff();
    $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
    unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
    $result = $db->query("SELECT * FROM {$gtablepre}users WHERE username='{$cuser}'");
    if (!$db->num_rows($result)) {
        echo "<span><font color=\"red\">Cookie无效，请登录。</font></span><br>";
        die;
    }
    $udata = $db->fetch_array($result);
    if ($udata['password'] != $cpass) {
        echo "<span><font color=\"red\">Cookie无效，请登录。</font></span><br>";
        die;
    } elseif ($udata['groupid'] < 9 && $cuser !== $gamefounder) {
        echo "<span><font color=\"red\">要求至少9权限。</font></span><br>";
        die;
    }
    unset($db);
    unset($cuser);
    unset($cpass);
    unset($udata);
    unset($result);
}

function getImCount()
{
    $db_uch = new dbstuff();
    $db_uch->charset = dbcharset;
    $db_uch->connect(dbhost, dbuser, dbpw, dbname, pconnect);
    $result = $db_uch->result($db_uch->query("SELECT COUNT(*) FROM " . tname("spacefield") . " WHERE qq <> ''"), 0);
    return $result;
}

 public function UcenterReg($data)
 {
     $db = new dbstuff();
     $db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, 0);
     $uid = uc_user_register($data['username'], $data['password'], $data['email']);
     if ($uid <= 0) {
         return $uid;
         /*	if($uid == -1) {
         				return '用户名不合法';
         			} elseif($uid == -2) {
         				return '包含要允许注册的词语';
         			} elseif($uid == -3) {
         				return '用户名已经存在';
         			} elseif($uid == -4) {
         				return 'Email 格式有误';
         			} elseif($uid == -5) {
         				return 'Email 不允许注册';
         			} elseif($uid == -6) {
         				return '该 Email 已经被注册';
         			} else {
         				return '未定义';
         			}*/
     } else {
         $username = $data['username'];
         $sql = "SELECT `username`,`password` FROM " . DZ_DBTABLEPRE . "common_member WHERE `uid`={$uid}";
         $result = $db->query($sql);
         if ($db->num_rows($result) == 0) {
             $sql = "SELECT `username`,`password` FROM " . UC_DBTABLEPRE . "members WHERE `uid`={$uid}";
             $result = $db->query($sql);
             $row = $db->fetch_array($result);
             //激活
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member set regdate='" . time() . "',uid='{$uid}',email='" . $data['email'] . "',username='" . $data['username'] . "',password='" . $row['password'] . "',timeoffset=9999";
             $db->query($sql);
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member_status set uid='{$uid}', regip='{$_SERVER['REMOTE_ADDR']}',lastip='{$_SERVER['REMOTE_ADDR']}',lastvisit=" . time() . ", lastactivity=" . time() . ',lastpost=0, lastsendmail=0';
             $db->query($sql);
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member_profile set uid='{$uid}'";
             $db->query($sql);
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member_field_forum set uid='{$uid}'";
             $db->query($sql);
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member_field_home set uid='{$uid}' ";
             $db->query($sql);
             $sql = "insert into " . DZ_DBTABLEPRE . "common_member_count set uid='{$uid}' ";
             $db->query($sql);
             $db->query('UPDATE ' . DZ_DBTABLEPRE . "common_setting SET svalue='{$data['username']}' WHERE skey='lastmember'");
             //exit;
         }
     }
     unset($db);
     return $uid;
 }

    $template = Template::getInstance();
    $template->setOptions($options);
}
//信息调用
//后台
$admin_login_temp = $_COOKIE["admin_login"];
$admin_exp = authcode($admin_login_temp, 'DECODE');
$admin_tem = explode("\t", $admin_exp);
$admin_login = $admin_tem['1'];
//前台
$authcookie = $_COOKIE["authcookie"];
$exp = authcode($authcookie, 'DECODE');
$tem = explode("\t", $exp);
if ($tem || $admin_tem) {
    $sql_us = "select * from et_users where mailadres='{$tem['1']}' && password='{$tem['0']}' && user_id='{$tem['2']}'";
    $query_us = $db->query($sql_us);
    $my = $db->fetch_array($query_us);
    $my['user_head'] = $my['user_head'] ? "{$webaddr}/attachments/head/" . $my['user_head'] : "{$webaddr}/images/noavatar.jpg";
    $tem1 = explode(" ", $my['home_city']);
    $my['home_sf'] = $tem1[0];
    $my['home_city'] = $tem1[1];
    $tem2 = explode(" ", $my['live_city']);
    $my['live_sf'] = $tem2[0];
    $my['live_city'] = $tem2[1];
    $tem3 = explode("-", $my['birthday']);
    $my['birth_year'] = $tem3[0];
    $my['birth_month'] = $tem3[1];
    $my['birth_day'] = $tem3[2];
    $tem4 = explode(" ", $my['msn']);
    if (count($tem4) == 2) {
        $my['msn'] = $tem4[0];

<?php

define('IN_DISCUZ', true);
include_once '../../config.inc.php';
require_once '../../include/global.func.php';
require_once '../../include/db_' . $database . '.class.php';
$uid = $_GET['uid'];
$buyer = $_GET['buyer'];
$price = $_GET['price'];
$amount = $_GET['amount'];
$orderid = $_GET['orderid'];
$submitdate = $_GET['submitdate'];
$db = new dbstuff();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
$db->select_db($dbname);
$settings = array();
$query = $db->query("SELECT * FROM {$tablepre}settings");
while ($setting = $db->fetch_array($query)) {
    $settings[$setting['variable']] = $setting['value'];
}
$settings['creditstrans'] = explode(',', $settings['creditstrans']);
$extcredits = $settings['creditstrans'][0];
updatecredits($uid, array($extcredits => $amount));
$timestamp = time();
$db->query("INSERT INTO {$tablepre}creditslog (uid, fromto, sendcredits, receivecredits, send, receive, dateline, operation)VALUES ({$uid}, '{$buyer}', 0, {$extcredits}, 0, {$amount}, {$timestamp}, 'AFD')");
$db->query("UPDATE {$tablepre}orders SET status = '2', confirmdate = {$timestamp} WHERE orderid = '{$orderid}'");

 runquery($extrasql);
 $sql = file_get_contents(ROOT_PATH . './install/data/install_data.sql');
 $sql = str_replace("\r\n", "\n", $sql);
 runquery($sql);
 $onlineip = $_SERVER['REMOTE_ADDR'];
 $timestamp = time();
 $backupdir = substr(md5($_SERVER['SERVER_ADDR'] . $_SERVER['HTTP_USER_AGENT'] . substr($timestamp, 0, 4)), 8, 6);
 $ret = false;
 if (is_dir(ROOT_PATH . 'data/backup')) {
     $ret = @rename(ROOT_PATH . 'data/backup', ROOT_PATH . 'data/backup_' . $backupdir);
 }
 if (!$ret) {
     @mkdir(ROOT_PATH . 'data/backup_' . $backupdir, 0777);
 }
 if (is_dir(ROOT_PATH . 'data/backup_' . $backupdir)) {
     $db->query("REPLACE INTO {$tablepre}common_setting (skey, svalue) VALUES ('backupdir', '{$backupdir}')");
 }
 $chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz';
 $siteuniqueid = 'DX' . $chars[date('y') % 60] . $chars[date('n')] . $chars[date('j')] . $chars[date('G')] . $chars[date('i')] . $chars[date('s')] . substr(md5($onlineip . $timestamp), 0, 4) . random(4);
 $db->query("REPLACE INTO {$tablepre}common_setting (skey, svalue) VALUES ('authkey', '{$authkey}')");
 $db->query("REPLACE INTO {$tablepre}common_setting (skey, svalue) VALUES ('siteuniqueid', '{$siteuniqueid}')");
 $db->query("REPLACE INTO {$tablepre}common_setting (skey, svalue) VALUES ('adminemail', '{$email}')");
 install_extra_setting();
 $db->query("REPLACE INTO {$tablepre}common_setting (skey, svalue) VALUES ('backupdir', '" . $backupdir . "')");
 $password = md5(random(10));
 $db->query("REPLACE INTO {$tablepre}common_member (uid, username, password, adminid, groupid, email, regdate) VALUES ('{$uid}', '{$username}', '{$password}', '1', '1', '{$email}', '" . time() . "');");
 $db->query("UPDATE {$tablepre}common_cron SET lastrun='0', nextrun='" . ($timestamp + 3600) . "'");
 install_data($username, $uid);
 if ($testdata) {
     install_testdata($username, $uid);
 }

$db = new dbstuff();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
$dbuser = $dbpw = $pconnect = $sdb = NULL;
$sid = daddslashes(($transsidstatus || CURSCRIPT == 'wap') && (isset($_GET['sid']) || isset($_POST['sid'])) ? isset($_GET['sid']) ? $_GET['sid'] : $_POST['sid'] : (isset($_DCOOKIE['sid']) ? $_DCOOKIE['sid'] : ''));
CURSCRIPT == 'attachment' && isset($_GET['sid']) && ($sid = addslashes(authcode($_GET['sid'], 'DECODE', $_DCACHE['settings']['authkey'])));
$discuz_auth_key = md5($_DCACHE['settings']['authkey'] . $_SERVER['HTTP_USER_AGENT']);
list($discuz_pw, $discuz_secques, $discuz_uid) = empty($_DCOOKIE['auth']) ? array('', '', 0) : daddslashes(explode("\t", authcode($_DCOOKIE['auth'], 'DECODE')), 1);
$prompt = $sessionexists = $seccode = 0;
$membertablefields = 'm.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques,
	m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts,
	m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5,
	m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
	m.lastvisit, m.lastactivity, m.lastpost, m.prompt, m.accessmasks, m.editormode, m.customshow, m.customaddfeed';
if ($sid) {
    if ($discuz_uid) {
        $query = $db->query("SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, {$membertablefields}\r\n\t\t\tFROM {$tablepre}sessions s, {$tablepre}members m\r\n\t\t\tWHERE m.uid=s.uid AND s.sid='{$sid}' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='{$onlineip}' AND m.uid='{$discuz_uid}'\r\n\t\t\tAND m.password='{$discuz_pw}' AND m.secques='{$discuz_secques}'");
    } else {
        $query = $db->query("SELECT sid, uid AS sessionuid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode\r\n\t\t\tFROM {$tablepre}sessions WHERE sid='{$sid}' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='{$onlineip}'");
    }
    if ($_DSESSION = $db->fetch_array($query)) {
        $sessionexists = 1;
        if (!empty($_DSESSION['sessionuid'])) {
            $_DSESSION = array_merge($_DSESSION, $db->fetch_first("SELECT {$membertablefields}\r\n\t\t\t\tFROM {$tablepre}members m WHERE uid='{$_DSESSION['sessionuid']}'"));
        }
    } else {
        if ($_DSESSION = $db->fetch_first("SELECT sid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode\r\n\t\t\tFROM {$tablepre}sessions WHERE sid='{$sid}' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='{$onlineip}'")) {
            clearcookies();
            $sessionexists = 1;
        }
    }
}

    if (empty($dbcharset)) {
        $dbcharset = in_array(strtolower($charset), array('gbk', 'big5', 'utf-8')) ? str_replace('-', '', $charset) : '';
    }
    $db->connect($dbhost, $dbuser, $dbpw, $dbname, $dbcharset, $pconnect, $tablepre);
} elseif ($apptype == 'ecshop') {
    //note ecshop
    define('BACKUP_DIR', ROOT_PATH . 'data/backup/');
    //note 數據庫備份文件放置路徑
    $tablepre = $prefix;
    //note 表前綴賦值，不同的產品請修改此表達式
    $dbcharset = 'utf8';
    $db->connect($db_host, $db_user, $db_pass, $db_name, $dbcharset, 0, $tablepre);
}
if ($get['method'] == 'export') {
    //note 導出備份
    $db->query('SET SQL_QUOTE_SHOW_CREATE=0', 'SILENT');
    $time = date("Y-m-d H:i:s", $timestamp);
    $tables = array();
    $tables = arraykeys2(fetchtablelist($tablepre), 'Name');
    if ($apptype == 'discuz') {
        //note discuz的備份需要備份插件表關聯的數據
        $query = $db->query("SELECT datatables FROM {$tablepre}plugins WHERE datatables<>''");
        while ($plugin = $db->fetch_array($query)) {
            foreach (explode(',', $plugin['datatables']) as $table) {
                if ($table = trim($table)) {
                    $tables[] = $table;
                }
            }
        }
    }
    $get['volume'] = isset($get['volume']) ? intval($get['volume']) : 0;

$db = new dbstuff();
$db->connect($server, $db_username, $db_password, $db_name, $pconnect, true);
@mysql_query("set names utf8");
include 'include/global.func.php';
//if(preg_match('/(mozilla|m3gate|winwap|openwave|Opera)/i', $_SERVER['HTTP_USER_AGENT']) && !preg_match('/(SymbianOS)/i', $_SERVER['HTTP_USER_AGENT'])) {
//	header("Location: ../index.php");
//}
$op = $_GET['op'] ? $_GET['op'] : "index";
$addtime = time();
$action = $_POST['action'];
$act = $_GET['act'];
$page = $_GET['page'] ? $_GET['page'] : 1;
//login
$ulmtem = explode("\t", authcode($_COOKIE["wapcookie"], 'DECODE'));
if ($ulmtem) {
    $query = $db->query("SELECT user_id,user_name,nickname,user_head FROM et_users where user_id='{$ulmtem['0']}' && password='{$ulmtem['1']}'");
    $user = $db->fetch_array($query);
    $user['user_head'] = $user['user_head'] ? "{$webaddr}/attachments/head/" . $user['user_head'] : "{$webaddr}/images/noavatar.jpg";
}
if (!$user['user_id']) {
    $head = "EasyTalk微博客 随时随地";
} else {
    $head = "欢迎您，" . $user['nickname'];
}
if (!$user['user_id'] && $op == "index") {
    $op = "login";
}
include 'include/' . $op . '.inc.php';
if ($user['user_id'] && $op != "logout") {
    echo "<div class=\"bottomline\">" . "<a href='index.php?op=index'>首页</a> | " . "<a href='index.php?op=home'>空间</a> | " . "<a href='index.php?op=atreplies'>@我</a> | " . "<a href='index.php?op=myfriends'>动态</a> | " . "<a href='index.php?op=privatemsg'>私信</a><br/>" . "<a href='index.php?op=privacy'>隐私信息</a> | " . "<a href='index.php?op=friends'>关注</a> | " . "<a href='index.php?op=sendphoto'>发照片</a> | " . "<a href='index.php?op=login&act=logout'>退出</a></div>";
}

        $options = array('template_dir' => './templates', 'cache_dir' => './templates/cache', 'auto_update' => true, 'cache_lifetime' => 0);
    }
    $template = Template::getInstance();
    $template->setOptions($options);
}
//后台
$admin_login_temp = $_COOKIE["admin_login"];
$admin_exp = authcode($admin_login_temp, 'DECODE');
$admin_tem = explode("\t", $admin_exp);
$admin_login = $admin_tem['1'];
//前台
$authcookie = $_COOKIE["authcookie"];
$exp = authcode($authcookie, 'DECODE');
$tem = explode("\t", $exp);
if ($tem || $admin_tem) {
    $userquery = $db->query("SELECT * FROM et_users WHERE user_name='{$tem['1']}' && password='{$tem['0']}'");
    $my = $db->fetch_array($userquery);
    $my['user_head'] = $my['user_head'] ? "{$webaddr}/attachments/head/" . $my['user_head'] : "{$webaddr}/images/noavatar.jpg";
    $tem1 = explode(" ", $my['home_city']);
    $my['home_sf'] = $tem1[0];
    $my['home_city'] = $tem1[1];
    $tem2 = explode(" ", $my['live_city']);
    $my['live_sf'] = $tem2[0];
    $my['live_city'] = $tem2[1];
    $tem3 = explode("-", $my['birthday']);
    $my['birth_year'] = $tem3[0];
    $my['birth_month'] = $tem3[1];
    $my['birth_day'] = $tem3[2];
    $tem4 = explode(" ", $my['gtalk']);
    $my['gtalk'] = $tem4[0] ? $tem4[0] : "";
    $my['gtalkauthcode'] = $tem4[1];

require GAME_ROOT . '/include/global.func.php';
$magic_quotes_gpc = get_magic_quotes_gpc();
extract(gstrfilter($_COOKIE));
extract(gstrfilter($_POST));
unset($_GET);
$_FILES = gstrfilter($_FILES);
require GAME_ROOT . '/config.inc.php';
$errorinfo ? error_reporting(E_ALL) : error_reporting(0);
$now = time() + $moveut * 3600 + $moveutmin * 60;
list($sec, $min, $hour, $day, $month, $year, $wday) = explode(',', date("s,i,H,j,n,Y,w", $now));
//if($attackevasive) {
//	include_once GAME_ROOT.'./include/security.inc.php';
//}
require GAME_ROOT . '/include/db_' . $database . '.class.php';
$db = new dbstuff();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
//$db->select_db($dbname);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
//require GAME_ROOT.'./gamedata/system.php';
//require config('resources',$gamecfg);
//require config('gamecfg',$gamecfg);
echo 'a';
//include GAME_ROOT.'./gamedata/gameinfo.php';
echo $q . '<br>';
//echo $db->query($q);
$q = "UPDATE {$tablepre}users SET achievement='' WHERE uid>0";
echo $db->query($q);
$q = "ALTER TABLE {$tablepre}users ADD titles text NOT NULL default '' AFTER achievement";
//echo $db->query($q);
$q = "ALTER TABLE {$tablepre}users ADD title text NOT NULL default '' AFTER title";
//echo $db->query($q);

         save_uc_config_file($dbinfo, QCS_ROOT . './Conf/uc_config.inc.php');
         touch($lockfile);
         $db = new dbstuff();
         $db->connect($dbinfo['dbhost'], $dbinfo['dbuser'], $dbinfo['dbpw'], $dbinfo['dbname'], 0, true);
         @mysql_query("set names utf8");
         $tablepre = $dbinfo['tablepre'];
         $sql = file_get_contents(QCS_ROOT . './install/include/data.sql');
         $sql = str_replace("\r\n", "\n", $sql);
         show_header();
         show_install();
         runquery($sql);
         $auth_code = generate_key();
         $invitecode = uniqid() . rand(1000, 9999);
         $regtime = time();
         $pwd = md5(strrev(md5($admininfo['password'])) . base64_encode($admininfo['password']));
         $db->query("INSERT INTO {$tablepre}user (name,pwd,province,city,county,email,invitecode,invitecount,regtime) VALUES ('{$admininfo['username']}', '{$pwd}','{$admininfo['province']}','{$admininfo['city']}','{$admininfo['county']}','{$admininfo['email']}','{$invitecode}',5,'{$regtime}');");
         $db->query("UPDATE {$tablepre}setting SET value = '{$auth_code}' WHERE name = 'auth_key'");
         $db->query("UPDATE {$tablepre}setting SET value = '{$dbinfo['sitename']}' WHERE name = 'site_name'");
         curl_post('http://www.quoracms.com/qcs/index.php?m=Index&a=addsite', "from=" . $default_appurl . "&type=install");
         echo '<script type="text/javascript">$("#laststep").removeAttr("disabled");$("#laststep").val("安装完成");$("#laststep").bind("click",function(){window.location=\'index.php?method=ext_info\'});setTimeout(function(){window.location=\'index.php?method=ext_info\'}, 3000);</script>' . "\r\n";
         show_footer();
     } else {
         show_dbinit();
     }
 } elseif ($method == 'ext_info') {
     show_header();
     echo '</div><div class="main" ><ul style="line-height: 200%; margin-left: 30px;">';
     echo '<li><a href="../index.php">安装成功，点击进入</a><br>';
     echo '<script>setTimeout(function(){window.location=\'../index.php\'}, 2000);</script>浏览器2秒后会自动跳转页面，无需人工干预</li>';
     echo '</ul></div>';
     show_footer();

 }
 if (empty($remoteinfo['time']) || empty($memberfields['username']) || empty($memberfields['password']) || empty($memberfields['email'])) {
     exit('Lack of required parameters');
 } elseif ($timestamp - $remoteinfo['time'] > $_DCACHE['settings']['passport_expire']) {
     exit('Request expired');
 }
 $db = new dbstuff();
 $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
 unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
 if ($_DCACHE['settings']['passport_extcredits']) {
     $memberfields['extcredits' . $_DCACHE['settings']['passport_extcredits']] = $memberfields['credits'];
     $table_member_columns[] = 'extcredits' . $_DCACHE['settings']['passport_extcredits'];
 }
 $memberfields['regip'] = empty($memberfields['regip']) ? onlineip() : $memberfields['regip'];
 $memberfields['regdate'] = empty($memberfields['regdate']) ? $timestamp : $memberfields['regdate'];
 $query = $db->query("SELECT uid, secques FROM {$tablepre}members WHERE username='{$memberfields['username']}'");
 if ($member = $db->fetch_array($query)) {
     $sql = $comma = '';
     foreach ($table_member_columns as $field) {
         if (isset($memberfields[$field])) {
             $sql .= "{$comma}{$field}='{$memberfields[$field]}'";
             $comma = ', ';
         }
     }
     $db->query("UPDATE {$tablepre}members SET {$sql} WHERE uid='{$member['uid']}'");
     $sql = $comma = '';
     foreach ($table_memberfields_columns as $field) {
         if (isset($memberfields[$field])) {
             $sql .= "{$comma}{$field}='{$memberfields[$field]}'";
             $comma = ', ';
         }

<?php

header('Content-Type: text/html; charset=utf-8');
define('ET_ROOT', dirname(__FILE__));
define('IN_ET', TRUE);
error_reporting(7);
include ET_ROOT . "/include/db_mysql.class.php";
include ET_ROOT . '/config.inc.php';
$db = new dbstuff();
$db->connect($server, $db_username, $db_password, $db_name, $pconnect, true);
@mysql_query("set names utf8");
$query1 = $db->query("ALTER TABLE `et_settings` CHANGE `replace_word` `replace_word` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;");
$query2 = $db->query("ALTER TABLE `et_content` CHANGE `content_body` `content_body` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;");
$query3 = $db->query("Describe `et_content` `replyshow`");
$fetch1 = $db->fetch_array($query3);
if (!$fetch1['Field']) {
    $query4 = $db->query("ALTER TABLE `et_content` ADD COLUMN `replyshow` tinyint(1) NOT NULL DEFAULT '1';");
}
echo $query1 * $query2 * $query3 ? "升级完成，请删除此文件" : "升级出现问题，请重新运行";