it is not about gameserver cleaning up, but about primary key restrictions in tables. so already inserting duplicate data into tables will produce sql error, before even starting up the server. the duplicate entry error has nothing to do with gs.jurchiks wrote:well sorry, but what did you expect?
you have to generate random unused IDs and put them instead of duplicate ones, since afaik when starting GS, it deletes duplicate entrys instead of fixing them
Think of and apply algorithm to duplicate ids and names until you've got unique ones. Not really much of an 'IF'...takhs7 wrote:lol and IF u manage to get pass the char_id (primary key) thingy then what? .. maybe.. just maybe.. there will be ALOT of players with same nickname? what u will do then? rename them all ?
why dont u just forget it..
Probably says more about the people you 'see' then the complexity of this problemtakhs7 wrote: first time i saw someone trying to merge 2 servers.. rofl
Man, i check the script and find it good enough for my purposeThE_PuNiSheR wrote:Or just write a php script which will transfer all chars
I'm working on script for the same and you can try this.
........................
EDIT: They are for linux OS soon will post for windows..
Code: Select all
<?phprequire_once('adodb/adodb.inc.php');set_time_limit(0);if (!ini_get('display_errors')){ ini_set('display_errors', 1);}error_reporting(E_ALL);// Primary Serverdefine('MySQL_USER', 'root'); // Default: root but is not recommended!!define('MySQL_PASS', 'pass'); // Default: define('MySQL_DB', 'l2jdb'); // Default: l2jdbdefine('MySQL_HOST', '127.0.0.1'); // Default: 127.0.0.1 $DB = NewADOConnection('mysql://' . MySQL_USER . ':' . MySQL_PASS . '@' . MySQL_HOST . '/' . MySQL_DB. '?persist'); // Connecting to MySQL serverif (!$DB) { die('Wrong mysql connect configuration please try again: ' . $DB->ErrorMsg());} define('PATTERN', '1'); // If there is a duplicate what we will append to account ?$acc2 = $DB->GetAll('SELECT login FROM accounts2 ORDER BY login'); // Copy your second server's account table into main database server foreach($acc2 as $row) { if (!empty($row[0])) { $count = $DB->Execute('SELECT COUNT(*) FROM accounts WHERE login = ?', array($row[0])); if ($count > 1) // so this is duplicate what we gona do with it? { echo 'Duplicate found for ' , $row[0] , PHP_EOL; $update = $DB->Execute('UPDATE accounts2 SET login = ? WHERE login = ?', array($row[0] . PATTERN, $row[0])); $update2 = $DB->Execute('UPDATE characters2 SET account_name = ? WHERE account_name = ?', array($row[0] . PATTERN, $row[0])); if ($update && $update2) echo 'Duplicate fixed.' , PHP_EOL; else echo 'Failed updating duplicate entry please use another pattern..' , PHP_EOL; } } }echo 'Duplicates are fixed ' , PHP_EOL;?> Code: Select all
DELETE FROM characters WHERE characters.level < 76 AND DATEDIFF(CURRENT_DATE( ) , FROM_UNIXTIME(`lastaccess`/1000)) > 60;Code: Select all
-- items TableUPDATE `items` SET `object_id` = `object_id` + 1000000000;UPDATE `items` SET `owner_id` = `owner_id` + 1000000000; -- item_attributes TableUPDATE `item_attributes` SET `itemId` = `itemId` + 1000000000; -- characters TableUPDATE `characters` SET `charId` = `charId` + 1000000000;UPDATE `characters` SET `clanid` = `clanid` + 1000000000; -- clan_data TableUPDATE `clan_data` SET `clan_id` = `clan_id` + 1000000000;UPDATE `clan_data` SET `ally_id` = `ally_id` + 1000000000;UPDATE `clan_data` SET `leader_id` = `leader_id` + 1000000000;UPDATE `clan_data` SET `crest_id ` = `crest_id ` + 1000000000;UPDATE `clan_data` SET `crest_large_id ` = `crest_large_id ` + 1000000000;UPDATE `clan_data` SET `ally_crest_id ` = `ally_crest_id ` + 1000000000; -- clan_notices TableUPDATE `clan_notices` SET `clan_id` = `clan_id` + 1000000000; -- clan_privs TableUPDATE `clan_privs` SET `clan_id` = `clan_id` + 1000000000; -- clan_skills TableUPDATE `clan_skills` SET `clan_id` = `clan_id` + 1000000000; -- clan_subpledges TableUPDATE `clan_subpledges` SET `clan_id` = `clan_id` + 1000000000;UPDATE `clan_subpledges` SET `leader_id` = `leader_id` + 1000000000; -- clan_wars TableUPDATE `clan_wars` SET `clan1` = `clan1` + 1000000000;UPDATE `clan_wars` SET `clan2` = `clan2` + 1000000000; -- character_friends tableUPDATE `character_friends` SET `charId` = `charId` + 1000000000; -- character_hennas tableUPDATE `character_hennas` SET `charId` = `charId` + 1000000000; -- character_instance_time tableUPDATE `character_instance_time` SET `charId` = `charId` + 1000000000; -- character_macroses tableUPDATE `character_macroses` SET `charId` = `charId` + 1000000000; -- character_premium_items tableUPDATE `character_premium_items` SET `charId` = `charId` + 1000000000; -- character_quest_global_data tableUPDATE `character_quest_global_data` SET `charId` = `charId` + 1000000000; -- character_quests tableUPDATE `character_quests` SET `charId` = `charId` + 1000000000; -- character_raid_points tableUPDATE `character_raid_points` SET `charId` = `charId` + 1000000000; -- character_recipebook tableUPDATE `character_recipebook` SET `charId` = `charId` + 1000000000; -- character_recipeshoplist tableUPDATE `character_recipeshoplist` SET `charId` = `charId` + 1000000000; -- character_recommends tableUPDATE `character_recommends` SET `charId` = `charId` + 1000000000; -- character_shortcuts tableUPDATE `character_shortcuts` SET `charId` = `charId` + 1000000000; -- character_skills tableUPDATE `character_skills` SET `charId` = `charId` + 1000000000; -- character_skills_save tableUPDATE `character_skills_save` SET `charId` = `charId` + 1000000000; -- character_subclasses tableUPDATE `character_subclasses` SET `charId` = `charId` + 1000000000; -- character_tpbookmark tableUPDATE `character_tpbookmark` SET `charId` = `charId` + 1000000000; -- olympiad_nobles tableUPDATE `olympiad_nobles` SET `charId` = `charId` + 1000000000;