Search results

DELETE FROM `fishing_loot_template` WHERE (`entry`=810); INSERT INTO `fishing_loot_template` VALUES (810, 118, 0.25, 1, 1, 1, 1), (810, 159, 0.01, 1, 1, 1, 1), (810, 727, 0.01, 1, 1, 1, 1), (810, 766, 0.01, 1, 1, 1, 1), (810, 767, 0.01, 1, 1, 1, 1), (810, 768, 0.01, 1, 1, 1, 1), (810, 774...

DELETE FROM `fishing_loot_template` WHERE (`entry`=162); INSERT INTO `fishing_loot_template` VALUES (162, 118, 0.25, 1, 1, 1, 1), (162, 159, 0.01, 1, 1, 1, 1), (162, 727, 0.01, 1, 1, 1, 1), (162, 766, 0.01, 1, 1, 1, 1), (162, 767, 0.01, 1, 1, 1, 1), (162, 768, 0.01, 1, 1, 1, 1), (162, 774...

This data is correct according to https://cata-twinhead.twinstar.cz/?zone=85#fishing:0+1-13 The reference loot that we have listed for fishing zones contains mostly invalid items, So i'm not using it. Also when you add quest items to a fishing zone, The reference loot won't activate. So...

-- 48668 Schnottz Elite Trooper update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 48668); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=48668;

-- 42098 Invisible Stalker (Cataclysm Boss, Ignore Combat, Floating) DELETE FROM `smart_scripts` WHERE (`entryorguid`=42098 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`...

-- 48547 Harrison Jones UPDATE `creature_template_addon` SET `auras`='84756' WHERE `entry`=48547;

-- 48621 Sullah UPDATE `creature_template_addon` SET `auras`='84756' WHERE `entry`=48621;

-- 8197 Chronalis UPDATE `creature_template` SET `InhabitType` = 5 WHERE `entry` = 8197; UPDATE `creature` SET `spawndist`='100', `MovementType`='1' WHERE `id`= 8197; DELETE FROM `creature` WHERE `id`=8197; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`...

-- 43173 Redridge Garrison Watchman update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 43173); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=43173;

-- 46487 Marshtide Peasant update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 46487); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=46487;

-- 41138 Okril'lon Defender update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41138); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=41138;

-- 866 Stonard Grunt update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 866); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=866;

-- 41134 Tak'arili update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 41134); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=41134;

-- 46164 Marshtide Footman update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 46164); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=46164;

-- 46841 Marshtide Cleric update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 46841); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=46841; UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 46841; DELETE FROM...

I know theres a million of these posted, But i'm fixing them as they appear on my console. -- 46749 Stonard Wardrummer update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 46749); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=46749...

-- 833 Coyote Packleader update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 833); UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=833;

-- 43861 Sven Yorgen update `creature_addon` set `auras` = '49415' where guid in (select guid from creature where id = 43861); UPDATE `creature_template_addon` SET `auras`='49415' WHERE `entry`=43861;

-- 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...

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