From eea6ab54cc9b45535af1b21adb137d89e91999e7 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 3 Jun 2013 21:39:20 -0230 Subject: DB/Conditions: Add conditions for rogue quest. --- .../world/2013_06_03_03_world_conditions.sql | 95 ++++++++++++++++++++++ 1 file changed, 95 insertions(+) create mode 100644 sql/updates/world/2013_06_03_03_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_03_03_world_conditions.sql b/sql/updates/world/2013_06_03_03_world_conditions.sql new file mode 100644 index 00000000000..3edbde56d5b --- /dev/null +++ b/sql/updates/world/2013_06_03_03_world_conditions.sql @@ -0,0 +1,95 @@ +-- Add option conditions for Rogue trainers +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceEntry`=4 AND `SourceGroup` IN (85,141,381,410,411,436,3984,4502,4512,4513,4540,4541,4542,4561,4562,4575,4576,4577,4658,4659,4676,4690,5061,6650); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`NegativeCondition`,`ScriptName`,`Comment`) VALUES +(15,85,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,85,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,85,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,85,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,141,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,141,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,141,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,141,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,410,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,410,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,410,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,410,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,411,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,411,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,411,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,411,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,436,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,436,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,436,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,436,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,3984,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,3984,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,3984,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,3984,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4502,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4502,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4502,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4502,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4512,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4512,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4512,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4512,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4513,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4513,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4513,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4513,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4540,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4540,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4540,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4540,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4541,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4541,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4541,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4541,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4542,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4542,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4542,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4542,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4561,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4561,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4561,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4561,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4562,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4562,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4562,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4562,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4575,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4575,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4575,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4575,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4576,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4576,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4576,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4576,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4577,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4577,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4577,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4577,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4658,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4658,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4658,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4658,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4659,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4659,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4659,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4659,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4676,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4676,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4676,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4676,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,4690,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4690,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,4690,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,4690,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,5061,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,5061,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,5061,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,5061,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'), +(15,6650,4,0,15,8,0,0,0,0,'','Show gossip option if player is a Rogue'), +(15,6650,4,0,27,24,3,0,0,0,'','Show gossip option if player is level 24 or higher'), +(15,6650,4,0,2,17126,1,0,0,0,'','Show gossip option if player has Elegant Letter'), +(15,6650,4,0,28,6681,0,0,0,1,'','Show gossip option if player has not completed quest 6681'); -- cgit v1.2.3