$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