$tablelist[$i][$itemtables[0]]['searchkey'] = $florensia->get_columnname("itemid", "item"); $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) {