Quest [12467] Chasing Icestorm: Thel'zan's Phylactery

TrinityCore Development TrinityCore Code Discussion
1

[CODE]
– Chasin Icestorm: Chasing Icestorm: Thel’Zan’s Phylactery
– “Wyrmbait” SAI
SET @ENTRY := 27843;
SET @QUEST := 12467;
SET @GOSSIP := 9603;
UPDATE creature_template SET gossip_menu_id = @GOSSIP, AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid IN (@ENTRY,@ENTRY100);
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
(@ENTRY,0,0,0,62,0,100,0,@GOSSIP,0,0,0,80,@ENTRY100,0,0,0,0,0,1,0,0,0,0,0,0,0,“Wyrmbait - On Gossip Select - Run Script”),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,12,26287,1,300000,0,0,0,8,0,0,0,4536.77,42.04,80.29,4.94,“Wyrmbait - On script - Summon Icestorm”);

–Add gossip text
DELETE FROM gossip_menu_option WHERE menu_id=@GOSSIP AND id=0;
INSERT INTO gossip_menu_option VALUES
(@GOSSIP, 0, 0, ‘Bring down the Icestorm!’, 1, 1, 0, 0, 0, 0, NULL);

– Add gossip_menu_option condition
DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=@GOSSIP;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionValue1) VALUES
(15,@GOSSIP,0,9,@QUEST);

– Add quest item to Icestorm
UPDATE creature_template SET lootid= 26287 WHERE entry=26287;
DELETE FROM creature_loot_template WHERE item = 37920;
INSERT INTO creature_loot_template VALUES (26287, 37920 -100,1,0,1,1);
[/sql][/CODE]

I’ve made this for this quest…but when i click on gossip nothing happens…creature ain’t summoned. What can be the probl if someone knows.? Thanks:)

2

It seems fine… do you get any console error when you run this script?

By the way, when you just want to use one action per event you don’t need the run script action, like this:

[CODE]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
(@ENTRY,0,0,0,62,0,100,0,@GOSSIP,0,0,0,12,26287,1,300000,0,0,0,8,0,0,0,4536.77,42.04,80.29,4.94,“Wyrmbait - On gossip select - Summon Icestorm”);
[/sql]

Are you sure the target_y coordinate is correct? 42 seems a low value

[/CODE]

3

This would be a huge hackery. Far from done according to this:

Also, you never removed the EventAI lines. /emoticons/default_smile.png

DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;

4

No console errors. Coordinate is taken from .gps command , i mean…i was in that position and i used .gps to see coords.

But when i press gossip menu, even gossip menu ain’t closing. Even i spam that menu, nothing happen…

@Discover: Thx; I’ll try this right now…let’s see if it works:)

L.E: Nope, still not working… /emoticons/default_sad.png Yes i know that would be a hackery, but i’m a begginer and…i want to learn…you know… /emoticons/default_biggrin.png

But that code, must activate that gossip…i’m still wondering why doesn’t do this…