DB/Quest: stay mounted on Infected Kodo Beast in 4 Borean Tundra zones

- Add conditions to allow player to stay mounted in the quest zones.
- Update comment text for existing condition, adding zone name.

By Foereaper
Closes issue #20078

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_07_25_00_world.sql b/sql/updates/world/master/2017_07_25_00_world.sql
new file mode 100644
index 00000000000..c25b856a118
--- /dev/null
+++ b/sql/updates/world/master/2017_07_25_00_world.sql
@@ -0,0 +1,10 @@
+-- "Bring 'Em Back Alive" (Quest 11690): Allow player to mount Infected Kodo Beast inside all 4 intended Borean Tundra zones
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25596 AND `ConditionTypeOrReference`=23 AND `ElseGroup` IN (1,2,3,4);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(16, 0, 25596, 0, 1, 23, 0, 4144, 0, 0, 0, 0, 0, '',"Bring 'Em Back Alive: Dismount when player is outside intended zone Warsong Farms Outpost"),
+(16, 0, 25596, 0, 2, 23, 0, 4143, 0, 0, 0, 0, 0, '',"Bring 'Em Back Alive: Dismount when player is outside intended zone Warsong Slaughterhouse"),
+(16, 0, 25596, 0, 3, 23, 0, 4142, 0, 0, 0, 0, 0, '',"Bring 'Em Back Alive: Dismount when player is outside intended zone Warsong Grannary"),
+(16, 0, 25596, 0, 4, 23, 0, 4141, 0, 0, 0, 0, 0, '',"Bring 'Em Back Alive: Dismount when player is outside intended zone Torp's Farm");
+
+UPDATE `conditions` SET `Comment`= "Bring 'Em Back Alive: Dismount when player is outside intended zone Borean Tundra"
+ WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25596 AND `ConditionTypeOrReference`=23 AND `ElseGroup`=0;