Sentinel Hill Duped Auras

eyerobot

Gold Supporter
Superior Member
917
2015
22
Location
Barryton Michigan USA
Code:
-- 501 Riverpaw Herbalist

update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 501);

UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=501;

-- 54373 Riverpaw Herbalist

update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 54373);

UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=54373;

-- 452 Riverpaw Bandit

update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 452);

UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=452;

-- 51915 Westfall Brigade Guard

update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 51915);

UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=51915;
 
Top