diff options
| -rw-r--r-- | sql/updates/world/2013_06_02_09_world_conditions.sql | 99 |
1 files changed, 99 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_02_09_world_conditions.sql b/sql/updates/world/2013_06_02_09_world_conditions.sql new file mode 100644 index 00000000000..647e608df87 --- /dev/null +++ b/sql/updates/world/2013_06_02_09_world_conditions.sql @@ -0,0 +1,99 @@ +-- Add option conditions for Priest trainers +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (3642,3643,3644,3645,4466,4467,4468,4521,4522,4523,4531,4532,4533,4543,4544,4545,4558,4559,4572,4573,4574,4665,4666,4679,4680,4691,4692,4801,6649,7265,7349,7438); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,3642,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3642,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3642,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3643,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3643,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3643,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3644,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3644,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3644,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3645,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3645,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,3645,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4466,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4466,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4466,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4467,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4467,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4467,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4468,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4468,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4468,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4521,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4521,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4521,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4522,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4522,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4522,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4523,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4523,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4523,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4531,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4531,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4531,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4532,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4532,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4532,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4533,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4533,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4533,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4543,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4543,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4543,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4544,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4544,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4544,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4545,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4545,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4545,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4558,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4558,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4558,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4559,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4559,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4559,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4572,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4572,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4572,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4573,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4573,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4573,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4574,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4574,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4574,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4665,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4665,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4665,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4666,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4666,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4666,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4679,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4679,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4679,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4680,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4680,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4680,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4691,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4691,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4691,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4692,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4692,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4692,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4801,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4801,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,4801,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,6649,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,6649,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,6649,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7265,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7265,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7265,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7349,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7349,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7349,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7438,0,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7438,1,0,15,16,0,0,0,'','Show gossip option if player is a Priest'), +(15,7438,2,0,15,16,0,0,0,'','Show gossip option if player is a Priest'); |