EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   object extractor (https://www.eqemulator.org/forums/showthread.php?t=18122)

sysadmin 03-15-2005 04:07 PM
object extractor dumps
 
database dumps made with object tractor, check tools forum for extractor updates.

Cisyouc 03-15-2005 04:28 PM
What do you mean by logs?

sysadmin 03-15-2005 04:45 PM
packet collector logs

Teppen 03-17-2005 01:56 PM
re: packet collector logs
 
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 03-17-2005 06:50 PM
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 03-17-2005 07:02 PM
Anyway you can post sql fixes for zones that you have or is that askin too much? hehe

sysadmin 03-17-2005 08:14 PM
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


Quote:
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 03-17-2005 08:15 PM
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



Quote:
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 03-18-2005 04:35 AM
Bazaar doors
 
Bazaar:

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


Quote:
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 03-18-2005 04:39 AM
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 03-18-2005 04:39 AM
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 03-18-2005 05:14 AM
Sweet!! Thanks a bunch!

solid11 03-18-2005 07:45 AM
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 03-18-2005 09:24 AM
some of the lines have a return & linefeed, just make sure when you shource them in the line appear like this:

Quote:
INSERT INTO doors VALUES
( bla , bla,-bla);
instead of this:
Quote:
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 03-18-2005 03:53 PM
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 03-18-2005 04:51 PM
Thanks for posting your log. It will help me fix a bug i have in the code.

solid11 03-18-2005 07:15 PM
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 03-19-2005 04:12 PM
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 03-24-2005 08:28 AM
object extractor 1.1 released
 
Check on top of this thread for info and download link, please post on this thread any errors you may encounter.

sysadmin 03-29-2005 07:41 AM
corrected door dumps
 
I edited and reposted all door dumps to latest version (obj2sql 1.12), posted dumps now include teleport support.

sysadmin 03-29-2005 07:53 AM
pok doors dump part 1
 
PoK sample dump

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

Quote:
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 03-29-2005 07:55 AM
pok doors dump part 2
 
Pok sample doors dump

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

Quote:
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 03-29-2005 07:56 AM
pok doors dump part 3
 
Pok sample doors dump

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

Quote:
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 03-29-2005 08:11 AM
Katta sample dump
 
- made with obj2sql ver 1.12
- Includes Teleport support
- Renumbered door id's
- Renumbered record id's

Quote:
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 03-30-2005 11:55 PM
error.
 
It says it's missing a DLL.


-edit-

MSSTDFMT.DLL

sysadmin 03-31-2005 04:05 AM
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 03-31-2005 08:22 AM
Quote:
Originally Posted by 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.

Works great thanks for the quick update.

sysadmin 03-31-2005 11:20 AM
no problem! ;)

sysadmin 04-04-2005 06:23 PM
PoK Gunthak Stone and base
 
Gunthak Stone:

Quote:
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 04-07-2005 09:51 AM
Gunthak Door Dump
 
Here are the doors from Gulf of Gunthak

Quote:

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 04-07-2005 11:04 AM
Moved to Database forum..

solid11 04-16-2005 10:23 AM
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 04-16-2005 11:02 AM
it would be great if you could upload some new logs for new and old zones that do not have any logs.


All times are GMT -4. The time now is 12:27 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.