A Boatload of Doors

[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

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

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