From b4083763bc8a1278701b5255b2a567b0874f2fd4 Mon Sep 17 00:00:00 2001 From: tkrokli Date: Tue, 13 Sep 2016 06:33:05 +0200 Subject: 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) --- sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2017_02_26_17_world_2016_09_13_04_world.sql (limited to 'sql/updates') 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.'); -- cgit v1.2.3