A Boatload of Doors

bufferofnewbies · #1 12-15-2006, 08:39 AM

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. :(

Code:

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 · #2 12-15-2006, 08:47 AM

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 · #3 12-15-2006, 08:53 AM

Which database did you do this work on?

bufferofnewbies · #4 12-15-2006, 08:58 AM

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 · #5 12-15-2006, 10:40 AM

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 · #6 12-24-2006, 12:20 PM

I finally got around to this, but doesn't work for me - here's the error;

Quote:

ERROR 1054 (42S22): Unknown column 'invertstate' in 'field list'

I'll try changing that to invert_state