aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_09_03_01_world_loot.sql1
-rw-r--r--sql/updates/world/2014_09_04_00_world_creature_template.sql2
2 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_03_01_world_loot.sql b/sql/updates/world/2014_09_03_01_world_loot.sql
new file mode 100644
index 00000000000..b56eba26355
--- /dev/null
+++ b/sql/updates/world/2014_09_03_01_world_loot.sql
@@ -0,0 +1 @@
+UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=6 WHERE `entry` IN (34566, 35216, 35268, 35269, 35347, 35348, 35349, 35350, 35351, 35352, 35447, 35448, 35449, 35615, 35616) AND `item`=3;
diff --git a/sql/updates/world/2014_09_04_00_world_creature_template.sql b/sql/updates/world/2014_09_04_00_world_creature_template.sql
new file mode 100644
index 00000000000..1484f317983
--- /dev/null
+++ b/sql/updates/world/2014_09_04_00_world_creature_template.sql
@@ -0,0 +1,2 @@
+-- Remove no longer used script
+UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 17662; -- Broggok Poison Cloud