$row=-1 //set variable $row
$newid=999999999 //set variable $newid
$oldid=1
$oldclan=1
REPAIR while $oldid>0 //begin REPAIR loop
$row=$row+1 //step row number
$newid=$newid+1 //step new id number
$oldid=select obj_id from characters limit $row,1; //get old id from row
update characters set obj_id=$newid where obj_id=$oldid; //give new id for characters
update character_macroses set char_obj_id=$newid where char_obj_id=$oldid; //give new id for macros
update character_quests set char_id=$newid where char_id=$oldid; //give new id for quests
update character_recipebook set char_id=$newid where char_id=$oldid; //give new id for recipes
update character_shortcuts set char_obj_id=$newid where char_obj_id=$oldid; //give new id for shortcuts
update character_skills set char_obj_id=$newid where char_obj_id=$oldid; //give new id for skills
update clan_data set leader_id=$newid where leader_id=$oldid; //give new id for clan_data
update items set owner_id=$newid where char_obj_id=$oldid; //give new id for items
loop to REPAIR //return to loop
$row=-1 //reset
CLANS while $oldclan>0 //begin CLAN loop
$row=$row+1 //step row number
$newid=$newid+1 //step new id number
$oldclan=select clanid from characters limit $row,1; //get old clanid from row
update characters set clanid=$newid where clanid=$oldclan; //give new clanid at row
update clan_data set clan_id=$newid where clan_id=$oldclan; //give new id for clans
loop to CLANS //return to loop
alter table items drop object_id; //drop object id column
alter table items add object_id int(11) auto_increment after owner_id, add primary key (object_id);
//add object id column with ids auto incrementing from 1
alter table items modify object_id int; //drop auto increment
update items set object_id=object_id+$newid; //give new id for item