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

1 files changed, 42 insertions, 0 deletions

diff --git a/sql/updates/world/2013_06_02_03_world_conditions.sql b/sql/updates/world/2013_06_02_03_world_conditions.sql
new file mode 100644
index 00000000000..c2d730ffc6d
--- /dev/null
+++ b/sql/updates/world/2013_06_02_03_world_conditions.sql
@@ -0,0 +1,42 @@
+-- Add option conditions for Paladin trainers
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (2304,4556,4557,4469,4470,4471,4662,4663,4664,4677,4678,7260,8111);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,2304,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,2304,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,2304,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4556,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4556,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4556,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4557,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4557,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4557,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4469,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4469,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4469,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4470,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4470,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4470,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4471,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4471,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4471,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4662,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4662,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4662,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4663,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4663,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4663,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4664,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4664,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4664,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4677,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4677,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4677,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4678,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4678,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,4678,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,7260,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,7260,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,7260,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,8111,0,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,8111,1,0,15,2,0,0,0,'','Show gossip option if player is a Paladin'),
+(15,8111,2,0,15,2,0,0,0,'','Show gossip option if player is a Paladin');