EQEmulator Forums - adding doors and objects

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - adding doors and objects (https://www.eqemulator.org/forums/showthread.php?t=13533)

adding doors and objects

I've been roughing around in the Door's part of my database and it seems that whenever I try adding a door to the database, it breaks the entire database full of the door spawns.

What I mean by this is if I add a pokbook to let's say cshome at loc x y z. I put the ID number at around 9000 because I have no idea where the doors in db end.

So after I put the pokbook portal to des zone of qeynos2. I log in, no book..so i zone to templeveeshan...no doors at all.

This means i'm adding one book and it's corrupting my entire door's database.

Any solutions to this problem?

The fact you're putting the ID number way up there might be your problem.

Somebody correct me if I'm wrong, but I think happens when the server loads up doors is it looks at the highest ID number and then allocates enough memory to hold that many doors. Try making your new door with only 1 higher than the highest existing ID.

You can determine what the highest existing door ID is by giving the command from a MySQL prompt:

Quote:

SELECT Max(ID) FROM Doors;