欧奥数据库升级工具
END;
}
function show_footer()
{
print<<
END;
}
function runquery($sql)
{
global $_G;
$tablepre = $_G['config']['db'][1]['tablepre'];
$dbcharset = $_G['config']['db'][1]['dbcharset'];
$sql = str_replace("\r", "\n", str_replace(array(' {tablepre}', ' dzz_', ' `dzz_'), array(' ' . $tablepre, ' ' . $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(create_table($query, $dbcharset));
} else {
DB::query($query);
}
}
}
}
function save_config_file($filename, $config, $default, $deletevar)
{
$config = setdefault($config, $default, $deletevar);
$date = gmdate("Y-m-d H:i:s", time() + 3600 * 8);
$content = <<
$config));
$content .= "\r\n// ".str_pad(' THE END ', 50, '-', STR_PAD_BOTH)."\r\n return \$_config;";
if (!is_writable($filename) || !($len = file_put_contents($filename, $content))) {
file_put_contents(DZZ_ROOT . './data/config.php', $content);
return 0;
}
return 1;
}
function setdefault($var, $default, $deletevar)
{
foreach ($default as $k => $v) {
if (!isset($var[$k])) {
$var[$k] = $default[$k];
} elseif (is_array($v)) {
$var[$k] = setdefault($var[$k], $default[$k]);
}
}
foreach ($deletevar as $k) {
unset($var[$k]);
}
return $var;
}
function getvars($data, $type = 'VAR')
{
$evaluate = '';
foreach ($data as $key => $val) {
if (!preg_match("/^[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*$/", $key)) {
continue;
}
if (is_array($val)) {
$evaluate .= buildarray($val, 0, "\${$key}") . "\r\n";
} else {
$val = addcslashes($val, '\'\\');
$evaluate .= $type == 'VAR' ? "\$$key = '$val';\n" : "define('" . strtoupper($key) . "', '$val');\n";
}
}
return $evaluate;
}
function buildarray($array, $level = 0, $pre = '$_config')
{
static $ks;
if ($level == 0) {
$ks = array();
$return = '';
}
foreach ($array as $key => $val) {
if ($level == 0) {
$newline = str_pad(' CONFIG ' . strtoupper($key) . ' ', 70, '-', STR_PAD_BOTH);
$return .= "\r\n// $newline //\r\n";
if ($key == 'admincp') {
$newline = str_pad(' Founders: $_config[\'admincp\'][\'founder\'] = \'1,2,3\'; ', 70, '-', STR_PAD_BOTH);
$return .= "// $newline //\r\n";
}
}
$ks[$level] = $ks[$level - 1] . "['$key']";
if (is_array($val)) {
$ks[$level] = $ks[$level - 1] . "['$key']";
$return .= buildarray($val, $level + 1, $pre);
} else {
$val = is_string($val) || strlen($val) > 12 || !preg_match("/^\-?[1-9]\d*$/", $val) ? '\'' . addcslashes($val, '\'\\') . '\'' : $val;
$return .= $pre . $ks[$level - 1] . "['$key']" . " = $val;\r\n";
}
}
return $return;
}
function dir_clear($dir, $index = 1)
{
global $lang;
if ($directory = @dir($dir)) {
while ($entry = $directory->read()) {
$filename = $dir . '/' . $entry;
if (is_file($filename)) {
@unlink($filename);
}
}
$directory->close();
if ($index) @touch($dir . '/index.htm');
}
}
function create_table($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', 'MEMORY')) ? $type : 'MYISAM';
return preg_replace("/^\s*(CREATE TABLE\s+.+\s+\(.+?\)).*$/isU", "\\1", $sql) .
(" ENGINE=$type DEFAULT CHARSET=" . $dbcharset);
}
function getpathdata($folderdata, $appid, $pathdata = array())
{
foreach ($folderdata as $v) {
$pathdata[$v['id'] . $appid] = $v['name'];
if ($v['children']) {
$tmpchild = $v['children'];
$pathdata = getpathdata($tmpchild, $appid, $pathdata);
}
}
return $pathdata;
}
//更新eagle库目录数据
function initFoldertag($data)
{
$path = $data['path'];
if (!is_dir($path)) {
$path = DZZ_ROOT . 'library' . BS . $data['path'];
}
if (!is_dir($path)) return;
$jsonfile = $path . BS . 'metadata.json';
$mtime = filemtime($jsonfile);
$appdatas = file_get_contents($jsonfile);
//解析出json数据
$appdatas = json_decode($appdatas, true);
//目录数据
$folderdata = $appdatas['folders'];
C::t('pichome_folder')->insert_folderdata_by_appid($data['appid'], $folderdata);
//对比目录数据
$folderarr = getpathdata($folderdata, $data['appid']);
$folderfids = array_keys($folderarr);
$delfids = [];
foreach (DB::fetch_all("select fid from %t where fid not in(%n) and appid = %s", array('pichome_folder', $folderfids, $data['appid'])) as $v) {
$delfids[] = $v['fid'];
}
C::t('pichome_folder')->delete($delfids);
C::t('pichome_vapp')->update($data['appid'], array('path' => $path));
return true;
}
function formatpath($path)
{
if(strpos($path,':') === false){
$bz = 'dzz';
}else{
$patharr = explode(':', $path);
$bz = $patharr[0];
$did = $patharr[1];
}
if(!is_numeric($did) || $did < 2){
$bz = 'dzz';
}
$rootpath = str_replace(BS,'/',DZZ_ROOT);
$path = str_replace(DZZ_ROOT, '', $path);
$path = str_replace($rootpath, '', $path);
$path = str_replace(BS, '/', $path);
$path = str_replace('//', '/', $path);
$path = str_replace('./', '', $path);
if($bz == 'dzz')$path = 'dzz::'.ltrim($path,'/');
else $path = ltrim($path,'/');
return $path;
}
function getbasename($filename)
{
return preg_replace('/^.+[\\\\\\/]/', '', $filename);
}
function getintPaletteNumber($colors, $palette = array())
{
if (empty($palette)) $palette = [
0xfff8e1,0xf57c00,0xffd740,0xb3e5fc,0x607d8b,0xd7ccc8,
0xff80ab,0x4e342e,0x9e9e9e,0x66bb6a,0xaed581,0x18ffff,
0xffe0b2,0xc2185b,0x00bfa5,0x00e676,0x0277bd,0x26c6da,
0x7c4dff,0xea80fc,0x512da8,0x7986cb,0x00e5ff,0x0288d1,
0x69f0ae,0x3949ab,0x8e24aa,0x40c4ff,0xdd2c00,0x283593,
0xaeea00,0xffa726,0xd84315,0x82b1ff,0xab47bc,0xd4e157,
0xb71c1c,0x880e4f,0x00897b,0x689f38,0x212121,0xffff00,
0x827717,0x8bc34a,0xe0f7fa,0x304ffe,0xd500f9,0xec407a,
0x6200ea,0xffab00,0xafb42b,0x6a1b9a,0x616161,0x8d6e63,
0x80cbc4,0x8c9eff,0xffeb3b,0xffe57f,0xfff59d,0xff7043,
0x1976d2,0x5c6bc0,0x64dd17,0xffd600
];
$arr = array();
if (is_array($colors)) {
$isarray = 1;
} else {
$colors = (array)$colors;
$isarray = 0;
}
foreach ($colors as $color) {
$bestColor = 0x000000;
$bestDiff = PHP_INT_MAX;
$color = new Color($color);
foreach ($palette as $key => $wlColor) {
// calculate difference (don't sqrt)
$diff = $color->getDiff($wlColor);
// see if we got a new best
if ($diff < $bestDiff) {
$bestDiff = $diff;
$bestColor = $wlColor;
}
}
unset($color);
$arr[] = array_search($bestColor, $palette);
}
return $isarray ? $arr : $arr[0];
}
function fetchtablelist($tablepre = '') {
global $db;
$arr = explode('.', $tablepre);
$dbname = $arr[1] ? $arr[0] : '';
$tablepre = str_replace('_', '\_', $tablepre);
$sqladd = $dbname ? " FROM $dbname LIKE '$arr[1]%'" : "LIKE '$tablepre%'";
$tables = $table = array();
$query = DB::query("SHOW TABLE STATUS $sqladd");
while ($table = DB::fetch($query)) {
$table['Name'] = ($dbname ? "$dbname." : '') . $table['Name'];
$tables[] = $table['Name'];
}
return $tables;
}
?>