DB/Conditions: Add gossip option conditions for Warrior trainers.

1 files changed, 93 insertions, 0 deletions

diff --git a/sql/updates/world/2013_06_02_04_world_conditions.sql b/sql/updates/world/2013_06_02_04_world_conditions.sql
new file mode 100644
index 00000000000..82ee44df19d
--- /dev/null
+++ b/sql/updates/world/2013_06_02_04_world_conditions.sql
@@ -0,0 +1,93 @@
+-- Add option conditions for Warrior trainers
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (523,655,656,4091,4475,4481,4482,4509,4511,4525,4526,4527,4546,4547,4548,4568,4569,4570,4578,4579,4581,4645,4649,4650,4653,4683,4684,4696,4697,7263);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,523,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,523,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,523,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,655,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,655,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,655,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,656,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,656,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,656,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4091,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4091,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4091,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4475,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4475,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4475,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4481,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4481,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4481,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4482,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4482,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4482,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4509,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4509,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4509,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4511,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4511,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4511,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4525,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4525,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4525,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4526,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4526,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4526,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4527,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4527,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4527,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4546,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4546,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4546,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4547,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4547,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4547,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4548,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4548,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4548,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4568,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4568,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4568,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4569,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4569,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4569,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4570,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4570,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4570,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4578,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4578,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4578,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4579,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4579,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4579,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4581,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4581,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4581,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4645,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4645,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4645,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4649,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4649,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4649,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4650,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4650,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4650,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4653,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4653,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4653,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4683,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4683,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4683,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4684,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4684,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4684,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4696,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4696,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4696,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4697,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4697,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,4697,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,7263,0,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,7263,1,0,15,1,0,0,0,'','Show gossip option if player is a Warrior'),
+(15,7263,2,0,15,1,0,0,0,'','Show gossip option if player is a Warrior');