rendered paste body<Juokelis> private static String[] id_updates =
<Juokelis> {
<Juokelis> "UPDATE items SET owner_id = ? WHERE owner_id = ?",
<Juokelis> "UPDATE items SET object_id = ? WHERE object_id = ?",
<Juokelis> "UPDATE character_recipebook SET char_id = ? WHERE char_id = ?",
<Juokelis> "UPDATE character_shortcuts SET char_obj_id = ? WHERE char_obj_id = ?",
<Juokelis> "UPDATE character_shortcuts SET shortcut_id = ? WHERE shortcut_id = ? AND type = 1", // items
<Juokelis> "UPDATE character_macroses SET char_obj_id = ? WHERE char_obj_id = ?",
<Juokelis> "UPDATE character_skills SET char_obj_id = ? WHERE char_obj_id = ?",
<Juokelis> "UPDATE characters SET obj_Id = ? WHERE obj_Id = ?",
<Juokelis> "UPDATE characters SET clanid = ? WHERE clanid = ?",
<Juokelis> "UPDATE clan_data SET clan_id = ? WHERE clan_id = ?",
<Juokelis> "UPDATE clan_data SET ally_id = ? WHERE ally_id = ?",
<Juokelis> "UPDATE clan_data SET leader_id = ? WHERE leader_id = ?",
<Juokelis> "UPDATE pets SET item_obj_id = ? WHERE item_obj_id = ?",
<Juokelis> };