From 11f3e87514197b5b49a406da03a409b504f6f640 Mon Sep 17 00:00:00 2001 From: Exodius Date: Sun, 30 Jun 2013 17:51:14 +0200 Subject: DB/Loot: Gnomish Grenades have Very High drop chance Closes #10086 --- sql/updates/world/2013_06_30_04_world_sai.sql | 2 +- sql/updates/world/2013_06_30_world_creature_loot_template.sql | 3 +++ 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2013_06_30_world_creature_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_30_04_world_sai.sql b/sql/updates/world/2013_06_30_04_world_sai.sql index 70936cd0b19..61ec09c9ff4 100644 --- a/sql/updates/world/2013_06_30_04_world_sai.sql +++ b/sql/updates/world/2013_06_30_04_world_sai.sql @@ -24,7 +24,7 @@ DELETE FROM `creature_text` WHERE `entry`=35127; INSERT INTO `creature_text` VALUES (35127,0,0, "Gladly",12,0,1,0,0,0, ''); ---SAI +-- SAI UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35116; UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35127; diff --git a/sql/updates/world/2013_06_30_world_creature_loot_template.sql b/sql/updates/world/2013_06_30_world_creature_loot_template.sql new file mode 100644 index 00000000000..402e00d685e --- /dev/null +++ b/sql/updates/world/2013_06_30_world_creature_loot_template.sql @@ -0,0 +1,3 @@ +-- Gnomish Grenades have Very High drop chance +-- http://eu.battle.net/wow/en/item/34772 +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-90 WHERE `entry`=25449 and `item`=34772; -- cgit v1.2.3