Search results

-- 7381 Silver Tabby Cat update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 7381); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=7381;

-- 7384 Cornish Rex Cat update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 7384); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=7384;

-- 7032 Greater Obsidian Elemental update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 7032); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=7032;

He is not a trainer. -- 48569 Eitrigg UPDATE `creature_template` SET `npcflag` = 15 WHERE `entry` = 48569;

-- 5858 Greater Lava Spider UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=5858;

-- 24819 Anvilrage Enforcer UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24819; DELETE FROM `smart_scripts` WHERE (`entryorguid`=24819 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`...

-- 41237 Kharanos Mountaineer update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41237);

-- 41175 Frostmane Scout update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41175);

-- 41146 Frostmane Scavenger update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41146);

-- 41202 Constriction Totem update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41202);

-- 1195 Forest Lurker update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 1195); DELETE FROM `creature_template_addon` WHERE `entry`=1195; INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES...

-- 45675 Garona Halforcen UPDATE `creature_template` SET `npcflag` = 3 WHERE `entry` = 45675;

-- 47119 Glenn Arbuckle DELETE FROM `creature` WHERE `id`=47119; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`...

-- 46591 Colin Thundermar UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 46591; DELETE FROM `smart_scripts` WHERE (`entryorguid`=46591 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`...

-- 47121 Aquinastrasz flight master DELETE FROM `creature` WHERE `id`=47121; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`...

-- 42536 Revantusk Stalker auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 42536);

-- 42518 Wildhammer Warrior auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 42518);

-- 48269 Dark Ranger update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 48269);

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

-- 883 Deer wrong auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 883);