diff options
| -rw-r--r-- | sql/updates/world/2013_12_01_06_world_misc.sql | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/sql/updates/world/2013_12_01_06_world_misc.sql b/sql/updates/world/2013_12_01_06_world_misc.sql new file mode 100644 index 00000000000..77654de6300 --- /dev/null +++ b/sql/updates/world/2013_12_01_06_world_misc.sql @@ -0,0 +1,68 @@ +-- gossip_menu_option for Squires David,Danny and Cavin +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10340,10383,10343); +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES +(10340, 0, 0, 'I am ready to fight!', 1, 1, 0, 0, 0, 0, NULL), +(10340, 1, 0, 'How do the Argent Crusade riders fight?', 1, 1, 10440, 0, 0, 0, NULL), +(10383, 0, 0, 'Ask Cavin to summon the Black Knight.', 1, 1, 0, 0, 0, 0, NULL), +(10343, 0, 0, 'I am ready to fight!', 1, 1, 0, 0, 0, 0, NULL); + +-- Squire Danny menu option conditions +DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=15 and SourceGroup=10343; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 10343, 0, 0, 0, 9, 0, 13731, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 0, 28, 0, 13731, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 0, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 0, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 1, 9, 0, 13729, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 1, 28, 0, 13729, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 1, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 1, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 2, 9, 0, 13728, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 2, 28, 0, 13728, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 2, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 2, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 3, 9, 0, 13727, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 3, 28, 0, 13727, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 3, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 3, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 4, 9, 0, 13726, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 4, 28, 0, 13726, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 4, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 4, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 5, 9, 0, 13725, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 5, 28, 0, 13725, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 5, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 5, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 6, 9, 0, 13724, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 6, 28, 0, 13724, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 6, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 6, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 7, 9, 0, 13723, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 7, 28, 0, 13723, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 7, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 7, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 8, 9, 0, 13713, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 8, 28, 0, 13713, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 8, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 8, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is not near'), +-- +(15, 10343, 0, 0, 9, 9, 0, 13699, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge'), +(15, 10343, 0, 0, 9, 28, 0, 13699, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Valiant''s Challenge not complete'), +(15, 10343, 0, 0, 9, 1, 0, 63034, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63034'), +(15, 10343, 0, 0, 9, 29, 0, 33707, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if an Argent Champion is now near'); + +-- Squire Cavin menu option conditions +DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=15 and SourceGroup=10383; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 10383, 0, 0, 0, 9, 0, 13664, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Black Knight''s Fall'), +(15, 10383, 0, 0, 0, 28, 0, 13664, 0, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if player has quest The Black Knight''s Fall not complete'), +(15, 10383, 0, 0, 0, 1, 0, 63663, 0, 0, 0, 0, 0, '', 'Squire Danny - Show gossip option if player has aura 63663'), +(15, 10383, 0, 0, 0, 29, 0, 33785, 100, 0, 1, 0, 0, '', 'Squire Danny - Show gossip option if The Black Knight is not near'); |