Doors & stones help please

[Zern]

Originally Posted by soulfood

Lurker_005: don't worry about the destination: zone, x, y, z
I've completed all of that already and the POK and all POKTELE500 doors will port you within millimeters of your destination door. I have not included "dest_heading" as you'll notice it is still "0".
Hope it helps out.
A new doors.zip file can be accessed directly at:

http://my.core.com/~tgarland/doors.zip

I know its not as nice looking as yours but it is in the same order anyhow =)

Everyone will have to drop their doors table manually unless you care to fix this part I'm more of a Systems/Networking Guru and only an enthusiast of Programming =)

Soulfood

Just add the following to the start of your sql file:



DROP TABLE IF EXISTS doors;
CREATE TABLE doors (
id int(11) NOT NULL auto_increment,
doorid smallint(4) NOT NULL default '0',
zone varchar(16) NOT NULL default '',
name varchar(16) NOT NULL default '',
pos_y float NOT NULL default '0',
pos_x float NOT NULL default '0',
pos_z float NOT NULL default '0',
heading float NOT NULL default '0',
opentype smallint(4) NOT NULL default '0',
guild smallint(4) NOT NULL default '0',
lockpick smallint(4) NOT NULL default '0',
keyitem int(11) NOT NULL default '0',
triggerdoor smallint(4) NOT NULL default '0',
triggertype smallint(4) NOT NULL default '0',
doorisopen smallint(4) NOT NULL default '0',
liftheight int(4) NOT NULL DEFAULT '0',
dest_zone varchar(16) default "NONE",
dest_x float default 0,
dest_y float default 0,
dest_z float default 0,
dest_heading float default 0,
PRIMARY KEY (id)
) TYPE=MyISAM;