function updateUnicode()
{
$db = new MySql(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DB);
$sql = "SELECT\r\n `id`,\r\n `character`\r\n FROM\r\n `tomoe_character`\r\n WHERE\r\n `unicode` = 0\r\n LIMIT 0,5000;";
$result = $db->query($sql);
$num_before = $db->num_rows;
if ($num_before > 0) {
$usc_4 = 0;
foreach ($result as $r) {
$usc_4 = utf8ToUnicode($r->character);
$sql = " UPDATE\r\n tomoe_character\r\n SET\r\n unicode = {$usc_4['0']}\r\n WHERE id = {$r->id};";
//echo $sql;
$db->update($sql);
}
echo "请刷新页面。" . time();
} else {
echo "Unicode字段更新完毕";
}
}
error_log($con->error);
self::err('Database find one failed. (Check log)');
return false;
}
if ($row = $result->fetch_assoc()) {
$ret = $row;
}
$con->close();
return $ret;
}
public static function err($err)
{
self::$err = $err;
}
public static function getError()
{
return self::$err;
}
public static function update()
{
$version = MySql::find('SELECT db_version FROM config');
$version = $version[0]['db_version'];
for ($i = $version; $i < sizeof(self::$updates); $i++) {
MySql::run(self::$updates[$i]);
}
MySql::run('UPDATE config SET db_version=' . sizeof(self::$updates));
unset($GLOBALS['updates']);
}
}
MySql::update();
