Search results

DELETE FROM `fishing_loot_template` WHERE (`entry`=279); INSERT INTO `fishing_loot_template` VALUES (279, 6647, .02, 1, 1, 1, 1), (279, 4339, .01, 1, 1, 1, 1), (279, 4305, .01, 1, 1, 1, 1), (279, 2997, .01, 1, 1, 1, 1), (279, 3210, .01, 1, 1, 1, 1), (279, 6366, .01, 1, 1, 1, 1), (279, 2072...

DELETE FROM `fishing_loot_template` WHERE (`entry`=232); INSERT INTO `fishing_loot_template` VALUES (232, 117, 0.02, 1, 1, 1, 2), (232, 118, 0.04, 1, 1, 1, 4), (232, 159, 0.04, 1, 1, 1, 3), (232, 765, 0.01, 1, 1, 1, 3), (232, 766, 0.01, 1, 1, 1, 1), (232, 769, 0.01, 1, 1, 1, 1), (232, 774...

DELETE FROM `fishing_loot_template` WHERE (`entry`=172); INSERT INTO `fishing_loot_template` VALUES (172, 117, 0.02, 1, 1, 1, 2), (172, 118, 0.04, 1, 1, 1, 4), (172, 159, 0.04, 1, 1, 1, 3), (172, 765, 0.01, 1, 1, 1, 3), (172, 766, 0.01, 1, 1, 1, 1), (172, 769, 0.01, 1, 1, 1, 1), (172, 774...

DELETE FROM `fishing_loot_template` WHERE (`entry`=237); INSERT INTO `fishing_loot_template` VALUES (237, 117, 0.02, 1, 1, 1, 2), (237, 118, 0.04, 1, 1, 1, 4), (237, 159, 0.04, 1, 1, 1, 3), (237, 765, 0.01, 1, 1, 1, 3), (237, 766, 0.01, 1, 1, 1, 1), (237, 769, 0.01, 1, 1, 1, 1), (237, 774...

DELETE FROM `fishing_loot_template` WHERE (`entry`=227); INSERT INTO `fishing_loot_template` VALUES (227, 117, 0.02, 1, 1, 1, 2), (227, 118, 0.04, 1, 1, 1, 4), (227, 159, 0.04, 1, 1, 1, 3), (227, 765, 0.01, 1, 1, 1, 3), (227, 766, 0.01, 1, 1, 1, 1), (227, 769, 0.01, 1, 1, 1, 1), (227, 774...

DELETE FROM `fishing_loot_template` WHERE (`entry`=1339); INSERT INTO `fishing_loot_template` VALUES (1339, 929, 0.05, 1, 1, 1, 1), (1339, 1712, 0.01, 1, 1, 1, 1), (1339, 2072, 0.01, 1, 1, 1, 1), (1339, 2997, 0.01, 1, 1, 1, 1), (1339, 3210, 0.01, 1, 1, 1, 1), (1339, 3393, 0.01, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=1338); INSERT INTO `fishing_loot_template` VALUES (1338, 117, 0.02, 1, 1, 1, 2), (1338, 118, 0.04, 1, 1, 1, 4), (1338, 159, 0.04, 1, 1, 1, 3), (1338, 765, 0.01, 1, 1, 1, 3), (1338, 766, 0.01, 1, 1, 1, 1), (1338, 769, 0.01, 1, 1, 1, 1), (1338...

DELETE FROM `fishing_loot_template` WHERE (`entry`=927); INSERT INTO `fishing_loot_template` VALUES (927, 117, 0.02, 1, 1, 1, 2), (927, 118, 0.04, 1, 1, 1, 4), (927, 159, 0.04, 1, 1, 1, 3), (927, 765, 0.01, 1, 1, 1, 3), (927, 766, 0.01, 1, 1, 1, 1), (927, 769, 0.01, 1, 1, 1, 1), (927, 774...

-- 5725 Deathguard Lundmark update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 5725);

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

DELETE FROM `fishing_loot_template` WHERE (`entry`=1497); INSERT INTO `fishing_loot_template` VALUES (1497, 118, 0.01, 1, 1, 1, 1), (1497, 159, 0.01, 1, 1, 1, 1), (1497, 769, 0.01, 1, 1, 1, 1), (1497, 818, 0.01, 1, 1, 1, 1), (1497, 828, 0.01, 1, 1, 1, 1), (1497, 856, 0.01, 1, 1, 1, 1), (1497...

DELETE FROM `fishing_loot_template` WHERE (`entry`=28); INSERT INTO `fishing_loot_template` VALUES (28, 8366, .04, 1, 1, 1, 1), (28, 1710, .17, 1, 1, 1, 1), (28, 21150, 3, 1, 1, 1, 1), (28, 1725, .01, 1, 1, 1, 1), (28, 13757, .02, 1, 1, 1, 1), (28, 2589, .01, 1, 1, 1, 1), (28, 3827, .16, 1, 1...

DELETE FROM `fishing_loot_template` WHERE (`entry`=193); INSERT INTO `fishing_loot_template` VALUES (193, 8366, .04, 1, 1, 1, 1), (193, 1710, .17, 1, 1, 1, 1), (193, 21150, 3, 1, 1, 1, 1), (193, 1725, .01, 1, 1, 1, 1), (193, 13757, .02, 1, 1, 1, 1), (193, 2589, .01, 1, 1, 1, 1), (193, 3827...

DELETE FROM `fishing_loot_template` WHERE (`entry`=197); INSERT INTO `fishing_loot_template` VALUES (197, 8366, .04, 1, 1, 1, 1), (197, 1710, .17, 1, 1, 1, 1), (197, 21150, 3, 1, 1, 1, 1), (197, 1725, .01, 1, 1, 1, 1), (197, 13757, .02, 1, 1, 1, 1), (197, 2589, .01, 1, 1, 1, 1), (197, 3827...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2297); INSERT INTO `fishing_loot_template` VALUES (2297, 8366, .04, 1, 1, 1, 1), (2297, 1710, .17, 1, 1, 1, 1), (2297, 21150, 3, 1, 1, 1, 1), (2297, 1725, .01, 1, 1, 1, 1), (2297, 13757, .02, 1, 1, 1, 1), (2297, 2589, .01, 1, 1, 1, 1), (2297...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2299); INSERT INTO `fishing_loot_template` VALUES (2299, 1710, 0.01, 1, 1, 1, 1), (2299, 3820, 1.84, 1, 1, 1, 3), (2299, 3914, 0.01, 1, 1, 1, 1), (2299, 3928, 0.15, 1, 1, 1, 2), (2299, 4339, 0.01, 1, 1, 1, 2), (2299, 4603, 2, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2620); INSERT INTO `fishing_loot_template` VALUES (2620, 8366, .04, 1, 1, 1, 1), (2620, 1710, .17, 1, 1, 1, 1), (2620, 21150, 3, 1, 1, 1, 1), (2620, 1725, .01, 1, 1, 1, 1), (2620, 13757, .02, 1, 1, 1, 1), (2620, 2589, .01, 1, 1, 1, 1), (2620...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2619); INSERT INTO `fishing_loot_template` VALUES (2619, 1710, 0.01, 1, 1, 1, 1), (2619, 3820, 1.84, 1, 1, 1, 3), (2619, 3914, 0.01, 1, 1, 1, 1), (2619, 3928, 0.15, 1, 1, 1, 2), (2619, 4339, 0.01, 1, 1, 1, 2), (2619, 4603, 2, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2277); INSERT INTO `fishing_loot_template` VALUES (2277, 1710, 0.01, 1, 1, 1, 1), (2277, 3820, 1.84, 1, 1, 1, 3), (2277, 3914, 0.01, 1, 1, 1, 1), (2277, 3928, 0.15, 1, 1, 1, 2), (2277, 4339, 0.01, 1, 1, 1, 2), (2277, 4603, 2, 1, 1, 1, 1)...

DELETE FROM `fishing_loot_template` WHERE (`entry`=2017); INSERT INTO `fishing_loot_template` VALUES (2017, 1710, 0.01, 1, 1, 1, 1), (2017, 3820, 1.84, 1, 1, 1, 3), (2017, 3914, 0.01, 1, 1, 1, 1), (2017, 3928, 0.15, 1, 1, 1, 2), (2017, 4339, 0.01, 1, 1, 1, 2), (2017, 4603, 2, 1, 1, 1, 1)...