|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
|
|
|
12-15-2006, 08:39 AM
|
Hill Giant
|
|
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
|
|
A Boatload of Doors
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.
|
|
|
|
12-15-2006, 08:47 AM
|
Demi-God
|
|
Join Date: Jul 2006
Posts: 1,552
|
|
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.
|
12-15-2006, 08:53 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Which database did you do this work on?
|
12-15-2006, 08:58 AM
|
Hill Giant
|
|
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
|
|
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
|
12-15-2006, 10:40 AM
|
Hill Giant
|
|
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
|
|
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..
|
12-24-2006, 12:20 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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
|
|
|
|
12-24-2006, 12:34 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
This is what worked for me;
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, 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.
|
|
|
|
12-24-2006, 03:27 PM
|
Hill Giant
|
|
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
|
|
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.
|
12-27-2006, 06:12 AM
|
Demi-God
|
|
Join Date: Jul 2006
Posts: 1,552
|
|
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~
|
01-15-2007, 05:38 PM
|
Sarnak
|
|
Join Date: Aug 2005
Location: Overthere
Posts: 82
|
|
Here's five more doors in POK.
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, 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)
|
01-27-2007, 01:31 PM
|
Developer
|
|
Join Date: Jul 2004
Posts: 773
|
|
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/
|
01-28-2007, 06:53 AM
|
Sarnak
|
|
Join Date: Aug 2005
Location: Overthere
Posts: 82
|
|
Wow lots more doors.
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.
|
02-09-2007, 05:59 AM
|
Discordant
|
|
Join Date: Aug 2006
Posts: 394
|
|
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.
Last edited by gernblan; 02-09-2007 at 02:07 PM..
|
02-09-2007, 06:17 AM
|
Sarnak
|
|
Join Date: Aug 2005
Location: Overthere
Posts: 82
|
|
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.
|
02-09-2007, 07:25 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 03:14 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|