diff options
| -rw-r--r-- | sql/updates/world/2012_02_12_00_world_gossip.sql | 132 | ||||
| -rw-r--r-- | sql/updates/world/2012_02_12_01_world_sai.sql | 243 |
2 files changed, 375 insertions, 0 deletions
diff --git a/sql/updates/world/2012_02_12_00_world_gossip.sql b/sql/updates/world/2012_02_12_00_world_gossip.sql new file mode 100644 index 00000000000..f0c57e87b01 --- /dev/null +++ b/sql/updates/world/2012_02_12_00_world_gossip.sql @@ -0,0 +1,132 @@ +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9709 AND `id` IN (0,1); +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9731 AND `id` IN (0,1,2,3,4,5); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9714,9717,9732,11091) AND `id`=0; +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 +(9709,0,0, 'I''ve lost Nass...',1,1,0,0,0,0, ''), +(9709,1,0, 'I''ve lost my ensorcelled choker!',1,1,9797,0,0,0, ''), +(9714,0,0, 'Stefan told me you would demonstrate the purpose of this item',1,1,0,0,0,0, ''), +(9717,0,1, 'What are you hiding under that fold of flesh?',3,128,0,0,0,0, ''), +(9731,0,0, 'I am ready to accompany you, Drakuru.',1,1,0,0,0,0, ''), +(9731,1,0, 'Gorebag has shown me the Drakkari Empire. I am eager to help you conquer it!',1,1,10403,0,0,0, ''), +(9731,2,0, 'I have whipped the Blight Geists into shape!',1,1,10404,0,0,0, ''), +(9731,3,0, 'I have defeated Darmuk! How else may I serve you?',1,1,10405,0,0,0, ''), +(9731,4,0, 'The Drakkari Chieftains have been captured! What more would you have me do?',1,1,10406,0,0,0, ''), +(9731,5,0, 'I have witnessed your magnificent operation, Drakuru. When do we put your plan into effect?',1,1,10407,0,0,0, ''), +(9732,0,0, 'Uhh, can you send me on the tour of Zul''Drak?',1,1,0,0,0,0, ''), +(11091,0,0, 'I''m ready.',1,1,0,0,0,0, ''); + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=9639 AND `text_id`=13046; +DELETE FROM `gossip_menu` WHERE `entry`=9655 AND `text_id`=13078; +DELETE FROM `gossip_menu` WHERE `entry`=9657 AND `text_id`=13080; +DELETE FROM `gossip_menu` WHERE `entry`=9675 AND `text_id`=13121; +DELETE FROM `gossip_menu` WHERE `entry`=9709 AND `text_id`=13271; +DELETE FROM `gossip_menu` WHERE `entry`=9714 AND `text_id`=13290; +DELETE FROM `gossip_menu` WHERE `entry`=9717 AND `text_id`=13300; +DELETE FROM `gossip_menu` WHERE `entry`=9731 AND `text_id`=13324; +DELETE FROM `gossip_menu` WHERE `entry`=9731 AND `text_id`=13325; +DELETE FROM `gossip_menu` WHERE `entry`=9731 AND `text_id`=13348; +DELETE FROM `gossip_menu` WHERE `entry`=9731 AND `text_id`=13422; +DELETE FROM `gossip_menu` WHERE `entry`=9732 AND `text_id`=13326; +DELETE FROM `gossip_menu` WHERE `entry`=9752 AND `text_id`=13390; +DELETE FROM `gossip_menu` WHERE `entry`=9752 AND `text_id`=13391; +DELETE FROM `gossip_menu` WHERE `entry`=9797 AND `text_id`=13501; +DELETE FROM `gossip_menu` WHERE `entry`=9848 AND `text_id`=13619; +DELETE FROM `gossip_menu` WHERE `entry`=9852 AND `text_id`=13639; +DELETE FROM `gossip_menu` WHERE `entry`=9861 AND `text_id`=13658; +DELETE FROM `gossip_menu` WHERE `entry`=10403 AND `text_id`=14441; +DELETE FROM `gossip_menu` WHERE `entry`=10404 AND `text_id`=14442; +DELETE FROM `gossip_menu` WHERE `entry`=10405 AND `text_id`=14443; +DELETE FROM `gossip_menu` WHERE `entry`=10406 AND `text_id`=14444; +DELETE FROM `gossip_menu` WHERE `entry`=10407 AND `text_id`=14445; +DELETE FROM `gossip_menu` WHERE `entry`=11091 AND `text_id`=15432; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(9639,13046), +(9655,13078), +(9657,13080), +(9675,13121), +(9709,13271), +(9714,13290), +(9717,13300), +(9731,13324),(9731,13325),(9731,13348),(9731,13422), +(9732,13326), +(9752,13390),(9752,13391), +(9797,13501), +(9848,13619), +(9852,13639), +(9861,13658), +(10403,14441), +(10404,14442), +(10405,14443), +(10406,14444), +(10407,14445), +(11091,15432); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=9639 WHERE `entry`=28059; -- Commander Falstaav +UPDATE `creature_template` SET `gossip_menu_id`=9655 WHERE `entry`=28141; -- Crusader Lamoof +UPDATE `creature_template` SET `gossip_menu_id`=9657 WHERE `entry`=28143; -- Crusader Josephine +UPDATE `creature_template` SET `gossip_menu_id`=9675 WHERE `entry`=28309; -- Sub-Lieutenant Jax +UPDATE `creature_template` SET `gossip_menu_id`=9715 WHERE `entry`=28561; -- Spirit of Rhunok +UPDATE `creature_template` SET `gossip_menu_id`=9717 WHERE `entry`=28589; -- Gristlegut +UPDATE `creature_template` SET `gossip_menu_id`=9731 WHERE `entry`=28503; -- Overlord Drakuru +UPDATE `creature_template` SET `gossip_menu_id`=9732 WHERE `entry`=28666; -- Gorebag +UPDATE `creature_template` SET `gossip_menu_id`=9752 WHERE `entry`=28888; -- Captured Drakkari Chieftain +UPDATE `creature_template` SET `gossip_menu_id`=9848 WHERE `entry`=29688; -- Engineer Reed +UPDATE `creature_template` SET `gossip_menu_id`=9852 WHERE `entry`=29647; -- Gymer +UPDATE `creature_template` SET `gossip_menu_id`=9861 WHERE `entry`=29689; -- Crusader MacKellar +UPDATE `creature_template` SET `gossip_menu_id`=9821 WHERE `entry`=28790; -- Fala Softhoof + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9709 AND `SourceEntry`=13271; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9714 AND `SourceEntry`=13290; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9731 AND `SourceEntry` IN (13324,13325,13348,13422); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9752 AND `SourceEntry`=13391; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (9709,9714,9732) AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9709 AND `SourceEntry`=1; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9731 AND `SourceEntry` IN (0,1,2,3,4,5); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,9709,13271,0,0,9,12630,0,0,0,0,'','Stefan Vadu - Show different gossip if player has taken quest 12630'), +(14,9709,13271,0,0,1,61438,0,0,1,0,'','Stefan Vadu - Show different gossip if player is not affected by aura 61438'), +(14,9714,13290,0,0,9,12637,0,0,0,0,'','Bloodrose Datura - Show different gossip if player has taken quest 12637'), +(14,9714,13290,0,1,9,12638,0,0,0,0,'','Bloodrose Datura - Show different gossip if player has taken quest 12638'), +(14,9731,13324,0,0,8,12238,0,0,0,0,'','Overlord Drakuru - Show different gossip if player has rewarded quest 12238'), +(14,9731,13325,0,0,8,12661,0,0,0,0,'','Overlord Drakuru - Show different gossip if player has rewarded quest 12663'), +(14,9731,13348,0,0,8,12238,0,0,1,0,'','Overlord Drakuru - Show different gossip if player has not rewarded quest 12238'), +(14,9731,13422,0,0,9,12713,0,0,0,0,'','Overlord Drakuru - Show different gossip if player has taken quest 12713'), +(14,9752,13391,0,0,1,51966,0,0,0,0,'','Captured Drakkari Chieftain - Show different gossip if player is affected by aura 51966'), +(15,9709,0,0,0,9,12630,0,0,0,0,'','Show gossip option only if player has taken quest 12630'), +(15,9709,0,0,0,1,61438,0,0,1,0,'','Show gossip option only if player is not affected by aura 61438'), +(15,9709,1,0,0,9,12648,0,0,0,0,'','Show gossip option only if player has taken quest 12648'), +(15,9709,1,0,0,2,38699,1,0,1,0,'','Show gossip option only if player has no item 38699'), +(15,9709,1,0,1,9,12649,0,0,0,0,'','Show gossip option only if player has taken quest 12649'), +(15,9709,1,0,1,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9709,1,0,2,9,12661,0,0,0,0,'','Show gossip option only if player has taken quest 12661'), +(15,9709,1,0,2,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9709,1,0,3,9,12669,0,0,0,0,'','Show gossip option only if player has taken quest 12669'), +(15,9709,1,0,3,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9709,1,0,4,9,12676,0,0,0,0,'','Show gossip option only if player has taken quest 12676'), +(15,9709,1,0,4,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9709,1,0,5,9,12677,0,0,0,0,'','Show gossip option only if player has taken quest 12677'), +(15,9709,1,0,5,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9709,1,0,6,9,12713,0,0,0,0,'','Show gossip option only if player has taken quest 12713'), +(15,9709,1,0,6,2,38699,1,0,1,0,'','Show gossip option only if player no item 38699'), +(15,9714,0,0,0,9,12637,0,0,0,0,'','Show gossip option only if player has taken quest 12637'), +(15,9714,0,0,1,9,12638,0,0,0,0,'','Show gossip option only if player has taken quest 12638'), +(15,9714,0,0,0,2,38678,1,0,0,0,'','Show gossip option only if player has item 38678'), +(15,9731,0,0,0,9,12713,0,0,0,0,'','Show gossip option only if player has taken quest 12713'), +(15,9731,1,0,0,8,12663,0,0,0,0,'','Show gossip option only if player has rewarded quest 12663'), +(15,9731,1,0,0,8,12661,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12661'), +(15,9731,1,0,1,8,12664,0,0,0,0,'','Show gossip option only if player has rewarded quest 12664'), +(15,9731,1,0,1,8,12661,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12661'), +(15,9731,2,0,0,8,12673,0,0,0,0,'','Show gossip option only if player has rewarded quest 12673'), +(15,9731,2,0,0,8,12669,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12669'), +(15,9731,3,0,0,8,12686,0,0,0,0,'','Show gossip option only if player has rewarded quest 12686'), +(15,9731,3,0,0,8,12677,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12677'), +(15,9731,4,0,0,8,12690,0,0,0,0,'','Show gossip option only if player has rewarded quest 12690'), +(15,9731,4,0,0,8,12676,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12676'), +(15,9731,5,0,0,8,12710,0,0,0,0,'','Show gossip option only if player has rewarded quest 12710'), +(15,9731,5,0,0,8,12676,0,0,1,0,'','Show gossip option only if player has not rewarded quest 12676'), +(15,9732,0,0,0,9,12663,0,0,0,0,'','Show gossip option only if player has taken quest 12663'), +(15,9732,0,0,1,9,12664,0,0,0,0,'','Show gossip option only if player has taken quest 12664'); diff --git a/sql/updates/world/2012_02_12_01_world_sai.sql b/sql/updates/world/2012_02_12_01_world_sai.sql new file mode 100644 index 00000000000..4e96f1da7c9 --- /dev/null +++ b/sql/updates/world/2012_02_12_01_world_sai.sql @@ -0,0 +1,243 @@ +-- Hot On The Trail (A:24849 H:24851) + +SET @QUEST_A := 24849; +SET @QUEST_H := 24851; + +SET @BUNNY_BANK := 38340; -- [DND] Holiday - Love - Bank Bunny +SET @BUNNY_BANK_SW_GUID := 208836; +SET @BUNNY_BANK_ORG_GUID := 208835; +SET @BUNNY_AH := 38341; -- [DND] Holiday - Love - AH Bunny +SET @BUNNY_AH_SW_GUID := 208837; +SET @BUNNY_AH_ORG_GUID := 208838; +SET @BUNNY_BARBER := 38342; -- [DND] Holiday - Love - Barber Bunny +SET @BUNNY_BARBER_SW_GUID := 208839; +SET @BUNNY_BARBER_ORG_GUID := 208840; + +SET @TRIGGER_BANK_SW := 5710; +SET @TRIGGER_AH_SW := 5711; +SET @TRIGGER_BARBER_SW := 5712; +SET @TRIGGER_BANK_ORG := 5715; +SET @TRIGGER_AH_ORG := 5714; +SET @TRIGGER_BARBER_ORG := 5716; + +SET @SPELL_BANK_SW := 71713; -- Searching the Bank +SET @SPELL_BANK_ORG := 71759; +SET @SPELL_AH_SW := 71745; -- Searching the Auction House +SET @SPELL_AH_ORG := 71760; +SET @SPELL_BARBER_SW := 71752; -- Searching the Barber Shop +SET @SPELL_BARBER_ORG := 71758; + +-- spells to 'trick' the player +SET @SPELL_ROCKET := 71715; -- Snivel's Rocket (bank) +SET @SPELL_BLIND := 71750; -- Blind! (ah) +SET @SPELL_VANISH := 24222; -- Vanish Visual (barber) + +SET @SNIVEL_BANK_SW := 38334; -- Snivel Rustrocket <Venture Co.> +SET @SNIVEL_BANK_ORG := 38337; +SET @SNIVEL_AH_SW := 38335; +SET @SNIVEL_AH_ORG := 38338; +SET @SNIVEL_BARBER_SW := 38336; +SET @SNIVEL_BARBER_ORG := 38339; + +SET @SPELL_SUM_SW_BANK := 71712; -- Summon Snivel +SET @SPELL_SUM_ORG_BANK := 71762; +SET @SPELL_SUM_SW_AH := 71744; +SET @SPELL_SUM_ORG_AH := 71763; +SET @SPELL_SUM_SW_BARBER := 71751; +SET @SPELL_SUM_ORG_BARBER := 71765; + +UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (@QUEST_A,@QUEST_H); + +DELETE FROM `areatrigger_involvedrelation` WHERE `id` IN (@TRIGGER_BANK_SW,@TRIGGER_AH_SW,@TRIGGER_BARBER_SW,@TRIGGER_BANK_ORG,@TRIGGER_AH_ORG,@TRIGGER_BARBER_ORG); +INSERT INTO `areatrigger_involvedrelation` (`id`,`quest`) VALUES +(@TRIGGER_BANK_SW,@QUEST_A), +(@TRIGGER_AH_SW,@QUEST_A), +(@TRIGGER_BARBER_SW,@QUEST_A), +-- +(@TRIGGER_BANK_ORG,@QUEST_H), +(@TRIGGER_AH_ORG,@QUEST_H), +(@TRIGGER_BARBER_ORG,@QUEST_H); + + +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (@TRIGGER_BANK_SW,@TRIGGER_AH_SW,@TRIGGER_BARBER_SW,@TRIGGER_BANK_ORG,@TRIGGER_AH_ORG,@TRIGGER_BARBER_ORG); +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(@TRIGGER_BANK_SW,'SmartTrigger'), +(@TRIGGER_AH_SW,'SmartTrigger'), +(@TRIGGER_BARBER_SW,'SmartTrigger'), +-- +(@TRIGGER_BANK_ORG,'SmartTrigger'), +(@TRIGGER_AH_ORG,'SmartTrigger'), +(@TRIGGER_BARBER_ORG,'SmartTrigger'); + + +-- area trigger scripts +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@TRIGGER_BANK_SW,@TRIGGER_AH_SW,@TRIGGER_BARBER_SW,@TRIGGER_BANK_ORG,@TRIGGER_AH_ORG,@TRIGGER_BARBER_ORG) AND `source_type`=2; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@TRIGGER_BANK_SW,2,0,1,46,0,100,0,@TRIGGER_BANK_SW,0,0,0,86,@SPELL_BANK_SW,0,10,@BUNNY_BANK_SW_GUID,@BUNNY_BANK,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_BANK_SW,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_BANK_SW_GUID,@BUNNY_BANK,0,0,0,0,0,'Link - Kill - Bunny'), +-- +(@TRIGGER_AH_SW,2,0,1,46,0,100,0,@TRIGGER_AH_SW,0,0,0,86,@SPELL_AH_SW,0,10,@BUNNY_AH_SW_GUID,@BUNNY_AH,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_AH_SW,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_AH_SW_GUID,@BUNNY_AH,0,0,0,0,0,'Link - Kill - Bunny'), +-- +(@TRIGGER_BARBER_SW,2,0,1,46,0,100,0,@TRIGGER_BARBER_SW,0,0,0,86,@SPELL_BARBER_SW,0,10,@BUNNY_BARBER_SW_GUID,@BUNNY_BARBER,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_BARBER_SW,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_BARBER_SW_GUID,@BUNNY_BARBER,0,0,0,0,0,'Link - Kill - Bunny'), +-- -- +(@TRIGGER_BANK_ORG,2,0,1,46,0,100,0,@TRIGGER_BANK_ORG,0,0,0,86,@SPELL_BANK_ORG,0,10,@BUNNY_BANK_ORG_GUID,@BUNNY_BANK,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_BANK_ORG,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_BANK_ORG_GUID,@BUNNY_BANK,0,0,0,0,0,'Link - Kill - Bunny'), +-- +(@TRIGGER_AH_ORG,2,0,1,46,0,100,0,@TRIGGER_AH_ORG,0,0,0,86,@SPELL_AH_ORG,0,10,@BUNNY_AH_ORG_GUID,@BUNNY_AH,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_AH_ORG,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_AH_ORG_GUID,@BUNNY_AH,0,0,0,0,0,'Link - Kill - Bunny'), +-- +(@TRIGGER_BARBER_ORG,2,0,1,46,0,100,0,@TRIGGER_BARBER_ORG,0,0,0,86,@SPELL_BARBER_ORG,0,10,@BUNNY_BARBER_ORG_GUID,@BUNNY_BARBER,0,7,0,0,0,0,0,0,0,'On Trigger - Crosscast - Invoker'), +(@TRIGGER_BARBER_ORG,2,1,0,61,0,100,0,0,0,0,0,51,0,0,0,0,0,0,10,@BUNNY_BARBER_ORG_GUID,@BUNNY_BARBER,0,0,0,0,0,'Link - Kill - Bunny'); + + +-- Snivel Rustrocket scripts +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@SNIVEL_BANK_SW,@SNIVEL_AH_SW,@SNIVEL_BARBER_SW,@SNIVEL_BANK_ORG,@SNIVEL_AH_ORG,@SNIVEL_BARBER_ORG); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@SNIVEL_BANK_SW,@SNIVEL_AH_SW,@SNIVEL_BARBER_SW,@SNIVEL_BANK_ORG,@SNIVEL_AH_ORG,@SNIVEL_BARBER_ORG) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@SNIVEL_BANK_SW*100,@SNIVEL_AH_SW*100,@SNIVEL_BARBER_SW*100,@SNIVEL_BANK_ORG*100,@SNIVEL_AH_ORG*100,@SNIVEL_BARBER_ORG*100) AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@SNIVEL_BANK_SW,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_BANK_SW*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +(@SNIVEL_BANK_SW,0,1,0,58,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On WP ended - Despawn - Self'), +-- +(@SNIVEL_BANK_SW*100,9,0,0,0,0,100,0,2000,2000,0,0,5,6,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BANK_SW*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BANK_SW*100,9,2,0,0,0,100,0,2000,2000,0,0,5,11,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BANK_SW*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BANK_SW*100,9,4,0,0,0,100,0,1000,1000,0,0,11,@SPELL_ROCKET,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Invoker'), +(@SNIVEL_BANK_SW*100,9,5,0,0,0,100,0,1000,1000,0,0,53,1,@SNIVEL_BANK_SW,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Start WP - Self'), +-- -- +(@SNIVEL_AH_SW,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_AH_SW*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +(@SNIVEL_AH_SW,0,1,0,58,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On WP ended - Despawn - Self'), +-- +(@SNIVEL_AH_SW*100,9,0,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_SW*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_SW*100,9,2,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_SW*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_SW*100,9,4,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_SW*100,9,5,0,0,0,100,0,1000,1000,0,0,1,2,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_SW*100,9,6,0,0,0,100,0,1000,1000,0,0,11,@SPELL_BLIND,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Invoker'), +(@SNIVEL_AH_SW*100,9,7,0,0,0,100,0,1000,1000,0,0,53,1,@SNIVEL_AH_SW,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Start WP - Self'), +-- -- +(@SNIVEL_BARBER_SW,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_BARBER_SW*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +-- +(@SNIVEL_BARBER_SW*100,9,0,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_SW*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_SW*100,9,2,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_SW*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_SW*100,9,4,0,0,0,100,0,2000,2000,0,0,5,5,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_SW*100,9,5,0,0,0,100,0,1000,1000,0,0,1,2,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_SW*100,9,6,0,0,0,100,0,1000,1000,0,0,11,@SPELL_VANISH,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Self'), +(@SNIVEL_BARBER_SW*100,9,7,0,0,0,100,0,1000,1000,0,0,1,3,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_SW*100,9,8,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Despawn - Self'), +-- -- -- +(@SNIVEL_BANK_ORG,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_BANK_ORG*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +(@SNIVEL_BANK_ORG,0,1,0,58,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On WP ended - Despawn - Self'), +-- +(@SNIVEL_BANK_ORG*100,9,0,0,0,0,100,0,2000,2000,0,0,5,6,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BANK_ORG*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BANK_ORG*100,9,2,0,0,0,100,0,2000,2000,0,0,5,11,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BANK_ORG*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BANK_ORG*100,9,4,0,0,0,100,0,1000,1000,0,0,11,@SPELL_ROCKET,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Invoker'), +(@SNIVEL_BANK_ORG*100,9,5,0,0,0,100,0,1000,1000,0,0,53,1,@SNIVEL_BANK_ORG,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Start WP - Self'), +-- -- +(@SNIVEL_AH_ORG,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_AH_ORG*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +(@SNIVEL_AH_ORG,0,1,0,58,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On WP ended - Despawn - Self'), +-- +(@SNIVEL_AH_ORG*100,9,0,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_ORG*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_ORG*100,9,2,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_ORG*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_ORG*100,9,4,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_AH_ORG*100,9,5,0,0,0,100,0,1000,1000,0,0,1,2,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_AH_ORG*100,9,6,0,0,0,100,0,1000,1000,0,0,11,@SPELL_BLIND,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Invoker'), +(@SNIVEL_AH_ORG*100,9,7,0,0,0,100,0,1000,1000,0,0,53,1,@SNIVEL_AH_ORG,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Start WP - Self'), +-- -- +(@SNIVEL_BARBER_ORG,0,0,0,54,0,100,0,0,0,0,0,80,@SNIVEL_BARBER_ORG*100,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On sumoned - Run script - Self'), +-- +(@SNIVEL_BARBER_ORG*100,9,0,0,0,0,100,0,2000,2000,0,0,5,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_ORG*100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_ORG*100,9,2,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_ORG*100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_ORG*100,9,4,0,0,0,100,0,2000,2000,0,0,5,5,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Emote - Self'), +(@SNIVEL_BARBER_ORG*100,9,5,0,0,0,100,0,1000,1000,0,0,1,2,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_ORG*100,9,6,0,0,0,100,0,1000,1000,0,0,11,@SPELL_VANISH,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Cast - Self'), +(@SNIVEL_BARBER_ORG*100,9,7,0,0,0,100,0,1000,1000,0,0,1,3,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Talk - Self'), +(@SNIVEL_BARBER_ORG*100,9,8,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'On script - Despawn - Self'); + + +DELETE FROM `creature_text` WHERE `entry` IN (@SNIVEL_BANK_SW,@SNIVEL_AH_SW,@SNIVEL_BARBER_SW,@SNIVEL_BANK_ORG,@SNIVEL_AH_ORG,@SNIVEL_BARBER_ORG); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@SNIVEL_BANK_SW,0,0,'What are you staring at? Haven''t you ever seen a genius before?',12,0,100,0,0,0,'say text'), +(@SNIVEL_BANK_SW,1,0,'This''ll teach you to mind your own business!',12,0,100,0,0,0,'say text'), +-- +(@SNIVEL_AH_SW,0,0,'That''s right, I''d like to list some of these ''fireworks''.',12,0,100,0,0,0,'say text'), +(@SNIVEL_AH_SW,1,0,'Those''ll net me a nice profit when I return from the South Seas.''.',12,0,100,0,0,0,'say text'), +(@SNIVEL_AH_SW,2,0,'You... Don''t think I don''t see you. Leave me alone!.',12,0,100,0,0,0,'say text'), +-- +(@SNIVEL_BARBER_SW,0,0,'Thanks for the great cut and shave, buddy.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_SW,1,0,'Here''s a little somethin'' extra since I''ll be away.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_SW,2,0,'On second thought, keep the whole bag. I have to, uh, get going.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_SW,3,0,'Did you really think you could corner me this easily?',12,0,100,0,0,0,'say text'), +-- -- +(@SNIVEL_BANK_ORG,0,0,'What are you staring at? Haven''t you ever seen a genius before?',12,0,100,0,0,0,'say text'), +(@SNIVEL_BANK_ORG,1,0,'This''ll teach you to mind your own business!',12,0,100,0,0,0,'say text'), +-- +(@SNIVEL_AH_ORG,0,0,'That''s right, I''d like to list some of these ''fireworks''.',12,0,100,0,0,0,'say text'), +(@SNIVEL_AH_ORG,1,0,'Those''ll net me a nice profit when I return from the South Seas.''.',12,0,100,0,0,0,'say text'), +(@SNIVEL_AH_ORG,2,0,'You... Don''t think I don''t see you. Leave me alone!.',12,0,100,0,0,0,'say text'), +-- +(@SNIVEL_BARBER_ORG,0,0,'Thanks for the great cut and shave, buddy.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_ORG,1,0,'Here''s a little somethin'' extra since I''ll be away.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_ORG,2,0,'On second thought, keep the whole bag. I have to, uh, get going.',12,0,100,0,0,0,'say text'), +(@SNIVEL_BARBER_ORG,3,0,'Did you really think you could corner me this easily?',12,0,100,0,0,0,'say text'); + + +DELETE FROM `waypoints` WHERE `entry` IN (@SNIVEL_BANK_SW,@SNIVEL_AH_SW,@SNIVEL_BARBER_SW,@SNIVEL_BANK_ORG,@SNIVEL_AH_ORG,@SNIVEL_BARBER_ORG); +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +-- need proper 3.3.5a WPs +(@SNIVEL_BANK_SW,1,-8922.295,620.7185,99.9155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,2,-8910.545,627.2185,99.9155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,3,-8902.795,631.2185,99.9155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,4,-8901.045,631.9685,99.9155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,5,-8898.795,633.2185,99.9155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,6,-8897.045,633.9685,99.4155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,7,-8895.545,634.7185,99.4155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,8,-8894.295,635.2185,99.4155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,9,-8892.045,636.2185,99.4155,'Snivel Rustrocket'), +(@SNIVEL_BANK_SW,10,-8890.389,637.309,99.52265,'Snivel Rustrocket'), +-- need proper 3.3.5a WPs +(@SNIVEL_AH_SW,1,-8806.079,665.8424,96.2017,'Snivel Rustrocket'), +(@SNIVEL_AH_SW,2,-8807.825,653.1030,96.1965,'Snivel Rustrocket'), +(@SNIVEL_AH_SW,3,-8829.964,634.2772,94.3178,'Snivel Rustrocket'), +(@SNIVEL_AH_SW,4,-8838.774,616.6351,92.8850,'Snivel Rustrocket'), +-- need proper 3.3.5a WPs +(@SNIVEL_BANK_ORG,1,1615.59,-4379.849,12.610,'Snivel Rustrocket'), +(@SNIVEL_BANK_ORG,2,1603.85,-4393.092,9.837,'Snivel Rustrocket'), +(@SNIVEL_BANK_ORG,3,1576.08,-4410.980,6.569,'Snivel Rustrocket'), +-- need proper 3.3.5a WPs +(@SNIVEL_AH_ORG,1,1669.29,-4433.413,19.643,'Snivel Rustrocket'), +(@SNIVEL_AH_ORG,2,1652.96,-4419.120,16.705,'Snivel Rustrocket'), +(@SNIVEL_AH_ORG,3,1627.23,-4427.485,13.353,'Snivel Rustrocket'); + + +DELETE FROM `spell_target_position` WHERE `id` IN (@SPELL_SUM_SW_BANK,@SPELL_SUM_SW_AH,@SPELL_SUM_SW_BARBER,@SPELL_SUM_ORG_BANK,@SPELL_SUM_ORG_AH,@SPELL_SUM_ORG_BARBER); +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(@SPELL_SUM_SW_BANK,0,-8922.7,620.628,100.225,0), +(@SPELL_SUM_SW_AH,0,-8815.04,662.193,95.4238,0), +(@SPELL_SUM_SW_BARBER,0,-8745.29,656.266,105.091,0), +-- +(@SPELL_SUM_ORG_BANK,1,1624.64,-4375.8662,12.0282,0), +(@SPELL_SUM_ORG_AH,1,1678.29,-4451.2597,19.2568,0), +(@SPELL_SUM_ORG_BARBER,1,1764.49,-4345.9306,-7.7980,0); + + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (@TRIGGER_BANK_SW,@TRIGGER_AH_SW,@TRIGGER_BARBER_SW,@TRIGGER_BANK_ORG,@TRIGGER_AH_ORG,@TRIGGER_BARBER_ORG); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(22,1,@TRIGGER_BANK_SW,2,0,9,0,@QUEST_A,0,0,0,0,'','execute sai only if player has quest taken'), +(22,1,@TRIGGER_AH_SW,2,0,9,0,@QUEST_A,0,0,0,0,'','execute sai only if player has quest taken'), +(22,1,@TRIGGER_BARBER_SW,2,0,9,0,@QUEST_A,0,0,0,0,'','execute sai only if player has quest taken'), +-- +(22,1,@TRIGGER_BANK_ORG,2,0,9,0,@QUEST_H,0,0,0,0,'','execute sai only if player has quest taken'), +(22,1,@TRIGGER_AH_ORG,2,0,9,0,@QUEST_H,0,0,0,0,'','execute sai only if player has quest taken'), +(22,1,@TRIGGER_BARBER_ORG,2,0,9,0,@QUEST_H,0,0,0,0,'','execute sai only if player has quest taken'); |