$tablelist[$i][$itemtables[0]]['columnnametable'] = "item";
$tablelist[$i][$itemtables[0]]['ignore'] = "id,name_Korea,name_Japan,name_English,name_German,name_Italian,name_Spanish,name_Portuguese,name_French,name_Turkish,name_China";
$i++;
}
$queryitemtables = MYSQL_QUERY("SHOW TABLES FROM florensia LIKE 'server_questtext_%'");
while ($itemtables = MYSQL_FETCH_ARRAY($queryitemtables)) {
$tablelist[$i][$itemtables[0]]['searchkey'] = "questlistid";
$tablelist[$i][$itemtables[0]]['ignore'] = "id";
$i++;
}
/* */
//NOT IMPLEMENTED: server_skilltrees, server_items_idtable, server_upgraderule, server_seal_option
//missbrauch der cache-funktion -> einfacheres einschreiben und ggf. workarounds fuer keys mit nummern/sonderzeichen
$sqldiff = new class_cache();
$sqldiff->load_cache("sqldiff");
$sqldiff->write_cache("timestamp", date("U"));
$dbold = MYSQL_CONNECT($cfg['dbhost'], $cfg['dbuser'], $cfg['dbpasswd'], TRUE) or die("No Database connection");
MYSQL_SELECT_DB("{$oldtable}", $dbold) or die("No Database connection");
MYSQL_QUERY("SET NAMES 'utf8'", $dbold);
foreach ($tablelist as $globalkey => $value) {
foreach ($tablelist[$globalkey] as $table => $tablesettings) {
$diffentries = 0;
$newentries = 0;
unset($allentries, $exceptkeys, $content);
$allentries = array();
$querytabledata = MYSQL_QUERY("SELECT * FROM {$table} " . $tablelist[$globalkey][$table]['dbwhere'], $db);
while ($tabledata = MYSQL_FETCH_ASSOC($querytabledata)) {
$querytabledata_old = MYSQL_QUERY("SELECT * FROM {$table} WHERE " . $tablelist[$globalkey][$table]['searchkey'] . "='" . $tabledata[$tablelist[$globalkey][$table]['searchkey']] . "'", $dbold);
if ($tabledata_old = MYSQL_FETCH_ASSOC($querytabledata_old)) {
foreach (explode(",", $tablelist[$globalkey][$table]['ignore']) as $ignorekey) {
unset($tabledata[$ignorekey], $tabledata_old[$ignorekey]);
