Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-01-2004, 10:14 AM
Gonkers
Sarnak
 
Join Date: Mar 2004
Posts: 65
Default 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?
Reply With Quote
  #2  
Old 05-01-2004, 02:03 PM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

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;
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:35 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3