function runquery($sql)
{
global $lang, $dbcharset, $tblprefix, $db;
$sql = str_replace("\r", "\n", str_replace(' {$tblprefix}', ' ' . $tblprefix, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
$ret[$num] = '';
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
$db->query(createtable($query, $dbcharset));
} else {
$db->query($query);
}
}
}
}
function runquery($sql)
{
global $dbcharset, $DBS;
$sql = str_replace("\r", "\n", $sql);
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
//echo '创建表 '.$name.' ... 成功<br />';
$DBS->query(createtable($query, $dbcharset));
} else {
$DBS->query($query);
}
}
}
}
function runquery($sql)
{
global $lvyi_db;
$sql = str_replace("\r", "\n", $sql);
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
$strtip = "";
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE\\s*([a-z0-9_]+)\\s*.*/is", "\\1", $query);
$res = $lvyi_db->runSql(createtable($query, 'utf8'));
$tablenum++;
} else {
$res = $lvyi_db->runSql($query);
}
}
}
return true;
}
function runquery($sql)
{
global $db_prefix, $DB, $tablenum;
$sql = str_replace("\r", "\n", str_replace(' sablog_', ' ' . $db_prefix, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
$ret[$num] = '';
foreach ($queries as $query) {
if ($query) {
$ret[$num] .= $query[0] == '#' ? '' : $query;
}
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
echo '创建表 ' . $name . ' ... <font color="#0000EE">成功</font><br />';
$DB->query(createtable($query));
$tablenum++;
} else {
$DB->query($query);
}
}
}
}
function runquery($sql)
{
global $_G;
$tablepre = $_G['config']['db'][1]['tablepre'];
$dbcharset = $_G['config']['db'][1]['dbcharset'];
$sql = str_replace(array(' dzz_', ' `dzz_', ' cdb_', ' `cdb_', ' pre_', ' `pre_'), array(' {tablepre}', ' `{tablepre}', ' {tablepre}', ' `{tablepre}', ' {tablepre}', ' `{tablepre}'), $sql);
$sql = str_replace("\r", "\n", str_replace(array(' {tablepre}', ' `{tablepre}'), array(' ' . $tablepre, ' `' . $tablepre), $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
DB::query(createtable($query, $dbcharset));
} else {
DB::query($query);
}
}
}
}
function runquery($sql)
{
global $dbcharset, $tbl, $db;
$tablepre = $tbl . 'bot_';
$sql = str_replace("\r", "\n", str_replace(' onez_', ' ' . $tablepre, $sql));
$ret = array();
$num = 0;
if ($dbcharset == 'utf8') {
@$db->query("set names {$dbcharset}");
}
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
$db->query(createtable($query));
} else {
if ($dbcharset == 'utf8') {
$query = iconv('gbk', $dbcharset, $query);
}
$db->query($query);
}
}
}
}
function runquery($sql, $showmessage = TRUE)
{
global $db;
$dbcharset = "utf8";
$sql = str_replace("\r", "\n", $sql);
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
@($ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query);
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE IF NOT EXISTS ([a-z0-9_]+) .*/is", "\\1", $query);
$showmessage && showjsmessage('建立数据表 ' . $name . ' ... 成功！');
$db->query(createtable($query, $dbcharset));
} else {
$db->query($query);
}
}
}
}
function runquery($query)
{
global $db;
$query = str_replace("\r", "\n", str_replace('ask_', DB_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, DB_CHARSET));
} else {
$db->query($sql);
}
}
}
/**
* [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved.
* The contents of this file are subject to the License; you may not use this file except in compliance with the License.
*
* @version $Revision: 2075 $
*/
function sql_run($sql, $default_table_prefix = 'pb_')
{
global $dbcharset, $tb_prefix;
$return = false;
if (mysql_get_server_info() > '4.1' && $dbcharset) {
$sql = preg_replace("/TYPE=(InnoDB|MyISAM)( DEFAULT CHARSET=[^; ]+)?/", "TYPE=\\1 DEFAULT CHARSET=" . $dbcharset, $sql);
}
if ($tb_prefix != $default_table_prefix) {
$sql = str_replace($tb_prefix, $default_table_prefix, $sql);
$sql = str_replace($default_table_prefix, $tb_prefix, $sql);
}
$sql = str_replace("\r", "\n", $sql);
$sql_content = array();
$intRunTimes = 0;
$arrQuery = explode(";\n", trim($sql));
unset($sql);
foreach ($arrQuery as $query) {
$sql_content[$intRunTimes] = '';
$tmpQuery = explode("\n", trim($query));
$tmpQuery = array_filter($tmpQuery);
foreach ($tmpQuery as $query) {
$str1 = substr($query, 0, 1);
if ($str1 != '#' && $str1 != '-') {
$sql_content[$intRunTimes] .= $query;
}
}
$intRunTimes++;
}
if (is_array($sql_content) && !empty($sql_content)) {
foreach ($sql_content as $sql) {
if (trim($sql) != '') {
if (substr($sql, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $sql);
$return = mysql_query(createtable(stripslashes(trim($sql)), $dbcharset));
} else {
$return = mysql_query(stripslashes(trim($sql)));
}
}
}
} else {
$return = mysql_query(stripslashes($sql_content));
}
return $return;
}
function runquery($sql, $tablepre, $db)
{
global $lang, $tablepre, $db;
require_once 'install_lang.php';
if (!isset($sql) || empty($sql)) {
return;
}
$orig_tablepre = "keke_";
$sql = str_replace("\r", "\n", str_replace(' ' . $orig_tablepre, ' ' . $tablepre, $sql));
$sql = str_replace("\r", "\n", str_replace(' `' . $orig_tablepre, ' `' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
$info = '';
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE \\`([a-z0-9_]+)\\` .*/is", "\\1", $query);
showjsmessage($lang['create_table'] . ' ' . $name . ' ... ' . $lang['succeed']);
$db->query(createtable($query));
} else {
$db->query($query);
}
$info .= $query . "\n";
}
}
return $info;
}
function runquery($sql)
{
global $db, $tablenum;
$sql = str_replace("\r", "\n", str_replace('#iCMS@__', DB_PREFIX, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
preg_match("|CREATE TABLE (.*) \\( |i", $query, $name);
flush();
echo '创建表 ' . $name[1] . ' ... <font color="#0000EE">成功</font><br />';
flush();
iCMS_DB::query(createtable($query, DB_CHARSET));
$tablenum++;
} else {
iCMS_DB::query($query);
}
}
}
}
$setting = !empty($setting) ? $setting : array();
$missingtable = !empty($missingtable) ? $missingtable : array();
$repairtable = is_array($repairtable) && !empty($repairtable) ? $repairtable : array();
if ($_POST['repairsubmit'] && (!empty($repair) || !empty($setting) || !empty($repairtable) || !empty($missingtable))) {
$error = '';
$errorcount = 0;
$alter = $fielddefault = array();
foreach ($missingtable as $value) {
if (!isset($installdata)) {
$fp = fopen($dbsql, "rb");
$installdata = fread($fp, filesize($dbsql));
$installdata = str_replace("\r", "\n", str_replace(' sablog_', ' ' . $db_prefix, $installdata));
fclose($fp);
}
preg_match("/CREATE TABLE " . $db_prefix . $value . "\\s+\\(.+?;/is", $installdata, $a);
$DB->query(createtable($a[0]));
}
foreach ($repair as $table => $valuedata) {
foreach ($valuedata as $value) {
echo print_r($value);
echo '<br>';
if (!in_array($r_table, $repairtable)) {
list($r_table, $r_field, $option) = explode('|', $value);
if (!isset($repairrtable[$r_table]) && ($fieldsquery = $DB->query("SHOW FIELDS FROM {$db_prefix}{$r_table}", 'SILENT'))) {
while ($fields = $DB->fetch_array($fieldsquery)) {
$fielddefault[$r_table][$fields['Field']] = $fields['Default'];
}
}
$field = $saxdb[$r_table][$r_field];
$altersql = '`' . $field['Field'] . '` ' . $field['Type'];
$altersql .= $field['Null'] == 'NO' ? ' NOT NULL' : '';
function runquery($sqlfile, $DB, $db_prefix, $tablenum = '0', $dbcharset)
{
$sqlfile = "install.sql";
$sql = getsql($sqlfile);
$sql = str_replace("\r", "\n", str_replace('yxb_', ' ' . $db_prefix, $sql));
//替换表前缀
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
//以";\n"分割sql
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' ? '' : $query;
//把#开头的行当作注释
}
$num++;
}
unset($sql);
//销毁变量
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 6) == 'CREATE') {
//语句前面12割字符是CREATE TABLE
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
//CREATE TABLE后面紧接着的a到z，0到9范围内字符组成的字符串第一次匹配当作表名
echo '<font color="#0f0dEE"></font>创建表 ' . $name . ' .................................................................................................................................................................... <font color="#0000EE">成功</font><br />';
$DB->query(createtable($query, $dbcharset));
//调用createtable函数
$tablenum++;
//表的数量增加
} else {
$DB->query($query);
//不是CREATE TABLE语句则调用query方法直接执行
}
}
}
}
function runquery($query) {
global $db;
$query = str_replace("\r", "\n", str_replace(' uc_', ' '.UC_DBTABLEPRE, $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, UC_DBCHARSET));
} elseif (strtoupper(substr($sql, 0, 11)) == 'ALTER TABLE') {
runquery_altertable($sql);
} else {
$db->query($sql);
}
}
}
$user = $response->getGraphUser();
*/
//echo 'Name: ' . $user['name'];
$time_pre = microtime(true);
//$request = $fb->get('/'.$requestedpageid.'?posts&limit=99','1615429865383287|nJkkwVhBA9Yf_uUXhw18GYYgSJU');
//$response = $request->execute();
//$graphObject = $request->getGraphObject();
//$graphArray=object_to_array( $graphObject);
//$meta=$graphObject->items['posts']->metaData['paging']['next'];
//print_r($graphArray);
$pageid = $requestedpageid;
//var_dump($graphObject);exit;
//echo '<table border=1>';
echo '<h1><a href="report.php?id=' . $pageid . '"> Click for reports</a></h1>';
if (!istable($pageid)) {
createtable($pageid);
} else {
die("local data loaded");
}
/*foreach($graphArray['posts'] as $post)
{$date_formal = new DateTime($post['created_time']['date']);
if(!isset($post['message'])){ $post['message']=''; $inclination=2;} else
$inclination=findsenti($post['message']);
$qr="INSERT INTO `$pageid` (`post_id`,`text`,`time`,`report`) VALUES (\"".$post['id']."\",\"".$post['message']."\",\"".$date_formal->gettimestamp()."\",$inclination)";
//echo $qr=mysqli_real_escape_string($mysqli,$qr);
//echo'<br>';
//exit;
mysqli_query($mysqli,$qr);
//echo '<tr><td>'.$post['id'].'</td><td>'.$post['message'].'</td><td>'.$inclination.'</td><td>'.$date_formal->gettimestamp().'</td></tr>';
}
//echo '</table>';
function runucquery($sql, $tablepre)
{
global $lang, $db;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace(' uc_', ' ' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
showjsmessage(lang('create_table') . ' ' . $name . ' ... ' . lang('succeed'));
$db->query(createtable($query));
} else {
$db->query($query);
}
}
}
}
function runquery($sql)
{
global $lang, $db, $multitable;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", $sql);
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
if (false !== strpos($query, '__tblname__')) {
if ($multitable > 0) {
$prefixs = array();
$prefixs = genPrefix();
foreach ($prefixs as $v) {
$name = "user_" . $v;
$new_sql = str_replace("__tblname__", $name, $query);
showjsmessage(lang('create_table') . ' ' . $name . ' ... ' . lang('succeed'));
$db->query("DROP TABLE IF EXISTS `{$name}`;");
$db->query(createtable($new_sql));
}
} else {
$name = "user";
$new_sql = str_replace("__tblname__", $name, $query);
showjsmessage(lang('create_table') . ' ' . $name . ' ... ' . lang('succeed'));
$db->query("DROP TABLE IF EXISTS `{$name}`;");
$db->query(createtable($new_sql));
}
} else {
$name = preg_replace("/CREATE TABLE IF NOT EXISTS ([`a-z0-9_]+) .*/is", "\\1", $query);
showjsmessage(lang('create_table') . ' ' . $name . ' ... ' . lang('succeed'));
$db->query(createtable($query));
}
} else {
$db->query($query);
}
}
}
}
} else {
$pmcount = $db->result_first("SELECT count(*) FROM " . UC_DBTABLEPRE . "pms");
echo '<b>UCenter 1.5 Short message data format conversion program</b><br />
> This procedure applies to upgrade to UCenter 1.5 short message after the data showed abnormal site.<br />
> The conversion process may be time-consuming and very long and very consuming system resources, the specific time and your short message and set the number of data entries.<br />
> If you sure you want to convert, we recommend that you turn off the station.<br />
> The conversion process will be the current short message data backup, ease of use.';
echo '<hr size=1>';
echo 'Current UCenter short message data entries: ' . $pmcount . '<br /><br /><a href="pmconvert.php?step=0">Click here to start conversion</a>';
}
} elseif ($step == 0) {
echo 'Preparation before being converted ...';
redirect('pmconvert.php?step=1');
} elseif ($step == 1) {
$db->query("DROP TABLE IF EXISTS " . UC_DBTABLEPRE . "pms_tmp");
$db->query(createtable("CREATE TABLE " . UC_DBTABLEPRE . "pms_tmp (\r\n\t\t pmid int(11) unsigned NOT NULL auto_increment,\r\n\t\t msgfrom varchar(255) NOT NULL default '',\r\n\t\t msgfromid int(11) unsigned NOT NULL default '0',\r\n\t\t msgtoid int(11) unsigned NOT NULL default '0',\r\n\t\t folder enum('inbox','outbox') NOT NULL default 'inbox',\r\n\t\t new tinyint(1) NOT NULL default '0',\r\n\t\t subject varchar(255) NOT NULL default '',\r\n\t\t dateline int(11) unsigned NOT NULL default '0',\r\n\t\t message text NOT NULL,\r\n\t\t delstatus tinyint(1) unsigned NOT NULL default '0',\r\n\t\t related int(11) unsigned NOT NULL default '0',\r\n\t\t fromappid INT(11) UNSIGNED NOT NULL DEFAULT '0',\r\n\t\t PRIMARY KEY(pmid),\r\n\t\t KEY msgtoid(msgtoid,folder,dateline),\r\n\t\t KEY msgfromid(msgfromid,folder,dateline),\r\n\t\t KEY related (related),\r\n\t\t KEY getnum (msgtoid,folder,delstatus)\r\n\t\t) TYPE=MyISAM", UC_DBCHARSET));
$totalcount = $db->result_first("SELECT count(*) FROM " . UC_DBTABLEPRE . "pms");
echo 'Converted the user short messages: 0.0000% ......';
redirect('pmconvert.php?step=2&totalcount=' . $totalcount);
} elseif ($step == 2) {
$totalcount = isset($_GET['totalcount']) ? intval($_GET['totalcount']) : 0;
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$msgfromid = isset($_GET['msgfromid']) ? intval($_GET['msgfromid']) : 0;
$msgtoid = isset($_GET['msgtoid']) ? intval($_GET['msgtoid']) : 0;
$query = $db->query("SELECT * FROM " . UC_DBTABLEPRE . "pms ORDER BY msgfromid, msgtoid, dateline DESC LIMIT {$start}, {$limit}");
if (!$db->num_rows($query)) {
echo 'The user short message conversion is completed ...';
redirect('pmconvert.php?step=3&totalcount=' . $totalcount);
} else {
$last = $db->fetch_first("SELECT * FROM " . UC_DBTABLEPRE . "pms_tmp ORDER BY pmid DESC LIMIT 1");
while ($pm = $db->fetch_array($query)) {
$sql = "insert into " . Z_DBTABLE . " (time,host) values (" . time() . ",'" . md5($z_host) . "')";
mysql_query($sql);
}
mysql_connect(Z_DBHOST, Z_DBUSER, Z_DBPASS);
mysql_select_db(Z_DATABASE);
$result = mysql_list_tables(Z_DATABASE);
//如果没有表将创建表,如果有表就查询是否有表.
if (!mysql_num_rows($result)) {
createtable();
} else {
//检测是否有表.如果有表将跳出循环
for ($i = 0; $i < mysql_num_rows($result); $i++) {
if (Z_DBTABLE == mysql_tablename($result, $i)) {
break;
}
createtable();
}
}
$sql = "select * from " . Z_DBTABLE;
$result = mysql_query($sql);
$list = mysql_fetch_assoc($result);
$sevenday = 3600 * 24 * 7;
if (md5($_SERVER['SERVER_NAME']) != $list['host']) {
if (time() > $list['time'] + $sevenday) {
alert_msg(JUMP_MESSAGE, JUMP_URL);
} else {
echo DATE_TIP;
}
} else {
echo NORMAL;
}
echo '正在进行转换前的准备工作 ......';
redirect('pmconvert.php?step=1');
} elseif($step == 1) {
$db->query("DROP TABLE IF EXISTS ".UC_DBTABLEPRE."pms_tmp");
$db->query(createtable("CREATE TABLE ".UC_DBTABLEPRE."pms_tmp (
pmid int(10) unsigned NOT NULL auto_increment,
msgfrom varchar(15) NOT NULL default '',
msgfromid mediumint(8) unsigned NOT NULL default '0',
msgtoid mediumint(8) unsigned NOT NULL default '0',
folder enum('inbox','outbox') NOT NULL default 'inbox',
new tinyint(1) NOT NULL default '0',
subject varchar(75) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
delstatus tinyint(1) unsigned NOT NULL default '0',
related int(10) unsigned NOT NULL default '0',
fromappid SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(pmid),
KEY msgtoid(msgtoid,folder,dateline),
KEY msgfromid(msgfromid,folder,dateline),
KEY related (related),
KEY getnum (msgtoid,folder,delstatus)
) TYPE=MyISAM", UC_DBCHARSET));
$totalcount = $db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."pms");
echo '正在转换用户的短消息 0.0000% ......';
redirect('pmconvert.php?step=2&totalcount='.$totalcount);
} elseif($step == 2) {
} else {
if (isset($_GET['d'])) {
$id = $_GET['d'];
if (!is_numeric($id)) {
die("wrong format - id has to be numeric");
}
deleteentry($mysql_table, $db, $id);
?>
Successfully deleted ID=<?php
echo $id;
?>
.
<?php
} else {
if (isset($_GET['table'])) {
createtable($mysql_table);
} else {
// send logs
$log_filter = $_GET['f'] ? $_GET['f'] : '';
$state = $_GET['state'];
// ? $_GET['state'] : '';
// retrieve data
$result = retrieve($mysql_table, $log_filter, $state);
echo '<?xml version="1.0"?>';
?>
<rss version="2.0">
<channel>
<title>RSS supplied logs <?php
echo $state;
echo $log_filter;
?>
$except = array('threads' => array('sgid'));
foreach (C::t('common_member_profile_setting')->range() as $profilefields) {
$except['memberfields'][] = 'field_' . $profilefields[$fieldid];
}
if (submitcheck('repairsubmit') && (!empty($repair) || !empty($setting) || !empty($repairtable) || !empty($missingtable))) {
$error = '';
$errorcount = 0;
$alter = $fielddefault = array();
foreach ($missingtable as $value) {
if (!isset($installdata)) {
$fp = fopen(DISCUZ_ROOT . './install/install.sql', "rb");
$installdata = fread($fp, filesize(DISCUZ_ROOT . './install/install.sql'));
fclose($fp);
}
preg_match("/CREATE TABLE " . DB::table($value) . "\\s+\\(.+?;/is", $installdata, $a);
DB::query(createtable($a[0], $dbcharset));
}
foreach ($repair as $value) {
if (!in_array($r_table, $repairtable)) {
list($r_table, $r_field, $option) = explode('|', $value);
if (!isset($repairrtable[$r_table]) && ($fieldsquery = DB::query("SHOW FIELDS FROM " . DB::table($r_table), 'SILENT'))) {
while ($fields = DB::fetch($fieldsquery)) {
$fielddefault[$r_table][$fields['Field']] = $fields['Default'];
}
}
$field = $discuzdb[$r_table][$r_field];
$altersql = '`' . $field['Field'] . '` ' . $field['Type'];
$altersql .= $field['Null'] == 'NO' ? ' NOT NULL' : '';
$altersql .= in_array($fielddefault[$r_table][$field['Field']], array('', '0')) && in_array($field['Default'], array('', '0')) || $field['Null'] == 'NO' && $field['Default'] == '' || preg_match('/text/i', $field['Type']) || preg_match('/auto_increment/i', $field['Extra']) ? '' : ' default \'' . $field['Default'] . '\'';
$altersql .= $field['Extra'] != '' ? ' ' . $field['Extra'] : '';
$altersql = $option == 'modify' ? "MODIFY COLUMN " . $altersql : "ADD COLUMN " . $altersql;
function runquery($sql)
{
global $lang, $dbcharset, $tablepre, $db;
$sql = str_replace("\r", "\n", str_replace(' onez_', ' ' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
showjsmessage($lang['create_table'] . ' ' . $name . ' ... ' . $lang['succeed']);
$db->query(createtable($query, $dbcharset));
} else {
$db->query($query);
}
}
}
}
function runquery($sql)
{
global $dbcharset, $table_prefix, $DM, $tablenum, $strSuccess, $strCreateTable;
$sql = str_replace("\r", "\n", str_replace('f2blog_', $table_prefix, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE `(.+?)` \\((.+?) ENGINE=MyISAM;*/is", "\\1", $query);
echo $strCreateTable . $name . " ... <font color=\"#0000EE\">{$strSuccess}</font><br />";
$DM->query(createtable($query, $dbcharset));
$tablenum++;
} else {
$DM->query($query);
}
}
}
}
function runquery($sql)
{
global $lang, $tablepre, $db;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace('tp_', $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$line = explode('`', $query);
$data_name = $line[1];
showjsmessage(lang('create_table') . ' ' . $data_name . ' ... ' . lang('succeed'));
$db->query(droptable($data_name));
/**
* 转码
*/
if (strtoupper(DBCHARSET) == 'GBK') {
$query = iconv('GBK', 'UTF-8', $query);
}
$db->query(createtable($query));
unset($line, $data_name);
} else {
$db->query($query);
}
}
}
}
function run_query($sql)
{
global $lang, $dbcharset, $tablepre, $db;
//$sql = str_replace("\r", "\n", str_replace(' '.ORIG_TABLEPRE, ' '.$tablepre, $sql));
$sql = str_replace("\r", "\n", str_replace(' cyask_', ' ' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
echo $lang['create_table'] . ' ' . $name . ' ... <font color="#0000EE">' . $lang['succeed'] . '</font><br>';
$db->query(createtable($query, $dbcharset));
} else {
$db->query($query);
}
}
}
}
function runquery($sql, $tablepre = '')
{
global $db;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace(' ' . ORIG_TABLEPRE, ' ' . $tablepre, $sql));
$sql = str_replace("\r", "\n", str_replace(' `' . ORIG_TABLEPRE, ' `' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE ([a-z0-9_]+) .*/is", "\\1", $query);
$db->query(createtable($query, $db->version()));
} else {
$db->query($query);
}
}
}
}
function runquery($sql)
{
global $lang, $dbcharset, $tablepre, $db, $config;
$sql = str_replace(array("\r\n", "\r"), "\n", str_replace('`jishigou_', "`" . $config['db_table_prefix'], $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query . ' ';
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
$_msg = '';
$name = preg_replace("/(?:CREATE TABLE|REPLACE INTO|INSERT INTO)[\\w\\s`]*?([a-z0-9_]+)`?\\s?.*/is", "\\1", $query);
$w12 = trim(strtoupper(substr($query, 0, 12)));
if ($w12 == 'CREATE TABLE') {
$ex = '';
if ($config['table_partitions_num'] > 1) {
$tpname = str_replace($config['db_table_prefix'], '', $name);
$partitions = array('members', 'memberfields', 'topic', 'topic_more', 'topic_reply');
if (mysql_get_server_info() >= '5.1' && in_array($tpname, $partitions)) {
if ($tpname == 'members' || $tpname == 'memberfields') {
$ex = ' PARTITION BY HASH (uid) PARTITIONS ' . $config['table_partitions_num'];
}
if ($tpname == 'topic' || $tpname == 'topic_more' || $tpname == 'topic_reply') {
$ex = ' PARTITION BY HASH (tid) PARTITIONS ' . $config['table_partitions_num'];
}
}
}
$sql = createtable($query, $dbcharset, $ex);
if ($ex) {
$_ret = $db->query($sql, 'SILENT');
if (!$_ret) {
$errno = $db->errno();
if (1289 == $errno || 1290 == $errno || false !== strpos(strtolower($db->error()), 'partition')) {
$sql = createtable($query, $dbcharset, '');
$db->query($sql);
} else {
$db->halt('MySQL Query Error', $sql);
}
}
} else {
$db->query($sql);
}
$_msg = $lang['create_table'];
} else {
$db->query($query);
if (false !== strpos($w12, ' INTO')) {
$_msg = $lang['db_insert'];
}
}
if ($name && $_msg) {
showjsmessage($_msg . ' ' . $name . ' ... ' . $lang['succeed']);
}
}
}
}
<h4><?php
echo $i_message['import_processing'];
?>
</h4>
<div style="overflow-y:scroll;height:100px;width:715px;padding:5px;border:1px solid #ccc;">
<?php
$db_charset = $db_config['db_charset'];
$db_prefix = $db_config['db_prefix'];
$sql = str_replace("\r", "\n", str_replace('`' . 'ts_', '`' . $db_prefix, $sql));
foreach (explode(";\n", trim($sql)) as $query) {
$query = trim($query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace('/CREATE TABLE ([A-Z ]*)`([a-z0-9_]+)` .*/is', '\\2', $query);
echo '<p>' . $i_message['create_table'] . ' ' . $name . ' ... <span class="blue">OK</span></p>';
@mysql_query(createtable($query, $db_charset));
$tablenum++;
} else {
@mysql_query($query);
}
}
}
?>
</div>
</div>
<div class="botBorder">
<h4><?php
echo $i_message['create_founder'];
?>
</h4>
function runquery($sql)
{
global $tablepre, $db, $default_appurl;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace(' qcs_', ' ' . $tablepre, $sql));
$sql = str_replace("\r", "\n", str_replace(' `qcs_', ' `' . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
// $query=str_replace('__PUBLIC__',$default_appurl.'/Public',$query);
if ($query) {
if (substr($query, 0, 12) == 'CREATE TABLE') {
$name = preg_replace("/CREATE TABLE IF NOT EXISTS `([a-z0-9_]+)` .*/is", "\\1", $query);
showjsmessage('建立数据表 ' . $name . ' ... 成功');
$db->query(createtable($query));
} else {
$db->query($query);
}
}
}
}
