object extractor

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