aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2013-01-30 01:33:46 +0000
committerNay <dnpd.dd@gmail.com>2013-01-30 01:33:46 +0000
commit5151c57b18af12f575e8799d69bf6ff91f0227b1 (patch)
treea1dd050b143833a612718c341973c0be4cfc7820 /sql
parent92d92df80960f046cac8cde15599b510cbc34109 (diff)
parent02814975732f8e919d33ff8f2cbaf98f13e04f91 (diff)
Merge remote-tracking branch 'origin/master' into 4.3.4
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql2
-rw-r--r--sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql9
2 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql b/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..39627a943cc
--- /dev/null
+++ b/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql
@@ -0,0 +1,2 @@
+UPDATE `achievement_criteria_data` SET `value1`=2 WHERE `criteria_id`=12979 AND `type`=12;
+UPDATE `achievement_criteria_data` SET `value1`=1 WHERE `criteria_id`=12971 AND `type`=12;
diff --git a/sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql b/sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql
new file mode 100644
index 00000000000..c3f2d0f0fb9
--- /dev/null
+++ b/sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql
@@ -0,0 +1,9 @@
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=27310 AND `item`=47035;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=27239 AND `item`=46364;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=24589 AND `item`=43697;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=26666 AND `item`=44319;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=26667 AND `item`=44320;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=26668 AND `item`=44321;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=26878 AND `item`=45062;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=27725 AND `item`=49648;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=27723 AND `item`=49678;