aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2024-11-15 19:14:44 +0100
committerMeji <alvaro.megias@outlook.com>2024-11-15 19:14:44 +0100
commit4931b7c41c40c6ffaeaf482aa97229b7062de341 (patch)
treebaadc26810c0ce1fd07bfaeb224658d789cf7d6e /sql
parent441d7e5dc1522680d52fde03e0f3cbe751350f3b (diff)
DB/TheJadeForest: Added Hellscream's Fist terrain swap
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2024_11_15_04_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_15_04_world.sql b/sql/updates/world/master/2024_11_15_04_world.sql
new file mode 100644
index 00000000000..47791028632
--- /dev/null
+++ b/sql/updates/world/master/2024_11_15_04_world.sql
@@ -0,0 +1,8 @@
+DELETE FROM `terrain_swap_defaults` WHERE `MapId`=870 AND `TerrainSwapMap`=1076;
+INSERT INTO `terrain_swap_defaults` (`MapId`, `TerrainSwapMap`, `Comment`) VALUES
+(870, 1076, 'The Jade Forest - Jade Forest Horde Starting Area');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=25 AND `SourceEntry`=1076;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(25,0,1076,0,0,6,0,67,0,0,'',0,0,0,'','Apply terrain swap 1076 if player is Horde'),
+(25,0,1076,0,0,47,0,31769,(2 | 64),0,'',1,0,0,'','Apply terrain swap 1076 if quest 31769 is not complete | rewarded');