object extractor

[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]