object extractor

[sysadmin]

database dumps made with object tractor, check tools forum for extractor updates.

[Cisyouc]

What do you mean by logs?

[sysadmin]

packet collector logs

[Teppen]

one thing I dont understand is....

how are you using packet collector logs if the current packet collector is broken, and there hasnt been a working with live release?

[sysadmin]

I am using the packet collector files that are available. The new zones that have not been packet collected will have to wait until the packet collector gets fixed. I am just trying to help out peq and server ops place stuff and fix broken ports with the data that is available.

[solid11]

Anyway you can post sql fixes for zones that you have or is that askin too much? hehe

[sysadmin]

i have a bunch, but since I am working on fixing the ports which involves 2 tables(doors and zonepoints) some are screwed up. if you want to test them here I am posting Bot and PoT. Just remember to make a backup before you source this

Potranquility Sample dump

NOTE:
- Dump was made with beta 1.12
- I renumbered the ID's to 10400+
- Includes teleport support
- Renumbered door id's



INSERT INTO doors VALUES
(10400, 1,'potranquility','POPCRATE501',1666.753,-1480.652,-774.867,154.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10401, 2,'potranquility','POPCRATE501',1793.197,-1478.321,-774.84,164.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10402, 3,'potranquility','POTORMFNT500',698.7,-1640.449,-912.358,0.0,58,0,0,0,0,0,0,18,'potorment',-341.0,1706.0,-490,0.0,0,0,100);

INSERT INTO doors VALUES
(10403, 4,'potranquility','POKTELE500',773.065,-1436.697,-880.159,375.0,57,0,0,0,0,0,0,77,'poknowledge',-285.0,-148.0,-158,383.0,0,0,100);

INSERT INTO doors VALUES
(10404, 5,'potranquility','FDOORSM302',569.54,-1481.746,-852.159,384.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10405, 6,'potranquility','FDOORSM302',698.773,-1613.556,-852.348,0.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10406, 7,'potranquility','FDOORSM302',698.752,-1613.772,-852.409,128.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10407, 8,'potranquility','FDOORSM302',836.734,-1492.876,-852.359,258.446,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10408, 9,'potranquility','FDOORSM302',836.835,-1482.277,-852.354,256.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10409, 10,'potranquility','CRATEG',-408.12,-1276.11,-905.997,256.0,53,0,0,0,0,0,0,105,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10410, 11,'potranquility','CRATEG',-408.152,-1253.175,-905.808,256.0,53,0,0,0,0,0,0,105,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10411, 12,'potranquility','CRATEG',-408.377,-1212.897,-905.877,256.0,53,0,0,0,0,0,0,105,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10412, 13,'potranquility','CRATEG',-408.788,-1173.835,-906.148,0.0,53,0,0,0,0,0,0,105,'NONE',0,0,0,0,0,0, 100);

INSERT INTO doors VALUES
(10413, 14,'potranquility','BOTPORT500',-688.957,1798.681,-929.279,482.0,58,0,0,0,0,0,0,25,'bothunder',178.0, 207.0,-1619,0.0,0,0,100);

INSERT INTO doors VALUES
(10414, 15,'potranquility','CRATEG',36.306,-644.637,-504.095,331.694,53,0,0,0,0,0,0,132,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10415, 16,'potranquility','CRATEG',12.848,-620.986,-504.095,101.86,53,0,0,0,0,0,0,132,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10416, 17,'potranquility','CRATEG',24.102,-620.809,-444.47,312.919,53,0,0,0,0,0,0,143,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10417, 18,'potranquility','POTPOJSC',50.403,-606.074,-524.422,450.0,58,0,0,0,0,0,0,47,'pojustice',58.0,-61.0, 6,127.0,0,0,100);

INSERT INTO doors VALUES
(10418, 19,'potranquility','TACTICPORT500',-152.579,-19.714,-618.342,491.124,58,0,0,0,0,0,0,21,'potactics',-210.0,10.0,-34,0.0,0,0,100);

INSERT INTO doors VALUES
(10419, 20,'potranquility','VALORPORT500',-163.279,20.024,-618.342,68.0,58,0,0,0,0,0,0,23,'hohonora',-2755.0,0.0, 1,128.0,0,0,100);

INSERT INTO doors VALUES
(10420, 21,'potranquility','SOLROPORT500',-202.877,30.985,-618.342,148.0,58,0,0,0,0,0,0,26,'solrotower',-1.0,-2915.0,-765,0.0,0,0,100);

INSERT INTO doors VALUES
(10421, 22,'potranquility','HONORPORT500',-231.806,1.724,-618.342,232.626,58,0,0,0,0,0,0,22,'povalor',190.0,-1668.0, 66,0.0,0,0,100);

INSERT INTO doors VALUES
(10422, 23,'potranquility','WARPORT500',-220.714,-38.235,-618.342,313.915,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10423, 24,'potranquility','INVISWITCH500',-2257.111,1220.236,-905.925,151.811,58,0,0,0,0,0,0,1,'potimea',223.0,1 40.0, 10,350.0,0,0,100);

INSERT INTO doors VALUES
(10424, 25,'potranquility','POTRANRAIN500',-720.949,1230.399,-828.466,229.59,58,0,0,0,0,0,0,24,'postorms',-1795.0,-2059.0,-472,0.0,0,0,100);

INSERT INTO doors VALUES
(10425, 26,'potranquility','POTRANCOD500',1888.217,-1093.798,-894.522,437.183,58,0,0,0,0,0,0,19,'codecay',-170.0,-65.0,-92,128.0,0,0,100);

INSERT INTO doors VALUES
(10426, 27,'potranquility','POTORMFNT501',701.042,-1650.096,-918.421,188.962,100,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10427, 28,'potranquility','CRATEG',-679.934,294.33,-800.366,231.479,53,0,0,0,0,0,0,143,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10428, 29,'potranquility','TRANWMBLAD500E',-1542.197,5.032,-896.745,370.368,58,0,0,0,0,0,0,37,'poinnovation',2 63.0,516.0,-52,187.0,0,0,100);

INSERT INTO doors VALUES
(10429, 30,'potranquility','TRANWMBLAD500E',-1553.782,5.282,-896.745,55.106,101,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10430, 31,'potranquility','TRANWMBLAD500E',-1554.464,25.532,-896.745,55.106,101,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10431, 32,'potranquility','TRANWMBLAD500E',-1542.637,25.782,-896.995,55.106,101,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10432, 33,'potranquility','TRANGWMBLAD500',-1548.004,16.608,-863.496,55.106,101,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10433, 34,'potranquility','TRANWMBLAD500C',-1548.636,136.624,-747.248,256.0,106,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10434, 35,'potranquility','TRANWMBLAD500B',-1548.017,16.192,-863.746,55.106,101,0,0,0,0,0,0,-3,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10435, 36,'potranquility','CRATEG',-678.021,284.061,-800.289,0.0,53,0,0,0,0,0,0,143,'NONE',0,0,0,0,0,0, 100);

INSERT INTO doors VALUES
(10436, 37,'potranquility','CRATEG',-679.573,272.723,-800.482,0.0,53,0,0,0,0,0,0,143,'NONE',0,0,0,0,0,0, 100);

INSERT INTO doors VALUES
(10437, 38,'potranquility','CRATEG',-681.035,260.32,-800.814,237.545,53,0,0,0,0,0,0,143,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10438, 39,'potranquility','CRATEG',-683.362,250.678,-798.577,67.161,53,0,0,0,0,0,0,143,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10439, 40,'potranquility','CRATEG',-705.69,248.505,-916.217,99.794,53,0,0,0,0,0,0,132,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10440, 41,'potranquility','CRATEG',-698.634,269.437,-910.924,105.914,53,0,0,0,0,0,0,132,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10441, 42,'potranquility','CRATEG',-693.366,287.63,-912.626,105.914,53,0,0,0,0,0,0,132,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10442, 43,'potranquility','POTRNQFIRE500',255.335,-2191.062,-913.81,55.106,101,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10443, 44,'potranquility','CRATEG',255.413,-2191.072,-913.06,274.769,53,0,0,0,0,0,0,112,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10444, 45,'potranquility','CRATEG',254.983,-2190.966,-903.06,1.853,53,0,0,0,0,0,0,105,'NONE',0,0,0,0,0,0 ,100);

INSERT INTO doors VALUES
(10445, 46,'potranquility','CRATEG',850.447,-688.51,-607.471,100.409,53,0,0,0,0,0,0,105,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10446, 47,'potranquility','CRATEG',49.79,-644.117,-444.975,320.0,53,0,0,0,0,0,0,143,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10447, 48,'potranquility','CRATEG',83.261,-602.92,-384.499,121.783,53,0,0,0,0,0,0,142,'NONE',0,0,0,0, 0,0,100);

INSERT INTO doors VALUES
(10448, 49,'potranquility','INVISWITCH500',-1547.763,16.462,-924.04,384.429,58,0,0,0,0,0,0,13,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10449, 50,'potranquility','VSBNI303',702.633,-1480.282,-873.214,6.543,100,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10450, 51,'potranquility','INVISWITCH10',703.068,-1479.837,-880.14,501.777,58,0,0,0,0,0,0,15,'NONE',0,0,0,0,0, 0,100);

INSERT INTO doors VALUES
(10451, 52,'potranquility','POTRANQROCK501',2042.878,-877.54,-704.923,452.0,59,0,0,0,0,0,0,0,'NONE',0,0,0,0,0,0, 100);

INSERT INTO doors VALUES
(10452, 53,'potranquility','POTRANQROCK501',2079.0,-899.0,-741.0,487.0,59,0,0,0,0,0,0,0,'NONE',0,0,0,0,0,0,10 0);

INSERT INTO doors VALUES
(10453, 54,'potranquility','POTRANBURN500',851.869,-687.5,-624.75,280.0,58,0,0,0,0,0,0,28,'poair',532.0,884.0 ,-89,0.0,0,0,100);

INSERT INTO doors VALUES
(10454, 55,'potranquility','POTRNQFIRE500',255.335,-2191.062,-913.81,256.0,58,0,0,0,0,0,0,29,'pofire',-1387.0,1210.0,-179,251.0,0,0,100);

INSERT INTO doors VALUES
(10455, 56,'potranquility','POTBLDR500',-1326.484,2211.333,-723.579,71.0,58,0,0,0,0,0,0,30,'poeartha',-1150.0,200.0, 72,0.0,0,0,100);

INSERT INTO doors VALUES
(10456, 57,'potranquility','POTPOWTRG500',-1161.25,960.5,-781.0,147.0,58,0,0,0,0,0,0,27,'powater',-93.0,-1234.0, 12,105.0,0,0,100);

INSERT INTO doors VALUES
(10457, 58,'potranquility','POTRHUT500W',-186.09,-1289.456,-913.794,503.0,58,0,0,0,0,0,0,57,'ponightmare',1668 .0,282.0, 213,5.0,0,0,100);

[sysadmin]

Here is bothunder.

Sample dump

NOTE:
- Dump was made with beta 1.12
- I renumbered the ID's to 10300+
- Includes teleport
- renumbered door id's




INSERT INTO doors VALUES
(10300, 1,'bothunder','BOTKDR501',-1756.002,-601.502,2354.002,130.411,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10301, 2,'bothunder','BOTKDR500',-1716.007,-601.007,2353.999,384.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10302, 3,'bothunder','CRATEG',285.409,37.145,1491.185,384 .967,53,0,0,0,0,0,0,180,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10303, 4,'bothunder','CRATEG',411.977,425.06,1188.362,134 .216,53,0,0,0,0,0,0,180,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10304, 5,'bothunder','CRATEG',-15.305,43.01,1110.388,9.638,53,0,0,0,0,0,0,180,'NO NE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10305, 6,'bothunder','CRATEG',86.434,78.718,661.598,259.1 18,53,0,0,0,0,0,0,180,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10306, 7,'bothunder','BOTPLPORT500',11.346,170.329,-647.998,0.0,57,0,0,0,0,0,0,38,'bothunder',-765.0,-1735.0, 1271,384.0,0,0,100);

INSERT INTO doors VALUES
(10307, 8,'bothunder','CRATEG',267.978,68.011,749.948,252. 447,53,0,0,0,0,0,0,180,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10308, 9,'bothunder','BOTPOSPORT500',-319.929,-234.995,-639.696,160.0,58,0,0,0,0,0,0,10,'bothunder',0.0,0. 0,-1549,256.0,0,0,100);

INSERT INTO doors VALUES
(10309, 10,'bothunder','BOTPOSPORT500',-384.93,-169.512,-639.696,160.69,58,0,0,0,0,0,0,37,'bothunder',85.0, 145.0, 636,128.0,0,0,100);

INSERT INTO doors VALUES
(10310, 11,'bothunder','BOTPOSPORT500',-397.111,500.075,-639.291,32.0,58,0,0,0,0,0,0,15,'bothunder',0.0,0.0 ,-1549,128.0,0,0,100);

INSERT INTO doors VALUES
(10311, 12,'bothunder','BOTPOSPORT500',-331.488,562.407,-639.291,32.0,58,0,0,0,0,0,0,35,'bothunder',-830.0,-865.0, 1376,128.0,0,0,100);

INSERT INTO doors VALUES
(10312, 13,'bothunder','BOTPOSPORT500',351.213,564.116,-638.755,416.0,58,0,0,0,0,0,0,17,'bothunder',0.0,0. 0,-1549,0.0,0,0,100);

INSERT INTO doors VALUES
(10313, 14,'bothunder','BOTPOSPORT500',417.583,501.435,-638.755,416.0,58,0,0,0,0,0,0,36,'bothunder',-350.0,-2200.0, 1956,256.0,0,0,100);

INSERT INTO doors VALUES
(10314, 15,'bothunder','BOTPOSPORT500',419.288,-165.639,-638.154,289.0,58,0,0,0,0,0,0,16,'bothunder',0.0,0. 0,-1549,128.0,0,0,100);

INSERT INTO doors VALUES
(10315, 16,'bothunder','BOTPOSPORT500',355.3,-230.36,-638.154,289.0,58,0,0,0,0,0,0,34,'bothunder',150.0,-1220.0, 1121,128.0,0,0,100);

INSERT INTO doors VALUES
(10316, 17,'bothunder','BOTPOSPORT500',258.88,180.577,-1629.998,352.0,58,0,0,0,0,0,0,42,'potranquility',1 740.0,-720.0,-930,348.0,0,0,100);

[sysadmin]

Bazaar:

NOTE:
- Dump was made with beta 1.12
- I renumbered the ID's to 10500+
- Renumbered door id's



INSERT INTO doors VALUES
(10500, 1,'bazaar','BAZIGATE302',16.0,290.003,-49.998,128.132,71,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10501, 2,'bazaar','BAZIGATE302',15.01,268.005,-49.998,256.0,71,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10502, 3,'bazaar','BAZIGATE302',30.995,281.998,-49.998,0.0,71,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10503, 4,'bazaar','BAZIGATE303',-26.501,-150.001,-69.948,384.223,66,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10504, 5,'bazaar','BAZIGATE303',-47.469,142.017,-70.098,128.0,66,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10505, 6,'bazaar','BAZIGATE303',95.466,-303.996,-39.998,384.677,71,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10506, 7,'bazaar','FDOORSL301',-751.994,-229.628,1.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10507, 8,'bazaar','FDOORSL301',-737.984,-170.397,1.002,384.216,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES
(10508, 9,'bazaar','FDOORSL301',-789.961,129.653,1.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

[sysadmin]

Shadowhaven Part1:

NOTE:
- Split on 2 parts because it is too long.
- Dump was made with beta 1.12
- I renumbered the ID's to 10550+
- Include teleport support
- Renumberd door id's

[QUOTEINSERT INTO doors VALUES
(10550, 1,'shadowhaven','FDOORSL301',-11.746,458.197,-13.608,384.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10551, 2,'shadowhaven','HODOOR301',-787.385,1602.727,-62.798,440.792,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10552, 3,'shadowhaven','HODOOR301',-740.975,1720.134,-62.79,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10553, 4,'shadowhaven','HSHDTREE301',189.481,1263.988,-115.198,126.228,58,0,0,0,0,0,0,6,'shadowhaven',130 0.0,190.0,-54,999.0,0,0,100);

INSERT INTO doors VALUES
(10554, 5,'shadowhaven','FDOORSS302',-348.011,1610.589,-59.998,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10555, 6,'shadowhaven','FDOORSS302',-450.03,1795.646,-59.998,128.38,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10556, 7,'shadowhaven','FDOORSS301',-489.015,1799.58,-59.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10557, 8,'shadowhaven','FDOORSS301',-575.974,1821.721,-59.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10558, 9,'shadowhaven','FDOORSS301',-571.946,1841.58,-59.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10559, 10,'shadowhaven','FDOORSS302',-607.991,1841.741,-59.998,128.603,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10560, 11,'shadowhaven','FDOORSS302',-603.97,1821.788,-59.998,128.543,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10561, 12,'shadowhaven','FDOORSS301',-321.007,1475.275,-36.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10562, 13,'shadowhaven','FDOORSM303',-25.018,1730.755,-58.998,128.608,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10563, 14,'shadowhaven','FDOORSM303',-71.0,1730.752,-58.998,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10564, 15,'shadowhaven','FDOORSM301',-53.999,1706.271,-58.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10565, 16,'shadowhaven','FDOORSM301',-7.971,1706.27,-58.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10566, 17,'shadowhaven','FDOORSM303',48.153,1725.033,-58.998,256.552,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10567, 18,'shadowhaven','FDOORSM301',76.989,1780.878,-58.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10568, 19,'shadowhaven','FMDOOR301',150.002,1780.663,-58.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10569, 20,'shadowhaven','FDOORSL304',215.988,1780.848,-58.998,128.116,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10570, 21,'shadowhaven','FDOORSM303',251.649,1620.959,-58.998,0.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10571, 22,'shadowhaven','FDOORSM303',251.007,1569.728,-58.998,128.517,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10572, 23,'shadowhaven','FDOORSM301',249.922,1534.997,-58.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10573, 24,'shadowhaven','FDOORSL304',274.984,1403.302,-58.998,128.159,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10574, 25,'shadowhaven','FDOORSM302',1213.014,-282.993,-49.998,384.382,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10575, 26,'shadowhaven','FDOORSM302',1165.972,-282.856,-49.998,384.0,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10576, 27,'shadowhaven','FDOORSM302',1174.033,-249.976,-49.998,256.704,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10577, 28,'shadowhaven','FDOORSM302',1197.12,-250.043,-49.998,256.0,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10578, 29,'shadowhaven','FDOORSM302',1495.984,82.127,-49.998,384.029,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10579, 30,'shadowhaven','FDOORSM302',1473.984,82.063,-49.998,384.829,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10580, 31,'shadowhaven','FDOORSM302',1459.988,81.993,-49.998,384.869,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10581, 32,'shadowhaven','FDOORSM302',1410.015,71.017,-49.998,128.0,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10582, 33,'shadowhaven','FDOORSM302',1359.999,129.203,-49.998,128.371,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10583, 34,'shadowhaven','FDOORSM302',1203.023,33.268,-49.998,128.193,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10584, 35,'shadowhaven','FDOORSM302',1156.007,33.478,-49.998,128.193,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10585, 36,'shadowhaven','FDOORSM302',1172.447,-0.014,-49.998,0.0,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10586, 37,'shadowhaven','FDOORSM302',1196.436,-0.003,-49.998,0.0,77,0,0,0,0,0,0,9,'bazaar',-215.0,-875.0, 16,0.0,0,0,100);

INSERT INTO doors VALUES
(10587, 38,'shadowhaven','FDOORSL301',140.228,1046.988,-58.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10588, 39,'shadowhaven','FDOORSL303',230.748,977.983,-58.998,0.15,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10589, 40,'shadowhaven','FDOORSL302',-90.33,1023.981,-79.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10590, 41,'shadowhaven','FDOORSL304',-90.243,984.013,-79.998,0.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10591, 42,'shadowhaven','FDOORSL304',-33.873,1024.006,-79.998,256.096,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10592, 43,'shadowhaven','FDOORSL302',-33.652,983.976,-79.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10593, 44,'shadowhaven','FDOORSL303',34.398,857.972,-58.998,257.981,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10594, 45,'shadowhaven','FDOORSL302',-12.09,712.281,-72.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10595, 46,'shadowhaven','FDOORSL304',66.011,712.359,-72.998,384.265,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10596, 47,'shadowhaven','FDOORSL303',197.974,664.423,-47.998,384.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10597, 48,'shadowhaven','FDOORSL301',23.457,657.972,-47.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10598, 49,'shadowhaven','FDOORSL304',124.966,277.272,-31.998,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10599, 50,'shadowhaven','FDOORSL302',207.687,176.015,-31.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

[/QUOTE]

[sysadmin]

Shadowhaven Part2:

NOTE:
- Dump was made with beta 1.12
- I renumbered the ID's to 10550+
- Includes teleport support
- Renumbered door id's



INSERT INTO doors VALUES
(10600, 51,'shadowhaven','FDOORSL302',258.651,6.04,-31.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10601, 52,'shadowhaven','FDOORSL302',207.961,14.932,-31.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10602, 53,'shadowhaven','FDOORSL302',132.038,14.465,-31.998,128.67,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10603, 54,'shadowhaven','FMDOOR301',-226.037,-256.396,-30.028,128.0,6,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10604, 55,'shadowhaven','FMDOOR301',114.759,-130.003,-32.018,256.0,6,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10605, 56,'shadowhaven','FDOORSL302',98.938,-248.346,16.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10606, 57,'shadowhaven','FDOORSL302',66.985,-248.667,16.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10607, 58,'shadowhaven','FDOORSL302',-20.965,-248.54,16.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10608, 59,'shadowhaven','FDOORSL302',-60.984,-248.38,16.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10609, 60,'shadowhaven','FDOORSL301',-79.045,-374.66,16.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10610, 61,'shadowhaven','FDOORSL302',-64.916,-343.583,16.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10611, 62,'shadowhaven','FDOORSL302',-8.976,-343.364,16.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10612, 63,'shadowhaven','FDOORSL301',61.489,-429.926,16.002,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10613, 64,'shadowhaven','FDOORSL302',34.529,-386.009,16.002,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10614, 65,'shadowhaven','FDOORSL302',72.989,-343.103,16.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10615, 66,'shadowhaven','FDOORSL301',68.958,50.092,-31.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10616, 67,'shadowhaven','CRATEG',393.422,-359.049,-62.938,437.098,53,0,0,0,0,0,0,175,'NONE',0,0,0,0,0 ,0,100);

INSERT INTO doors VALUES
(10617, 68,'shadowhaven','FDOORSL302',-43.108,56.016,-27.993,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10618, 69,'shadowhaven','FDOORSL302',-43.122,104.025,-27.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10619, 70,'shadowhaven','HODOOR301',-713.462,1600.18,-63.048,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10620, 71,'shadowhaven','FDOORSL301',-131.871,-269.042,-23.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10621, 72,'shadowhaven','FDOORSL304',115.932,328.002,-31.998,0.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10622, 73,'shadowhaven','FDOORSL304',116.101,404.001,-32.008,0.718,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10623, 74,'shadowhaven','FDOORSL301',66.994,438.776,0.002 ,384.715,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10624, 75,'shadowhaven','FDOORSL304',52.147,379.97,0.002, 0.833,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10625, 76,'shadowhaven','FDOORSL302',27.828,351.971,0.002 ,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10626, 77,'shadowhaven','FDOORSM301',27.624,379.981,0.002 ,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10627, 78,'shadowhaven','FDOORSM303',52.149,351.959,0.002 ,0.149,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10628, 79,'shadowhaven','FDOORSM301',52.394,303.965,0.002 ,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10629, 80,'shadowhaven','FDOORSM303',27.869,304.024,0.002 ,256.788,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10630, 81,'shadowhaven','FDOORSL301',-43.074,211.975,-27.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10631, 82,'shadowhaven','FDOORSL303',202.987,1067.461,-58.998,384.959,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10632, 83,'shadowhaven','FDOORSM303',215.977,1026.305,-36.998,384.336,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10633, 84,'shadowhaven','FDOORSM301',215.918,1043.779,-36.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10634, 85,'shadowhaven','FDOORSM301',173.052,1026.298,-36.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10635, 86,'shadowhaven','FDOORSM303',173.018,1043.578,-36.998,128.414,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10636, 87,'shadowhaven','FDOORSM301',340.986,1180.325,-58.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10637, 88,'shadowhaven','FDOORSM301',395.674,30.003,-30.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10638, 89,'shadowhaven','FDOORSM301',371.341,62.016,-31.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10639, 90,'shadowhaven','FDOORSM301',386.775,-17.988,-31.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10640, 91,'shadowhaven','FDOORSM303',371.311,-41.981,-31.998,256.423,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10641, 92,'shadowhaven','FDOORSM303',386.682,-47.99,-31.998,0.481,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10642, 93,'shadowhaven','FDOORSM303',399.02,-129.855,-31.998,384.039,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10643, 94,'shadowhaven','FDOORSM303',350.949,-129.831,-31.998,384.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10644, 95,'shadowhaven','FDOORSL302',371.004,-88.252,-31.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10645, 96,'shadowhaven','FDOORSM303',271.279,-124.008,-31.998,256.197,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10646, 97,'shadowhaven','FDOORSM301',288.727,-169.957,-31.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10647, 98,'shadowhaven','FDOORSL304',271.184,-160.053,-31.998,256.274,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10648, 99,'shadowhaven','FDOORSM301',288.999,-268.732,-31.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10649, 100,'shadowhaven','FDOORSM301',319.25,-308.014,-31.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10650, 101,'shadowhaven','FDOORSM301',399.767,1195.976,-58.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10651, 102,'shadowhaven','FDOORSS302',346.978,1199.726,-58.998,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10652, 103,'shadowhaven','FDOORSL304',47.596,1169.97,-58.998,256.642,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10653, 104,'shadowhaven','FDOORSL304',47.959,1260.029,-58.998,256.12,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10654, 105,'shadowhaven','SHPLPC400',170.0,1569.5,-63.5,0.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

[RangerDown]

Sweet!! Thanks a bunch!

[solid11]

Looks like you have something great on your hands Sys. I only got to check out Potranq and I guess some of the doors had extra spaces or other errors in them because I got errors sourcing them in. The ones that took did show up in zone though in right spot and look great. For example, the two inputs up from the very last one had errors, do you see anything off the bat wrong with the lines? There were more, like 1/3 of them had errors sourcing them in, if I can figure them out all will be right with the world hehe. Thanks again sys and great work, look forward to more stuff from ya.

[sysadmin]

some of the lines have a return & linefeed, just make sure when you shource them in the line appear like this:


INSERT INTO doors VALUES
( bla , bla,-bla);


instead of this:

INSERT INTO doors VALUES
(bla, bla,-
bla);

I have not had any problems sourcing any of the resulting files to my database, please post the errors you get so I can fix the error if it is in the source data or the code itself.

[solid11]

I have already sourced in tranquility, but I did it again just so you will see the errors along with duplicate entries.

This sql is a direct copy and paste from your tranquility entries from the thread.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.23-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source Potranquility_doors.sql
ERROR 1062: Duplicate entry '10200' for key 1
ERROR 1062: Duplicate entry '10201' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '0)' at line
2
ERROR 1062: Duplicate entry '10203' for key 1
ERROR 1062: Duplicate entry '10204' for key 1
ERROR 1062: Duplicate entry '10205' for key 1
ERROR 1062: Duplicate entry '10206' for key 1
ERROR 1062: Duplicate entry '10207' for key 1
ERROR 1062: Duplicate entry '10208' for key 1
ERROR 1062: Duplicate entry '10209' for key 1
ERROR 1062: Duplicate entry '10210' for key 1
ERROR 1062: Duplicate entry '10211' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1062: Duplicate entry '10213' for key 1
ERROR 1062: Duplicate entry '10214' for key 1
ERROR 1062: Duplicate entry '10215' for key 1
ERROR 1062: Duplicate entry '10216' for key 1
ERROR 1062: Duplicate entry '10217' for key 1
ERROR 1062: Duplicate entry '10218' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1062: Duplicate entry '10220' for key 1
ERROR 1062: Duplicate entry '10221' for key 1
ERROR 1062: Duplicate entry '10222' for key 1
ERROR 1062: Duplicate entry '10223' for key 1
ERROR 1062: Duplicate entry '10224' for key 1
ERROR 1062: Duplicate entry '10225' for key 1
ERROR 1062: Duplicate entry '10226' for key 1
ERROR 1062: Duplicate entry '10227' for key 1
ERROR 1062: Duplicate entry '10228' for key 1
ERROR 1062: Duplicate entry '10229' for key 1
ERROR 1062: Duplicate entry '10230' for key 1
ERROR 1062: Duplicate entry '10231' for key 1
ERROR 1062: Duplicate entry '10232' for key 1
ERROR 1062: Duplicate entry '10233' for key 1
ERROR 1062: Duplicate entry '10234' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1062: Duplicate entry '10237' for key 1
ERROR 1062: Duplicate entry '10238' for key 1
ERROR 1062: Duplicate entry '10239' for key 1
ERROR 1062: Duplicate entry '10240' for key 1
ERROR 1062: Duplicate entry '10241' for key 1
ERROR 1062: Duplicate entry '10242' for key 1
ERROR 1062: Duplicate entry '10243' for key 1
ERROR 1062: Duplicate entry '10244' for key 1
ERROR 1062: Duplicate entry '10245' for key 1
ERROR 1062: Duplicate entry '10246' for key 1
ERROR 1062: Duplicate entry '10247' for key 1
ERROR 1062: Duplicate entry '10248' for key 1
ERROR 1062: Duplicate entry '10249' for key 1
ERROR 1062: Duplicate entry '10250' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '0)' at line
2
ERROR 1062: Duplicate entry '10253' for key 1
ERROR 1062: Duplicate entry '10254' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '00)' at line
2
ERROR 1062: Duplicate entry '10257' for key 1
mysql>

[sysadmin]

Thanks for posting your log. It will help me fix a bug i have in the code.

[solid11]

Do you need logs for the other zones you posted or is that one enough? I haven't sourced in the others yet but I can.

[sysadmin]

If you get errors yes, please post them. I will be able to finish the next release in a few days since I am overloaded with work but when I release it, it will be able to fix zone points and teleports as well as doors and objects.

[sysadmin]

Check on top of this thread for info and download link, please post on this thread any errors you may encounter.

[sysadmin]

I edited and reposted all door dumps to latest version (obj2sql 1.12), posted dumps now include teleport support.

[sysadmin]

PoK sample dump

- made with obj2sql ver 1.12
- includes teleport support
- renumbered door id's

INSERT INTO doors VALUES
(10705, 1,'poknowledge','POKDOOR500',-796.492,692.442,-159.949,64.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10706, 2,'poknowledge','POKDOOR500',-875.778,683.305,-160.099,192.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10707, 3,'poknowledge','POKDOOR500',-642.468,898.706,-127.999,192.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10708, 4,'poknowledge','POKDOOR500',356.479,886.01,-92.528,384.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10709, 5,'poknowledge','VSRUGS301',-831.422,655.155,-163.962,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10710, 6,'poknowledge','VSRUGS301',-831.665,626.831,-163.84,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10711, 7,'poknowledge','VSRUGS301',-831.412,585.638,-155.972,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10712, 8,'poknowledge','VTBKSHF302',889.778,649.769,-113.999,448.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10713, 9,'poknowledge','VTBKSHF302',824.282,650.241,-113.999,64.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10714, 10,'poknowledge','VSWRACKS303',833.633,614.959,-113.999,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10715, 11,'poknowledge','VSWRACKS304',880.304,615.089,-113.999,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10716, 12,'poknowledge','VSWRACKS304',833.294,556.891,-113.999,192.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10717, 13,'poknowledge','VSWRACKS304',829.01,619.656,-113.999,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10718, 14,'poknowledge','VSWRACKS303',885.114,610.3,-113.999,0.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10719, 15,'poknowledge','VSWRACKS303',821.625,568.954,-114.249,192.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10720, 16,'poknowledge','VSWRACKS303',881.403,557.278,-113.999,320.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10721, 17,'poknowledge','VSWRACKS301',884.508,620.908,-113.999,0.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10722, 18,'poknowledge','VSWRACKS301',829.203,608.797,-113.999,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10723, 19,'poknowledge','VSWRACKS301',892.01,569.168,-113.999,64.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10724, 20,'poknowledge','POKDOOR503',0.023,804.071,0.002, 128.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10725, 21,'poknowledge','POKDOOR500',-316.458,879.035,-95.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10726, 22,'poknowledge','POKDOOR500',-317.058,794.007,-95.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10727, 23,'poknowledge','POKDOOR500',173.914,1473.968,-127.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10728, 24,'poknowledge','POKDOOR500',413.967,1042.053,-103.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10729, 25,'poknowledge','POKDOOR500',408.967,1065.917,-103.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10730, 26,'poknowledge','POKDOOR500',370.015,888.03,-95.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10731, 27,'poknowledge','POKDOOR500',376.071,850.073,-95.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10732, 28,'poknowledge','POKDOOR500',358.095,919.98,-95.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10733, 29,'poknowledge','POKDOOR500',376.188,970.011,-95.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10734, 30,'poknowledge','POKDOOR500',381.963,919.98,-95.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10735, 31,'poknowledge','POKDOOR500',393.957,888.03,-95.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10736, 32,'poknowledge','POKDOOR500',398.011,795.95,-95.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10737, 33,'poknowledge','POKDOOR500',383.947,774.026,-95.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10738, 34,'poknowledge','POKDOOR500',445.972,450.043,-127.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10739, 35,'poknowledge','POKDOOR500',37.992,230.996,-127.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10740, 36,'poknowledge','POKDOOR500',56.043,273.106,-127.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10741, 37,'poknowledge','POKDOOR500',-38.032,243.032,-127.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10742, 38,'poknowledge','POKDOOR500',-44.009,273.086,-127.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10743, 39,'poknowledge','POKDOOR501',639.982,926.062,-127.998,256.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10744, 40,'poknowledge','POKDOOR500',852.077,1027.935,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10745, 41,'poknowledge','POKDOOR500',839.916,1100.113,-159.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10746, 42,'poknowledge','POKDOOR501',801.997,1063.946,-159.998,0.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10747, 43,'poknowledge','POKDOOR501',863.98,710.956,-159.998,128.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10748, 44,'poknowledge','POKDOOR501',856.955,660.753,-113.998,384.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10749, 45,'poknowledge','POKDOOR500',844.002,335.919,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10750, 46,'poknowledge','POKDOOR500',895.993,336.055,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10751, 47,'poknowledge','POKDOOR501',910.001,350.062,-159.998,256.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10752, 48,'poknowledge','POKDOOR500',656.095,123.982,-159.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10753, 49,'poknowledge','POKDOOR500',656.195,175.957,-159.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10754, 50,'poknowledge','POKDOOR501',594.013,146.024,-159.998,0.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10755, 51,'poknowledge','POKELEVATOR500',0.028,917.384,-0.998,128.0,59,0,0,0,0,0,0,386,'NONE',0,0,0,0,0,0, 100);

INSERT INTO doors VALUES
(10756, 52,'poknowledge','POKRVPORT500',908.668,1228.057,-156.248,384.0,58,0,0,0,0,0,0,1,'misty',-1260.0,-513.0, 10,259.0,0,0,100);

INSERT INTO doors VALUES
(10757, 53,'poknowledge','POKKELPORT500',908.392,883.566,-156.248,384.0,58,0,0,0,0,0,0,2,'gfaydark',-734.0,-188.0,-2,430.0,0,0,100);

INSERT INTO doors VALUES
(10758, 54,'poknowledge','POKKALPORT500',908.506,475.293,-156.148,384.0,58,0,0,0,0,0,0,3,'butcher',-523.0,1726.0, 0,45.0,0,0,100);

INSERT INTO doors VALUES
(10759, 55,'poknowledge','POKHALPORT500',908.6,132.109,-155.998,128.0,58,0,0,0,0,0,0,4,'everfrost',-31.0,2835.0,-61,453.0,0,0,100);

INSERT INTO doors VALUES
(10760, 56,'poknowledge','POKFELPORT500',811.879,37.137,-155.998,256.0,58,0,0,0,0,0,0,5,'gfaydark',-1824.0,-2223.0, 0,244.0,0,0,100);

INSERT INTO doors VALUES
(10761, 57,'poknowledge','POKERPORT500',594.484,35.938,-155.998,384.0,58,0,0,0,0,0,0,6,'tox',-538.0,2327.0,-41,375.0,0,0,100);

INSERT INTO doors VALUES
(10762, 58,'poknowledge','POKTNPORT500',460.965,-76.371,-156.098,128.0,58,0,0,0,0,0,0,7,'nexus',442.0,48.0,-28,135.0,0,0,100);

INSERT INTO doors VALUES
(10763, 59,'poknowledge','POKTGDPORT500',459.376,-235.678,-156.248,0.0,58,0,0,0,0,0,0,8,'greatdivide',-1811.0,-41.0, 392,0.0,0,0,100);

INSERT INTO doors VALUES
(10764, 60,'poknowledge','POKSHPORT500',363.598,-332.179,-156.098,256.0,58,0,0,0,0,0,0,9,'shadeweaver',-2433.0,-2970.0,-214,236.0,0,0,100);

INSERT INTO doors VALUES
(10765, 61,'poknowledge','POKQNSPORT500',147.521,-331.698,-156.248,384.0,58,0,0,0,0,0,0,10,'qeynos2',487.0,21 9.0, 3,267.0,0,0,100);

INSERT INTO doors VALUES
(10766, 62,'poknowledge','POKPTPORT500',-147.699,-332.22,-155.998,0.0,58,0,0,0,0,0,0,11,'potranquility',-1463.0,774.0,-877,131.0,0,0,100);

[sysadmin]

Pok sample doors dump

- made with ver obj2sql ver 1.12
- includes teleport support
- renumbered door id's


INSERT INTO doors VALUES
(10767, 63,'poknowledge','POKFVPORT500',-364.254,-331.823,-156.348,384.0,58,0,0,0,0,0,0,12,'firiona',4673.0,-455.0, 10,128.0,0,0,100);

INSERT INTO doors VALUES
(10768, 64,'poknowledge','POKFPTPORT500',-461.026,-235.181,-156.148,128.0,58,0,0,0,0,0,0,13,'freportw',76.0,-658.0,-31,255.0,0,0,100);

INSERT INTO doors VALUES
(10769, 65,'poknowledge','POKAAPORT500',-460.389,-76.483,-156.248,256.0,58,0,0,0,0,0,0,14,'steamfont',931.0,-1329.0,-108,248.0,0,0,100);

INSERT INTO doors VALUES
(10770, 66,'poknowledge','POKOVPORT500',-897.068,872.22,-159.348,384.0,58,0,0,0,0,0,0,19,'overthere',1888.0 ,3133.0,-50,128.0,0,0,100);

INSERT INTO doors VALUES
(10771, 67,'poknowledge','POKCABPORT500',-596.697,36.122,-155.998,0.0,58,0,0,0,0,0,0,15,'fieldofbone',1845.0 ,-2980.0, 12,259.0,0,0,100);

INSERT INTO doors VALUES
(10772, 68,'poknowledge','POKGROPORT500',-801.225,46.984,-159.248,0.0,58,0,0,0,0,0,0,16,'innothule',-40.0,-706.0,-24,216.0,0,0,100);

INSERT INTO doors VALUES
(10773, 69,'poknowledge','POKNRKPORT500',-909.187,131.793,-156.148,256.0,58,0,0,0,0,0,0,17,'nektulos',-349.0,705.0,-3,20.0,0,0,100);

INSERT INTO doors VALUES
(10774, 70,'poknowledge','POKOGPORT500',-906.998,443.859,-156.148,256.0,58,0,0,0,0,0,0,18,'feerrott',-163.0,908.0,-8,248.0,0,0,100);

INSERT INTO doors VALUES
(10775, 71,'poknowledge','POKPPORT500',-896.653,1215.843,-159.348,384.0,58,0,0,0,0,0,0,20,'tox',272.0,-2347.0,-46,116.0,0,0,100);

INSERT INTO doors VALUES
(10776, 72,'poknowledge','POKDOOR502',-802.015,279.938,-159.998,0.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10777, 73,'poknowledge','POKDOOR500',-851.974,242.032,-159.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10778, 74,'poknowledge','POKDOOR500',-839.962,318.123,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10779, 75,'poknowledge','POKDOOR502',-832.087,699.961,-159.998,384.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10780, 76,'poknowledge','POKDOOR502',-825.025,649.949,-113.998,128.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10781, 77,'poknowledge','POKDOOR502',-909.998,1090.023,-159.998,0.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10782, 78,'poknowledge','POKDOOR500',-822.009,1103.904,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10783, 79,'poknowledge','POKDOOR500',-883.994,1069.922,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10784, 80,'poknowledge','POKDOOR502',-627.057,1025.938,-127.998,0.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10785, 81,'poknowledge','POKDOOR503',351.94,71.963,-159.998,0.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10786, 82,'poknowledge','POKDOOR500',396.032,108.002,-159.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10787, 83,'poknowledge','POKDOOR500',407.991,35.967,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10788, 84,'poknowledge','POKDOOR503',223.124,-201.067,-113.998,256.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10789, 85,'poknowledge','POKDOOR503',173.03,-193.986,-160.072,256.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10790, 86,'poknowledge','POKDOOR503',-73.942,-145.869,-159.998,128.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10791, 87,'poknowledge','POKDOOR500',-123.983,-184.07,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10792, 88,'poknowledge','POKDOOR500',-39.994,-184.083,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10793, 89,'poknowledge','POKDOOR503',-289.951,-145.977,-160.248,128.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10794, 90,'poknowledge','POKDOOR500',-312.083,-171.959,-159.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10795, 91,'poknowledge','POKDOOR500',-255.984,-184.09,-159.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10796, 92,'poknowledge','POKDOOR503',-321.999,-78.0,-159.998,128.0,27,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10797, 93,'poknowledge','POKDOOR500',-301.958,-52.003,-159.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10798, 94,'poknowledge','POKDOOR500',-334.044,-41.96,-159.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10799, 95,'poknowledge','POKDOOR503',-0.037,91.942,-127.998,128.0,77,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10800, 96,'poknowledge','POKDOOR500',100.012,1399.933,-111.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10801, 97,'poknowledge','POKDOOR500',80.007,1439.971,-111.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10802, 98,'poknowledge','POKDOOR500',54.015,1399.886,-111.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10803, 99,'poknowledge','POKDOOR500',-41.99,1399.962,-111.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10804, 100,'poknowledge','POKDOOR500',-88.039,1399.883,-111.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10805, 101,'poknowledge','POKDOOR500',-80.085,1428.006,-111.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10806, 102,'poknowledge','POKDOOR500',-173.914,1486.005,-127.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10807, 103,'poknowledge','POKDOOR500',-343.016,905.527,-95.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10808, 104,'poknowledge','POKDOOR500',-466.422,550.082,-127.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10809, 105,'poknowledge','POKDOOR500',-377.941,523.943,-127.998,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10810, 106,'poknowledge','POKDOOR500',-408.046,504.153,-127.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10811, 107,'poknowledge','POKDOOR500',-389.949,413.812,-127.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10812, 108,'poknowledge','POKDOOR500',-360.36,527.804,-93.998,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10813, 109,'poknowledge','POKELESWTCH500',-12.001,930.75,5.002,0.0,109,0,0,0,0,0,0,1000,'NONE ',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10814, 110,'poknowledge','POKELESWTCH500',-10.189,904.01,392.002,128.0,109,0,0,0,0,0,0,1000,' NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10815, 111,'poknowledge','VTBKSHF302',822.981,560.417,-155.999,192.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10816, 112,'poknowledge','VTBKSHF302',904.723,560.202,-155.999,320.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10817, 113,'poknowledge','VTBKSHF302',904.413,699.215,-159.999,448.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10818, 114,'poknowledge','VTBKSHF302',823.745,699.685,-159.999,64.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10819, 115,'poknowledge','VSSHELF301',912.882,651.226,-152.249,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10820, 116,'poknowledge','VSSHELF301',912.881,632.712,-152.245,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10821, 117,'poknowledge','VSPSHELF301',847.741,552.0,-150.249,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10822, 118,'poknowledge','VSPSHELF301',839.989,551.937,-150.248,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10823, 119,'poknowledge','VTDESK302',878.98,643.909,-163.999,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10824, 120,'poknowledge','VTDESK302',850.42,664.701,-163.999,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10825, 121,'poknowledge','VTCHAIR302',879.35,647.566,-163.999,474.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10826, 122,'poknowledge','VTCHAIR302',846.144,664.317,-163.999,104.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10827, 123,'poknowledge','POPCRATE501',844.073,623.046,-163.999,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10828, 124,'poknowledge','POPCRATE501',849.955,628.803,-163.999,437.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10829, 125,'poknowledge','POPCRATE501',843.229,629.505,-158.065,165.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10830, 126,'poknowledge','POPCRATE501',851.231,622.973,-157.749,298.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

[sysadmin]

Pok sample doors dump

- made with obj2sql ver 1.12
- includes teleport support
- renumbered door id's


INSERT INTO doors VALUES
(10831, 127,'poknowledge','POPCRATE500',851.279,622.474,-163.999,384.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10832, 128,'poknowledge','POPCRATE500',849.903,628.722,-159.999,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10833, 129,'poknowledge','POPCRATE500',844.154,630.104,-163.999,256.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10834, 130,'poknowledge','SHBOOK306',879.287,644.085,-160.249,472.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10835, 131,'poknowledge','SHBOOK307',913.082,648.334,-146.999,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10836, 132,'poknowledge','SHBOOK306',912.862,636.747,-148.749,167.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10837, 133,'poknowledge','SHBOOK303',913.278,631.964,-146.103,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10838, 134,'poknowledge','SHBOOK302',912.869,635.378,-148.189,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10839, 135,'poknowledge','SHBOOK301',913.124,630.564,-146.117,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10840, 136,'poknowledge','SHBOOK302',913.16,631.053,-146.124,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10841, 137,'poknowledge','VSWRACKS304',816.765,670.776,-159.999,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10842, 138,'poknowledge','VSWRACKS303',816.672,685.794,-159.999,128.0,58,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(10843, 139,'poknowledge','POKDOOR500',-682.492,900.476,-127.999,320.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

[sysadmin]

- made with obj2sql ver 1.12
- Includes Teleport support
- Renumbered door id's
- Renumbered record id's

INSERT INTO doors VALUES
(11000, 1,'katta','KATGLYPH301',-1699.0,-671.957,-531.248,256.375,57,0,0,0,0,0,0,11,'katta',-1085.0,-163.0,-265,244.0,0,0,100);

INSERT INTO doors VALUES
(11001, 2,'katta','KATGLYPH301',-1698.575,-1275.93,-535.998,256.0,57,0,0,0,0,0,0,12,'katta',-1085.0,-163.0,-265,244.0,0,0,100);

INSERT INTO doors VALUES
(11002, 3,'katta','KATGLYPH302',-928.5,-98.328,150.502,256.0,58,0,0,0,0,0,0,9,'katta',-96.0,-907.0, 211,256.0,0,0,100);

INSERT INTO doors VALUES
(11003, 4,'katta','KATGLYPH302',-928.5,-98.326,80.502,256.0,58,0,0,0,0,0,0,8,'katta',-96.0,-907.0, 144,256.0,0,0,100);

INSERT INTO doors VALUES
(11004, 5,'katta','KATDOOR301A',582.005,-227.998,6.082,0.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11005, 6,'katta','KATDOOR301',581.998,-251.983,6.082,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11006, 7,'katta','KATDOOR301A',-263.028,-612.001,6.002,384.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11007, 8,'katta','KATDOOR301',-287.002,-611.998,6.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11008, 9,'katta','KATDOOR301',-264.029,-939.007,-262.998,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11009, 10,'katta','KATDOOR301A',-288.004,-939.008,-262.998,128.884,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11010, 11,'katta','KATDOOR301A',-69.005,-1077.988,-262.998,0.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11011, 12,'katta','KATDOOR301',-69.004,-1101.974,-262.998,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11012, 13,'katta','KATDOOR301',297.999,-1233.017,6.002,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11013, 14,'katta','KATDOOR301A',298.0,-1256.988,6.002,256.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11014, 15,'katta','KATDOOR301A',2.0,-1820.991,28.002,384.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11015, 16,'katta','KATDOOR302',334.997,-744.008,33.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11016, 17,'katta','KATDOOR302',425.0,-744.004,33.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11017, 18,'katta','KATDOOR302',348.997,-791.0,0.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11018, 19,'katta','KATDOOR302',368.003,-780.99,33.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11019, 20,'katta','KATDOOR302',131.01,-61.008,0.002,128.044,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11020, 21,'katta','KATDOOR302',270.002,-61.008,0.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11021, 22,'katta','KATDOOR302',119.98,251.007,0.002,384.7 86,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11022, 23,'katta','KATDOOR302',258.994,251.008,0.002,384. 128,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11023, 24,'katta','KATDOOR302',258.989,54.01,0.002,384.0, 5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11024, 25,'katta','KATDOOR302',270.008,114.997,-0.048,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11025, 26,'katta','KATDOOR302',119.993,54.001,0.002,384.9 51,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11026, 27,'katta','KATDOOR302',131.004,115.007,0.002,128. 171,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11027, 28,'katta','KATDOOR302',-259.0,-60.988,0.002,128.273,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11028, 29,'katta','KATDOOR302',-120.004,-60.99,0.002,128.594,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11029, 30,'katta','KATDOOR302',-130.99,250.984,0.002,384.675,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11030, 31,'katta','KATDOOR302',-269.998,250.972,0.002,384.896,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11031, 32,'katta','KATDOOR302',-131.001,54.0,-0.108,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11032, 33,'katta','KATDOOR302',-270.003,53.997,0.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11033, 34,'katta','KATDOOR302',-258.958,115.046,0.002,128.94,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11034, 35,'katta','KATDOOR302',410.147,-793.413,0.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11035, 36,'katta','KATDOOR303A',-31.938,-96.02,0.002,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11036, 37,'katta','KATDOOR301A',-545.982,-1543.989,7.002,256.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11037, 38,'katta','KATDOOR301',-545.987,-1520.01,7.002,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11038, 39,'katta','KATDOOR301',-21.979,-1820.997,28.002,384.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11039, 40,'katta','KATDOOR302',91.999,-2080.995,71.032,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11040, 41,'katta','KATDOOR302',-119.961,114.982,0.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11041, 42,'katta','KATDOOR302',264.994,156.005,66.002,384 .501,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11042, 43,'katta','KATDOOR302',276.009,205.998,66.002,128 .96,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11043, 44,'katta','KATDOOR302',134.998,156.009,66.002,384 .299,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11044, 45,'katta','KATDOOR302',146.0,206.0,66.002,128.439 ,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11045, 46,'katta','KATDOOR302',-264.989,205.991,66.002,128.774,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11046, 47,'katta','KATDOOR302',-275.998,156.009,66.002,384.614,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11047, 48,'katta','KATDOOR302',-134.994,205.998,65.882,128.731,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11048, 49,'katta','KATDOOR302',-145.993,156.001,66.002,384.97,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11049, 50,'katta','KATDOOR302',379.0,-879.004,0.002,128.193,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11050, 51,'katta','KATDOOR303',31.995,-95.891,0.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11051, 52,'katta','KATDOOR302',91.996,-2030.014,71.002,0.848,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11052, 53,'katta','KATDOOR302',91.991,-1980.003,71.002,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11053, 54,'katta','KATDOOR302',-111.994,-2069.984,71.002,256.86,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11054, 55,'katta','KATDOOR302',-111.993,-2019.994,71.002,256.297,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11055, 56,'katta','KATDOOR302',-111.996,-1969.0,71.002,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11056, 57,'katta','KATDOOR301',-2.004,-1548.0,6.002,128.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11057, 58,'katta','KATDOOR301A',-25.985,-1548.005,6.002,128.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11058, 59,'katta','KATDOOR304',-729.981,-79.939,-0.098,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11059, 60,'katta','KATDOOR304A',-730.014,-114.095,-0.098,256.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(11060, 61,'katta','KATGLYPH301',-928.5,-97.025,214.751,256.585,58,0,0,0,0,0,0,10,'katta',-100.0,-760.0, 5,510.0,0,0,100);

INSERT INTO doors VALUES
(11061, 62,'katta','KATGLYPH301',-928.6,-98.262,10.502,256.0,58,0,0,0,0,0,0,7,'katta',-96.0,-907.0, 74,256.0,0,0,100);

[sdabbs65]

It says it's missing a DLL.


-edit-

MSSTDFMT.DLL

[sysadmin]

I uploaded an installer package for those who don't have any developer software installed on their computer. Use the same link on top of thread to download, unzip and install it.

[sdabbs65]

I uploaded an installer package for those who don't have any developer software installed on their computer. Use the same link on top of thread to download, unzip and install it.


Works great thanks for the quick update.

[sysadmin]

no problem! ;)

[sysadmin]

Gunthak Stone:

INSERT INTO doors VALUES (11003,295,'poknowledge','POKGTHPORT501',-738.14,1249.63,-161,256,57,0,0,0,0,-1,0,0,'NONE',0,0,0,0,0,0,100);
INSERT INTO doors VALUES (11004,294,'poknowledge','POKGTHPORT500',-738.14,1249.63,-161,256,58,0,0,0,0,0,0,0,'gunthak',0,0,0,0,0,0,100 );

[sysadmin]

Here are the doors from Gulf of Gunthak



INSERT INTO doors VALUES
(13000, 1,'gunthak','GKHAY404',1419.483,-266.726,1.0,342.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13001, 2,'gunthak','GKHAY403',1433.363,-204.576,1.0,195.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13002, 3,'gunthak','GKHAY403',1643.0,-276.0,0.0,405.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13003, 4,'gunthak','GKHAY405',1532.0,-333.0,0.0,161.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13004, 5,'gunthak','GKHAY404',1600.0,-319.0,0.0,30.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13005, 6,'gunthak','GKHAY403',1559.0,-393.0,0.0,272.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13006, 7,'gunthak','GKSTRNGHLD400',1558.0,-247.0,-1.5,256.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13007, 8,'gunthak','GKSTRNGHLD400',1540.75,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13008, 9,'gunthak','GKSTRNGHLD400',1591.0,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13009, 10,'gunthak','GKSTRNGHLD400',1608.5,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13010, 11,'gunthak','GKSTRNGHLD400',1626.0,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13011, 12,'gunthak','GKSTRNGHLD400',1643.0,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13012, 13,'gunthak','GKSTRNGHLD400',1660.5,-247.0,-1.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13013, 14,'gunthak','GKTROUGH401',1536.25,-269.75,-0.5,0.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13014, 15,'gunthak','GKTROUGH400',1520.5,-300.0,-0.75,447.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13015, 16,'gunthak','GKSTRNGHLD400',1508.0,-321.0,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13016, 17,'gunthak','GKSTRNGHLD400',1508.0,-339.25,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13017, 18,'gunthak','GKSTRNGHLD400',1508.0,-356.75,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13018, 19,'gunthak','GKSTRNGHLD400',1508.0,-391.5,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13019, 20,'gunthak','GKSTRNGHLD400',1508.0,-409.25,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13020, 21,'gunthak','GKSTRNGHLD400',1508.0,-426.5,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13021, 22,'gunthak','GKSTRNGHLD400',1508.0,-444.25,-1.5,128.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13022, 23,'gunthak','GKARRIVDR400',1460.71,-964.315,20.8,0.0,58,0,0,0,0,0,0,2,'stonebrunt',-1545.0,-4110.0,-374,0.0,0,0,100);

INSERT INTO doors VALUES
(13023, 24,'gunthak','GKTMPLDR601',-2859.0,3099.0,475.0,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13024, 25,'gunthak','GKTMPLDR601',-2859.0,2141.0,475.0,256.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13025, 26,'gunthak','GKTMPLDR602',-2750.0,2558.0,475.0,256.0,0,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13026, 27,'gunthak','GKTMPLDR603',-2750.0,2648.0,475.0,0.0,5,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13027, 28,'gunthak','GKNDEBRIS405',-2066.083,-88.71,81.126,426.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13028, 29,'gunthak','GKNDEBRIS405',-2064.509,-87.876,81.126,169.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13029, 30,'gunthak','GKNDEBRIS405',-2063.155,-88.035,81.126,171.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13030, 31,'gunthak','GKNDEBRIS405',-2065.994,-102.736,81.126,426.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13031, 32,'gunthak','GKNDEBRIS405',-2064.41,-101.922,81.126,169.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13032, 33,'gunthak','GKNDEBRIS405',-2063.059,-102.098,81.126,171.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13033, 34,'gunthak','GKNDEBRIS405',-2050.365,-79.042,81.126,298.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13034, 35,'gunthak','GKNDEBRIS405',-2049.551,-80.627,81.126,41.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13035, 36,'gunthak','GKNDEBRIS405',-2049.727,-81.978,81.126,43.0,54,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13036, 37,'gunthak','BAZWREIGNS302',1462.0,-303.0,-3.25,256.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13037, 38,'gunthak','BAZWREIGNS301',1452.0,-303.0,-4.75,256.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13038, 39,'gunthak','BAZWREIGNS301',1448.75,-303.0,-3.75,256.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13039, 40,'gunthak','BAZSADDLE301',1443.25,-268.09,6.09,505.0,59,0,0,0,0,0,0,-1,'NONE',0,0,0,0,0,0,100);

INSERT INTO doors VALUES
(13040, 41,'gunthak','POKTELE',1791.5,-1030.75,56.0,256.0,58,0,0,0,0,0,0,5,'poknowledge', 1203.0,-747.0,-156,128.0,0,0,100);

[Cisyouc]

Moved to Database forum..

[solid11]

Hey sysadmin, is there any zones you been wanting logs for that you can use for your doors dumps? I'm hoping you'll keep posting your doors dumps on your thread. Been working great so far. I might shell out 15 bucks to get on and get some logs.

[sysadmin]

it would be great if you could upload some new logs for new and old zones that do not have any logs.