From 8266fe9b86ed8552a3201d68acf2164fb4c92bb4 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 3 Jun 2013 00:03:04 -0230 Subject: DB/Conditions: Add option conditions for Shaman trainers. --- .../world/2013_06_03_00_world_conditions.sql | 42 ++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 sql/updates/world/2013_06_03_00_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_03_00_world_conditions.sql b/sql/updates/world/2013_06_03_00_world_conditions.sql new file mode 100644 index 00000000000..518479930f2 --- /dev/null +++ b/sql/updates/world/2013_06_03_00_world_conditions.sql @@ -0,0 +1,42 @@ +-- Add option conditions for Shaman trainers +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (4103,4104,4515,4516,4528,4529,4530,4652,5123,7357,7467,7522,8110,7377); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,4103,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4103,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4103,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4104,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4104,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4104,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4515,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4515,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4515,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4516,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4516,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4516,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4528,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4528,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4528,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4529,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4529,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4529,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4530,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4530,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4530,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4652,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4652,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,4652,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,5123,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,5123,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,5123,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7357,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7357,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7357,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7467,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7467,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7467,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,8110,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,8110,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,8110,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7377,0,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7377,1,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'), +(15,7377,2,0,15,64,0,0,0,'','Show gossip option if player is a Shaman'); -- cgit v1.2.3