aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/3.3.5/2020_09_12_07_world.sql96
-rw-r--r--src/server/scripts/Outland/zone_terokkar_forest.cpp100
2 files changed, 97 insertions, 99 deletions
diff --git a/sql/updates/world/3.3.5/2020_09_12_07_world.sql b/sql/updates/world/3.3.5/2020_09_12_07_world.sql
new file mode 100644
index 00000000000..24fe556f365
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_09_12_07_world.sql
@@ -0,0 +1,96 @@
+-- Isla Starmane SAI (https://www.youtube.com/watch?v=_kpk1XmPZkA & https://www.youtube.com/watch?v=MdmpUARYJvg)
+SET @ID := 18760;
+UPDATE `creature_template` SET `AIName` = "SmartAI", `ScriptName` = "" WHERE `entry` = @ID;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+3 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
+-- Probably impossible to confirm if it happens in retail since GO resets in 90 secs and quite possible
+-- it's not enough for creature to respawn even if she will be killed after escort start
+-- (@ID,0,0,0,11,0,100,0,0,0,0,0,0,32,0,0,0,0,0,0,20,182794,5,0,0,0,0,0,0,"Isla Starmane - On Respawn - Reset Closest Gameobject 'Cage'"),
+(@ID,0,0,0,11,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Respawn - Set Event Phase 1"),
+(@ID,0,1,0,1,1,100,0,30000,30000,60000,180000,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - Out Of Combat - Say Line 0 (Phase 1)"),
+-- Seems like she can reset timers after evade https://www.youtube.com/watch?v=MdmpUARYJvg
+(@ID,0,2,0,0,0,100,0,7000,10000,10000,15000,0,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Isla Starmane - In Combat - Cast 'Wrath'"),
+(@ID,0,3,0,0,0,100,0,8000,12000,10000,15000,0,11,15798,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Isla Starmane - In Combat - Cast 'Moonfire'"),
+(@ID,0,4,0,0,0,100,0,0,2000,13000,18000,0,11,33844,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Isla Starmane - In Combat - Cast 'Entangling Roots'"),
+-- No Repeat is experimental. For some reason gossip flag removal is delayed sometimes or always, let's try to simulate it for the first time
+(@ID,0,5,0,19,0,100,1,0,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Quest Taken - Run Script (No Repeat)"),
+(@ID,0,6,0,40,0,100,0,1,0,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Waypoint 1 Reached - Run Script"),
+(@ID,0,7,0,40,0,100,0,4,0,0,0,0,80,@ID*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Waypoint 4 Reached - Run Script"),
+(@ID,0,8,0,40,0,100,0,27,0,0,0,0,80,@ID*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Waypoint 27 Reached - Run Script"),
+(@ID,0,9,0,40,0,100,0,30,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Waypoint 30 Reached - Despawn Instant"),
+(@ID,0,10,0,6,0,100,0,0,0,0,0,0,6,10051,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Death - Fail Quest 'Escape from Firewing Point!'"),
+(@ID,0,11,0,6,0,100,0,0,0,0,0,0,6,10052,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Death - Fail Quest 'Escape from Firewing Point!'"),
+
+(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,16,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Store Targetlist"),
+(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Set Event Phase 0"),
+(@ID*100+0,9,2,0,0,0,100,0,2000,2000,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Remove NPC Flags Gossip & Questgiver"),
+(@ID*100+0,9,3,0,0,0,100,0,1000,1000,0,0,0,9,0,0,0,0,0,0,20,182794,5,0,0,0,0,0,0,"Isla Starmane - On Script - Activate Closest Gameobject 'Cage'"),
+(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,0,53,0,18760,0,0,0,2,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Start Waypoint"),
+(@ID*100+0,9,5,0,0,0,100,0,0,0,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Remove Flags Immune To Players & Immune To NPC's"),
+(@ID*100+0,9,6,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Set Faction 113"),
+
+(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,0,54,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Pause Waypoint"),
+(@ID*100+1,9,1,0,0,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Say Line 1"),
+
+(@ID*100+2,9,0,0,0,0,100,0,0,0,0,0,0,54,21000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Pause Waypoint"),
+(@ID*100+2,9,1,0,0,0,100,0,0,0,0,0,0,1,2,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Say Line 2"),
+(@ID*100+2,9,2,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,2.20155,"Isla Starmane - On Script - Set Orientation"),
+(@ID*100+2,9,3,0,0,0,100,0,16000,16000,0,0,0,1,3,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Say Line 3"),
+
+(@ID*100+3,9,0,0,0,0,100,0,0,0,0,0,0,54,17000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Pause Waypoint"),
+(@ID*100+3,9,1,0,0,0,100,0,2000,2000,0,0,0,1,4,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Say Line 4"),
+(@ID*100+3,9,2,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Set Orientation Stored Target 1"),
+(@ID*100+3,9,3,0,0,0,100,0,8000,8000,0,0,0,15,10051,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Quest Credit 'Escape from Firewing Point!'"),
+(@ID*100+3,9,4,0,0,0,100,0,0,0,0,0,0,15,10052,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Isla Starmane - On Script - Quest Credit 'Escape from Firewing Point!'"),
+(@ID*100+3,9,5,0,0,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Set Active"),
+(@ID*100+3,9,6,0,0,0,100,0,1000,1000,0,0,0,5,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Play Emote 3"),
+(@ID*100+3,9,7,0,0,0,100,0,4000,4000,0,0,0,11,32447,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Cast 'Travel Form'"),
+(@ID*100+3,9,8,0,0,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Isla Starmane - On Script - Set Run On");
+
+-- http://web.archive.org/web/20120420070331/www.wowhead.com/npc=18760
+DELETE FROM `creature_text` WHERE `CreatureID` = @ID;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(@ID,0,0,"Hello? Help?",12,0,100,0,0,0,15878,0,"Isla Starmane"),
+(@ID,0,1,"<cough> <cough> Damsel in distress over here!",12,0,100,0,0,0,15879,0,"Isla Starmane"),
+(@ID,0,2,"When you get a chance do you think you could let me out of here?",12,0,100,0,0,0,15880,0,"Isla Starmane"),
+(@ID,0,3,"Don't leave me in here! Cause if you do, I will find you...",12,0,100,0,0,0,15881,0,"Isla Starmane"),
+(@ID,1,0,"Ok, let's get out of here!",12,0,100,0,0,0,15882,0,"Isla Starmane"),
+(@ID,2,0,"You sure you're ready? Take a moment.",12,0,100,0,0,0,15883,0,"Isla Starmane"),
+(@ID,3,0,"Alright, let's do this!",12,0,100,0,0,0,15884,0,"Isla Starmane"),
+-- 15885 15886 probably related but not used
+(@ID,4,0,"Ok, I think I can make it on my own from here. Thank you so much for breaking me out of there!",12,0,100,0,0,0,15887,0,"Isla Starmane");
+
+DELETE FROM `script_waypoint` WHERE `entry` = 18760;
+DELETE FROM `waypoints` WHERE `entry` = 18760;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
+(18760,1,-2268.2,3091.14,13.82,"Isla Starmane"),
+(18760,2,-2278.32,3098.98,13.82,"Isla Starmane"),
+(18760,3,-2294.82,3110.59,13.82,"Isla Starmane"),
+(18760,4,-2300.71,3114.6,13.82,"Isla Starmane"), --
+(18760,5,-2307.36,3122.76,13.79,"Isla Starmane"),
+(18760,6,-2312.83,3130.55,12.04,"Isla Starmane"),
+(18760,7,-2345.02,3151,8.38,"Isla Starmane"),
+(18760,8,-2351.97,3157.61,6.27,"Isla Starmane"),
+(18760,9,-2360.35,3171.48,3.31,"Isla Starmane"),
+(18760,10,-2371.44,3185.41,0.89,"Isla Starmane"),
+(18760,11,-2371.21,3197.92,-0.96,"Isla Starmane"),
+(18760,12,-2380.35,3210.45,-1.08,"Isla Starmane"),
+(18760,13,-2384.74,3221.25,-1.17,"Isla Starmane"),
+(18760,14,-2386.15,3233.39,-1.29,"Isla Starmane"),
+(18760,15,-2383.45,3247.79,-1.32,"Isla Starmane"),
+(18760,16,-2367.5,3265.64,-1.33,"Isla Starmane"),
+(18760,17,-2354.9,3273.3,-1.5,"Isla Starmane"),
+(18760,18,-2348.88,3280.58,-0.09,"Isla Starmane"),
+(18760,19,-2349.06,3295.86,-0.95,"Isla Starmane"),
+(18760,20,-2350.43,3328.27,-2.1,"Isla Starmane"),
+(18760,21,-2346.76,3356.27,-2.82,"Isla Starmane"),
+(18760,22,-2340.56,3370.68,-4.02,"Isla Starmane"),
+(18760,23,-2318.84,3384.6,-7.61,"Isla Starmane"),
+(18760,24,-2313.99,3398.61,-10.4,"Isla Starmane"),
+(18760,25,-2320.85,3414.49,-11.49,"Isla Starmane"),
+(18760,26,-2338.26,3426.06,-11.46,"Isla Starmane"),
+(18760,27,-2342.67,3439.44,-11.32,"Isla Starmane"), --
+(18760,28,-2344.6,3461.27,-10.44,"Isla Starmane"),
+(18760,29,-2396.81,3517.17,-3.55,"Isla Starmane"),
+(18760,30,-2439.23,3523,-1.05,"Isla Starmane");
diff --git a/src/server/scripts/Outland/zone_terokkar_forest.cpp b/src/server/scripts/Outland/zone_terokkar_forest.cpp
index 2967ffc4448..212f2268c66 100644
--- a/src/server/scripts/Outland/zone_terokkar_forest.cpp
+++ b/src/server/scripts/Outland/zone_terokkar_forest.cpp
@@ -18,13 +18,12 @@
/* ScriptData
SDName: Terokkar_Forest
SD%Complete: 85
-SDComment: Quest support: 9889, 10051, 10052.
+SDComment: Quest support: 9889
SDCategory: Terokkar Forest
EndScriptData */
/* ContentData
npc_unkor_the_ruthless
-npc_isla_starmane
EndContentData */
#include "ScriptMgr.h"
@@ -162,102 +161,6 @@ public:
};
};
-/*######
-## npc_isla_starmane
-######*/
-enum IslaStarmaneData
-{
- SAY_PROGRESS_1 = 0,
- SAY_PROGRESS_2 = 1,
- SAY_PROGRESS_3 = 2,
- SAY_PROGRESS_4 = 3,
- GO_DISTANCE = 10,
- ESCAPE_FROM_FIREWING_POINT_A = 10051,
- ESCAPE_FROM_FIREWING_POINT_H = 10052,
- SPELL_TRAVEL_FORM_CAT = 32447,
- GO_CAGE = 182794
-};
-
-class npc_isla_starmane : public CreatureScript
-{
-public:
- npc_isla_starmane() : CreatureScript("npc_isla_starmane") { }
-
- struct npc_isla_starmaneAI : public EscortAI
- {
- npc_isla_starmaneAI(Creature* creature) : EscortAI(creature) { }
-
- void WaypointReached(uint32 waypointId, uint32 /*pathId*/) override
- {
- Player* player = GetPlayerForEscort();
- if (!player)
- return;
-
- switch (waypointId)
- {
- case 0:
- if (GameObject* Cage = me->FindNearestGameObject(GO_CAGE, GO_DISTANCE))
- Cage->SetGoState(GO_STATE_ACTIVE);
- break;
- case 2:
- Talk(SAY_PROGRESS_1, player);
- break;
- case 5:
- Talk(SAY_PROGRESS_2, player);
- break;
- case 6:
- Talk(SAY_PROGRESS_3, player);
- break;
- case 29:
- Talk(SAY_PROGRESS_4, player);
- if (player->GetTeam() == ALLIANCE)
- player->GroupEventHappens(ESCAPE_FROM_FIREWING_POINT_A, me);
- else if (player->GetTeam() == HORDE)
- player->GroupEventHappens(ESCAPE_FROM_FIREWING_POINT_H, me);
- me->SetFacingToObject(player);
- break;
- case 30:
- me->HandleEmoteCommand(EMOTE_ONESHOT_WAVE);
- break;
- case 31:
- DoCast(me, SPELL_TRAVEL_FORM_CAT);
- me->SetWalk(false);
- break;
- }
- }
-
- void Reset() override
- {
- me->RestoreFaction();
- }
-
- void JustDied(Unit* /*killer*/) override
- {
- if (Player* player = GetPlayerForEscort())
- {
- if (player->GetTeam() == ALLIANCE)
- player->FailQuest(ESCAPE_FROM_FIREWING_POINT_A);
- else if (player->GetTeam() == HORDE)
- player->FailQuest(ESCAPE_FROM_FIREWING_POINT_H);
- }
- }
-
- void OnQuestAccept(Player* player, Quest const* quest) override
- {
- if (quest->GetQuestId() == ESCAPE_FROM_FIREWING_POINT_H || quest->GetQuestId() == ESCAPE_FROM_FIREWING_POINT_A)
- {
- Start(true, false, player->GetGUID());
- me->SetFaction(FACTION_ESCORTEE_N_NEUTRAL_PASSIVE);
- }
- }
- };
-
- CreatureAI* GetAI(Creature* creature) const override
- {
- return new npc_isla_starmaneAI(creature);
- }
-};
-
// 40655 - Skyguard Flare
class spell_skyguard_flare : public SpellScript
{
@@ -277,6 +180,5 @@ class spell_skyguard_flare : public SpellScript
void AddSC_terokkar_forest()
{
new npc_unkor_the_ruthless();
- new npc_isla_starmane();
RegisterSpellScript(spell_skyguard_flare);
}