Search results

DELETE FROM `fishing_loot_template` WHERE (`entry`=3461); INSERT INTO `fishing_loot_template` VALUES (3461, 6356, .33, 1, 1, 1, 1), (3461, 4563, 0.01, 1, 1, 1, 1), (3461, 6643, 0.09, 1, 1, 1, 1), (3461, 8179, 0.01, 1, 1, 1, 1), (3461, 23334, 0.01, 1, 1, 1, 1), (3461, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3911); INSERT INTO `fishing_loot_template` VALUES (3911, 6356, .33, 1, 1, 1, 1), (3911, 4563, 0.01, 1, 1, 1, 1), (3911, 6643, 0.09, 1, 1, 1, 1), (3911, 8179, 0.01, 1, 1, 1, 1), (3911, 23334, 0.01, 1, 1, 1, 1), (3911, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3471); INSERT INTO `fishing_loot_template` VALUES (3471, 6356, .33, 1, 1, 1, 1), (3471, 4563, 0.01, 1, 1, 1, 1), (3471, 6643, 0.09, 1, 1, 1, 1), (3471, 8179, 0.01, 1, 1, 1, 1), (3471, 23334, 0.01, 1, 1, 1, 1), (3471, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3472); INSERT INTO `fishing_loot_template` VALUES (3472, 6356, .33, 1, 1, 1, 1), (3472, 4563, 0.01, 1, 1, 1, 1), (3472, 6643, 0.09, 1, 1, 1, 1), (3472, 8179, 0.01, 1, 1, 1, 1), (3472, 23334, 0.01, 1, 1, 1, 1), (3472, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3532); INSERT INTO `fishing_loot_template` VALUES (3532, 6356, .33, 1, 1, 1, 1), (3532, 4563, 0.01, 1, 1, 1, 1), (3532, 6643, 0.09, 1, 1, 1, 1), (3532, 8179, 0.01, 1, 1, 1, 1), (3532, 23334, 0.01, 1, 1, 1, 1), (3532, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3470); INSERT INTO `fishing_loot_template` VALUES (3470, 6356, .33, 1, 1, 1, 1), (3470, 4563, 0.01, 1, 1, 1, 1), (3470, 6643, 0.09, 1, 1, 1, 1), (3470, 8179, 0.01, 1, 1, 1, 1), (3470, 23334, 0.01, 1, 1, 1, 1), (3470, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3430); INSERT INTO `fishing_loot_template` VALUES (3430, 6356, .33, 1, 1, 1, 1), (3430, 4563, 0.01, 1, 1, 1, 1), (3430, 6643, 0.09, 1, 1, 1, 1), (3430, 8179, 0.01, 1, 1, 1, 1), (3430, 23334, 0.01, 1, 1, 1, 1), (3430, 6351, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=3431); INSERT INTO `fishing_loot_template` VALUES (3431, 6356, .33, 1, 1, 1, 1), (3431, 4563, 0.01, 1, 1, 1, 1), (3431, 6643, 0.09, 1, 1, 1, 1), (3431, 8179, 0.01, 1, 1, 1, 1), (3431, 23334, 0.01, 1, 1, 1, 1), (3431, 6351, 0.01, 1, 1, 1, 1)...

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;