Code:
delete from doors where zone like 'poknowledge';
INSERT IGNORE INTO doors (doorid, zone, name, pos_y, pos_x, pos_z, heading, opentype, keyitem) VALUES
(-111,'PoKnowledge','VSRUGS301',-831.421509,655.155029,-163.961639,17344,58,0),
(-112,'PoKnowledge','VSRUGS301',-831.664551,626.831177,-163.840469,17344,58,0),
(-113,'PoKnowledge','VSRUGS301',-831.411560,585.638367,-155.971878,17152,58,0),
(110,'PoKnowledge','VTBKSHF302',889.777710,649.768921,-113.998970,17375,58,0),
(109,'PoKnowledge','VTBKSHF302',824.282043,650.241211,-113.998970,17024,58,0),
(108,'PoKnowledge','VSWRACKS303',833.632629,614.958557,-113.998978,17152,58,0),
(107,'PoKnowledge','VSWRACKS304',880.304321,615.088928,-113.998978,17344,58,0),
(106,'PoKnowledge','VSWRACKS304',833.294189,556.891296,-113.998978,17216,58,0),
(105,'PoKnowledge','VSWRACKS304',829.010376,619.655884,-113.998970,17280,58,0),
(104,'PoKnowledge','VSWRACKS303',885.114136,610.300110,-113.998970,0,58,0),
(103,'PoKnowledge','VSWRACKS303',821.624817,568.954102,-114.248970,17216,58,0),
(102,'PoKnowledge','VSWRACKS303',881.403137,557.277710,-113.998970,17312,58,0),
(101,'PoKnowledge','VSWRACKS301',884.507813,620.907532,-113.998970,0,58,0),
(100,'PoKnowledge','VSWRACKS301',829.202515,608.797058,-113.998970,17280,58,0),
(99,'PoKnowledge','VSWRACKS301',892.010193,569.168396,-113.998978,17024,58,0),
(96,'PoKnowledge','POKDOOR503',0.023378,804.070618,0.002001,17152,27,0),
(95,'PoKnowledge','POKDOOR500',-316.458099,879.035095,-95.997978,0,5,0),
(94,'PoKnowledge','POKDOOR500',-317.057953,794.006714,-95.997971,17344,5,0),
(79,'PoKnowledge','POKDOOR500',173.913666,1473.968018,-127.997971,17280,5,0),
(78,'PoKnowledge','POKDOOR500',413.967255,1042.053467,-103.997971,17152,5,0),
(77,'PoKnowledge','POKDOOR500',408.966644,1065.917236,-103.997971,17280,5,0),
(76,'PoKnowledge','POKDOOR500',370.015320,888.030457,-95.997978,17344,5,0),
(75,'PoKnowledge','POKDOOR500',376.070831,850.072998,-95.997978,0,5,0),
(74,'PoKnowledge','POKDOOR500',358.094849,919.979980,-95.997978,17152,5,0),
(73,'PoKnowledge','POKDOOR500',376.187897,970.010925,-95.997971,0,5,0),
(72,'PoKnowledge','POKDOOR500',381.962860,919.979980,-95.997978,17152,5,0),
(71,'PoKnowledge','POKDOOR500',393.956543,888.029968,-95.997978,17344,5,0),
(70,'PoKnowledge','POKDOOR500',398.010681,795.950134,-95.997978,17152,5,0),
(69,'PoKnowledge','POKDOOR500',383.947479,774.025696,-95.997978,0,5,0),
(68,'PoKnowledge','POKDOOR500',445.972076,450.042969,-127.997971,17344,5,0),
(67,'PoKnowledge','POKDOOR500',37.992420,230.996185,-127.997971,17280,5,0),
(66,'PoKnowledge','POKDOOR500',56.042866,273.105713,-127.997971,17344,5,0),
(65,'PoKnowledge','POKDOOR500',-38.031536,243.032104,-127.997971,0,5,0),
(64,'PoKnowledge','POKDOOR500',-44.009003,273.086365,-127.997971,17344,5,0),
(48,'PoKnowledge','POKDOOR501',639.982056,926.062439,-127.997978,17280,77,0),
(47,'PoKnowledge','POKDOOR500',852.076965,1027.934692,-159.997955,17344,5,0),
(46,'PoKnowledge','POKDOOR500',839.915710,1100.112671,-159.997971,17152,5,0),
(45,'PoKnowledge','POKDOOR501',801.996887,1063.946289,-159.997955,0,27,0),
(44,'PoKnowledge','POKDOOR501',863.979919,710.955872,-159.997955,17152,77,0),
(43,'PoKnowledge','POKDOOR501',856.955200,660.752991,-113.997978,17344,77,0),
(42,'PoKnowledge','POKDOOR500',844.002197,335.919189,-159.997955,17344,5,0),
(41,'PoKnowledge','POKDOOR500',895.992554,336.055450,-159.997955,17344,5,0),
(40,'PoKnowledge','POKDOOR501',910.000916,350.062408,-159.997955,17280,27,0),
(39,'PoKnowledge','POKDOOR500',656.095337,123.982147,-159.997955,0,5,0),
(38,'PoKnowledge','POKDOOR500',656.195496,175.957306,-159.997955,0,5,0),
(37,'PoKnowledge','POKDOOR501',594.012573,146.024170,-159.997971,0,27,0),
(26,'PoKnowledge','POKELEVATOR500',0.027769,917.383789,-0.997999,17152,59,0),
(23,'PoKnowledge','POKRVPORT500',908.667664,1228.056763,-156.247955,17344,58,0),
(22,'PoKnowledge','POKKELPORT500',908.392334,883.565674,-156.247955,17344,58,0),
(21,'PoKnowledge','POKKALPORT500',908.506226,475.292755,-156.147964,17344,58,0),
(20,'PoKnowledge','POKHALPORT500',908.600464,132.108978,-155.997971,17152,58,0),
(19,'PoKnowledge','POKFELPORT500',811.879089,37.137459,-155.997971,17280,58,0),
(18,'PoKnowledge','POKERPORT500',594.483582,35.937756,-155.997955,17344,58,0),
(16,'PoKnowledge','POKTNPORT500',460.964691,-76.371353,-156.097946,17152,58,0),
(15,'PoKnowledge','POKTGDPORT500',459.375549,-235.677505,-156.247955,0,58,0),
(14,'PoKnowledge','POKSHPORT500',363.597595,-332.178619,-156.097946,17280,58,0),
(13,'PoKnowledge','POKQNSPORT500',147.520615,-331.698303,-156.247955,17344,58,0),
(12,'PoKnowledge','POKPTPORT500',-147.699265,-332.219818,-155.997925,0,58,0),
(11,'PoKnowledge','POKFVPORT500',-364.253540,-331.822662,-156.347961,17344,58,0),
(10,'PoKnowledge','POKFPTPORT500',-461.026367,-235.181366,-156.147964,17152,58,0),
(9,'PoKnowledge','POKAAPORT500',-460.388733,-76.482666,-156.247971,17280,58,0),
(8,'PoKnowledge','POKOVPORT500',-897.068054,872.220398,-159.347961,17344,58,0),
(0,'PoKnowledge','POKCABPORT500',-596.697144,36.121975,-155.997955,0,58,0),
(1,'PoKnowledge','POKGROPORT500',-801.225220,46.983891,-159.247955,0,58,0),
(3,'PoKnowledge','POKNRKPORT500',-909.187378,131.793137,-156.147964,17280,58,0),
(4,'PoKnowledge','POKOGPORT500',-906.998169,443.858795,-156.147964,17280,58,0),
(7,'PoKnowledge','POKPPORT500',-896.652588,1215.843384,-159.347946,17344,58,0),
(28,'PoKnowledge','POKDOOR502',-802.014648,279.938446,-159.997971,0,27,0),
(29,'PoKnowledge','POKDOOR500',-851.974365,242.032471,-159.997971,17152,5,0),
(30,'PoKnowledge','POKDOOR500',-839.962463,318.122559,-159.997971,17344,5,0),
(31,'PoKnowledge','POKDOOR502',-832.086914,699.960510,-159.997971,17344,77,0),
(32,'PoKnowledge','POKDOOR502',-825.024536,649.949402,-113.997978,17152,77,0),
(33,'PoKnowledge','POKDOOR502',-909.997681,1090.023315,-159.997955,0,27,0),
(34,'PoKnowledge','POKDOOR500',-822.008728,1103.904053,-159.997955,17344,5,0),
(35,'PoKnowledge','POKDOOR500',-883.993652,1069.922363,-159.997955,17344,5,0),
(36,'PoKnowledge','POKDOOR502',-627.056702,1025.937622,-127.997978,0,77,0),
(49,'PoKnowledge','POKDOOR503',351.939606,71.963234,-159.997955,0,27,0),
(50,'PoKnowledge','POKDOOR500',396.031708,108.002281,-159.997971,17152,5,0),
(51,'PoKnowledge','POKDOOR500',407.990875,35.966793,-159.997971,17344,5,0),
(52,'PoKnowledge','POKDOOR503',223.123672,-201.066788,-113.997971,17280,77,0),
(53,'PoKnowledge','POKDOOR503',173.029938,-193.985672,-160.071976,17280,77,0),
(54,'PoKnowledge','POKDOOR503',-73.941803,-145.869110,-159.997971,17152,27,0),
(55,'PoKnowledge','POKDOOR500',-123.982536,-184.070038,-159.997971,17344,5,0),
(56,'PoKnowledge','POKDOOR500',-39.994114,-184.083496,-159.997971,17344,5,0),
(57,'PoKnowledge','POKDOOR503',-289.950928,-145.977264,-160.247971,17152,27,0),
(58,'PoKnowledge','POKDOOR500',-312.083466,-171.959000,-159.997971,17280,5,0),
(59,'PoKnowledge','POKDOOR500',-255.983582,-184.090363,-159.997971,17344,5,0),
(60,'PoKnowledge','POKDOOR503',-321.998871,-78.000412,-159.997955,17152,27,0),
(61,'PoKnowledge','POKDOOR500',-301.957977,-52.003029,-159.997971,0,5,0),
(62,'PoKnowledge','POKDOOR500',-334.044495,-41.959698,-159.997971,17280,5,0),
(63,'PoKnowledge','POKDOOR503',-0.037455,91.942261,-127.997978,17152,77,0),
(80,'PoKnowledge','POKDOOR500',100.011917,1399.932739,-111.997971,17344,5,0),
(81,'PoKnowledge','POKDOOR500',80.007164,1439.971313,-111.997971,0,5,0),
(82,'PoKnowledge','POKDOOR500',54.014759,1399.885742,-111.997971,17344,5,0),
(83,'PoKnowledge','POKDOOR500',-41.990246,1399.961792,-111.997978,17344,5,0),
(84,'PoKnowledge','POKDOOR500',-88.039398,1399.882935,-111.997971,17344,5,0),
(85,'PoKnowledge','POKDOOR500',-80.084541,1428.005981,-111.997971,17280,5,0),
(86,'PoKnowledge','POKDOOR500',-173.913605,1486.004761,-127.997978,0,5,0),
(88,'PoKnowledge','POKDOOR500',-343.015900,905.526794,-95.997971,17152,5,0),
(89,'PoKnowledge','POKDOOR500',-466.422485,550.081665,-127.997971,0,5,0),
(90,'PoKnowledge','POKDOOR500',-377.941193,523.942749,-127.997971,17344,5,0),
(91,'PoKnowledge','POKDOOR500',-408.046326,504.152771,-127.997971,0,5,0),
(92,'PoKnowledge','POKDOOR500',-389.948517,413.811676,-127.997971,17152,5,0),
(93,'PoKnowledge','POKDOOR500',-360.360443,527.804138,-93.997971,17280,5,0),
(97,'PoKnowledge','POKELESWTCH500',-12.000710,930.749939,5.001999,0,109,0),
(98,'PoKnowledge','POKELESWTCH500',-10.188633,904.009521,392.001953,17152,109,0),
(111,'PoKnowledge','VTBKSHF302',822.980591,560.417480,-155.998947,17216,58,0),
(112,'PoKnowledge','VTBKSHF302',904.722595,560.202087,-155.998962,17312,58,0),
(113,'PoKnowledge','VTBKSHF302',904.412964,699.215210,-159.998947,17375,58,0),
(114,'PoKnowledge','VTBKSHF302',823.745178,699.684998,-159.998947,17024,58,0),
(115,'PoKnowledge','VSSHELF301',912.881775,651.226379,-152.248947,17344,58,0),
(116,'PoKnowledge','VSSHELF301',912.881165,632.711548,-152.245407,17344,58,0),
(119,'PoKnowledge','VSPSHELF301',847.741455,551.999939,-150.248962,17280,58,0),
(120,'PoKnowledge','VSPSHELF301',839.988708,551.936584,-150.248169,17280,58,0),
(121,'PoKnowledge','VTDESK302',878.979919,643.908508,-163.998947,17280,58,0),
(122,'PoKnowledge','VTDESK302',850.420166,664.701050,-163.998962,17344,58,0),
(123,'PoKnowledge','VTCHAIR302',879.349976,647.565857,-163.998947,17389,58,0),
(124,'PoKnowledge','VTCHAIR302',846.144287,664.317078,-163.998947,17103,58,0),
(125,'PoKnowledge','POPCRATE501',844.073242,623.046265,-163.998947,17344,58,0),
(126,'PoKnowledge','POPCRATE501',849.955444,628.803406,-163.998947,17370,58,0),
(127,'PoKnowledge','POPCRATE501',843.228638,629.505066,-158.064911,17188,58,0),
(-128,'PoKnowledge','POPCRATE501',851.230835,622.973083,-157.748947,17300,58,0),
(-127,'PoKnowledge','POPCRATE500',851.278687,622.474365,-163.998947,17344,58,0),
(-126,'PoKnowledge','POPCRATE500',849.902527,628.721924,-159.998947,17280,58,0),
(-125,'PoKnowledge','POPCRATE500',844.154053,630.103699,-163.998947,17280,58,0),
(-124,'PoKnowledge','SHBOOK306',879.286621,644.084839,-160.248947,17388,58,0),
(-123,'PoKnowledge','SHBOOK307',913.082153,648.334229,-146.998947,17152,58,0),
(-122,'PoKnowledge','SHBOOK306',912.862000,636.746704,-148.748947,17191,58,0),
(-121,'PoKnowledge','SHBOOK303',913.278137,631.963867,-146.102997,17152,58,0),
(-119,'PoKnowledge','SHBOOK302',912.868835,635.377747,-148.188995,17152,58,0),
(-117,'PoKnowledge','SHBOOK301',913.123901,630.564392,-146.116989,17152,58,0),
(-116,'PoKnowledge','SHBOOK302',913.160339,631.052979,-146.123962,17152,58,0),
(-115,'PoKnowledge','VSWRACKS304',816.764526,670.776184,-159.998947,17152,58,0),
(-114,'PoKnowledge','VSWRACKS303',816.671814,685.794373,-159.998947,17152,58,0);