Thought I would post this. It is sql commands to "compress" all the door ID's so there aren't any gaps and it starts at 1
As long as you have less than 10000 doors this will fix the door ID limit. Normaly there are about 5500 doors that we have data for.
Replace
eq440 (2 places) with the name of your DB.
Code:
use eq440;
drop database lurk_temp;
create database lurk_temp;
create table lurk_temp.doors select doors.* from doors;
truncate table doors;
#EQEmu 4.4 doors format
insert into eq440.doors (doorid, zone, name, pos_y, pos_x, pos_z, heading, opentype, guild, lockpick, keyitem, triggerdoor, triggertype, doorisopen, liftheight, dest_zone, dest_x, dest_y, dest_z, dest_heading) select lurk_temp.doors.doorid, lurk_temp.doors.zone, lurk_temp.doors.name, lurk_temp.doors.pos_y, lurk_temp.doors.pos_x, lurk_temp.doors.pos_z, lurk_temp.doors.heading, lurk_temp.doors.opentype, lurk_temp.doors.guild, lurk_temp.doors.lockpick, lurk_temp.doors.keyitem, lurk_temp.doors.triggerdoor, lurk_temp.doors.triggertype, lurk_temp.doors.doorisopen, lurk_temp.doors.liftheight, lurk_temp.doors.dest_zone, lurk_temp.doors.dest_x, lurk_temp.doors.dest_y, lurk_temp.doors.dest_z, lurk_temp.doors.dest_heading from lurk_temp.doors;
drop database lurk_temp;