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);
|