MQWarp/MQZone/MQGate Detector (Code Name: The VZTZ Hammer!)

[TheLieka]

SQL Part 2: Continued

insert into zone_points values (377, 'freporte',9,100,-64,-24,0,-84,-926,-28,999,0,9);
insert into zone_points values (378, 'freporte',10,448,-360,-28,0,-418,-622,-28,999,0,9);
insert into zone_points values (379, 'freporte',11,-1306,999999,-52.21,0,4131,332,-24.28,999,0,34);
insert into zone_points values (380, 'freporte',53,-155,344,-94,0,-740,-1632,-94,999,0,9);
insert into zone_points values (381, 'freportw',5,149,-716,-11,0,12,-656,-55,999,0,9);
insert into zone_points values (382, 'freportw',6,96,-652,-39,0,147,-682,-13,999,0,9);
insert into zone_points values (383, 'freportw',7,270,-699,-25,0,-376,-83,999999,999,0,8);
insert into zone_points values (384, 'freportw',8,225,-126,-10,0,-415,491,999999,999,0,8);
insert into zone_points values (385, 'freportw',9,-84,-926,-28,0,100,-64,-24,999,0,10);
insert into zone_points values (386, 'freportw',10,-418,-622,-28,0,448,-360,-28,999,0,10);
insert into zone_points values (387, 'freportw',12,999999,775,-24,0,999999,-1592,-54,999,0,22);
insert into zone_points values (388, 'freportw',51,1585,-272,2,0,372,722,-8,999,0,8);
insert into zone_points values (389, 'freportw',52,719,-586,-20,0,-2,-441,-18,999,0,8);
insert into zone_points values (390, 'freportw',53,-740,-1632,-94,0,-155,344,-94,999,0,10);
insert into zone_points values (391, 'freportw',177,0,0,0,0,-406,-234,-157,258,0,202);
insert into zone_points values (392, 'freportn',7,-379,-83,-25,0,267,-700,999999,0,0,9);
insert into zone_points values (393, 'freportn',8,-415,491,-11,0,227,-124,999999,0,0,9);
insert into zone_points values (394, 'freportn',51,372,722,-11,0,1590,-275,4,0,0,9);
insert into zone_points values (395, 'freportn',52,-6,-436,-20,0,730,-581,-18,0,0,9);
insert into zone_points values (396, 'grobb',1,-133,50,3.13,0,-2827,-665.3,-30,127.5,0,46);
insert into zone_points values (397, 'halas',1,-692.79,-77.88,3.13,0,3684,380,5,999,0,30);
insert into zone_points values (398, 'kaladima',1,-64.45,42.17,3.13,0,3131,-179,3.13,999,0,68);
insert into zone_points values (399, 'kaladima',2,419.97,333.59,-18.15,0,416,340,-22,999,0,67);
insert into zone_points values (400, 'kaladima',3,390,-264,3.13,0,354,-224,4,999,0,67);
insert into zone_points values (401, 'kaladimb',1,416,340,-22,0,419.97,333.59,-18.15,999,0,60);
insert into zone_points values (402, 'kaladimb',2,354,-224,4,0,390,-264,4,999,0,60);
insert into zone_points values (413, 'neriaka',1,0,0,0,0,-242,999999,999999,999,0,41);
insert into zone_points values (414, 'neriaka',2,86,-354,-11,0,999999,-367,999999,999,0,41);
insert into zone_points values (415, 'neriaka',3,29,155,30,0,2252,-1105,1,999,0,25);
insert into zone_points values (416, 'neriakb',1,0,0,0,0,-247,999999,999999,999,0,40);
insert into zone_points values (417, 'neriakb',2,86,-401,-11,0,999999,-361,999999,999,0,40);
insert into zone_points values (418, 'neriakb',3,200,-852,-39,0,206,999999,999999,999,0,42);
insert into zone_points values (419, 'neriakc',1,205,-852,-39,0,200,999999,999999,999,0,41);
insert into zone_points values (420, 'neriakc',2,0,0,0,0,-876,1146,-1,252,0,57);
insert into zone_points values (440, 'oggok',1,-396,-90,4,0,1609,901.4,58,126,0,47);
insert into zone_points values (472, 'qeynos',3,0,0,0,0,230,-64,-80,129,0,45);
insert into zone_points values (473, 'qeynos',4,177,-477,-16,0,307,-184,-38,250,0,45);
insert into zone_points values (474, 'qeynos',22,-185,149,-64,0,-175,147,-77,999,0,45);
insert into zone_points values (475, 'qeynos',33,-151,-596,-25,0,217,-301,-38,999,0,45);
insert into zone_points values (476, 'qeynos2',1,0,0,0,0,-168,-714,-10,999,0,2);
insert into zone_points values (477, 'qeynos2',2,0,0,0,0,-30,-153,9,250,0,2);
insert into zone_points values (478, 'qeynos2',4,0,0,0,0,-175,141,-80,384,0,45);
insert into zone_points values (479, 'qeynos2',5,175,90,-39,0,637,105,-38,999,0,45);
insert into zone_points values (480, 'qeynos2',6,194,348,-27,0,889,217,-50,999,0,45);
insert into zone_points values (481, 'qeynos2',14,0,0,0,0,893,756,-82,0,0,2);
insert into zone_points values (482, 'qeynos2',77,0,0,0,0,147,-289,-157,383,0,202);
insert into zone_points values (483, 'qeynos2',99,308,-161,4,0,1057,-49,-43,999,0,45);
insert into zone_points values (484, 'qcat',1,-175,147,-77,0,-189,127,-90,999,0,1);
insert into zone_points values (485, 'qcat',2,217,-301,-38,0,-147,-608,-24,999,0,1);
insert into zone_points values (486, 'qcat',3,307,-184,-38,0,175,-483,-27,999,0,1);
insert into zone_points values (487, 'qcat',4,339,-175,-67,0,273,-553,-62,999,0,1);
insert into zone_points values (488, 'qcat',5,637,105,-40,0,175,90,-38,999,0,2);
insert into zone_points values (489, 'qcat',6,889,217,-50,0,190,340,-30,999,0,2);
insert into zone_points values (490, 'qcat',7,0,0,0,0,1122,-852,-50,275,0,38);
insert into zone_points values (491, 'qcat',99,1051,-49,-58,0,302,-161,-13,999,0,2);
insert into zone_points values (492, 'rivervale',98,-371,-278,4,0,2022,3825,463,999,0,20);
insert into zone_points values (493, 'rivervale',99,0,0,0,0,410,-2552,-4,999,0,33);
insert into zone_points values (537, 'qrg',5,-594.8,211.9,2.8,0,5100.9,196.7,-1,128,0,4);
insert into zone_points values (538, 'qrg',7,47.4,-512.2,42.8,129.6,47.4,-512.2,42.8,0,0,3);
insert into zone_points values (549, 'butcher',1,-1312,-3070,3.75,0,-1650,2673,1,999,0,54);
insert into zone_points values (550, 'butcher',2,3114.75,-186.57,3.75,0,-64,42,4,999,0,60);
insert into zone_points values (551, 'butcher',3,-2929,-344,3.75,0,2856,262,473,999,0,70);
insert into zone_points values (552, 'butcher',77,1752,-502,1,0,829,474,-157,999,0,202);
insert into zone_points values (557, 'cauldron',1,2856,262,472.47,0,-2935,-337,3.13,999,0,68);
insert into zone_points values (558, 'cauldron',2,-1167,-1013,-330,0,100,30,326,999,0,64);
insert into zone_points values (559, 'cauldron',3,-2002.06,-627.76,93.15,0,64,330,3.13,999,0,63);
insert into zone_points values (575, 'ecommons',1,-2462,-105,3.13,0,2604,2903,3.13,999,0,34);
insert into zone_points values (590, 'everfrost',1,3700,370,3,0,-676,-76.46,3.13,999,0,29);
insert into zone_points values (591, 'everfrost',2,-3061,-530,-109,0,95,-340,4,999,0,17);
insert into zone_points values (592, 'everfrost',3,2020,-7048,-60,0,-60,100,4,999,0,73);
insert into zone_points values (594, 'everfrost',77,2884.4,-75,-60,0,846,131,-157,999,0,202);
insert into zone_points values (640, 'innothule',1,2569.11,1140.77,-24.78,0,-3203,1098,-21,192.2,0,35);
insert into zone_points values (641, 'innothule',2,-1131.29,1893.76,-9.22,0,-1102,-3100.5,-9,8,0,47);
insert into zone_points values (642, 'innothule',3,-2763.64,-615.55,-31.44,0,-95.1,-2.3,3.1,9.1,0,52);
insert into zone_points values (643, 'innothule',4,140.98,-827.97,-8.37,0,-36,7.4,3,255.5,0,65);
insert into zone_points values (644, 'innothule',77,-731.99,-30.93,-25.78,0,-812,95,-157,999,0,202);
insert into zone_points values (647, 'kerraridge',1,467.9,-915.7,23,60.3,-512,2653,-34.5,194.8,0,38);
insert into zone_points values (648, 'kithicor',1,644,4890,693,0,-979,91,4,999,0,5);
insert into zone_points values (649, 'kithicor',2,2007,3825,465,0,-369,-282,4,999,0,19);
insert into zone_points values (657, 'lavastorm',1,-937.4,-1063,16,0,-15,856,5,999,0,44);
insert into zone_points values (658, 'lavastorm',25,-2117.83,-194.11,-16.45,0,3107,289,-17,999,0,25);
insert into zone_points values (659, 'lavastorm',31,798,223,129,0,-476.07,-485.77,73.72,999,0,31);
insert into zone_points values (660, 'lavastorm',32,915,483,54,0,-413,-265,-112,999,0,32);
insert into zone_points values (663, 'lfaydark',1,925,-2185,0,0,579,2205,-112,999,0,56);
insert into zone_points values (664, 'lfaydark',2,2179,-1213,0,0,-2624,-1113,1,999,0,54);
insert into zone_points values (665, 'lfaydark',3,-1111,3360,4,0,-347,126,-182,999,0,59);
insert into zone_points values (666, 'lfaydark',9,0,0,0,0,910,-1775,-75,226,0,42);
insert into zone_points values (675, 'misty',1,-834,1432,-7,0,228,152,6,999,0,11);
insert into zone_points values (676, 'misty',2,410,-2588,-7,0,-79,78,5,1470,0,19);
insert into zone_points values (677, 'misty',77,0,0,0,0,830,1227,-157,511,0,202);
insert into zone_points values (685, 'nektulos',77,0,0,0,0,-841,132,-157,257,0,202);
insert into zone_points values (686, 'nro',1,4175,999999,-24.27,0,-1097,999999,-52.22,999,0,10);
insert into zone_points values (687, 'nro',2,-1889,999999,3,0,2501.1,999999,999999,999,0,37);
insert into zone_points values (688, 'nro',3,2626,2908,4,0,-2461,-152,4,999,0,22);
insert into zone_points values (689, 'nro',4,0,0,0,0,5330,390,-15,322,0,110);
insert into zone_points values (690, 'northkarana',0,0,0,0,0,0,0,-32,128,0,152);
insert into zone_points values (691, 'northkarana',6,0,0,0,0,0,0,-25,0,0,152);
insert into zone_points values (692, 'oasis',1,2545,999999,999999,0,-1876,999999,999999,999,0,34);
insert into zone_points values (693, 'oasis',2,-1876,255,5,0,1530,95.6,7,104.9,0,35);
insert into zone_points values (700, 'qeytoqrg',1,-304.6,999999,999999,0,1395,999999,999999,999,0,2);
insert into zone_points values (701, 'qeytoqrg',2,1222,-2468,-1,0,36,45,999999,999,0,12);
insert into zone_points values (703, 'qeytoqrg',3,3436,-1135,3,0,-162.1,16.05,3.8009,999,0,17);
insert into zone_points values (704, 'qeytoqrg',4,5199,69,-3,0,-65.9,136.9,4,241,0,3);
insert into zone_points values (725, 'rathemtn',1,3411,3036,-1.4,0,2518,-2282,4,999,0,51);
insert into zone_points values (726, 'rathemtn',2,416,-3108,3,0,377,3424,2,999,0,47);
insert into zone_points values (738, 'sro',1,1535,196,5,0,-1899,95.6,7,11.2,0,37);
insert into zone_points values (739, 'sro',2,-3207,1137,-23,0,2563,1153,-23,117.1,0,46);
insert into zone_points values (740, 'southkarana',1,-8554,1144,3,0,4374,1151,1,999,0,51);
insert into zone_points values (741, 'steamfont',1,-2056,526,-107,0,54,-77,4,999,0,55);
insert into zone_points values (742, 'steamfont',2,590,2212,-110,0,918,-2177,-4,999,0,57);

[TheLieka]

SQL Part 2: Concluded

insert into zone_points values (743, 'steamfont',77,0,0,0,0,-401,-76,-157,255,0,202);
insert into zone_points values (752, 'soltemple',1,243,56,2,0,1322.4,280.9,149,128,0,27);
insert into zone_points values (769, 'tox',0,-1518.6,-919.3,-37.4,0,0,0,-32,128,0,152);
insert into zone_points values (770, 'tox',1,2515.4,222.29,-44.72,0,-1556,-184,-45,999,0,24);
insert into zone_points values (771, 'tox',2,-2627,-431,-41,0,878.4,101.5,3.8,92.5,0,75);
insert into zone_points values (772, 'tox',3,-512,2653,-34.5,62,467.9,-915.7,24,60.3,0,74);
insert into zone_points values (773, 'tox',4,0,0,0,0,266,203,-38,0,0,45);
insert into zone_points values (774, 'tox',77,2326,-580,-45,0,662,36,-157,256,0,202);
insert into zone_points values (775, 'tox',177,-2339,284,-47,0,-840,1227,-157,257,0,202);
insert into zone_points values (799, 'qey2hh1',1,0,0,0,0,1238,-2449,-2,999,0,4);
insert into zone_points values (800, 'arena',1,-57.43,-844.61,12.02,0,2346.56,2676.59,97,999,0,51);
insert into zone_points values (801, 'befallen',1,-75.27,35.22,3.75,0,-1150,596,-38,999,0,21);
insert into zone_points values (802, 'blackburrow',1,-158.97,38.92,3.75,0,3431,-1155,3.75,999,0,4);
insert into zone_points values (803, 'blackburrow',2,94.53,-345.21,3.75,0,-3058,-530,-109,999,0,30);
insert into zone_points values (804, 'blackburrow',7,163.07,148.64,-155.19,0,270,2730,-2,999,0,181);
insert into zone_points values (806, 'lakerathe',1,2513,-2280,5,0,3411,3036,-2,999,0,50);
insert into zone_points values (807, 'lakerathe',2,2347.52,2704.3,95,0,-59,-841,9,999,0,77);
insert into zone_points values (808, 'lakerathe',3,4376.63,1155.48,3.13,0,-8563,1156,4,999,0,14);
insert into zone_points values (851, 'guktop',1,1632,353,-87,0,1667,-136,-98,0,0,66);
insert into zone_points values (852, 'guktop',2,1535,-71,-98,0,1498,-13,-94,0,0,66);
insert into zone_points values (853, 'guktop',4,1134,608,-81,0,1127,650,-85,999,0,66);
insert into zone_points values (854, 'guktop',5,1196,-192,-78,0,1196,-212,-78,0,0,66);
insert into zone_points values (855, 'guktop',6,-63.68,41.72,3.13,0,172.2,-811.6,-7,65.1,0,46);
insert into zone_points values (857, 'gukbottom',1,1667,-136,-98,0,1630,359,-88,0,0,65);
insert into zone_points values (858, 'gukbottom',2,1498,-13,-94,0,1527,-59,-94,0,0,65);
insert into zone_points values (860, 'gukbottom',4,1127,650.56,-88,0,1134,608,-81,999,0,65);
insert into zone_points values (861, 'gukbottom',5,1196,-212,-81,0,1196,-192,-78,0,0,65);
insert into zone_points values (862, 'gukbottom',3,0,0,0,0,170,-818,-9,0,0,46);
insert into zone_points values (888, 'mistmoore',1,-350,123,-178,0,-1115,3359,4,999,0,57);
insert into zone_points values (889, 'najena',1,-19,869,4,0,-936,-1058,13,999,0,27);
insert into zone_points values (905, 'permafrost',1,0,0,0,0,2022,-7073,-55,999,0,30);
insert into zone_points values (910, 'soldunga',1,-443,-525,70,0,783.95,227.54,127.36,999,0,27);
insert into zone_points values (911, 'soldunga',2,-303,-507,25,0,-273,-506,25,999,0,32);
insert into zone_points values (912, 'soldunga',3,-1080,-541,-0.9,0,-1081,-518,-0.9,999,0,32);
insert into zone_points values (914, 'soldunga',5,-361,-384,13,0,-364,-413,11,999,0,32);
insert into zone_points values (915, 'soldunga',6,-705,-450,-12,128,-706,-434,-29,52,0,32);
insert into zone_points values (916, 'soldunga',7,-286,-506,25,0,-278,999999,999999,999,0,32);
insert into zone_points values (917, 'soldunga',8,-165,-551,26,0,-166,-582,17,999,0,32);
insert into zone_points values (918, 'soldunga',9,-986,-566,2,0,-977,-475,-28,128,0,32);
insert into zone_points values (920, 'soldunga',11,0,0,0,0,-371,999999,999999,999,0,32);
insert into zone_points values (921, 'soldunga',12,-872,-391,11,0,-907,-381,10,128,0,31);
insert into zone_points values (970, 'paw',1,0,0,0,0,-3143,931,-11,999,0,14);
insert into zone_points values (971, 'unrest',1,81,335,3,0,-2032,-626,91,999,0,70);
insert into zone_points values (977, 'qeynos2',7,-151,-5,1.5,0,464,-442,1.5,999,0,1);
insert into zone_points values (978, 'qeynos2',8,-26,356,1.5,0,586,-80,1.5,999,0,1);
insert into zone_points values (1142, 'kedge',1,0,0,0,0,-1182,-1009,-334,999,0,70);
insert into zone_points values (1145, 'highpass',1,844.8,105.4,4.1,0,-3097,-8338,690,999,0,15);
insert into zone_points values (1146, 'highpass',2,-981,92,431,0,557,4892,691,999,0,20);
insert into zone_points values (1147, 'soldungb',1,-413,-265,-112,0,911.18,484.37,57.44,999,0,27);
insert into zone_points values (1148, 'soldungb',2,-281,-506,25,0,-295,-505,26,144,0,31);
insert into zone_points values (1149, 'soldungb',3,-1084,-536,0,0,-1084,-538,0,999,0,31);
insert into zone_points values (1150, 'soldungb',4,0,0,0,0,999999,-454,999999,999,0,31);
insert into zone_points values (1151, 'soldungb',5,-365,-400,11,0,-372,-381,13,122,0,31);
insert into zone_points values (1152, 'soldungb',6,-361,-400,11,0,999999,-398,999999,999,0,31);
insert into zone_points values (1153, 'soldungb',7,-281,-506,25,0,-176,-537,29,157,0,31);
insert into zone_points values (1154, 'soldungb',8,0,0,0,0,999999,-570,21,999,0,31);
insert into zone_points values (1155, 'soldungb',9,-996,-489,-24,0,-972,-504,-22,128,0,31);
insert into zone_points values (1158, 'runnyeye',1,0,0,0,0,903,-1844,4,999,0,16);
insert into zone_points values (1159, 'runnyeye',2,248,141,4,0,-830,1431,-9,999,0,33);
insert into zone_points values (1160, 'erudnext',1,-1398.23,-256.76,-40.28,128,-1410.7,-184.5,38,999,0,24);
insert into zone_points values (1161, 'erudnext',2,-1408.01,-308.03,40.7,0,-1410.7,-310.3,-42,128,0,24);
insert into zone_points values (1162, 'erudnext',3,-1556,-184,-45,999,2550,296,-48,999,0,38);
insert into zone_points values (1174, 'cazicthule',1,70.4,-65.1,3.1,64,-1464,-107,52,5,0,47);
insert into zone_points values (1218, 'fearplane',1,844,482,142,0,-2288,2605,1,999,0,47);
insert into zone_points values (1268, 'paineel',1,891,105,4,0,-2607,-429,-42,40,0,38);
insert into zone_points values (1269, 'paineel',2,0,0,0,0,669.6,300,-69.4,148.6,0,39);
insert into zone_points values (1270, 'paineel',3,735,-884,-33,0,746,-900,-34,192,0,101);
insert into zone_points values (1271, 'paineel',4,601.3,-940.8,-94.2,0,800,200,0,0,0,75);
insert into zone_points values (1272, 'paineel',5,0,0,0,0,725,999999,999999,999,0,75);
insert into zone_points values (1273, 'paineel',10,910.9,523.3,-118.2,0,959,557.3,-79,64,0,75);
insert into zone_points values (1274, 'paineel',11,959,557.3,-79,192,906,525,-121,128,0,75);
insert into zone_points values (1275, 'paineel',12,881.6,755.9,-77.2,124.9,1068.7,658.2,-36.2,128,0,75);
insert into zone_points values (1276, 'paineel',13,1085.8,657.7,-35.3,128,464,217,41,0,0,75);
insert into zone_points values (1277, 'paineel',14,1068.7,658.2,-35.2,0,886,755,-77,0,0,75);
insert into zone_points values (1278, 'paineel',15,476,217,43.7,0,1091,658,-41,0,0,75);
insert into zone_points values (1314, 'warrens',2,-92.4,1142,-107.2,59.8,712,-876,-33,107,0,75);
insert into zone_points values (1315, 'warrens',3,750,-887,-33,0,712,-876,-33,107,0,75);
insert into zone_points values (1327, 'erudnext',4,-645,-193.6,77.7,65,712,807,22,192,0,23);
insert into zone_points values (1328, 'highpass',3,-91.5,-112.6,4.1,0,-16,88,4.1,192.2,0,6);
insert into zone_points values (1329, 'highpass',4,62.8,-112.6,4.1,0,-16,88,4.1,192.2,0,6);
insert into zone_points values (1333, 'soldungb',12,-705,-450,-12,0,-681,-463,-20,34,0,31);
insert into zone_points values (1750, 'erudnext',5,-645.1,-271.1,-70.7,192.4,-394.1,-6.6,41.8,0,0,24);
insert into zone_points values (1751, 'erudnext',6,-344.1,-10,39.8,0,-770,-183,54.7,0,0,24);

Holy shit - ok, I wonder if anyone else will actually make it through all that. Nonetheless, that's the pride and joy of VZ/TZ - enjoy it and keep those hackers at bay.

Thanks,
Dax

[TheLieka]

dammit, I missed AirPlane:

delete from zone_points where id = 1163 || id = 1164 || id = 1165 || id = 1166 || id = 1167 || id = 1168 || id = 1169 || id = 1170 || id = 1171 || id = 1172 || id = 1173;

insert into zone_points values (1163, 'airplane', 1, 0, 0, 0, 0, -387, 415, 132, 0, 0, 37);
insert into zone_points values (1164, 'airplane', 3, 0, 0, 0, 0, 516, 1108, -8, 999, 0, 71);
insert into zone_points values (1165, 'airplane', 4, 0, 0, 0, 0, -103, -434, -359, 999, 0, 71);
insert into zone_points values (1166, 'airplane', 5, 0, 0, 0, 0, 564, 320, -55, 0, 0, 71);
insert into zone_points values (1167, 'airplane', 6, 0, 0, 0, 0, 1185, -781, 130, 999, 0, 71);
insert into zone_points values (1168, 'airplane', 7, 0, 0, 0, 0, -884, 1089, 412, 999, 0, 71);
insert into zone_points values (1169, 'airplane', 8, 0, 0, 0, 0, -750, 306, 772, 999, 0, 71);
insert into zone_points values (1170, 'airplane', 9, 0, 0, 0, 0, -984, -471, 1013, 999, 0, 71);
insert into zone_points values (1171, 'airplane', 10, 0, 0, 0, 0, -262, -1294, 1221, 999, 0, 71);
insert into zone_points values (1172, 'airplane', 11, 999999, 999999, -2000, 999, -41.52, -1552.49, -70.81, 999, 0, 10);
insert into zone_points values (1173, 'airplane', 12, 0, 0, 0, 0, 1463, 574, -765, 250, 0, 71);

Dax

[moydock]

Holy. Shit. Much appreciation Dax. I'll post results, may take me a few days .