rendered paste bodyDROP 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),
(13,-83157,149846,-3155,-1),
(13,-79563,152726,-3204,-1),
(13,-79123,155098,-3204,-1),
(14,-16168,124129,-3143,-1),
(14,-14563,121461,-3015,-1),
(14,-14199,126128,-3171,-1),
(14,-12344,123605,-3132,-1),
(15,16901,144748,-3027,-1),
(15,17557,147084,-3150,-1),
(15,19038,142923,-3078,-1),
(15,20826,145769,-3171,-1),
(16,77830,148627,-3623,-1),
(16,81540,144204,-3559,-1),
(16,81556,152183,-3559,-1),
(16,83872,143882,-3431,-1),
(16,85328,147352,-3431,-1),
(17,114907,77916,-2662,-1),
(17,115509,74857,-2625,-1),
(17,118273,74592,-2529,-1),
(18,107251,218166,-3701,-1),
(18,115482,219266,-3689,-1),
(19,80039,54291,-1586,-1),
(19,81002,53495,-1586,-1),
(19,81527,56009,-1551,-1),
(20,143926,26468,-2338,-1),
(20,147460,20537,-2101,-1),
(20,150417,25182,-2141,-1),
(21,-83107,150270,-3155,-1),
(21,-83070,152740,-3204,-1),
(21,-80752,152738,-3204,-1),
(21,-80690,149996,-3070,-1),
(21,-80037,154344,-3204,-1),
(22,-15549,124170,-3143,-1),
(22,-14480,122330,-3126,-1),
(22,-14268,124941,-3156,-1),
(22,-13252,123689,-3143,-1),
(22,-12591,122673,-3142,-1),
(23,15722,142877,-2732,-1),
(23,18172,145740,-3140,-1),
(23,19096,143980,-3096,-1),
(23,19823,145863,-3142,-1),
(24,79825,148619,-3559,-1),
(24,81535,146866,-3559,-1),
(24,81547,150347,-3559,-1),
(24,83319,148054,-3431,-1),
(24,83894,147495,-3431,-1),
(25,115893,77551,-2729,-1),
(25,115936,75382,-2625,-1),
(25,117098,77066,-2720,-1),
(25,118049,75783,-2715,-1),
(26,107256,218615,-3701,-1),
(26,109660,217339,-3775,-1),
(26,110189,221393,-3569,-1),
(26,111389,219257,-3572,-1),
(26,113479,217795,-3731,-1),
(26,114086,220214,-3568,-1),
(27,80416,55959,-1586,-1),
(27,80617,54116,-1586,-1),
(27,82048,55417,-1551,-1),
(27,82863,53290,-1522,-1),
(28,145015,25269,-2167,-1),
(28,145394,27629,-2295,-1),
(28,146616,25816,-2039,-1),
(28,147440,30047,-2487,-1),
(28,147459,21148,-2167,-1),
(28,148013,27029,-2231,-1),
(28,149515,27641,-2295,-1),
(28,149899,24719,-2167,-1),
(29,184460,-12015,-5495,-1),
(30,184460,-12015,-5495,-1);