Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delete from creature where id in (33920, 34087, 33921, 34036, 34073, 34075, 34084, 34078);
- UPDATE creature_template SET npcflag = 1 WHERE entry IN (SELECT entry FROM npc_vendor WHERE item IN (SELECT entry FROM item_template WHERE (NAME LIKE '%Relentless%' OR NAME LIKE '%furious%' OR NAME LIKE '%deadly%') AND itemlevel >= 213));
- /* doplnky */
- UPDATE npc_vendor SET item = 42122, ExtendedCost = 2605 WHERE entry = 34037 AND item = 42126;
- UPDATE npc_vendor SET item = 42123, ExtendedCost = 2605 WHERE entry = 34076 AND item = 42124;
- delete from creature where id = 34058;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','34058','1','1','1','0','0','1670.61','-4199.13','56.3811','4.04476','25','0','0','32400','0','0','0');
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','34058','0','1','1','0','0','-8775.38','423.978','105.233','5.37526','25','5','0','32400','0','0','0');
- delete from creature where id = 34076;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','34076','0','1','1','0','0','-8780.98','419.937','105.233','5.42317','25','5','0','7048','0','0','0');
- delete from creature where id = 34037;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','34037','1','1','1','0','0','1670.54','-4225.89','56.3837','2.6617','25','5','0','11828','0','0','0');
- /* shat */
- delete from creature where id = 34092;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','34092','530','1','1','0','657','-1975.89','5169.29','-38.6778','0.288797','25','5','0','6986','0','0','0');
- delete from creature where id = 33926;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','33926','530','1','1','0','0','-1973.63','5174.89','-38.2333','0.563684','25','5','0','8025','0','0','0');
- delete from creature where id = 33924;
- -- insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('','33924','530','1','1','0','1417','-1971.38','5165.79','-38.4904','0.512635','25','5','0','6986','0','0','0');
- UPDATE creature_template SET npcflag = 4224 WHERE entry IN (34058, 34076, 34037, 34092, 33926, 33924);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement