|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
12-26-2009, 06:29 PM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
Crescent Reach Lifts... anyone have?
Anyone have lifts in crescent reach actually working? if so, any chance of posting the table info for them? I can't seem to get them to even show up, which is sad. Hoping someone was succesful already in this venture and is kind enough to share.
|
12-29-2009, 04:53 PM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
Got lifts to show up, but...
Seems I figured out why I couldnt get them to show up. new problems...
1. using opentypes 60+ make the lift visible but you are not able to step on it. if I use opentype 54, 58 or 59 I can step on it, but it doesnt raise the right amount.
2. what does version do? if I use anything other than 0 it makes it invisible.
While writing this I got distracted, came back and forgot I was asking for help. turns out i figured it out.
I use version 0, opentype 59 and doorparam I set to something larger than 0 (the amount I want the lift to raise to be exact) and I have them working.
the beautiful things that happen when you step away for a minute and come back. hope this helps other people who where doing trial and error like i was. when I get the crescent reach lifts 100% correct, I will probably post them for all.
|
 |
|
 |
01-03-2010, 06:01 AM
|
 |
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
For you to get all of the stuff in the doors table to get Crescent Reach 100% accurate would be nearly impossible to do manually :P
Luckily, I took the time a while back to collect the door packets from Live in Crescent and manually convert each packet into a database entry.
I don't have the actual MySQL handy for you to run, but you should be able to use this info to get your doors all running 100% perfectly:
Doors Table:
Code:
id doorid zone version name pos_y pos_x pos_z heading opentype guild lockpick keyitem nokeyring triggerdoor triggertype doorisopen door_param dest_zone dest_x dest_y dest_z dest_heading is_ldon_door invert_state incline size buffer
13217 1 crescent 0 OBJ_ELEV -1307.99 -1541.54 -89.5 0 59 0 0 0 0 0 255 3 100 NONE 0 0 0 0 0 0 0 100 0
13218 2 crescent 0 OBJ_ELEV -1307.96 -1390.32 11 0 59 0 0 0 0 0 255 0 100 NONE 0 0 0 0 0 0 0 100 0
13219 3 crescent 0 OBJ_GEARSB -1316.5 -1541.35 -93.25 256 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 458 100 0
13220 4 crescent 0 OBJ_GEARSB -1299.59 -1541.26 -93.25 0 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 184 100 0
13221 5 crescent 0 OBJ_GEARSB -1316.3 -1390.32 6.69013 256 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 190 100 0
13222 6 crescent 0 OBJ_GEARSB -1299.43 -1390.26 7.0403 0 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 99 100 0
13223 7 crescent 0 OBJ_LIFT -192.098 -573.474 -68.899 128 59 0 0 0 0 0 255 0 144 NONE 0 0 0 0 0 0 0 100 0
13224 8 crescent 0 OBJ_LIFT -192.099 -734.161 -69 384 59 0 0 0 0 0 255 0 144 NONE 0 0 0 0 0 0 0 100 0
13225 9 crescent 0 OBJ_PADDLE 340.251 -2166.94 -94.188 256 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 174 100 0
13226 10 crescent 0 OBJ_ELEV_BUTTON -1318.24 -1531.51 -87 0 59 0 0 0 0 1 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13227 11 crescent 0 OBJ_ELEV_BUTTON -1318.31 -1531.44 13 63 59 0 0 0 0 1 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13228 12 crescent 0 OBJ_ELEV_BUTTON -1318.12 -1380.19 13.5 0 59 0 0 0 0 2 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13229 13 crescent 0 OBJ_ELEV_BUTTON -1318.82 -1379.75 114.25 0 59 0 0 0 0 2 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13230 14 crescent 0 OBJ_LIFT_BUTTON -187.096 -587.703 -64.25 64 59 0 0 0 0 7 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13231 15 crescent 0 OBJ_LIFT_BUTTON -178.712 -586.536 79 0 59 0 0 0 0 7 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13232 16 crescent 0 OBJ_LIFT_BUTTON -187.096 -720.01 -64.5 474 59 0 0 0 0 8 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13233 17 crescent 0 OBJ_LIFT_BUTTON -178.73 -721.043 79.5 0 59 0 0 0 0 8 1 0 1 NONE 0 0 0 0 0 0 0 100 0
13234 18 crescent 0 OBJ_OGRESKELETON -1239.01 -226.163 123.218 384 59 0 0 0 0 0 0 0 0 NONE 0 0 0 0 0 0 0 100 0
13235 19 crescent 0 OBJ_WATERWHEELMOUNT -419.528 -1864.41 -120 73 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13236 20 crescent 0 OBJ_WATERWHEEL -419.778 -1863.66 -120 202 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 68 100 0
13237 21 crescent 0 OBJ_WATERWHEELMOUNT -116.58 -2077.51 -115.75 384 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13238 22 crescent 0 OBJ_WATERWHEEL -116.58 -2077.51 -115.75 256 105 0 0 0 0 0 0 1 -1 NONE 0 0 0 0 0 1 290 100 0
13239 23 crescent 0 OBJ_STILL_BARREL -1147.62 -1605.04 -85.5 0 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13240 24 crescent 0 OBJ_STILL_BARREL -1166 -1642.4 -52.7 507 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13241 25 crescent 0 OBJ_CRDOOR -1577.62 -1530.56 -90.255 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13242 26 crescent 0 OBJ_CRDOOR -1643.28 -1530.56 -70.578 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13243 27 crescent 0 OBJ_CRDOOR -1633.67 -1550.86 -70.578 128 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13244 28 crescent 0 OBJ_CRDOOR -1600.38 -1550.86 -70.578 128 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13245 29 crescent 0 OBJ_CRDOOR -1609.97 -1530.56 -70.578 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13246 30 crescent 0 OBJ_CRDOOR -1567.14 -1550.82 -70.578 128 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13247 31 crescent 0 OBJ_CRDOOR -1576.73 -1530.57 -70.578 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13248 32 crescent 0 OBJ_CRDOOR -1568.04 -1550.84 -90.255 125 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13249 33 crescent 0 OBJ_CRDOOR -1610.85 -1530.66 -90.255 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13250 34 crescent 0 OBJ_CRDOOR -1601.29 -1550.84 -90.255 128 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13251 35 crescent 0 OBJ_CRDOOR -1644.13 -1530.57 -90.255 384 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13252 36 crescent 0 OBJ_CRDOOR -1634.56 -1550.82 -90.255 126 0 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13603 100 crescent 0 POKTELE500 -3.5 -45 -2.4 165 58 0 0 0 0 0 0 0 0 freeporttemple -175 216 13.8 127 0 0 0 50 0
13605 101 crescent 0 POKTELE500 -49 -45 -2.4 88 58 0 0 0 0 0 0 0 0 nexus 0 0 -31 165 0 0 0 50 0
Objects Table:
Code:
id zoneid version xpos ypos zpos heading itemid charges objectname type icon unknown08 unknown10 unknown20 unknown24 unknown60 unknown64 unknown68 unknown72 unknown76 unknown84
150002 394 0 -1614.06 -1242.72 33.6 328 0 0 IT10714_ACTORDEF 53 1142 0 0 0 0 0 1 0 0 0 0
150040 394 0 1065.6 414.65 329.83 105 0 0 IT10864_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150041 394 0 -1462 -1201 11 256 0 0 IT10800_ACTORDEF 21 1112 0 0 0 0 0 1 0 0 0 0
150042 394 0 -1510 -1201 11 0 0 0 IT10800_ACTORDEF 21 1112 0 0 0 0 0 1 0 0 0 0
150043 394 0 -1550.38 -1469.11 31 128 0 0 IT10865_ACTORDEF 15 1114 0 0 0 0 0 1 0 0 0 0
150044 394 0 -1527.14 -1469.11 31 128 0 0 IT10865_ACTORDEF 15 1114 0 0 0 0 0 1 0 0 0 0
150045 394 0 -1502 -1430 31 384 0 0 IT10802_ACTORDEF 16 892 0 0 0 0 0 1 0 0 0 0
150046 394 0 -1502 -1470 31 249 0 0 IT10802_ACTORDEF 16 892 0 0 0 0 0 1 0 0 0 0
150047 394 0 -1449 -1200 11 0 0 0 IT10801_ACTORDEF 22 1113 0 0 0 0 0 1 0 0 0 0
150048 394 0 -1521 -1200 11 0 0 0 IT10801_ACTORDEF 22 1113 0 0 0 0 0 1 0 0 0 0
150049 394 0 -1513.35 -1096.09 11 387 0 0 IT10864_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150050 394 0 -1453.69 -1097.12 11 378 0 0 IT10864_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150051 394 0 -1485.52 -1088.52 11 381 0 0 IT10863_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150052 394 0 -1526.07 -1046.04 26 381 0 0 IT10863_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150053 394 0 -1444.61 -1046.04 26 381 0 0 IT10863_ACTORDEF 17 1115 0 0 0 0 0 1 0 0 0 0
150054 394 0 -1644 -1167 -57 83 0 0 IT10805_ACTORDEF 15 1114 0 0 0 0 0 1 0 0 0 0
150055 394 0 -1606 -1146 -90 214 0 0 IT10805_ACTORDEF 15 1114 0 0 0 0 0 1 0 0 0 0
150059 394 0 -9 -30 -3 0 0 0 POKTELE500 255 0 0 0 0 0 0 0 0 0 0 0
If we had the packet collectors working, it would have made easy work of getting this info into the database. Unfortunately since they don't work yet, I had to convert each one by hand. Luckily between using notepad++ and textpad macros, I was able to automate a good portion of the process. Then, I still had to convert each loc using winhex. After that, it just took some minor testing and adjustments where needed to tie triggers to lifts, and to get the waterwheels to rotate properly and such.
I meant to post these for you when you first asked the question, but had read it from work and wanted to post the actual MySQL to make it easier, and I don't have access to that from work. At work again, so I still don't have the mysql, but this info shouldn't be too hard for you to get into your tables if you use Navicat.
I have been waiting to see if PEQ ever starts work on SoF to post more of the zones I have done this for. It is only a few so far anyway. |
 |
|
 |
|
|
|
01-03-2010, 01:46 PM
|
 |
Demi-God
|
|
Join Date: May 2007
Location: b
Posts: 1,450
|
|
Objects:
Code:
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150002, 394, 0, -1614.06, -1242.72, 33.6, 328, 0, 0, 'IT10714_ACTORDEF', 53, 1142, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150040, 394, 0, 1065.6, 414.65, 329.83, 105, 0, 0, 'IT10864_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150041, 394, 0, -1462, -1201, 11, 256, 0, 0, 'IT10800_ACTORDEF', 21, 1112, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150042, 394, 0, -1510, -1201, 11, 0, 0, 0, 'IT10800_ACTORDEF', 21, 1112, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150043, 394, 0, -1550.38, -1469.11, 31, 128, 0, 0, 'IT10865_ACTORDEF', 15, 1114, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150044, 394, 0, -1527.14, -1469.11, 31, 128, 0, 0, 'IT10865_ACTORDEF', 15, 1114, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150045, 394, 0, -1502, -1430, 31, 384, 0, 0, 'IT10802_ACTORDEF', 16, 892, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150046, 394, 0, -1502, -1470, 31, 249, 0, 0, 'IT10802_ACTORDEF', 16, 892, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150047, 394, 0, -1449, -1200, 11, 0, 0, 0, 'IT10801_ACTORDEF', 22, 1113, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150048, 394, 0, -1521, -1200, 11, 0, 0, 0, 'IT10801_ACTORDEF', 22, 1113, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150049, 394, 0, -1513.35, -1096.09, 11, 387, 0, 0, 'IT10864_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150050, 394, 0, -1453.69, -1097.12, 11, 378, 0, 0, 'IT10864_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150051, 394, 0, -1485.52, -1088.52, 11, 381, 0, 0, 'IT10863_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150052, 394, 0, -1526.07, -1046.04, 26, 381, 0, 0, 'IT10863_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150053, 394, 0, -1444.61, -1046.04, 26, 381, 0, 0, 'IT10863_ACTORDEF', 17, 1115, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150054, 394, 0, -1644, -1167, -57, 83, 0, 0, 'IT10805_ACTORDEF', 15, 1114, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150055, 394, 0, -1606, -1146, -90, 214, 0, 0, 'IT10805_ACTORDEF', 15, 1114, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO object
(`id`, `zoneid`, `version`, `xpos`, `ypos`, `zpos`, `heading`, `itemid`, `charges`, `objectname`, `type`, `icon`, `unknown08`, `unknown10`, `unknown20`, `unknown24`, `unknown60`, `unknown64`, `unknown68`, `unknown72`, `unknown76`, `unknown84`)
VALUES
(150059, 394, 0, -9, -30, -3, 0, 0, 0, 'POKTELE500 ', 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Doors
Code:
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13217, 1, 'crescent ', 0, 'OBJ_ELEV ', -1307.99, -1541.54, -89.5, 0, 59, 0, 0, 0, 0, 0, 255, 3, 100, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13218, 2, 'crescent ', 0, 'OBJ_ELEV ', -1307.96, -1390.32, 11, 0, 59, 0, 0, 0, 0, 0, 255, 0, 100, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13219, 3, 'crescent ', 0, 'OBJ_GEARSB ', -1316.5, -1541.35, -93.25, 256, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 458, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13220, 4, 'crescent ', 0, 'OBJ_GEARSB ', -1299.59, -1541.26, -93.25, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 184, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13221, 5, 'crescent ', 0, 'OBJ_GEARSB ', -1316.3, -1390.32, 6.69013, 256, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 190, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13222, 6, 'crescent ', 0, 'OBJ_GEARSB ', -1299.43, -1390.26, 7.0403, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 99, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13223, 7, 'crescent ', 0, 'OBJ_LIFT ', -192.098, -573.474, -68.899, 128, 59, 0, 0, 0, 0, 0, 255, 0, 144, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13224, 8, 'crescent ', 0, 'OBJ_LIFT ', -192.099, -734.161, -69, 384, 59, 0, 0, 0, 0, 0, 255, 0, 144, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13225, 9, 'crescent ', 0, 'OBJ_PADDLE ', 340.251, -2166.94, -94.188, 256, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 174, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13226, 10, 'crescent ', 0, 'OBJ_ELEV_BUTTON ', -1318.24, -1531.51, -87, 0, 59, 0, 0, 0, 0, 1, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13227, 11, 'crescent ', 0, 'OBJ_ELEV_BUTTON ', -1318.31, -1531.44, 13, 63, 59, 0, 0, 0, 0, 1, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13228, 12, 'crescent ', 0, 'OBJ_ELEV_BUTTON ', -1318.12, -1380.19, 13.5, 0, 59, 0, 0, 0, 0, 2, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13229, 13, 'crescent ', 0, 'OBJ_ELEV_BUTTON ', -1318.82, -1379.75, 114.25, 0, 59, 0, 0, 0, 0, 2, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13230, 14, 'crescent ', 0, 'OBJ_LIFT_BUTTON ', -187.096, -587.703, -64.25, 64, 59, 0, 0, 0, 0, 7, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13231, 15, 'crescent ', 0, 'OBJ_LIFT_BUTTON ', -178.712, -586.536, 79, 0, 59, 0, 0, 0, 0, 7, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13232, 16, 'crescent ', 0, 'OBJ_LIFT_BUTTON ', -187.096, -720.01, -64.5, 474, 59, 0, 0, 0, 0, 8, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13233, 17, 'crescent ', 0, 'OBJ_LIFT_BUTTON ', -178.73, -721.043, 79.5, 0, 59, 0, 0, 0, 0, 8, 1, 0, 1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13234, 18, 'crescent ', 0, 'OBJ_OGRESKELETON ', -1239.01, -226.163, 123.218, 384, 59, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13235, 19, 'crescent ', 0, 'OBJ_WATERWHEELMOUNT ', -419.528, -1864.41, -120, 73, 55, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13236, 20, 'crescent ', 0, 'OBJ_WATERWHEEL ', -419.778, -1863.66, -120, 202, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 68, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13237, 21, 'crescent ', 0, 'OBJ_WATERWHEELMOUNT ', -116.58, -2077.51, -115.75, 384, 55, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13238, 22, 'crescent ', 0, 'OBJ_WATERWHEEL ', -116.58, -2077.51, -115.75, 256, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 290, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13239, 23, 'crescent ', 0, 'OBJ_STILL_BARREL ', -1147.62, -1605.04, -85.5, 0, 55, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13240, 24, 'crescent ', 0, 'OBJ_STILL_BARREL ', -1166, -1642.4, -52.7, 507, 55, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13241, 25, 'crescent ', 0, 'OBJ_CRDOOR ', -1577.62, -1530.56, -90.255, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13242, 26, 'crescent ', 0, 'OBJ_CRDOOR ', -1643.28, -1530.56, -70.578, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13243, 27, 'crescent ', 0, 'OBJ_CRDOOR ', -1633.67, -1550.86, -70.578, 128, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13244, 28, 'crescent ', 0, 'OBJ_CRDOOR ', -1600.38, -1550.86, -70.578, 128, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13245, 29, 'crescent ', 0, 'OBJ_CRDOOR ', -1609.97, -1530.56, -70.578, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13246, 30, 'crescent ', 0, 'OBJ_CRDOOR ', -1567.14, -1550.82, -70.578, 128, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13247, 31, 'crescent ', 0, 'OBJ_CRDOOR ', -1576.73, -1530.57, -70.578, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13248, 32, 'crescent ', 0, 'OBJ_CRDOOR ', -1568.04, -1550.84, -90.255, 125, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13249, 33, 'crescent ', 0, 'OBJ_CRDOOR ', -1610.85, -1530.66, -90.255, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13250, 34, 'crescent ', 0, 'OBJ_CRDOOR ', -1601.29, -1550.84, -90.255, 128, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13251, 35, 'crescent ', 0, 'OBJ_CRDOOR ', -1644.13, -1530.57, -90.255, 384, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13252, 36, 'crescent ', 0, 'OBJ_CRDOOR ', -1634.56, -1550.82, -90.255, 126, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, , 0, 0, 0, 0, 100, 0, 0);
|
|
|
|
|
|
|
01-03-2010, 10:30 PM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
You both kick so much Arse right now.
1. for you Trev posting that, which is 100% usable by me since I understand mysql very well.
2. for you secrets of posting the sql parts.
That is much more than I expected, I was only trying to get the two lifts inside and the two lifts outside, but the fact you gave me the doors and objects is just amazing!!! If I could give you a high five, this would be the time!
You guys really made my day coming home from a 10.5 hour shift at work dealing with customers at my tech support job by saving me so much time, those doors and objects was next on my list since I noticed random fire in the middle of the room and other missing items.
Again, thank you both SO MUCH.
p.s. when I get some really cool stuff done with the TSS zones I am working with I will get them posted (I have two more zone lines to get to work properly for TSS zones, but for the most part they are 96% complete and ready to use by anyone. Stonehive zone line is giving me a rough time, cant get it to work, think I might be using an invis 240 race guy as a teleporter when someone enters his proximity, when I get that done I'll post.)
|
|
|
|
01-03-2010, 11:25 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Quote:
Originally Posted by Thovar
Stonehive zone line is giving me a rough time, cant get it to work, think I might be using an invis 240 race guy as a teleporter when someone enters his proximity, when I get that done I'll post.)
|
Yeah, I couldn't figure out Stone Hive zone line either, so I just had to use an invis guy with a proximity to simulate it just like you are saying.
Also, you do know that there are doors and lifts in Stone Hive as well, right? :P |
01-04-2010, 10:42 AM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
Hrmm, wasn't aware of any lifts in stone hive, never ventured too far in since I couldnt get the zone line to work... great LOL. I hope getting doors and lifts in wont be impossible like the stupid zone line.
Luckily I have a script for the teleport man so all hope is not lost. I did get the door to vergalids mine to work both ways and since I found out how to do lifts in crescent reach I will be adding in the one in the mine as well and the one(s) in stonehive if I can get them to work. thanks for the heads up on stonehive. Looks like the Super Ultra Mega Bixie Queen of the Stone will have to wait to be spawned.
|
01-04-2010, 01:49 PM
|
|
Sarnak
|
|
Join Date: Oct 2009
Posts: 35
|
|
I got an error on line four when I tried importing the one for doors and I still have nothing. I am learning but my knowledge of this is still very limited so I wasnt surprised when I couldnt find anything wrong. =)
Found a script for the inviz zone line guy... I should put something like that in neriak because my nektulos forest is apparently fubared.
Last edited by Tilar; 01-04-2010 at 02:06 PM..
Reason: Found the script.
|
01-04-2010, 09:21 PM
|
|
Fire Beetle
|
|
Join Date: Aug 2009
Location: -
Posts: 10
|
|
Quote:
Originally Posted by Tilar
I got an error on line four when I tried importing the one for doors and I still have nothing.
|
Quote:
|
Originally Posted by Secrets
INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
VALUES
(13252, 36, 'crescent ', 0, 'OBJ_CRDOOR ', -1634.56, -1550.82, -90.255, 126, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, , 0, 0, 0, 0, 100, 0, 0);
|
I see a missing '0' in here, should be :
VALUES
(13252, 36, 'crescent ', 0, 'OBJ_CRDOOR ', -1634.56, -1550.82, -90.255, 126, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 100, 0, 0);
I think. |
01-04-2010, 10:10 PM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
@Tilar....
Teleport man code
Code:
sub EVENT_SPAWN
{
$x = $npc->GetX();
$y = $npc->GetY();
quest::set_proximity($x - 100, $x + 100, $y - 100, $y + 100);
}
sub EVENT_ENTER
{
quest::movepc(zoneID, x, y, z, heading);
}
its that easy. just name it the NPCID.pl... so example would be 100999.pl put in the right zone for that NPC. Also for nektulos being fubared... make sure you have the right client map being used when playing in EQ. find nektulos.egq and rename it to .bak instead. that is the usual fix. |
01-05-2010, 10:52 PM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
Error in SQL.
Well not a "real" error, but each of the line you made Secrets all have an extra space in them, which in turn makes mysql think the name of the object and zone is "OBJ_LIFT_" instead of just "OBJ_LIFT" so if anyone is going to copy and paste the above, take out the spaces in all the names. I still say "thank you" for making these easy for everyone to input into their own DB's
Notice all the spaces...
Code:
(13220, 4, 'crescent ', 0, 'OBJ_GEARSB ', -1299.59, -1541.26, -93.25, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 184, 100, 0);
so they should all be...
Code:
(13220,4,'crescent',0,'OBJ_GEARSB',-1299.59,-1541.26,-93.25,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,184,100,0);
They will work if you take out the spaces. in ALL of them.
Once Again, thank you Trevius AND secrets!!! |
01-09-2010, 05:09 PM
|
|
Sarnak
|
|
Join Date: Oct 2009
Posts: 35
|
|
Thanks Thovar, I appreciate that!
I did get into a strange version of Nek forest before I got the old one working. I started playing EQ back in 99 within a couple weeks
of release and have never seen this version of Nektulos. Very small zone, probably less than 1/3 the size of the regular zone.
Anyone see any of this before?
 |
|
|
|
01-09-2010, 05:21 PM
|
|
Sarnak
|
|
Join Date: Oct 2009
Posts: 35
|
|
Quote:
Originally Posted by Thovar
Well not a "real" error, but each of the line you made Secrets all have an extra space in them, which in turn makes mysql think the name of the object and zone is "OBJ_LIFT_" instead of just "OBJ_LIFT" so if anyone is going to copy and paste the above, take out the spaces in all the names. I still say "thank you" for making these easy for everyone to input into their own DB's
Notice all the spaces...
Code:
(13220, 4, 'crescent ', 0, 'OBJ_GEARSB ', -1299.59, -1541.26, -93.25, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 184, 100, 0);
so they should all be...
Code:
(13220,4,'crescent',0,'OBJ_GEARSB',-1299.59,-1541.26,-93.25,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,184,100,0);
They will work if you take out the spaces. in ALL of them.
Once Again, thank you Trevius AND secrets!!! |
So should it look like this? I have a "notepad" replacement that I use that makes this easy.
Object
Code:
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150002,394,0,-1614.06,-1242.72,33.6,328,0,0,'IT10714_ACTORDEF',53,1142,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150040,394,0,1065.6,414.65,329.83,105,0,0,'IT10864_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150041,394,0,-1462,-1201,11,256,0,0,'IT10800_ACTORDEF',21,1112,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150042,394,0,-1510,-1201,11,0,0,0,'IT10800_ACTORDEF',21,1112,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150043,394,0,-1550.38,-1469.11,31,128,0,0,'IT10865_ACTORDEF',15,1114,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150044,394,0,-1527.14,-1469.11,31,128,0,0,'IT10865_ACTORDEF',15,1114,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150045,394,0,-1502,-1430,31,384,0,0,'IT10802_ACTORDEF',16,892,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150046,394,0,-1502,-1470,31,249,0,0,'IT10802_ACTORDEF',16,892,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150047,394,0,-1449,-1200,11,0,0,0,'IT10801_ACTORDEF',22,1113,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150048,394,0,-1521,-1200,11,0,0,0,'IT10801_ACTORDEF',22,1113,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150049,394,0,-1513.35,-1096.09,11,387,0,0,'IT10864_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150050,394,0,-1453.69,-1097.12,11,378,0,0,'IT10864_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150051,394,0,-1485.52,-1088.52,11,381,0,0,'IT10863_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150052,394,0,-1526.07,-1046.04,26,381,0,0,'IT10863_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150053,394,0,-1444.61,-1046.04,26,381,0,0,'IT10863_ACTORDEF',17,1115,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150054,394,0,-1644,-1167,-57,83,0,0,'IT10805_ACTORDEF',15,1114,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150055,394,0,-1606,-1146,-90,214,0,0,'IT10805_ACTORDEF',15,1114,0,0,0,0,0,1,0,0,0,0);
INSERT INTO object
(`id`,`zoneid`,`version`,`xpos`,`ypos`,`zpos`,`heading`,`itemid`,`charges`,`objectname`,`type`,`icon`,`unknown08`,`unknown10`,`unknown20`,`unknown24`,`unknown60`,`unknown64`,`unknown68`,`unknown72`,`unknown76`,`unknown84`)
VALUES
(150059,394,0,-9,-30,-3,0,0,0,'POKTELE500',255,0,0,0,0,0,0,0,0,0,0,0);
Doors
Code:
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13217,1,'crescent',0,'OBJ_ELEV',-1307.99,-1541.54,-89.5,0,59,0,0,0,0,0,255,3,100,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13218,2,'crescent',0,'OBJ_ELEV',-1307.96,-1390.32,11,0,59,0,0,0,0,0,255,0,100,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13219,3,'crescent',0,'OBJ_GEARSB',-1316.5,-1541.35,-93.25,256,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,458,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13220,4,'crescent',0,'OBJ_GEARSB',-1299.59,-1541.26,-93.25,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,184,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13221,5,'crescent',0,'OBJ_GEARSB',-1316.3,-1390.32,6.69013,256,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,190,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13222,6,'crescent',0,'OBJ_GEARSB',-1299.43,-1390.26,7.0403,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,99,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13223,7,'crescent',0,'OBJ_LIFT',-192.098,-573.474,-68.899,128,59,0,0,0,0,0,255,0,144,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13224,8,'crescent',0,'OBJ_LIFT',-192.099,-734.161,-69,384,59,0,0,0,0,0,255,0,144,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13225,9,'crescent',0,'OBJ_PADDLE',340.251,-2166.94,-94.188,256,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,174,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13226,10,'crescent',0,'OBJ_ELEV_BUTTON',-1318.24,-1531.51,-87,0,59,0,0,0,0,1,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13227,11,'crescent',0,'OBJ_ELEV_BUTTON',-1318.31,-1531.44,13,63,59,0,0,0,0,1,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13228,12,'crescent',0,'OBJ_ELEV_BUTTON',-1318.12,-1380.19,13.5,0,59,0,0,0,0,2,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13229,13,'crescent',0,'OBJ_ELEV_BUTTON',-1318.82,-1379.75,114.25,0,59,0,0,0,0,2,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13230,14,'crescent',0,'OBJ_LIFT_BUTTON',-187.096,-587.703,-64.25,64,59,0,0,0,0,7,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13231,15,'crescent',0,'OBJ_LIFT_BUTTON',-178.712,-586.536,79,0,59,0,0,0,0,7,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13232,16,'crescent',0,'OBJ_LIFT_BUTTON',-187.096,-720.01,-64.5,474,59,0,0,0,0,8,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13233,17,'crescent',0,'OBJ_LIFT_BUTTON',-178.73,-721.043,79.5,0,59,0,0,0,0,8,1,0,1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13234,18,'crescent',0,'OBJ_OGRESKELETON',-1239.01,-226.163,123.218,384,59,0,0,0,0,0,0,0,0,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13235,19,'crescent',0,'OBJ_WATERWHEELMOUNT',-419.528,-1864.41,-120,73,55,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13236,20,'crescent',0,'OBJ_WATERWHEEL',-419.778,-1863.66,-120,202,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,68,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13237,21,'crescent',0,'OBJ_WATERWHEELMOUNT',-116.58,-2077.51,-115.75,384,55,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13238,22,'crescent',0,'OBJ_WATERWHEEL',-116.58,-2077.51,-115.75,256,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,290,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13239,23,'crescent',0,'OBJ_STILL_BARREL',-1147.62,-1605.04,-85.5,0,55,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13240,24,'crescent',0,'OBJ_STILL_BARREL',-1166,-1642.4,-52.7,507,55,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13241,25,'crescent',0,'OBJ_CRDOOR',-1577.62,-1530.56,-90.255,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13242,26,'crescent',0,'OBJ_CRDOOR',-1643.28,-1530.56,-70.578,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13243,27,'crescent',0,'OBJ_CRDOOR',-1633.67,-1550.86,-70.578,128,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13244,28,'crescent',0,'OBJ_CRDOOR',-1600.38,-1550.86,-70.578,128,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13245,29,'crescent',0,'OBJ_CRDOOR',-1609.97,-1530.56,-70.578,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13246,30,'crescent',0,'OBJ_CRDOOR',-1567.14,-1550.82,-70.578,128,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13247,31,'crescent',0,'OBJ_CRDOOR',-1576.73,-1530.57,-70.578,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13248,32,'crescent',0,'OBJ_CRDOOR',-1568.04,-1550.84,-90.255,125,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13249,33,'crescent',0,'OBJ_CRDOOR',-1610.85,-1530.66,-90.255,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13250,34,'crescent',0,'OBJ_CRDOOR',-1601.29,-1550.84,-90.255,128,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13251,35,'crescent',0,'OBJ_CRDOOR',-1644.13,-1530.57,-90.255,384,0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,0,100,0);
INSERT INTO doors
(`id`,`doorid`,`zone`,`version`,`name`,`pos_y`,`pos_x`,`pos_z`,`heading`,`opentype`,`guild`,`lockpick`,`keyitem`,`nokeyring`,`triggerdoor`,`triggertype`,`doorisopen`,`door_param`,`dest_zone`,`dest_x`,`dest_y`,`dest_z`,`dest_heading`,`invert_state`,`incline`,`size`,`buffer`,`is_ldon_door`)
VALUES
(13252,36,'crescent',0,'OBJ_CRDOOR',-1634.56,-1550.82,-90.255,126,0,0,0,0,0,0,0,0,-1,'NONE',0,,0,0,0,0,100,0,0);
|
|
|
|
01-10-2010, 12:55 AM
|
|
Sarnak
|
|
Join Date: Nov 2009
Posts: 41
|
|
Yes!!! that is perfect! and yes... that version is the strange version, shaped kinda odd... looks like the hidden forest hub zone, although, they use an instance that was directly off that zone before they revamped nek for the 3rd time and took out that monster mission from DODH
|
|
|
|
01-10-2010, 01:01 AM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Here are the doors for StoneHive:
Code:
id doorid zone version name pos_y pos_x pos_z heading opentype guild lockpick keyitem nokeyring triggerdoor triggertype doorisopen door_param dest_zone dest_x dest_y dest_z dest_heading is_ldon_door invert_state incline size buffer
13608 100 stonehive 0 POKTELE500 0 -1322 40.1 128 58 0 0 0 0 0 0 0 0 freeporttemple 115 160 4 128 0 0 0 50 0
13610 21 stonehive 0 OBJ_CATACOMB_FLOOR 131.763 -107.927 408.526 238 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 20 0
13611 22 stonehive 0 OBJ_CATACOMB_FLOOR 12.0181 -102.553 408.587 0 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 20 0
13612 1 stonehive 0 OBJ_ELEVATOR 185.97 22.1013 115.093 416 59 0 0 0 0 0 255 0 148 NONE 0 0 0 0 0 0 0 100 0
13613 2 stonehive 0 OBJ_ELEVATOR_QUEEN -0.305932 49.228 282.6 160 59 0 0 0 0 0 255 0 105 NONE 0 0 0 0 0 0 0 100 0
13614 3 stonehive 0 OBJ_ELVTR_LEVER 190.313 39.6279 118.941 380 40 0 0 0 0 1 1 0 -1 NONE 0 0 0 0 0 0 0 100 0
13615 4 stonehive 0 OBJ_ELVTR_LEVER 181.25 3.78411 266.91 127 40 0 0 0 0 1 1 0 -1 NONE 0 0 0 0 0 0 3 100 0
13616 5 stonehive 0 OBJ_ELVTR_LEVER -8.26514 37.743 286.146 128 40 0 0 0 0 2 1 0 -1 NONE 0 0 0 0 0 0 0 100 0
13617 6 stonehive 0 OBJ_ELVTR_LEVER 6.49183 60.197 390.959 384 40 0 0 0 0 2 1 0 -1 NONE 0 0 0 0 0 0 0 100 0
13618 7 stonehive 0 OBJ_HARVEST_GATE -54.55 143.998 276.47 384 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13619 8 stonehive 0 OBJ_HARVEST_GATE -54.533 167.927 276.384 384 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13620 9 stonehive 0 OBJ_HARVEST_GATE -54.5426 191.926 276.384 384 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13621 10 stonehive 0 OBJ_HARVEST_GATE -33.5929 210.376 276.412 256 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13622 11 stonehive 0 OBJ_HARVEST_GATE -12.6385 191.954 276.384 128 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13623 12 stonehive 0 OBJ_HARVEST_GATE -12.5981 168.017 276.384 128 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13624 13 stonehive 0 OBJ_HARVEST_GATE -12.5927 143.977 276.384 128 66 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 100 0
13625 14 stonehive 0 OBJ_HARVEST_CENTER 36.75 -68 394 128 59 0 0 0 0 0 0 0 7 NONE 0 0 0 0 0 0 0 70 0
13626 15 stonehive 0 OBJ_HARVEST_DRNSML 105.75 -123 401 289 59 0 0 0 0 0 0 0 6 NONE 0 0 0 0 0 0 0 120 0
13627 16 stonehive 0 OBJ_HARVEST_DRNSML 37 -123 401 205 59 0 0 0 0 0 0 0 6 NONE 0 0 0 0 0 0 0 120 0
13628 17 stonehive 0 OBJ_HARVEST_CENTER 106.5 -68 394 384 59 0 0 0 0 0 0 0 7 NONE 0 0 0 0 0 0 0 70 0
13629 18 stonehive 0 OBJ_HARVEST_CENTER 41.75 -30 394 80 59 0 0 0 0 0 0 0 7 NONE 0 0 0 0 0 0 0 70 0
13630 19 stonehive 0 OBJ_HARVEST_CENTER 101.25 -30 394 432 59 0 0 0 0 0 0 0 7 NONE 0 0 0 0 0 0 0 70 0
13631 20 stonehive 0 OBJ_CATACOMB_FLOOR 74.7372 -173.291 411.324 128 55 0 0 0 0 0 0 0 -1 NONE 0 0 0 0 0 0 0 40 0
I don't recall there being any objects in the zone. Oh, BTW, I think the objects in Crescent that I posted have 2 PoKBooks that are not actually in the official zone. I added those in later for some custom travel stuff I was working on. So, you can remove those easy enough if you don't need them.. |
|
|
|
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 08:22 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
