diff options
| -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; |