'错误信息', 'message_return' => '返回', 'old_step' => '上一步', 'new_step' => '下一步', 'uc_appname' => '论坛', 'uc_appreg' => '注册', 'uc_appreg_succeed' => '到 UCenter 成功，', 'uc_continue' => '点击这里继续', 'uc_setup' => '如果没有安装过，点击这里安装 UCenter', 'uc_title_ucenter' => '请填写 UCenter 的相关信息', 'uc_url' => 'UCenter 的 URL', 'uc_ip' => 'UCenter 的 IP', 'uc_admin' => 'UCenter 的管理员帐号', 'uc_adminpw' => 'UCenter 的管理员密码', 'uc_title_app' => '相关信息', 'uc_app_name' => '的名称', 'uc_app_url' => '的 URL', 'uc_app_ip' => '的 IP', 'uc_app_ip_comment' => '当主机 DNS 有问题时需要设置，默认请保留为空', 'uc_connent_invalid1' => '连接服务器', 'uc_connent_invalid2' => ' 失败，请返回检查。', 'error_message' => '提示信息', 'error_return' => '返回', 'tagtemplates_subject' => '标题', 'tagtemplates_uid' => '用户 ID', 'tagtemplates_username' => '发帖者', 'tagtemplates_dateline' => '日期', 'tagtemplates_url' => '主题地址', ); $msglang = array( 'redirect_msg' => '浏览器会自动跳转页面，无需人工干预。除非当您的浏览器长时间没有自动跳转时，请点击这里', 'uc_url_empty' => '您没有填写 UCenter 的 URL，请返回填写。', 'uc_url_invalid' => 'UCenter 的 URL 格式不合法，正常的格式为： http://www.domain.com ，请返回检查。', 'uc_ip_invalid' => '无法连接 UCenter 所在的 Web 服务器，请填写 UCenter 服务器的IP，如果 UCenter 与论坛在同一台服务器，可以尝试填写：127.0.0.1。', 'uc_admin_invalid' => '登录 UCenter 的管理员帐号密码错误。', 'uc_data_invalid' => 'UCenter 获取数据失败，请返回检查 UCenter URL、管理员帐号、密码。 ', ); require DISCUZ_ROOT.'./include/db_mysql.class.php'; @include DISCUZ_ROOT.'./config.inc.php'; $version['old'] = 'Discuz! 7.1 正式版'; $version['new'] = 'Discuz! 7.2'; $version['newnumber'] = '7.2'; $lock_file = DISCUZ_ROOT.'./forumdata/upgrade13.lock'; if(!$dbhost || !$dbname || !$dbuser) { instmsg('论坛数据库的主机，数据库名，用户名为空。'); } $db = new dbstuff(); $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset); function get_charset($tablename) { global $db; $tablestruct = $db->fetch_first("show create table $tablename"); preg_match("/CHARSET=(\w+)/", $tablestruct['Create Table'], $m); return $m[1]; } if($db->version() > '4.1.0') { $tablethreadcharset = get_charset($tablepre.'threads'); $dbcharset = strtolower($dbcharset); $tablethreadcharset = strtolower($tablethreadcharset); if($dbcharset && $dbcharset != $tablethreadcharset) { instmsg("您的配置文件 (./config.inc.php) 中的字符集 ($dbcharset) 与表的字符集 ($tablethreadcharset) 不匹配。"); } } $upgrade1 = <<'.str_replace(DISCUZ_ROOT, '', $lock_file).'
之后再来刷新页面。'); } if($step == 1) { $msg = '

'; echo <<

本升级程序只能从 $version[old] 升级到 $version[new]

升级之前务必备份数据库资料，否则升级失败无法恢复

正确的升级方法为:

关闭原有论坛，上传 $version[new] 的全部文件和目录（除install目录和config.inc.php文件），覆盖服务器上的 $version[old]
上传升级程序到论坛目录中。
运行本程序，直到出现升级完成的提示
如果中途失败，请使用Discuz!工具箱（./utilities/tools.php）里面的数据恢复工具恢复备份，去除错误后重新运行本程序

$msg EOT; instfooter(); } elseif($step == 'check') { @touch(DISCUZ_ROOT.'./forumdata/install.lock'); @unlink(DISCUZ_ROOT.'./install/index.php'); // echo "

Discuz!程序版本检测

"; if(!defined('UC_CONNECT')) { instmsg('您的config.inc.php文件被覆盖，请恢复备份好的config.inc.php文件，之后再尝试升级。'); } include_once DISCUZ_ROOT.'./discuz_version.php'; if(!defined('DISCUZ_VERSION') || DISCUZ_VERSION != $version['newnumber']) { instmsg('您还没有上传(或者上传不完全)最新的'.$version['new'].'的程序文件，请先上传之后再尝试升级。'); } instmsg("Discuz!程序版本检测通过，自动执行下一步。", '?step=2'); } elseif($step == 2) { // echo "

新增数据表

"; dir_clear('./forumdata/cache'); dir_clear('./forumdata/templates'); runquery($upgrade1); instmsg("新增数据表处理完毕。", '?step=3'); instfooter(); } elseif($step == 3) { $start = isset($_GET['start']) ? intval($_GET['start']) : 0; //echo "

"; if(isset($upgradetable[$start]) && $upgradetable[$start][0]) { //echo "升级数据表 [ $start ] {$tablepre}{$upgradetable[$start][0]} {$upgradetable[$start][3]}:"; $successed = upgradetable($upgradetable[$start]); if($successed === TRUE) { $start ++; if(isset($upgradetable[$start]) && $upgradetable[$start][0]) { instmsg("升级数据表 [ $start ] {$tablepre}{$upgradetable[$start][0]} {$upgradetable[$start][3]}:OK", "?step=3&start=$start"); } } elseif($successed === FALSE) { instmsg("调整数据表结构失败：{$tablepre}{$upgradetable[$start][0]} {$upgradetable[$start][3]}"); } elseif($successed == 'TABLE NOT EXISTS') { instmsg("数据表：{$tablepre}{$upgradetable[$start][0]}不存在，升级无法继续，请确认您的论坛版本是否正确!"); } } instmsg("论坛数据表结构调整完毕。", "?step=4"); instfooter(); } elseif($step == 4) { // echo "

更新部分数据

"; runquery($upgrade3); $query = $db->query("SELECT value, variable FROM {$tablepre}settings WHERE variable IN('bbname', 'dateformat', 'timeoffset')"); while($row = $db->fetch_array($query)) { $settings[$row['variable']] = $row['value']; } $timestamp = time(); $data = array('title' => array( 'bbname' => $settings['bbname'], 'time' => gmdate($settings['dateformat'], $timestamp + $settings['timeoffset'] * 3600), 'version' => $version['new'], ) ); $template = array('title' => '{bbname} 于 {time} 升级到 {version}'); $db->query("INSERT INTO {$tablepre}feeds (type, fid, typeid, sortid, appid, uid, username, data, template, dateline) VALUES ('feed_announce', '0', '0', '0', '0', '0', '', '".addslashes(serialize($data))."', '".addslashes(serialize($template))."', '$timestamp')"); $edittimelimit = $db->result_first("SELECT value FROM {$tablepre}settings WHERE variable='edittimelimit'"); $db->query("UPDATE {$tablepre}usergroups SET edittimelimit='$edittimelimit'"); updatespecial(); instmsg("部分数据更新完毕。", "?step=5"); instfooter(); } elseif($step == 5) { if(getgpc('addfounder_contact','P')) { $email = strip_tags(getgpc('email', 'P')); $msn = strip_tags(getgpc('msn', 'P')); $qq = strip_tags(getgpc('qq', 'P')); if(!preg_match("/^[\d]+$/", $qq)) $qq = ''; if(strlen($email) < 6 || !preg_match("/^[\w\-\.]+@[\w\-\.]+(\.\w+)+$/", $email)) $email = ''; if(strlen($msn) < 6 || !preg_match("/^[\w\-\.]+@[\w\-\.]+(\.\w+)+$/", $msn)) $msn = ''; $contact = serialize(array('qq' => $qq, 'msn' => $msn, 'email' => $email)); $db->query("REPLACE {$tablepre}settings (variable, value) VALUES ('founder_contact', '$contact')"); instmsg("进入下一步。","?step=7"); } else { $contact = array(); $contact = unserialize($db->result_first("SELECT value FROM {$tablepre}settings WHERE variable='founder_contact'")); $founder_contact = str_replace(array("\n","\t"), array('
',' '), $founder_contact); echo <<

关于《康盛改善计划》的说明

为了不断改进产品质量，改善用户体验，$version[new]版内置了统计系统。
该统计系统有利于我们分析用户在论坛的操作习惯，进而帮助我们在未来的版本中对产品进行改进，设计出更符合用户需求的新功能。
该统计系统不会收集站点敏感信息，不收集用户资料，不存在安全风险，并且经过实际测试不会影响论坛的运行效率。
您安装使用本版本表示您同意加入《康盛改善计划》，Discuz!运营部门会通过对站点数据的分析为您提供运营指导建议，我们将提示您如何根据站点运行情况开启论坛功能，如何进行合理的功能配置，以及提供其他的一些运营经验等。
为了方便我们和您沟通运营策略，请您留下常用的网络联系方式。

填写联系方式

正确的联系方式有助于我们给你提供最新的信息和安全方面的报告

QQ：		请正确填写QQ号码
MSN：		MSN账号
E-mail：		邮箱地址
	跳过

EOD; } } else { $settings = array(); $query = $db->query("SELECT value, variable FROM {$tablepre}settings WHERE variable IN('statid', 'statkey', 'bbname')"); while($row = $db->fetch_array($query)) { $settings[$row['variable']] = $row['value']; } getstatinfo($settings['statid'], $settings['statkey']); dir_clear('./forumdata/cache'); dir_clear('./forumdata/templates'); dir_clear('./uc_client/data/cache'); @touch($lock_file); if(!@unlink('upgrade13.php')) { $msg = '

必删除本程序

'; } else { $msg = ''; } echo <<

恭喜您论坛数据升级成功

接下来请您：

使用管理员身份登录论坛，进入后台，更新缓存
进行论坛注册、登录、发贴等常规测试，看看运行是否正常

EOT; echo '

'; instfooter(); } function send_sql_to_uc($sql) { $url = UC_API.'/accept_sql.php?appid='.UC_APPID.'&uckey='.UC_KEY.'&sql='.urlencode($sql); return file_get_contents($url); } function insertconfig($s, $find, $replace) { if(preg_match($find, $s)) { $s = preg_replace($find, $replace, $s); } else { // 插入到最后一行 $s .= "\r\n".$replace; } return $s; } function instheader() { global $charset, $version; ?> Discuz! 升级向导

$msglang[redirect_msg]

"; $message .= ""; } elseif(strpos($message, $lang['return'])) { $message .= "

$lang[message_return]

"; } echo <<

{$lang[error_message]}

$message

EOD; instfooter(); exit; } function getgpc($k, $var='G') { switch($var) { case 'G': $var = &$_GET; break; case 'P': $var = &$_POST; break; case 'C': $var = &$_COOKIE; break; case 'R': $var = &$_REQUEST; break; } return isset($var[$k]) ? $var[$k] : NULL; } function dir_clear($dir) { if($directory = dir($dir)) { while($entry = $directory->read()) { $filename = $dir.'/'.$entry; if(is_file($filename)) { @unlink($filename); } } @touch($dir.'/index.htm'); $directory->close(); } } function createtable($sql, $dbcharset) { $type = strtoupper(preg_replace("/^\s*CREATE TABLE\s+.+\s+$.+?$.*(ENGINE|TYPE)\s*=\s*([a-z]+?).*$/isU", "\\2", $sql)); $type = in_array($type, array('MYISAM', 'HEAP')) ? $type : 'MYISAM'; return preg_replace("/^\s*(CREATE TABLE\s+.+\s+$.+?$).*$/isU", "\\1", $sql). (mysql_get_server_info() > '4.1' ? " ENGINE=$type DEFAULT CHARSET=$dbcharset" : " TYPE=$type"); } function runquery($query) { global $db, $tablepre, $dbcharset; $query = str_replace("\r", "\n", str_replace(' cdb_', ' '.$tablepre, $query)); $expquery = explode(";\n", $query); foreach($expquery as $sql) { $sql = trim($sql); if($sql == '' || $sql[0] == '#') continue; if(strtoupper(substr($sql, 0, 12)) == 'CREATE TABLE') { $db->query(createtable($sql, $dbcharset)); } else { $db->query($sql); } } } function upgradetable($updatesql) { global $db, $tablepre, $dbcharset; $successed = TRUE; if(is_array($updatesql) && !empty($updatesql[0])) { list($table, $action, $field, $sql) = $updatesql; if(empty($field) && !empty($sql)) { $query = "ALTER TABLE {$tablepre}{$table} "; if($action == 'INDEX') { $successed = $db->query("$query $sql", "SILENT"); } elseif ($action == 'UPDATE') { $successed = $db->query("UPDATE {$tablepre}{$table} SET $sql", 'SILENT'); } } elseif($tableinfo = loadtable($table)) { $fieldexist = isset($tableinfo[$field]) ? 1 : 0; $query = "ALTER TABLE {$tablepre}{$table} "; if($action == 'MODIFY') { $query .= $fieldexist ? "MODIFY $field $sql" : "ADD $field $sql"; $successed = $db->query($query, 'SILENT'); } elseif($action == 'CHANGE') { $field2 = trim(substr($sql, 0, strpos($sql, ' '))); $field2exist = isset($tableinfo[$field2]); if($fieldexist && ($field == $field2 || !$field2exist)) { $query .= "CHANGE $field $sql"; } elseif($fieldexist && $field2exist) { $db->query("ALTER TABLE {$tablepre}{$table} DROP $field2", 'SILENT'); $query .= "CHANGE $field $sql"; } elseif(!$fieldexist && $fieldexist2) { $db->query("ALTER TABLE {$tablepre}{$table} DROP $field2", 'SILENT'); $query .= "ADD $sql"; } elseif(!$fieldexist && !$field2exist) { $query .= "ADD $sql"; } $successed = $db->query($query); } elseif($action == 'ADD') { $query .= $fieldexist ? "CHANGE $field $field $sql" : "ADD $field $sql"; $successed = $db->query($query); } elseif($action == 'DROP') { if($fieldexist) { $successed = $db->query("$query DROP $field", "SILENT"); } $successed = TRUE; } } else { $successed = 'TABLE NOT EXISTS'; } } return $successed; } function loadtable($table, $force = 0) { global $db, $tablepre, $dbcharset; static $tables = array(); if(!isset($tables[$table]) || $force) { if($db->version() > '4.1') { $query = $db->query("SHOW FULL COLUMNS FROM {$tablepre}$table", 'SILENT'); } else { $query = $db->query("SHOW COLUMNS FROM {$tablepre}$table", 'SILENT'); } while($field = @$db->fetch_array($query)) { $tables[$table][$field['Field']] = $field; } } return $tables[$table]; } function daddslashes($string, $force = 0) { !defined('MAGIC_QUOTES_GPC') && define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc()); if(!MAGIC_QUOTES_GPC || $force) { if(is_array($string)) { foreach($string as $key => $val) { $string[$key] = daddslashes($val, $force); } } else { $string = addslashes($string); } } return $string; } function get_uc_root() { $uc_root = ''; $uc = parse_url(UC_API); if($uc['host'] == $_SERVER['HTTP_HOST']) { $php_self_len = strlen($_SERVER['PHP_SELF'] ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME']); $uc_root = substr(__FILE__, 0, -$php_self_len).$uc['path']; } return $uc_root; } function random($length, $numeric = 0) { PHP_VERSION < '4.2.0' && mt_srand((double)microtime() * 1000000); if($numeric) { $hash = sprintf('%0'.$length.'d', mt_rand(0, pow(10, $length) - 1)); } else { $hash = ''; $chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz'; $max = strlen($chars) - 1; for($i = 0; $i < $length; $i++) { $hash .= $chars[mt_rand(0, $max)]; } } return $hash; } function getstatinfo($siteid = 0, $key = '') { global $db, $tablepre, $dbcharset, $settings, $version; if($siteid && $key) { return; } else { $siteid = $key = ''; } $versionnumber = $version['newnumber']; $onlineip = ''; if(getenv('HTTP_CLIENT_IP') && strcasecmp(getenv('HTTP_CLIENT_IP'), 'unknown')) { $onlineip = getenv('HTTP_CLIENT_IP'); } elseif(getenv('HTTP_X_FORWARDED_FOR') && strcasecmp(getenv('HTTP_X_FORWARDED_FOR'), 'unknown')) { $onlineip = getenv('HTTP_X_FORWARDED_FOR'); } elseif(getenv('REMOTE_ADDR') && strcasecmp(getenv('REMOTE_ADDR'), 'unknown')) { $onlineip = getenv('REMOTE_ADDR'); } elseif(isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] && strcasecmp($_SERVER['REMOTE_ADDR'], 'unknown')) { $onlineip = $_SERVER['REMOTE_ADDR']; } $members = $db->result_first("SELECT COUNT(*) FROM {$tablepre}members"); $funcurl = 'http://stat.discuz.com/stat_ins.php'; $bbname = $settings['bbname']; $PHP_SELF = htmlspecialchars($_SERVER['PHP_SELF'] ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME']); $url = htmlspecialchars('http://'.$_SERVER['HTTP_HOST'].preg_replace("/\/+(api|archiver|wap)?\/*$/i", '', substr($PHP_SELF, 0, strrpos($PHP_SELF, '/')))); $posts = $db->result($db->query("SELECT count(*) FROM {$tablepre}posts"), 0); $domain = $_SERVER['HTTP_HOST']; $hash = $bbname.$url.$mark.$versionnumber.$posts; $threads = $db->result($db->query("SELECT count(*) FROM {$tablepre}threads"), 0); $hash = md5($hash.$members.$threads.$email.$siteid.md5($key).'install'); $q = "bbname=$bbname&url=$url&domain=$domain&mark=$mark&version=$versionnumber&posts=$posts&members=$members&threads=$threads&email=$email&siteid=$siteid&key=".md5($key)."&ip=$onlineip&time=".time()."&hash=$hash"; $q=rawurlencode(base64_encode($q)); $siteinfo = dfopen($funcurl."?action=install&q=$q"); if(empty($siteinfo)) { $siteinfo = dfopen($funcurl."?action=install&q=$q"); } if($siteinfo && preg_match("/^[a-zA-Z0-9_]+,[A-Z]+$/i", $siteinfo)) { $siteinfo = explode(',', $siteinfo); $db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('statid', '$siteinfo[0]')"); $db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('statkey', '$siteinfo[1]')"); } } function dfopen($url, $limit = 0, $post = '', $cookie = '', $bysocket = FALSE, $ip = '', $timeout = 15, $block = TRUE) { $return = ''; $matches = parse_url($url); $host = $matches['host']; $path = $matches['path'] ? $matches['path'].($matches['query'] ? '?'.$matches['query'] : '') : '/'; $port = !empty($matches['port']) ? $matches['port'] : 80; if($post) { $out = "POST $path HTTP/1.0\r\n"; $out .= "Accept: */*\r\n"; //$out .= "Referer: $boardurl\r\n"; $out .= "Accept-Language: zh-cn\r\n"; $out .= "Content-Type: application/x-www-form-urlencoded\r\n"; $out .= "User-Agent: $_SERVER[HTTP_USER_AGENT]\r\n"; $out .= "Host: $host\r\n"; $out .= 'Content-Length: '.strlen($post)."\r\n"; $out .= "Connection: Close\r\n"; $out .= "Cache-Control: no-cache\r\n"; $out .= "Cookie: $cookie\r\n\r\n"; $out .= $post; } else { $out = "GET $path HTTP/1.0\r\n"; $out .= "Accept: */*\r\n"; //$out .= "Referer: $boardurl\r\n"; $out .= "Accept-Language: zh-cn\r\n"; $out .= "User-Agent: $_SERVER[HTTP_USER_AGENT]\r\n"; $out .= "Host: $host\r\n"; $out .= "Connection: Close\r\n"; $out .= "Cookie: $cookie\r\n\r\n"; } $fp = @fsockopen(($ip ? $ip : $host), $port, $errno, $errstr, $timeout); if(!$fp) { return ''; } else { stream_set_blocking($fp, $block); stream_set_timeout($fp, $timeout); @fwrite($fp, $out); $status = stream_get_meta_data($fp); if(!$status['timed_out']) { while (!feof($fp)) { if(($header = @fgets($fp)) && ($header == "\r\n" || $header == "\n")) { break; } } $stop = false; while(!feof($fp) && !$stop) { $data = fread($fp, ($limit == 0 || $limit > 8192 ? 8192 : $limit)); $return .= $data; if($limit) { $limit -= strlen($data); $stop = $limit <= 0; } } } @fclose($fp); return $return; } } function updatespecial() { global $db, $tablepre, $dbcharset; $fieldtypes = array('number' => 'bigint(20)', 'text' => 'mediumtext', 'radio' => 'smallint(6)', 'checkbox' => 'mediumtext', 'textarea' => 'mediumtext', 'select' => 'smallint(6)', 'calendar' => 'mediumtext', 'email' => 'mediumtext', 'url' => 'mediumtext', 'image' => 'mediumtext'); $optionvalues = array(); $query = $db->query("SELECT v.*, p.identifier, p.type FROM {$tablepre}typevars v LEFT JOIN {$tablepre}typeoptions p ON p.optionid=v.optionid WHERE search='1' OR p.type IN('radio','select','number')"); $optionvalues = array(); while($row = $db->fetch_array($query)) { $optionvalues[$row['sortid']][$row['identifier']] = $row['type']; $optionids[$row['sortid']][$row['optionid']] = $row['identifier']; } foreach($optionvalues as $sortid => $options) { $keys = array('KEY tid (tid)', 'KEY fid (fid)'); $tablename = "{$tablepre}optionvalue{$sortid}"; $db->query("DROP TABLE IF EXISTS $tablename"); $sql = "CREATE TABLE $tablename (\n tid int(10) NOT NULL DEFAULT '0',\n fid int(10) NOT NULL DEFAULT '0',"; foreach($options as $fieldname => $type) { $unsigned = $default = ''; if(strstr($fieldtypes[$type], 'int')) { $unsigned = 'unsigned'; $default = 0; $keys[] = "KEY `$fieldname` (`$fieldname`)"; } $sql .= "\n`$fieldname` $fieldtypes[$type] $unsigned NOT NULL DEFAULT '$default',"; } if($keys) { $sql .= implode(",\n", $keys); } $sql .= "\n) TYPE=MyISAM;"; $sql = syntablestruct(trim($sql), $db->version() > '4.1', $dbcharset); $db->query($sql); $opids = array_keys($optionids[$sortid]); $query = $db->query("SELECT t.*, th.fid FROM {$tablepre}typeoptionvars t left join {$tablepre}threads th ON th.tid=t.tid WHERE t.sortid='$sortid' AND t.optionid IN ('".implode("','", $opids)."')"); $inserts = array(); while($row = $db->fetch_array($query)) { $opname = $optionids[$sortid][$row['optionid']]; if(empty($inserts[$row[tid]])) { $inserts[$row['tid']]['tid'] = $row['tid']; $inserts[$row['tid']]['fid'] = $row['fid']; } $inserts[$row['tid']][$opname] = addslashes($row['value']); } if($inserts) { foreach($inserts as $tid => $fieldval) { $ikeys = $ivals = array(); foreach($fieldval as $ikey => $ival) { $ikeys[] = $ikey; $ivals[] = $ival; } $db->query("INSERT INTO $tablename (`".implode("`,`", $ikeys)."`) VALUES ('".implode("','", $ivals)."')"); } } } } function syntablestruct($sql, $version, $dbcharset) { if(strpos(trim(substr($sql, 0, 18)), 'CREATE TABLE') === FALSE) { return $sql; } $sqlversion = strpos($sql, 'ENGINE=') === FALSE ? FALSE : TRUE; if($sqlversion === $version) { return $sqlversion && $dbcharset ? preg_replace(array('/ character set \w+/i', '/ collate \w+/i', "/DEFAULT CHARSET=\w+/is"), array('', '', "DEFAULT CHARSET=$dbcharset"), $sql) : $sql; } if($version) { return preg_replace(array('/TYPE=HEAP/i', '/TYPE=(\w+)/is'), array("ENGINE=MEMORY DEFAULT CHARSET=$dbcharset", "ENGINE=\\1 DEFAULT CHARSET=$dbcharset"), $sql); } else { return preg_replace(array('/character set \w+/i', '/collate \w+/i', '/ENGINE=MEMORY/i', '/\s*DEFAULT CHARSET=\w+/is', '/\s*COLLATE=\w+/is', '/ENGINE=(\w+)(.*)/is'), array('', '', 'ENGINE=HEAP', '', '', 'TYPE=\\1\\2'), $sql); } } ?>