diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_09_26_02_world.sql | 159 |
1 files changed, 159 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_09_26_02_world.sql b/sql/updates/world/3.3.5/2021_09_26_02_world.sql new file mode 100644 index 00000000000..4b4171da092 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_09_26_02_world.sql @@ -0,0 +1,159 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (17702,21057,24016,24161,24162,25729,28490,28857) AND `source_type` = 0; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(17702,0,0,1,25,0,100,0,0,0,0,0,0,44,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Reset - Set Phasemask 2"), +(17702,0,1,2,61,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Reset - Set ImmunePC"), +(17702,0,2,0,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Reset - Set ImmuneNPC"), +(17702,0,3,4,38,0,20,0,1,1,0,0,0,44,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Data Set - Set Phasemask 1"), -- +(17702,0,4,5,61,0,100,0,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Data set - Remove ImmunePC"), +(17702,0,5,6,61,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Data set - Remove ImmuneNPC"), +(17702,0,6,0,61,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Data set - Say"), +(17702,0,7,0,4,0,100,0,0,0,0,0,0,11,20753,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - On Agro - Cast Demoralizing Roar"), +(17702,0,8,0,9,0,100,0,0,5,3000,5000,0,11,15793,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"High Chief Bristlelimb - IC - Cast Maul"), + +(21057,0,0,1,38,0,100,0,1,1,45000,45000,0,45,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Data Set 1 1 - Set Data 10"), -- +(21057,0,1,2,61,0,100,0,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Data Set 1 1 - Remove ImmunePC"), +(21057,0,2,3,61,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Data Set 1 1 - Remove ImmuneNPC"), +(21057,0,3,4,61,0,100,0,0,0,0,0,0,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Data Set 1 1 - Set Visible"), +(21057,0,4,0,61,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Data Set 1 1 - Say"), +(21057,0,5,6,25,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On spawn - Set ImmunePC"), +(21057,0,6,7,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On spawn - Set ImmuneNPC"), +(21057,0,7,0,61,0,100,0,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On spawn - Set Invisible"), +(21057,0,8,9,21,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Creature reached home - Set ImmunePC"), +(21057,0,9,10,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Creature reached home - Set ImmuneNPC"), +(21057,0,10,0,61,0,100,0,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Creature reached home - Set Invisible"), +(21057,0,11,0,9,0,100,0,0,8,8000,11000,0,11,35924,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Range - Cast Energy Flux"), +(21057,0,12,0,6,0,100,0,0,0,0,0,0,11,37957,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nexus-Prince Razaan - On Death - Spawn Collection of Souls"), + +(24016,0,0,0,9,0,100,0,0,5,7000,12000,0,11,48288,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - Within 0-5 Range - Cast 'Mace Smash' (Phase 1) (No Repeat)"), +(24016,0,1,0,6,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Just Died - Set Event Phase 1 (Phase 1) (No Repeat)"), +(24016,0,2,0,8,1,100,1,43178,0,0,0,0,11,43191,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Spellhit 'Plant Forsaken Banner' - Cast 'Ulf Credit' (Phase 1) (No Repeat)"), +(24016,0,3,4,11,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Spawn - Set ImmunePC"), +(24016,0,4,5,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Spawn - Set ImmuneNPC"), +(24016,0,5,0,61,0,100,0,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Spawn - Set Invisible"), +(24016,0,6,7,38,0,100,1,1,1,0,0,0,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Data Set - Set Visible"), -- +(24016,0,7,8,61,0,100,1,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Data Set - Remove ImmunePC"), +(24016,0,8,9,61,0,100,1,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Data Set - Remove ImmuneNPC"), +(24016,0,9,0,61,0,100,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ulf the Bloodletter - On Data Set - Say"), + +(24161,0,0,0,9,0,100,0,0,5,5000,8000,0,11,15496,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Oric the Baleful - Within 0-5 Range - Cast 'Cleave' (Phase 1) (No Repeat)"), +(24161,0,1,0,0,0,100,0,9000,11000,9000,13000,0,11,32736,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Oric the Baleful - In Combat - Cast 'Mortal Strike' (Phase 1) (No Repeat)"), +(24161,0,2,0,6,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Just Died - Set Event Phase 1 (Phase 1) (No Repeat)"), +(24161,0,3,0,8,1,100,1,43178,0,0,0,0,11,43192,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Oric the Baleful - On Spellhit 'Plant Forsaken Banner' - Cast 'Oric Credit' (Phase 1) (No Repeat)"), +(24161,0,4,5,11,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Spawn - Set ImmunePC"), +(24161,0,5,6,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Spawn - Set ImmuneNPC"), +(24161,0,6,0,61,0,100,0,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Spawn - Set Invisible"), +(24161,0,7,8,38,0,100,1,1,1,0,0,0,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Data Set - Set Visible"), -- +(24161,0,8,9,61,0,100,1,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Data Set - Remove ImmunePC"), +(24161,0,9,10,61,0,100,1,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Data Set - Remove ImmuneNPC"), +(24161,0,10,0,61,0,100,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Oric the Baleful - On Data Set - Say"), + +(24162,0,0,0,9,0,100,0,0,5,7000,9000,0,11,41056,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - Within 0-5 Range - Cast 'Whirlwind' (Phase 1) (No Repeat)"), +(24162,0,1,0,6,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Just Died - Set Event Phase 1 (Phase 1) (No Repeat)"), +(24162,0,2,0,8,1,100,1,43178,0,0,0,0,11,43193,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Spellhit 'Plant Forsaken Banner' - Cast 'Gunnar Credit' (Phase 1) (No Repeat)"), +(24162,0,3,4,11,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Spawn - Set ImmunePC"), +(24162,0,4,5,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Spawn - Set ImmuneNPC"), +(24162,0,5,0,61,0,100,0,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Spawn - Set Invisible"), +(24162,0,6,7,38,0,100,1,1,1,0,0,0,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Data Set - Set Visible"), -- +(24162,0,7,8,61,0,100,1,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Data Set - Remove ImmunePC"), +(24162,0,8,9,61,0,100,1,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Data Set - Remove ImmuneNPC"), +(24162,0,9,0,61,0,100,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Gunnar Thorvardsson - On Data Set - Say"), + +(25729,0,0,1,19,0,100,0,11705,0,0,0,0,64,1,0,0,0,0,0,16,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Store targetlist"), +(25729,0,1,2,61,0,100,0,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Remove npcflag questgiver"), +(25729,0,2,3,61,0,100,0,0,0,0,0,0,1,0,3000,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Say line"), +(25729,0,3,4,61,0,100,0,0,0,0,0,0,11,45924,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Spellcast On Getry's Quest"), +(25729,0,4,5,61,0,100,0,0,0,0,0,0,11,45924,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Spellcast On Getry's Quest"), +(25729,0,5,0,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,25618,50,0,0,0,0,0,0,"Shadowstalker Getry - On quest accept - Set data 0 1 Varidus the Flenser"), +(25729,0,6,7,52,0,100,0,0,25729,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On text 0 over - Say line"), +(25729,0,7,0,61,0,100,0,0,0,0,0,0,53,0,25729,0,0,0,3,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On text 0 over - Start WP"), +(25729,0,8,0,11,0,100,0,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On spawn - Set npcflag questgiver"), +(25729,0,9,0,40,0,100,0,8,25729,0,0,0,11,34189,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP8 reached - Spellcast Stealth"), +(25729,0,10,11,40,0,100,0,9,25729,0,0,0,45,0,2,0,0,0,0,19,25618,30,0,0,0,0,0,0,"Shadowstalker Getry - On WP 9 reached - Set data 0 2 Varidus the Flenser"), +(25729,0,11,0,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,25618,30,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Send targetlist to Varidus the Flenser"), +(25729,0,12,13,40,0,100,0,10,25729,0,0,0,66,0,0,0,0,0,0,19,25618,20,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Turn to"), +(25729,0,13,14,61,0,100,0,0,0,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Set home position"), +(25729,0,14,15,61,0,100,0,0,0,0,0,0,28,34189,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Remove aura Stealth"), +(25729,0,15,16,61,0,100,0,0,0,0,0,0,11,45922,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Spellcast Shadow Prison"), +(25729,0,16,17,61,0,100,0,0,0,0,0,0,86,45922,0,12,1,0,0,12,1,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Crosscast Shadow Prison"), +(25729,0,17,0,61,0,100,0,0,0,0,0,0,45,0,3,0,0,0,0,19,25618,20,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached - Set Data 0 3 Varidus the Flenser"), +(25729,0,18,19,38,0,100,0,1,1,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 1 set - Remove ImmunePC"), +(25729,0,19,20,61,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 1 set - Remove ImmuneNPC"), +(25729,0,20,0,61,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,19,25618,20,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 1 set - Start attack"), +(25729,0,21,22,38,0,100,0,1,3,0,0,0,15,11705,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 3 set - Quest credit"), +(25729,0,22,0,61,0,100,0,0,0,0,0,0,1,2,5000,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 3 set - Say line"), +(25729,0,23,0,52,0,100,0,2,25729,0,0,0,1,3,5000,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On text 2 over - Say line"), +(25729,0,24,0,52,0,100,0,3,25729,0,0,0,45,1,2,0,0,0,0,19,25751,20,0,0,0,0,0,0,"Shadowstalker Getry - On text 3 over - Set data 1 2 High Overlord Saurfang"), +(25729,0,25,0,38,0,100,0,1,4,0,0,0,53,0,2572900,0,0,0,3,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On data 1 4 set - Start WP movement"), +(25729,0,26,27,40,0,100,0,10,2572900,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached (Return) - Set npcflag questgiver"), +(25729,0,27,28,61,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached (Return) - Set ImmunePC"), +(25729,0,28,29,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached (Return) - Set ImmuneNPC"), +(25729,0,29,0,61,0,100,0,0,0,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On WP10 reached (Return) - Set homeposition"), +(25729,0,30,31,8,0,100,0,45950,0,0,0,0,28,45922,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shadowstalker Getry - On spellhit Saurfangs Rage - Remove aura Shadow Prison"), +(25729,0,31,0,61,0,100,0,0,0,0,0,0,28,45922,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Shadowstalker Getry - On spellhit Saurfangs Rage - Remove aura Shadow Prison"), +(25729,0,32,33,6,0,100,0,0,0,0,0,0,6,11705,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Shadowstalker Getry - On Death - Fail Quest"), +(25729,0,33,34,61,0,100,0,0,0,0,0,0,45,2,2,0,0,0,0,19,25618,0,0,0,0,0,0,0,"Shadowstalker Getry - On Death - Set Data 2 2 Varidus"), +(25729,0,34,35,61,0,100,0,0,0,0,0,0,45,2,2,0,0,0,0,19,25730,0,0,0,0,0,0,0,"Shadowstalker Getry - On Death - Set Data 2 2 Varidus"), +(25729,0,35,0,61,0,100,0,0,0,0,0,0,45,2,2,0,0,0,0,19,25751,0,0,0,0,0,0,0,"Shadowstalker Getry - On Death - Set Data 2 2 Varidus"), + +(28490,0,0,0,13,0,100,0,15000,20000,0,0,0,11,53550,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Disciple of Frost - On Victim Casting - Cast 'Mind Freeze'"), +(28490,0,1,0,0,0,100,0,5000,10000,15000,20000,0,11,50349,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Disciple of Frost - In Combat - Cast 'Icy Touch'"), +(28490,0,2,0,0,1,100,0,16000,16000,30000,40000,0,11,51209,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Disciple of Frost - In Combat - Cast 'Hungering Cold' (Phase 1)"), +(28490,0,3,0,0,1,100,0,27000,27000,30000,40000,0,11,53536,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Disciple of Frost - In Combat - Cast 'Howling Blast' (Phase 1)"), +(28490,0,4,5,25,0,100,0,0,0,0,0,0,18,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Reset - Set ImmunePC"), +(28490,0,5,6,61,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Reset - Set ImmuneNPC"), +(28490,0,6,7,61,0,100,0,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Reset - Set Run Off"), +(28490,0,7,0,61,0,100,0,0,0,0,0,0,2,2104,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Reset - Set Faction"), +(28490,0,8,9,6,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,19,28474,50,0,0,0,0,0,0,"Disciple of Frost - On Death - Say Line 5 (Amal'thazad)"), +(28490,0,9,0,61,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,19,29194,50,0,0,0,0,0,0,"Disciple of Frost - On Death - Say Line 5 (Amal'thazad)"), +(28490,0,10,11,5,0,100,0,0,0,0,28488,0,1,6,0,0,0,0,0,19,28474,50,0,0,0,0,0,0,"Disciple of Frost - On Killed Coldwraith - Say Line 6 (Amal'thazad)"), +(28490,0,11,0,61,0,100,0,0,0,0,0,0,1,6,0,0,0,0,0,19,29194,50,0,0,0,0,0,0,"Disciple of Frost - On Killed Coldwraith - Say Line 6 (Amal'thazad)"), +(28490,0,12,13,5,0,100,0,0,0,0,29210,0,1,6,0,0,0,0,0,19,28474,50,0,0,0,0,0,0,"Disciple of Frost - On Killed Frigid Bones - Say Line 6 (Amal'thazad)"), -- +(28490,0,13,0,61,0,100,0,0,0,0,0,0,1,6,0,0,0,0,0,19,29194,50,0,0,0,0,0,0,"Disciple of Frost - On Killed Frigid Bones - Say Line 6 (Amal'thazad)"), -- +(28490,0,14,0,34,0,100,0,0,1,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,0.58552,"Disciple of Frost - On Point 1 Reached - Set Orientation"), +(28490,0,15,0,34,0,100,0,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,3.82097,"Disciple of Frost - On Point 2 Reached - Set Orientation"), +(28490,0,16,0,38,0,100,0,1,1,0,0,0,69,1,0,0,0,0,0,8,0,0,0,0,2414.77,-5532.06,377.027,0,"Disciple of Frost - On Data 1 1 Set - Move To Pos"), +(28490,0,17,18,38,0,100,0,2,2,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Data 2 2 Set - Remove ImmunePC"), +(28490,0,18,19,61,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Data 2 2 Set - Remove ImmuneNPC"), +(28490,0,19,20,61,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Data 2 2 Set - Set Run On"), +(28490,0,20,21,61,0,100,0,0,0,0,0,0,2,2081,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Data 2 2 Set - Set Faction"), +(28490,0,21,0,61,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,19,28488,10,0,0,0,0,0,0,"Disciple of Frost - On Data 2 2 Set - Attack Coldwraith"), +(28490,0,22,0,38,0,100,0,3,3,0,0,0,80,2849000,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Disciple of Frost - On Data 3 3 Set - Run Actionlist"), +(28490,0,23,0,38,0,100,0,4,4,0,0,0,69,2,0,0,0,0,0,8,0,0,0,0,2422,-5527.29,377.055,0,"Disciple of Frost - On Data 4 4 Set - Move To Pos"), + +(28857,0,0,1,54,0,100,0,0,0,0,0,0,11,52573,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cast 'Drostan On Spawn'"), +(28857,0,1,0,61,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Face Invoker"), +(28857,0,3,0,54,0,100,0,0,0,0,0,0,86,52585,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 1'"), +(28857,0,4,0,54,0,100,0,0,0,0,0,0,86,52725,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 2'"), +(28857,0,5,0,54,0,100,0,0,0,0,0,0,86,52726,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 3'"), +(28857,0,6,0,54,0,100,0,0,0,0,0,0,86,52727,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 4'"), +(28857,0,7,0,54,0,100,0,0,0,0,0,0,86,52728,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 5'"), +(28857,0,8,0,54,0,100,0,0,0,0,0,0,86,52729,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 6'"), +(28857,0,9,0,54,0,100,0,0,0,0,0,0,86,52730,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 7'"), +(28857,0,10,0,54,0,100,0,0,0,0,0,0,86,52731,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - Just Summoned - Cross Cast 'Cue Drostan Response Set 8'"), +(28857,0,11,0,8,0,100,0,52585,0,0,0,0,80,2885700,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 1' - Run Actionlist"), +(28857,0,12,0,8,0,100,0,52725,0,0,0,0,80,2885701,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 2' - Run Actionlist"), +(28857,0,13,0,8,0,100,0,52726,0,0,0,0,80,2885702,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 3' - Run Actionlist"), +(28857,0,14,0,8,0,100,0,52727,0,0,0,0,80,2885703,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 4' - Run Actionlist"), +(28857,0,15,0,8,0,100,0,52728,0,0,0,0,80,2885704,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 5' - Run Actionlist"), +(28857,0,16,0,8,0,100,0,52729,0,0,0,0,80,2885705,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 6' - Run Actionlist"), +(28857,0,17,0,8,0,100,0,52730,0,0,0,0,80,2885706,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 7' - Run Actionlist"), +(28857,0,18,0,8,0,100,0,52731,0,0,0,0,80,2885707,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Drostan - On Spellhit 'Cue Drostan Response Set 8' - Run Actionlist"); + +UPDATE `creature_template` SET `unit_flags` = 512 WHERE `entry` = 28857; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` IN (17702,21057,24016,24161,24162,25729,28490) AND `SourceId` = 0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,4,17702,0,0,26,1,2,0,0,0,0,0,"","High Chief Bristlelimb must be in phasemask 2 in order to execute SAI ID 3"), +(22,4,17702,0,0,36,1,0,0,0,0,0,0,"","High Chief Bristlelimb must be alive in order to execute SAI ID 3 AND"), + +(22,1,21057,0,0,36,1,0,0,0,0,0,0,"","Only execute SAI if Nexus-Prince Razaan alive"), + +(22,7,24016,0,0,36,1,0,0,0,0,0,0,"","Only execute SAI if Ulf the Bloodletter alive"), + +(22,8,24161,0,0,36,1,0,0,0,0,0,0,"","Only execute SAI if Oric the Baleful alive"), + +(22,7,24162,0,0,36,1,0,0,0,0,0,0,"","Only execute SAI if Gunnar Thorvardsson alive"), + +(22,13,28490,0,0,29,1,29210,50,0,1,0,0,"","Run SAI only if there are no alive 'Frigid Bones' nearby"), +(22,14,28490,0,0,29,1,29210,50,0,1,0,0,"","Run SAI only if there are no alive 'Frigid Bones' nearby"); |