diff options
| author | Exodius <exodius@trinity.contrib> | 2013-06-30 17:51:14 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-06-30 17:51:14 +0200 |
| commit | 11f3e87514197b5b49a406da03a409b504f6f640 (patch) | |
| tree | 804e1b17fe21cc0682331acb6c53906b75033cda | |
| parent | 7bfe0b58cb5d40c4b14a11d7428af2499aeb3073 (diff) | |
DB/Loot: Gnomish Grenades have Very High drop chance
Closes #10086
| -rw-r--r-- | sql/updates/world/2013_06_30_04_world_sai.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2013_06_30_world_creature_loot_template.sql | 3 |
2 files changed, 4 insertions, 1 deletions
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; |