diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_06_02_08_world_conditions.sql | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_02_08_world_conditions.sql b/sql/updates/world/2013_06_02_08_world_conditions.sql new file mode 100644 index 00000000000..2fe812c1934 --- /dev/null +++ b/sql/updates/world/2013_06_02_08_world_conditions.sql @@ -0,0 +1,75 @@ +-- Add option conditions for Rogue trainers +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) 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`,`ScriptName`,`Comment`) VALUES +(15,85,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,85,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,85,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,141,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,141,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,141,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,381,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,381,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,381,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,410,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,410,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,410,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,411,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,411,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,411,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,436,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,436,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,436,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,3984,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,3984,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,3984,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4502,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4502,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4502,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4512,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4512,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4512,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4513,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4513,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4513,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4540,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4540,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4540,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4541,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4541,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4541,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4542,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4542,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4542,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4561,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4561,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4561,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4562,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4562,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4562,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4575,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4575,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4575,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4576,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4576,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4576,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4577,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4577,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4577,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4658,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4658,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4658,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4659,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4659,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4659,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4676,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4676,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4676,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4690,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4690,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,4690,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,5061,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,5061,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,5061,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,6650,0,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,6650,1,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'), +(15,6650,2,0,15,8,0,0,0,'','Show gossip option if player is a Rogue'); |