A Boatload of Doors

[bufferofnewbies]

zone: abysmal (the tradeskill boat)
effects: doors, dang it!

I hope this is useful to someone.
oh btw: anyone know a way to copy a section of mysql into text? I have been doing these by hand due to my lack of skills. :(

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, invertstate, incline, size)
VALUES (1, abysmal, SCADOOR800, -182, 34.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(2, abysmal, SCADOOR800, -182, -7, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(3, abysmal, SCADOOR800, -182, -48.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(4, abysmal, SCADOOR800, -66.5, -68.3, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(5, abysmal, SCADOOR800, -66.5, 68, 137, -128, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(6, abysmal, SCADOOR800, -19, 18.2, 154.8, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(7, abysmal, SCADOOR800, -19, -18.2, 154.8, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(8, abysmal, SCADOOR800, -227.3, 222.2, 111, -128, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(9, abysmal, SCADOOR800, -137.5, 244.8, 111, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(10, abysmal, SCADOOR800, 83.2, 157, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(11, abysmal, SCADOOR800, 83.1, -157, 111, -255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(12, abysmal, SCADOOR800, 137.5, -244.5, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(13, abysmal, SCADOOR800, -227.5, -222.1, 111, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(14, abysmal, SCADOOR800, -264.5, -267, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(15, abysmal, SCADOOR800, -264.5, 267, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(16, abysmal, SCADOOR800, -264.5, 177.5, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(17, abysmal, SCADOOR800, -264.5, -177.5, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(18, abysmal, SCADOOR801, -203.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(19, abysmal, SCADOOR801, -203.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(20, abysmal, SCADOOR801, -153.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(21, abysmal, SCADOOR801, -153.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(22, abysmal, SCADOOR801, -103.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(23, abysmal, SCADOOR801, -103.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(24, abysmal, SCADOOR801, -53.5, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(25, abysmal, SCADOOR801, -53.5, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(26, abysmal, SCADOOR801, -3.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(27, abysmal, SCADOOR801, -3.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(28, abysmal, SCADOOR801, -153.7, -2475., 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(29, abysmal, SCADOOR801, -153.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(30, abysmal, SCADOOR801, -203.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(31, abysmal, SCADOOR801, -203.7, -247.5, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(32, abysmal, SCADOOR801, -53.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(33, abysmal, SCADOOR801, -53.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(34, abysmal, SCADOOR801, -103.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(35, abysmal, SCADOOR801, -103.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(36, abysmal, SCADOOR801, -53.6, -161, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(37, abysmal, SCADOOR801, -53.6, 161, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(38, abysmal, SCADOOR800, -247, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100),
(39, abysmal, SCADOOR800, -131.4, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, NONE, 0, 0, 0, 0, 0, 0, 100);

more to come as time permits.
As always, let me know if any errors pop up with this addition.

[John Adams]

If you are using phpMyAdmin, you can export selected records. Run a Search query for the stuff you know you changed, select only your records, and at the bottom is an export selected option. Puts it into a nice text-shaped .sql file.

If you are not using the web-based admin tool, there should be a similar way to export a recordset, one would think. If not, and you have php, I recommend the simplicity of phpMyAdmin 2.81 or whatever they are on.

[Angelox]

Which database did you do this work on?

[bufferofnewbies]

technically, a 'blank one'.. but I used this file to pull over on my 'play server' from it. That is why I leave the id field out, so it will be autoadded. But there is always a chance that I missed a , or a ) somewhere. Thus my caution for alot of this addition listing.

Who's dbase do you think I use Ang? /bonk
There is only one I send people after, when they ask for one: Some crazy guy's site (http://www.nahunta.org/~angelox/)

[bufferofnewbies]

oh btw: I might have missed 2 or 3 doors (kinda), as there was one hallway that I thought looked better as a hall instead of putting the door there to close it off.

I couldn't remember the zone exactly from live as it was mostly a quick "boom boom, then a zoom zoom" kind of zone for me. So, if you find a spot a door is needed, just yell. I tended to go on 'oh that would look good' instead of doing something useful like logging into my live account to check.

I'm lazy like that..

[Angelox]

I finally got around to this, but doesn't work for me - here's the error;
ERROR 1054 (42S22): Unknown column 'invertstate' in 'field list'
I'll try changing that to invert_state

[Angelox]

This is what worked for me;
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 (1, "abysmal", "SCADOOR800", -182, 34.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(2, "abysmal", "SCADOOR800", -182, -7, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(3, "abysmal", "SCADOOR800", -182, -48.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(4, "abysmal", "SCADOOR800", -66.5, -68.3, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(5, "abysmal", "SCADOOR800", -66.5, 68, 137, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(6, "abysmal", "SCADOOR800", -19, 18.2, 154.8, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(7, "abysmal", "SCADOOR800", -19, -18.2, 154.8, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(8, "abysmal", "SCADOOR800", -227.3, 222.2, 111, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(9, "abysmal", "SCADOOR800", -137.5, 244.8, 111, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(10, "abysmal", "SCADOOR800", 83.2, 157, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(11, "abysmal", "SCADOOR800", 83.1, -157, 111, -255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(12, "abysmal", "SCADOOR800", 137.5, -244.5, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(13, "abysmal", "SCADOOR800", -227.5, -222.1, 111, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(14, "abysmal", "SCADOOR800", -264.5, -267, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(15, "abysmal", "SCADOOR800", -264.5, 267, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(16, "abysmal", "SCADOOR800", -264.5, 177.5, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(17, "abysmal", "SCADOOR800", -264.5, -177.5, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(18, "abysmal", "SCADOOR801", -203.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(19, "abysmal", "SCADOOR801", -203.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(20, "abysmal", "SCADOOR801", -153.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(21, "abysmal", "SCADOOR801", -153.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(22, "abysmal", "SCADOOR801", -103.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(23, "abysmal", "SCADOOR801", -103.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(24, "abysmal", "SCADOOR801", -53.5, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(25, "abysmal", "SCADOOR801", -53.5, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(26, "abysmal", "SCADOOR801", -3.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(27, "abysmal", "SCADOOR801", -3.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(28, "abysmal", "SCADOOR801", -153.7, -2475., 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(29, "abysmal", "SCADOOR801", -153.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(30, "abysmal", "SCADOOR801", -203.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(31, "abysmal", "SCADOOR801", -203.7, -247.5, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(32, "abysmal", "SCADOOR801", -53.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(33, "abysmal", "SCADOOR801", -53.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(34, "abysmal", "SCADOOR801", -103.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(35, "abysmal", "SCADOOR801", -103.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(36, "abysmal", "SCADOOR801", -53.6, -161, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(37, "abysmal", "SCADOOR801", -53.6, 161, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(38, "abysmal", "SCADOOR800", -247, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(39, "abysmal", "SCADOOR800", -131.4, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100);


Had to quote "abysmal", "SCADOOR800", "SCADOOR801",and "NONE", too.

[bufferofnewbies]

ahh rats. I shoulda caught that from way before. That's what I get for posting it right after I finished, was seeing crosseyed when I put it up. Glad you found the fix for it, just got back home and was checking up on the boards here.

[John Adams]

Yeah, generally speaking, if it's a text field, it should have quoties around the text. ;)

I usually do an export of my work using the SQL tools so things are formatted properly straight away. But, even I am known to make mistakes. ~grins~

[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 (http://www.projecteq.net/sql/doors-contents.sql) 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]

Just source this (http://www.projecteq.net/sql/doors-contents.sql) 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]

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.