ss

-- script fix

UPDATE `creature_template` SET `ScriptName` = "npc_ricket_ticker" WHERE `entry` = 49823;

-- spawns

SET @GUID:=610000;
DELETE FROM `creature` WHERE `id` IN (49824,49865,49866,49867);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID+0,'49824','646','1','1','0','0','2022.96','-207.461','-180','4.54638','600','0','0','42','0','0','0','0','0'),
(@GUID+1,'49824','646','1','1','0','0','2024.88','-228.847','-180','4.80163','600','0','0','42','0','0','0','0','0'),
(@GUID+2,'49824','646','1','1','0','0','2073.93','-217.233','-180','1.17308','600','0','0','42','0','0','0','0','0'),
(@GUID+3,'49824','646','1','1','0','0','2064.79','-178.049','-180','2.52397','600','0','0','42','0','0','0','0','0'),
(@GUID+4,'49824','646','1','1','0','0','2074.93','-143.783','-180','0.835363','600','0','0','42','0','0','0','0','0'),
(@GUID+5,'49824','646','1','1','0','0','2051.54','-143.277','-180','1.78962','600','0','0','42','0','0','0','0','0'),
(@GUID+6,'49824','646','1','1','0','0','2022.94','-144.907','-180','2.88525','600','0','0','42','0','0','0','0','0'),
(@GUID+7,'49824','646','1','1','0','0','1954.05','-174.28','-180','3.29366','600','0','0','42','0','0','0','0','0'),
(@GUID+8,'49824','646','1','1','0','0','2015.66','-210.54','-180','6.16664','600','0','0','42','0','0','0','0','0'),
(@GUID+9,'49865','646','1','1','0','0','2134.13','-130.112','-191','1.75193','600','0','0','42','0','0','0','0','0'),
(@GUID+10,'49865','646','1','1','0','0','2123.6','-128.573','-191','0.954751','600','0','0','42','0','0','0','0','0'),
(@GUID+11,'49865','646','1','1','0','0','2116.21','-82.4102','-191','2.11793','600','0','0','42','0','0','0','0','0'),
(@GUID+12,'49865','646','1','1','0','0','2156.55','-74.4644','-191','0.861289','600','0','0','42','0','0','0','0','0'),
(@GUID+13,'49865','646','1','1','0','0','2129.06','-71.7842','-191','1.5171','600','0','0','42','0','0','0','0','0'),
(@GUID+14,'49865','646','1','1','0','0','2163.1','-123.099','-191','5.01212','600','0','0','42','0','0','0','0','0'),
(@GUID+15,'49865','646','1','1','0','0','2168.61','-80.9025','-191','0.790603','600','0','0','42','0','0','0','0','0'),
(@GUID+16,'49865','646','1','1','0','0','2163.1','-123.099','-171','5.01212','600','0','0','42','0','0','0','0','0'),
(@GUID+17,'49866','646','1','1','0','0','2143.11','-262.961','-171','4.25106','600','0','0','42','0','0','0','0','0'),
(@GUID+18,'49866','646','1','1','0','0','2183.39','-250.714','-171','4.94536','600','0','0','42','0','0','0','0','0'),
(@GUID+19,'49866','646','1','1','0','0','2173.74','-210.314','-171','3.21748','600','0','0','42','0','0','0','0','0'),
(@GUID+20,'49866','646','1','1','0','0','2127.87','-226.48','-171','6.25775','600','0','0','42','0','0','0','0','0'),
(@GUID+21,'49866','646','1','1','0','0','2130.39','-216.492','-171','3.35178','600','0','0','42','0','0','0','0','0'),
(@GUID+22,'49866','646','1','1','0','0','2160.51','-204.847','-171','0.722272','600','0','0','42','0','0','0','0','0'),
(@GUID+23,'49867','646','1','1','0','0','2080.59','-320.728','-164','1.72835','600','0','0','42','0','0','0','0','0'),
(@GUID+24,'49867','646','1','1','0','0','2090.36','-317.444','-164','1.31994','600','0','0','42','0','0','0','0','0'),
(@GUID+25,'49867','646','1','1','0','0','2071.32','-321.664','-164','1.87758','600','0','0','42','0','0','0','0','0'),
(@GUID+26,'49867','646','1','1','0','0','2071.76','-370.857','-164','4.06884','600','0','0','42','0','0','0','0','0');