diff options
| -rw-r--r-- | sql/updates/world/2013_06_03_03_world_conditions.sql | 95 |
1 files changed, 95 insertions, 0 deletions
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'); |