Return to Caldanis Brightspear

– [Q] Return to Mydarion Sunblaze / Caladis Brightspear

– Return to Caladis Brightspear

/*
##############
Creatures #
##############
*/
– Blood Queen Lana’Thel (37846)
DELETE FROM creature_template_addon WHERE entry=37846;
INSERT INTO creature_template_addon (entry, mount, bytes1, bytes2, auras)
VALUES
(37846, 0, 0x0, 0x1, ‘’);

DELETE FROM creature_text WHERE entry=37846;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, comment)
VALUES
(37846, 0, 0, ‘Quel’‘Delar.’, 12, 0, 100, 1, 0, 16808, ‘Blood-Queen Lana’‘thel’),
(37846, 1, 0, ‘Quiet, fools. If I had wished to kill you, you’‘d already be dead.’, 12, 0, 100, 11, 0, 0, ‘Blood-Queen Lana’‘thel’),
(37846, 2, 0, ‘As Quel’‘Serrar was forged by the dragons and given to the kaldorei, its twin, Quel’‘Delar, was given to my people.’, 12, 0, 100, 1, 0, 16809, ‘Blood-Queen Lana’‘thel’),
(37846, 3, 0, ‘The king bestowed the blade upon my friend, Thalorien Dawnseeker.’, 12, 0, 100, 1, 0, 16800, ‘Blood-Queen Lana’‘thel’),
(37846, 4, 0, ‘But even Thalorien’‘s skill and Quel’‘Delar’‘s magic could not save Silvermoon from the might of the Scourge.’, 12, 0, 100, 1, 0, 16801, ‘Blood-Queen Lana’‘thel’),
(37846, 5, 0, ‘Thalorien fell before the gates of the Sunwell, buying time for others to escape.’, 12, 0, 100, 1, 0, 16802, ‘Blood-Queen Lana’‘thel’),
(37846, 6, 0, ‘After the battle, I recovered the sword from the field. I bore it to Northrend in the service of my prince, seeking to avenge our people’‘s defeat.’, 12, 0, 100, 381, 0, 16803, ‘Blood-Queen Lana’‘thel’),
(37846, 7, 0, ‘Arthas shattered our forces and took the most powerful of us into his service as the San’‘layn.’, 12, 0, 100, 1, 0, 16804, ‘Blood-Queen Lana’‘thel’),
(37846, 8, 0, ‘My memories of Thalorien went cold and so did his blade.’, 12, 0, 100, 1, 0, 16805, ‘Blood-Queen Lana’‘thel’),
(37846, 9, 0, ‘It was I who brought Quel’‘Delar here, to return it to its makers. In breaking the weapon, so did I break its power.’, 12, 0, 100, 25, 0, 16806, ‘Blood-Queen Lana’‘thel’),
(37846, 10, 0, ‘Quel’‘Delar will never serve another!’, 12, 0, 100, 5, 0, 16807, ‘Blood-Queen Lana’‘thel’);

DELETE FROM waypoints WHERE entry=37846;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment)
VALUES
(37846, 1, 8116.109, 779.8637, 481.6346, ‘Blood Queen Lana’‘Thel’);

– Caladis Brightspear
DELETE FROM creature_text WHERE entry=36624;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, comment)
VALUES
(36624, 0, 0, ‘I knew this was a dragonforged blade when I first laid eyes on it.’, 12, 0, 100, 1, 0, 16604, ‘Caladis Brightspear’),
(36624, 1, 0, ‘But can it be? Is this really --’, 12, 0, 100, 6, 0, 16605, ‘Caladis Brightspear’),
(36624, 2, 0, ‘I vow that the Silver Covenant will see Quel’‘Delar restored.’, 12, 0, 100, 1, 0, 0, ‘Caladis Brightspear’);

DELETE FROM waypoints WHERE entry=36624;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment)
VALUES
(36624, 1, 8117.508, 783.0759, 481.438, ‘Caladis Brightspear’);

– Sunweaver War Mage (36656)

– Siler Covenant Sentinel
DELETE FROM creature_text WHERE entry=36656;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, comment)
VALUES
(36656, 0, 0, ‘You are not welcome here, minion of the Lich King!’, 12, 0, 100, 0, 0, 16808, ‘Silver Covenant Sentinel’);

/*
#######
SAI #
#######
*/

– Full SAI → Return to Caladis Brightspear
SET @ENTRY_CALADIS := 36624;
SET @ENTRY_BLOODQUEEN := 37846;
SET @ENTRY_SUNWEAVERMAGE := 36657;
SET @ENTRY_SENTINEL := 36656;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry IN (@ENTRY_CALADIS, @ENTRY_BLOODQUEEN, @ENTRY_SUNWEAVERMAGE, @ENTRY_SENTINEL);
DELETE FROM smart_scripts WHERE entryorguid IN (@ENTRY_CALADIS, @ENTRY_BLOODQUEEN, @ENTRY_SUNWEAVERMAGE, @ENTRY_SENTINEL, -202278, -202277, -202276, -202275) 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, 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
– Caladis
(@ENTRY_CALADIS, 0, 0, 0, 20, 0, 100, 1, 24454, 0, 0, 0, 53, 0, @ENTRY_CALADIS, 0, 24454, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Caladis Brightspear - On Quest Reward 24454 - Start WP Movement’),
(@ENTRY_CALADIS, 0, 1, 0, 1, 0, 100, 1, 2000, 2000, 2000, 2000, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Caladis Brightspear - On Timer - Dismount creature’),
(@ENTRY_CALADIS, 0, 2, 0, 1, 0, 100, 1, 2000, 2000, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Caladis Brightspear - On Timer - Say groupid 0’),
(@ENTRY_CALADIS, 0, 3, 0, 52, 0, 100, 1, 0, @ENTRY_CALADIS, 0, 0, 12, @ENTRY_BLOODQUEEN, 1, 50, 0, 0, 0, 8, 0, 0, 0, 8103.869, 785.2864, 481.1694, 5.8373, ‘Caladis Brightspear - On text over - summon Blood Queen Lana’‘Thel’),
(@ENTRY_CALADIS, 0, 4, 0, 1, 0, 100, 1, 6000, 6000, 6000, 6000, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Caladis Brightspear - On Timer - Say groupid 1’),
(@ENTRY_CALADIS, 0, 5, 4, 61, 0, 100, 1, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, @ENTRY_BLOODQUEEN, 20, 45, 0, 0, 0, 0, ‘Caladis Brightspear - On link - Set data on Blood Queen Lana’‘Thel’),
– Blood Queen Lana’Thel
(@ENTRY_BLOODQUEEN, 0, 0, 0, 54, 0, 100, 1, 0, 0, 0, 0, 53, 0, @ENTRY_BLOODQUEEN, 0, 24454, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Just Summoned - Start WP Movement’),
(@ENTRY_BLOODQUEEN, 0, 1, 0, 61, 0, 100, 1, 0, 0, 0, 0, 11, 64195, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Just Summoned - Cast spell 64195’),
(@ENTRY_BLOODQUEEN, 0, 2, 0, 38, 0, 100, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Data Set - Say groupid 0’),
(@ENTRY_BLOODQUEEN, 0, 3, 2, 61, 0, 100, 1, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 10, 202278, @ENTRY_SUNWEAVERMAGE, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On link - Set Data on Sunweaver War Mage GUID’),
(@ENTRY_BLOODQUEEN, 0, 4, 2, 61, 0, 100, 1, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 10, 202277, @ENTRY_SUNWEAVERMAGE, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On link - Set Data on Sunweaver War Mage GUID’),
(@ENTRY_BLOODQUEEN, 0, 5, 2, 61, 0, 100, 1, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 10, 202276, @ENTRY_SENTINEL, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On link - Set Data on Silver Covenant Sentinel GUID’),
(@ENTRY_BLOODQUEEN, 0, 6, 2, 61, 0, 100, 1, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 10, 202275, @ENTRY_SENTINEL, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On link - Set Data on Silver Covenant Sentinel GUID’),
(@ENTRY_BLOODQUEEN, 0, 7, 0, 1, 0, 100, 1, 5000, 5000, 5000, 5000, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 1’),
(@ENTRY_BLOODQUEEN, 0, 8, 7, 61, 0, 100, 1, 0, 0, 0, 0, 11, 71365, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - cast spell 71365’),
(@ENTRY_BLOODQUEEN, 0, 9, 0, 1, 0, 100, 1, 6000, 6000, 6000, 6000, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 2’),
(@ENTRY_BLOODQUEEN, 0, 10, 0, 1, 0, 100, 1, 11000, 11000, 11000, 11000, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 3’),
(@ENTRY_BLOODQUEEN, 0, 11, 0, 1, 0, 100, 1, 11000, 11000, 11000, 11000, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 4’),
(@ENTRY_BLOODQUEEN, 0, 12, 0, 1, 0, 100, 1, 13000, 13000, 13000, 13000, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 5’),
(@ENTRY_BLOODQUEEN, 0, 13, 0, 1, 0, 100, 1, 12000, 12000, 12000, 12000, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 8124.342, 778.9861, 482.0804, 3.34602, ‘Blood Queen Lana’‘Thel - On Timer - Move to position’),
(@ENTRY_BLOODQUEEN, 0, 14, 0, 1, 0, 100, 1, 2000, 2000, 2000, 2000, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 6’),
(@ENTRY_BLOODQUEEN, 0, 15, 0, 1, 0, 100, 1, 13000, 13000, 13000, 13000, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 7’),
(@ENTRY_BLOODQUEEN, 0, 16, 0, 1, 0, 100, 1, 7000, 7000, 7000, 7000, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 8’),
(@ENTRY_BLOODQUEEN, 0, 17, 0, 1, 0, 100, 1, 7000, 7000, 7000, 7000, 1, 9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 9’),
(@ENTRY_BLOODQUEEN, 0, 18, 0, 1, 0, 100, 1, 10000, 10000, 10000, 10000, 11, 70586, 0, 0, 0, 0, 0, 9, 37852, 50, 100, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - Cast Throw Quel’‘Daner at trigger’),
(@ENTRY_BLOODQUEEN, 0, 19, 0, 1, 0, 100, 1, 7000, 7000, 7000, 7000, 1, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - say groupid 10’),
(@ENTRY_BLOODQUEEN, 0, 20, 0, 1, 0, 100, 1, 6000, 6000, 6000, 6000, 41, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Blood Queen Lana’‘Thel - On Timer - Despawn’),
– Sunweaver War Mage

(-202278, 0, 0, 0, 38, 0, 100, 1, 2, 2, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 8114.629, 774.4673, 481.7515, 2.02655, ‘Sunweaver War Mage GUID - On Data Set - Move to position’),
(-202277, 0, 0, 0, 38, 0, 100, 1, 3, 3, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 8118.916, 774.8649, 481.98, 1.87261, ‘Sunweaver War Mage GUID - On Data Set - Move to position’),

– Silver Covenant Sentinel
(-202276, 0, 0, 0, 38, 0, 100, 1, 4, 4, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 8117.81, 784.6957, 481.5, 4.60266, ‘Silver Covenant Sentinel GUID - On Data Set - Move to position’),
(-202276, 0, 1, 0, 1, 0, 100, 1, 1500, 1500, 1500, 1500, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Silver Covenant Sentinel GUID - On Timer - say groupid 0’),
(-202275, 0, 0, 0, 38, 0, 100, 1, 5, 5, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 8113.22, 785.0972, 481.3771, 5.08332, ‘Silver Covenant Sentinel GUID - On Data Set - Move to position’);

I can’t find a working event to start the event (on quest completion). I’m using event type 20 which is on rewarded, but it needs completion.

Is there any way i can use it or is it for the trash can?

**Just tested this event, it isn’t working, if it is for completed.

But maybe this event = on quest forced in character quest log?

void sQuestAccept(Player* player, Quest const* quest);//void sQuestSelect(Player* player, Quest const* quest);

//void sQuestComplete(Player* player, Quest const* quest);

void sQuestReward(Player* player, Quest const* quest, uint32 opt);

case SMART_EVENT_ACCEPTED_QUEST:

case SMART_EVENT_REWARD_QUEST:

{

if (e.event.quest.quest && var0 != e.event.quest.quest)

return;

ProcessAction(e, unit, var0);

break;

I don’t understand you 100%.

What are you trying to say?

Event 20 is not working if it is intented for completed quests. And I suppose if it by any chance has other role it may be for quests that are forced into player log - like quest add function etc, which sound reasonable to me.

Only salvation would be, if there was any spell that is supposed to trigger the event as quest reward spell or someone must script this event the quest needs.

Other deprecated solution as far as I know would be this:

CompleteScript

ID of the end script. See quest_end_scripts.id

SCRIPT_COMMAND_LOAD_PATH = 2

source: Unit

datalong: Path ID. See waypoint_data.id.

datalong2: If value > 0, means waypoint movement is repeatable.

Since you don’t have the events connected you only want to cause the waypoint started it can be done from there.

This doesn’t support SAI, am i right?

And there are also functions i need in SAI which aren’t in EAI.

Yes, you are right my fault, forgot this won’t work with SmartAI.

Well, last thing I can think is custom made. Use a spell that is awarded on quest complete that trigger player to cast back another on the quest giver and use it with event 8 on spell hit.

I will give detailed info what and why is being done, so please don’t ignore it as simple meaningless hack.

-----

47107 - [FONT=arial][SIZE=12px]Give Summer Scorchling Incense[/FONT][/SIZE] (this is a simple trigger spell, it has absolutely no effects, just a trigger, that activates from player another spell that is trigger with implicit effect /that has absolutely no influence as auras, visuals, any changes you can imagine).

47104 - this is the triggered spell.

You can add 47014 to be spellreward casted on character on quest complete. /this will be not visible to noone by any means/ On other hand you will use it along with:

[CODE]-- Caladis
(@ENTRY_CALADIS,0,0,0,8,0,100,0,47104,0,0,0, 53, 0, @ENTRY_CALADIS, 0, 24454, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Caladis Brightspear - On spell hit by trigger - Start WP Movement’),
– Update quest_template to cast a spell on complete
UPDATE quest_template SET RewardSpellCast=47107 WHERE Id=24454;
– Add conditions for Scorchling Gets Incense spell
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=47104;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition ,ErrorTextId,ScriptName,Comment) VALUES
(13,1,47104,0,1,31,0,3,26520,0,0,0,‘’,‘Scorching gets incense can only hit Scorchling /Horde side/’),
(13,1,47104,0,2,31,0,3,26401,0,0,0,‘’,‘Scorching gets incense can only hit Scorchling /Alliance side/’),
(13,1,47104,0,3,31,0,3,36624,0,0,0,‘’,‘Scorching gets incense can only hit Caladis Brightspear’);[/sql]
That will basicly cast back the trigger on the quest giver, so it can start WP activated by event 8.

I just like the way this spell can be used until we get the proper event scripted.

[/CODE]

Aha i see, that could do it /emoticons/default_smile.png

I’ll test it later since i’m on my laptop at the moment (:

EDIT: Yes it does, thanks /emoticons/default_smile.png