A Boatload of Doors

[JrFaust]

Here's five more doors in POK.

INSERT INTO doors (doorid, zone, name, pos_y, pos_x, pos_z, heading, opentype, guild, lockpick, keyitem, triggerdoor, triggertype, doorisopen, door_param, dest_zone, dest_x, dest_y, dest_z, dest_heading, invert_state, incline, size)
VALUES (144,"PoKnowledge","POKDOOR503",-322.049,-78,-159.998,384,27,0,0,0,0,0,0,0,"NONE",0,0,0,0,0,0,100)
(143,"PoKnowledge","POKDOOR500",-334,-41.949,-159.998,256,5,0,0,0,0,0,0,0,"NONE",0,0,0,0,0,0,100)
(142,"PoKnowledge","POKDOOR500",-302,-52,-159.998,0,5,0,0,0,0,0,0,0,"NONE",0,0,0,0,0,0,100)
(141,"PoKnowledge","POKDOOR500",-256.061,-183.979,-159.998,384,5,0,0,0,0,0,0,0,"NONE",0,0,0,0,0,0,100)
(140,"PoKnowledge","POKDOOR503",0,92,-127.998,128,77,0,0,0,0,0,0,0,"NONE",0,0,0,0,0,0,100)

[fathernitwit]

hey,

sorry it took so long to find this thread... but... I built every zone I had logs for for the PEQ db, and that included zone points and doors... so check out the SQL dumps over there for some of the newer zones:
http://www.projecteq.net/sql/

[JrFaust]

Nice job PEQ team there are more than 1200 doors added using their door file.

Also little off topic but there are 9 more zones added as well using their zone files, including the guild hall off of POK.

[gernblan]

These just wont' work for me.. on ax_peq.

Any suggestions, please? Using Navicat because I'm still kinda dumb on how to merge these using just the mysql command line.

Also, what are these doors for please?

Especially the abysmal ones.. what do they add?

Thanks for any help you can give me.

[JrFaust]

Just source this into you database that will add all the doors. Sorry I'm not sure where all the doors lead but if they are like most I've seen they are mainly cosmetic. Some may be portal to a zone or different area of the zone. As for adding this sql file in I use the MySQL admin restore utility and restore the sql file into my database.

Hope that helps.

[Angelox]

Originally Posted by JrFaust

Just source this into you database that will add all the doors. Sorry I'm not sure where all the doors lead but if they are like most I've seen they are mainly cosmetic. Some may be portal to a zone or different area of the zone. As for adding this sql file in I use the MySQL admin restore utility and restore the sql file into my database.

Hope that helps.

Hey Jr , didn't I already source it in? I think so, I usually add most any work that's posted here.
He's probably trying to add the same doors over again.

[bufferofnewbies]

Originally Posted by gernblan

Also, what are these doors for please?

Especially the abysmal ones.. what do they add?

Thanks for any help you can give me.

They add doors to rooms so its not one large open area.
None of these are portals to any other location, just simple doors for cosmetic reasons.