aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortkrokli <tkrokli@hotmail.com>2016-09-13 06:33:05 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-26 20:00:46 +0100
commitb4083763bc8a1278701b5255b2a567b0874f2fd4 (patch)
treeee5f985a2a788858e8094727a7569590e3ab0d03
parentcab4ce3a532b15f95144ef17ff2bf752c56495d6 (diff)
DB/conditions: add condition Pet Type to Pet Trainers gossip
Use ConditionTypeOrReference 45 (PetType in PetDefines.h): - Show gossip menu 4783 option id 1 if Pet Type is hunter pet ( follow-up to PR #17746 / commit 03bafe3 ) (cherry picked from commit 9d7cd93e0da110546c5a572096773901c54c7f2b)
-rw-r--r--sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql b/sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql
new file mode 100644
index 00000000000..dfe1a52f514
--- /dev/null
+++ b/sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql
@@ -0,0 +1,4 @@
+-- Condition for Pet Trainer gossip menu option, condition type PetType
+DELETE FROM `conditions` WHERE `ConditionTypeOrReference`= 45 AND `SourceGroup`= 4783 AND `SourceEntry`= 1;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,4783,1,0,0,45,0,2,0,0,0,0,0, '','Show gossip menu 4783 option id 1 if Pet Type is hunter pet.');