Quest's [Eyes of the Eagle] 11416/11417 Ally/Horde

Hi @ All!

I look for the quests

http://old.wowhead.com/quest=11416

http://old.wowhead.com/quest=11417

The content is the same.

I found this issue https://github.com/TrinityCore/TrinityCore/issues/2077

Now im ready to fix his but im not ready really.

Im missing the right gameobject guids.

Also i dont know wthats the right way to make this at a fix.

Can anybody help me?

Thx before

Don’t worry about the guids (use some higher values; proper values will be used when you submit your fix to us)

Thx Nay!

I send this fix and i testet ist on our actually core.

Please let me know what is to do or what is wrong (style and other things).


SET @OGUID := XXXXXX

DELETE FROM gameobject

WHERE id IN (190284, 190283, 186814, 186813);

INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES

(@OGUID, 190284, 571, 1, 1, 1595.69, -3905.33, 79.7439, 0.610864, 0, 0, 0, 0, 5, 0, 1),

(@OGUID+1, 190283, 571, 1, 1, 1597.4, -3903.79, 79.702, 0, 0, 0, 0, 0, 60, 100, 1),

(@OGUID+2, 186814, 571, 1, 1, 1597.4, -3903.79, 79.702, 0, 0, 0, 0, 0, 60, 100, 1),

(@OGUID+3, 186813, 571, 1, 1, 1596.3, -3904.79, 79.5351, -2.67035, 0, 0, 0, 0, 5, 0, 1);


-- Talonshrike's Egg

SET @entry := 186814;

SET @SOURCETYPE := 1;

DELETE FROM smart_scripts WHERE entryorguid=@entry AND source_type=@SOURCETYPE;

UPDATE gameobject_template SET AIName="SmartGameObjectAI" WHERE entry=@entry LIMIT 1;

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,@SOURCETYPE,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,"ON egg USE notify Talonshrike");


-- Talonshrike's Egg

SET @entry := 190283;

SET @SOURCETYPE := 1;

DELETE FROM smart_scripts WHERE entryorguid=@entry AND source_type=@SOURCETYPE;

UPDATE gameobject_template SET AIName="SmartGameObjectAI" WHERE entry=@entry LIMIT 1;

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,@SOURCETYPE,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,"ON egg USE notify Talonshrike");


-- Talonshrike

SET @entry := 24518;

SET @SOURCETYPE := 0;

DELETE FROM smart_scripts WHERE entryorguid=@entry AND source_type=@SOURCETYPE;

UPDATE creature_template SET AIName="SmartAI" WHERE entry=@entry LIMIT 1;

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,@SOURCETYPE,0,0,38,0,100,0,0,1,0,0,69,0,0,0,0,0,0,8,0,0,0,1597.4,-3903.79,79.702,0.0,"ON notification fly TO nest"),

(@entry,@SOURCETYPE,1,0,0,0,100,0,5000,5000,10000,12000,11,49865,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0," USE Eye Peck"),

(@entry,@SOURCETYPE,2,0,0,0,100,0,3000,3000,5000,7000,11,32909,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0," USE Talon Strike");

code-stile:

[CODE]
SET @OGUID := XXXXXX; – Set by TDB team
DELETE FROM gameobject WHERE id IN (190284,190283,186814,186813);
INSERT INTO gameobject (guid,id,map,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
(@OGUID+0,190284,571,1,1,1595.69,-3905.33,79.7439,0.610864,0,0,0,0,5,0,1),
(@OGUID+1,190283,571,1,1,1597.40,-3903.79,79.7020,0,0,0,0,0,60,100,1),
(@OGUID+2,186814,571,1,1,1597.40,-3903.79,79.7020,0,0,0,0,0,60,100,1),
(@OGUID+3,186813,571,1,1,1596.30,-3904.79,79.5351,-2.67035,0,0,0,0,5,0,1);

– Talonshrike’s Egg
SET @ENTRY := 186814;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=1;
UPDATE gameobject_template SET AIName=“SmartGameObjectAI” WHERE entry=@ENTRY LIMIT 1;
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,1,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,“ON egg USE notify Talonshrike”);

– Talonshrike’s Egg
SET @ENTRY := 190283;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=1;
UPDATE gameobject_template SET AIName=“SmartGameObjectAI” WHERE entry=@ENTRY LIMIT 1;
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,1,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,“ON egg USE notify Talonshrike”);

– Talonshrike
SET @ENTRY := 24518;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
UPDATE creature_template SET AIName=“SmartAI” WHERE entry=@ENTRY LIMIT 1;
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,38,0,100,0,0,1,0,0,69,0,0,0,0,0,0,8,0,0,0,1597.4,-3903.79,79.702,0.0,“ON notification fly TO nest”),
(@ENTRY,0,1,0,0,0,100,0,5000,5000,10000,12000,11,49865,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,“USE Eye Peck”),
(@ENTRY,0,2,0,0,0,100,0,3000,3000,5000,7000,11,32909,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,“USE Talon Strike”);

[/SQL][/CODE]

P.S. The forum supports [sql] tags.

Ok /emoticons/default_smile.png nelegalno!

I tried next one with SQL Tags

.

Thanks

[CODE]
SET @OGUID := XXXXXX; – Set by TDB team
DELETE FROM gameobject WHERE id IN (190284,190283,186814,186813);
INSERT INTO gameobject (guid,id,map,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
(@OGUID+0,190284,571,1,1,1595.69,-3905.33,79.7439,0.610864,0,0,0,0,5,0,1),
(@OGUID+1,190283,571,1,1,1597.40,-3903.79,79.7020,0,0,0,0,0,60,100,1),
(@OGUID+2,186814,571,1,1,1597.40,-3903.79,79.7020,0,0,0,0,0,60,100,1),
(@OGUID+3,186813,571,1,1,1596.30,-3904.79,79.5351,-2.67035,0,0,0,0,5,0,1);

– Talonshrike’s Egg
SET @ENTRY := 186814;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=1;
UPDATE gameobject_template SET AIName=“SmartGameObjectAI” WHERE entry=@ENTRY LIMIT 1;
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,1,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,“Talonshrike’s Egg - On Go State Changed - Set data on Talonshrike”);

– Talonshrike’s Egg
SET @ENTRY := 190283;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=1;
UPDATE gameobject_template SET AIName=“SmartGameObjectAI” WHERE entry=@ENTRY LIMIT 1;
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,1,0,0,70,0,100,0,2,0,0,0,45,0,1,0,0,0,0,11,24518,500,0,0.0,0.0,0.0,0.0,“Talonshrike’s Egg - On Go State Changed - Set data on Talonshrike”);

– Talonshrike
SET @ENTRY := 24518;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
UPDATE creature_template SET AIName=“SmartAI” WHERE entry=@ENTRY LIMIT 1;
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,38,0,100,0,0,1,0,0,69,0,0,0,0,0,0,8,0,0,0,1597.4,-3903.79,79.702,0.0,“Talonshrike - On Data Set - Move to nest”),
(@ENTRY,0,1,0,0,0,100,0,5000,5000,10000,12000,11,49865,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,“Talonshrike - Timed - Cast Eye Peck”),
(@ENTRY,0,2,0,0,0,100,0,3000,3000,5000,7000,11,32909,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,“TalonShrike - Timed - Talon Strike”);

[/SQL][/CODE]

Fixed SAI comments.

Thx!