EQEmulator Forums - Looking for door

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

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Looking for door_update.sql (https://www.eqemulator.org/forums/showthread.php?t=18786)

Oxalic

06-12-2005 10:50 AM

Broken Doors with 6.0

Got my server all working fine, except for having 2 doors, 1 that works, and one that sits there stupified. My friend said to get door_update.sql, and i can only find dead links for it. Any help is appreaciated!

Oxalic

06-12-2005 11:09 AM

Quote:

ALTER TABLE `doors` ADD UNIQUE DoorIndex (doorid,zone);
ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NULL;

# Make SURE all three queries dont produce any errors!!!

Thats what my friend suggested, wouldn't work for me, i'm just sourcing over anything i may have broken, will post results :D.

Oxalic

06-12-2005 12:12 PM

Didnt help me, hmmm. Doors all open, but some are doubled up which prevents you from entering a building and using the lifts. *lame*

sylverwolf

06-13-2005 03:47 AM

I think you mean doors_update and you can find em here http://cvs.sourceforge.net/viewcvs.p...CVS/SQL-Files/

Oxalic

06-13-2005 07:08 AM

Quote:

ERROR 1062: Duplicate entry '0-freportw' for key 2
ERROR 1060: Duplicate column name 'size'
ERROR 1054: Unknown column 'liftheight' in 'doors'

Doesn't sound good :-/

Oxalic

06-14-2005 07:49 AM

Some doors work, lifts dont, and some doors don't.

Oxalic

06-14-2005 10:39 AM

South Qeynos seens to have the most or all broken doors, lifts are also broken.

All times are GMT -4. The time now is 05:03 PM.