Looking for door_update.sql

[Oxalic]

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]

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 .

[Oxalic]

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]

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

[Oxalic]

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]

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

[Oxalic]

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