A Boatload of Doors

[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 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.

[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.