|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
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: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.. |
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
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 09:58 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
