DROP TABLE IF EXISTS `random_spawn_loc`; CREATE TABLE `random_spawn_loc` ( `groupId` int(11) NOT NULL default '0', `x` int(11) NOT NULL default '0', `y` int(11) NOT NULL default '0', `z` int(11) NOT NULL default '0', `heading` int(11) NOT NULL default '-1', PRIMARY KEY (`groupId`,`x`,`y`,`z`,`heading`) ) ENGINE=InnoDB; -- -- Dumping data for table `l2jdb`.`random_spawn_loc` -- INSERT INTO `random_spawn_loc` VALUES (1,151680,-174891,-1782,-1), (1,154153,-220105,-3402,-1), (1,178834,-184336,-355,-1), (2,-12345,121695,-2984,0), (3,81360,150016,-3528,16000), (4,120493,76520,-2136,35500), (5,-84745,151732,-3128,50000), (6,113481,218450,-3624,33000), (7,80129,56947,-1552,32500), (8,146986,29566,-2271,32500), (9,183280,-11905,-4904,-1), (10,185662,-13093,-5498,-1), (11,-52172,78884,-4741,-1), (11,-41350,209876,-5087,-1), (11,-21657,77164,-5173,-1), (11,45029,123802,-5413,-1), (11,83175,208998,-5439,-1), (11,111337,173804,-5439,-1), (11,118343,132578,-4831,-1), (11,172373,-17833,-4901,-1), (12,-19360,13278,-4901,-1), (12,43093,143706,-5381,-1), (12,46303,170091,-4981,-1), (12,77787,78176,-5125,-1), (12,114013,84326,-6541,-1), (12,140519,79464,-5429,-1), (13,-84356,152742,-3204,-1), (14,-83157,149846,-3155,-1), (15,-79563,152726,-3204,-1), (16,-79123,155098,-3204,-1), (17,-16168,124129,-3143,-1), (18,-14563,121461,-3015,-1), (19,-14199,126128,-3171,-1), (20,-12344,123605,-3132,-1), (21,16901,144748,-3027,-1), (22,17557,147084,-3150,-1), (23,19038,142923,-3078,-1), (24,20826,145769,-3171,-1), (25,77830,148627,-3623,-1), (26,81540,144204,-3559,-1), (27,81556,152183,-3559,-1), (28,83872,143882,-3431,-1), (29,85328,147352,-3431,-1), (30,114907,77916,-2662,-1), (31,115509,74857,-2625,-1), (32,118273,74592,-2529,-1), (33,107251,218166,-3701,-1), (34,115482,219266,-3689,-1), (35,80039,54291,-1586,-1), (36,81002,53495,-1586,-1), (37,81527,56009,-1551,-1), (38,143926,26468,-2338,-1), (39,147460,20537,-2101,-1), (40,150417,25182,-2141,-1), (41,-83107,150270,-3155,-1), (42,-83070,152740,-3204,-1), (43,-80752,152738,-3204,-1), (44,-80690,149996,-3070,-1), (45,-80037,154344,-3204,-1), (46,-15549,124170,-3143,-1), (47,-14480,122330,-3126,-1), (48,-14268,124941,-3156,-1), (49,-13252,123689,-3143,-1), (50,-12591,122673,-3142,-1), (51,15722,142877,-2732,-1), (52,18172,145740,-3140,-1), (53,19096,143980,-3096,-1), (54,19823,145863,-3142,-1), (55,79825,148619,-3559,-1), (56,81535,146866,-3559,-1), (57,81547,150347,-3559,-1), (58,83319,148054,-3431,-1), (59,83894,147495,-3431,-1), (60,115893,77551,-2729,-1), (61,115936,75382,-2625,-1), (62,117098,77066,-2720,-1), (63,118049,75783,-2715,-1), (64,107256,218615,-3701,-1), (65,109660,217339,-3775,-1), (66,110189,221393,-3569,-1), (67,111389,219257,-3572,-1), (68,113479,217795,-3731,-1), (69,114086,220214,-3568,-1), (70,80416,55959,-1586,-1), (71,80617,54116,-1586,-1), (72,82048,55417,-1551,-1), (73,82863,53290,-1522,-1), (74,145015,25269,-2167,-1), (75,145394,27629,-2295,-1), (76,146616,25816,-2039,-1), (77,147440,30047,-2487,-1), (78,147459,21148,-2167,-1), (79,148013,27029,-2231,-1), (80,149515,27641,-2295,-1), (81,149899,24719,-2167,-1), (82,184460,-12015,-5495,-1), (83,184460,-12015,-5495,-1);