Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building
Reload this Page Crescent Reach Lifts... anyone have?

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2010, 10:52 PM
Thovar
Sarnak
  
Join Date: Nov 2009
Posts: 41
Default 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!!!
__________________
~Thovar
GM of http://www.beradingoldbeard.info/
Reply With Quote
  #2  
Old 01-09-2010, 05:21 PM
Tilar
Sarnak
  
Join Date: Oct 2009
Posts: 35
Default
Quote:
Originally Posted by Thovar View Post
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);
Reply With Quote
  #3  
Old 01-10-2010, 12:55 AM
Thovar
Sarnak
  
Join Date: Nov 2009
Posts: 41
Default
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
__________________
~Thovar
GM of http://www.beradingoldbeard.info/
Reply With Quote
  #4  
Old 01-10-2010, 01:01 AM
trevius's Avatar
trevius
Developer
  
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default
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..
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #5  
Old 01-10-2010, 01:50 AM
Thovar
Sarnak
  
Join Date: Nov 2009
Posts: 41
Default
Trev, you kick ass. simply put. ya I noticed those books and removed them before I sourced everything into my DB since I put the book in the blood moors near the crescent reach zone.

I remember having to run from CR to the book in live and it pissing me off cause it was soooo far away as opposed to ALL of the other cities books. thats why I love what I am doing with my server, fixing all the lil things like that as well as adding in some pretty cool custom stuff.

I have plenty more months before I open mine up to the public...

/whisper many secrets to unfold when that happens, hehe.

Question Trev... is that POK book you put in Stone Hive in the official zone? i dont recall that in live.
__________________
~Thovar
GM of http://www.beradingoldbeard.info/
Reply With Quote
  #6  
Old 01-10-2010, 10:38 PM
trevius's Avatar
trevius
Developer
  
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default
Oh, no, that one isn't in there either. I forgot about that lol. It does kinda look natural there though, huh? :P I have made Freeporttemple into a new SoF hub zone for my server and am making a teleport system similar to PoK for getting around to custom zones. I figure it will change things up a bit from the standard hub zone full of port NPCs.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #7  
Old 01-10-2010, 11:39 PM
Thovar
Sarnak
  
Join Date: Nov 2009
Posts: 41
Default
Its all good. I am highly greatful for it even if i dont need it because it came with stuff I can use 100%.

Thanks again! I really mean it.

I am working on finishing up some lore for EQ, namely two zones. Neriak D and Nektropos. I just need to do more research on them. If I create them would you like them as well?
__________________
~Thovar
GM of http://www.beradingoldbeard.info/
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode 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
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 04:19 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3