function runquery($sql, $db)
{
if (!isset($sql) || empty($sql)) {
return;
}
$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];
echo "数据表 " . $data_name . " ... 创建成功\n";
$db->query(droptable($data_name));
$db->query($query);
unset($line, $data_name);
} else {
$db->query($query);
}
}
}
}
function runquery($sql, $db_prefix, $db)
{
// global $lang, $tablepre, $db;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace('#__', $db_prefix, $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('数据表 ' . $data_name . ' ... 创建成功');
$db->query(droptable($data_name));
/**
* 转码
*/
if (strtoupper(DBCHARSET) == 'GBK') {
$query = iconv('GBK', 'UTF-8', $query);
}
$db->query($query);
unset($line, $data_name);
} else {
$db->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);
}
}
}
}
