aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-11-23 20:17:04 +0100
committerKillyana <morphone1@gmail.com>2015-11-23 20:17:04 +0100
commit4298ade165aa07fd893d9d463ac57cf5e63bc9ae (patch)
treeef1bedd374b13070fd5e215b37c51e42d1d7c238
parent5c97339e89237807274f74a0d67224ed5f092c71 (diff)
DB/Quest: Hot and Cold
-rw-r--r--sql/updates/world/2015_11_23_05_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2015_11_23_05_world.sql b/sql/updates/world/2015_11_23_05_world.sql
new file mode 100644
index 00000000000..579af5a5ca1
--- /dev/null
+++ b/sql/updates/world/2015_11_23_05_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `conditions` WHERE `SourceEntry` = 56099 AND `SourceTypeOrReferenceId` = 13;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,56099,0,0,31,0,3,30169,0,0,0,'','Essence of Ice target Smoldering Scrap Bunny');
+
+DELETE FROM `creature` WHERE `guid` IN (116640, 116641, 116642); -- duplicated spawns