aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/3.3.5/2022_02_27_01_world.sql45
-rw-r--r--src/server/scripts/Spells/spell_quest.cpp48
2 files changed, 45 insertions, 48 deletions
diff --git a/sql/updates/world/3.3.5/2022_02_27_01_world.sql b/sql/updates/world/3.3.5/2022_02_27_01_world.sql
new file mode 100644
index 00000000000..a0f758e4640
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_02_27_01_world.sql
@@ -0,0 +1,45 @@
+--
+DELETE FROM `creature_text` WHERE `CreatureID` = 27435;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(27435,0,0,"%s armed.",16,0,100,0,0,0,24590,0,"Wintergarde Mine Bomb"),
+(27435,1,0,"Detonation in 5...",16,0,100,0,0,0,24591,0,"Wintergarde Mine Bomb"),
+(27435,2,0,"4...",16,0,100,0,0,0,24592,0,"Wintergarde Mine Bomb"),
+(27435,3,0,"3...",16,0,100,0,0,0,24593,0,"Wintergarde Mine Bomb"),
+(27435,4,0,"2...",16,0,100,0,0,0,24594,0,"Wintergarde Mine Bomb"),
+(27435,5,0,"1...",16,0,100,0,0,0,24595,0,"Wintergarde Mine Bomb");
+
+UPDATE `creature_template` SET `unit_flags` = 256 WHERE `entry` = 27435;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27435 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2743500 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`,`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
+(27435,0,0,0,11,0,100,0,0,0,0,0,0,80,2743500,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Spawn - Run Script"),
+(27435,0,1,0,8,0,100,0,48746,0,0,0,0,11,48744,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Spellhit 'Tap Upper Mine' - Cast 'Upper Wintergarde Mine Credit'"),
+(27435,0,2,0,8,0,100,0,48747,0,0,0,0,11,48745,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Spellhit 'Tap Lower Mine' - Cast 'Lower Wintergarde Mine Credit'"),
+-- The only flags it actually has are ImmunePC and Sessile, let's keep this hack from previous script for now
+(27435,0,3,0,63,0,100,0,0,0,0,0,0,145,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Just Created - Set ImmuneNPC On"),
+
+(2743500,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 0"),
+(2743500,9,1,0,0,0,100,0,1500,1500,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 1"),
+(2743500,9,2,0,0,0,100,0,1500,1500,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 2"),
+(2743500,9,3,0,0,0,100,0,1500,1500,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 3"),
+(2743500,9,4,0,0,0,100,0,1500,1500,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 4"),
+(2743500,9,5,0,0,0,100,0,1500,1500,0,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Say Line 5"),
+(2743500,9,6,0,0,0,100,0,1500,1500,0,0,0,11,48742,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Cast 'Wintergarde Mine Explosion'"),
+(2743500,9,7,0,0,0,100,0,2000,2000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wintergarde Mine Bomb - On Script - Despawn");
+
+UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (27436,27437);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27436,27437) 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
+(27436,0,0,0,8,0,100,0,48742,0,0,0,0,11,48746,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Upper Wintergarde Mine Shaft - On Spellhit 'Wintergarde Mine Explosion' - Cast 'Tap Upper Mine'"),
+(27437,0,0,0,8,0,100,0,48742,0,0,0,0,11,48747,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Lower Wintergarde Mine Shaft - On Spellhit 'Wintergarde Mine Explosion' - Cast 'Tap Lower Mine'");
+
+DELETE FROM `spell_script_names` WHERE `spell_id` = 48742 AND `ScriptName` = 'spell_q12277_wintergarde_mine_explosion';
+
+--
+UPDATE `gameobject` SET `VerifiedBuild` = 12340 WHERE `guid` = 66639 AND `id` = 188711;
+UPDATE `gameobject` SET `position_x` = 3903.77685546875, `position_y` = -882.82940673828125, `position_z` = 121.3870697021484375, `orientation` = -2.967041015625, `rotation2` = -0.99619388580322265, `rotation3` = 0.087165042757987976, `VerifiedBuild` = 12340 WHERE `guid` = 370 AND `id` = 188711;
+DELETE FROM `gameobject_addon` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 188711);
+
+UPDATE `creature` SET `position_x` = 3904.216064453125, `position_y` = -882.77777099609375, `position_z` = 119.691162109375, `orientation` = 3.473205089569091796, `VerifiedBuild` = 12340 WHERE `guid` = 42576 AND `id` = 27436;
+UPDATE `creature` SET `VerifiedBuild` = 12340 WHERE `guid` = 131174 AND `id` = 27437;
diff --git a/src/server/scripts/Spells/spell_quest.cpp b/src/server/scripts/Spells/spell_quest.cpp
index ba19f1b62a7..fdbe614d123 100644
--- a/src/server/scripts/Spells/spell_quest.cpp
+++ b/src/server/scripts/Spells/spell_quest.cpp
@@ -898,53 +898,6 @@ class spell_q14076_14092_pound_drum : public SpellScript
}
};
-enum LeaveNothingToChance
-{
- NPC_UPPER_MINE_SHAFT = 27436,
- NPC_LOWER_MINE_SHAFT = 27437,
-
- SPELL_UPPER_MINE_SHAFT_CREDIT = 48744,
- SPELL_LOWER_MINE_SHAFT_CREDIT = 48745,
-};
-
-// 48742 - Wintergarde Mine Explosion
-class spell_q12277_wintergarde_mine_explosion : public SpellScript
-{
- PrepareSpellScript(spell_q12277_wintergarde_mine_explosion);
-
- void HandleDummy(SpellEffIndex /*effIndex*/)
- {
- if (Creature* unitTarget = GetHitCreature())
- {
- if (Unit* caster = GetCaster())
- {
- if (caster->GetTypeId() == TYPEID_UNIT)
- {
- if (Unit* owner = caster->GetOwner())
- {
- switch (unitTarget->GetEntry())
- {
- case NPC_UPPER_MINE_SHAFT:
- caster->CastSpell(owner, SPELL_UPPER_MINE_SHAFT_CREDIT, true);
- break;
- case NPC_LOWER_MINE_SHAFT:
- caster->CastSpell(owner, SPELL_LOWER_MINE_SHAFT_CREDIT, true);
- break;
- default:
- break;
- }
- }
- }
- }
- }
- }
-
- void Register() override
- {
- OnEffectHitTarget += SpellEffectFn(spell_q12277_wintergarde_mine_explosion::HandleDummy, EFFECT_0, SPELL_EFFECT_DUMMY);
- }
-};
-
enum FocusOnTheBeach
{
SPELL_BUNNY_CREDIT_BEAM = 47390,
@@ -2311,7 +2264,6 @@ void AddSC_quest_spell_scripts()
RegisterSpellScript(spell_q14112_14145_chum_the_water);
RegisterSpellScript(spell_q9452_cast_net);
RegisterSpellScript(spell_q14076_14092_pound_drum);
- RegisterSpellScript(spell_q12277_wintergarde_mine_explosion);
RegisterSpellScript(spell_q12066_bunny_kill_credit);
RegisterSpellScript(spell_q12735_song_of_cleansing);
RegisterSpellScript(spell_q12372_cast_from_gossip_trigger);