[Completed][12060/12061] Projection and Plans

hi, need some good advices für this quest(s) http://www.wowhead.com/quest=12061 / http://www.wowhead.com/quest=12060.

the existing EventAI does not work.

i created a smart_script with the same commands, but i´ve got the feeling SMART_EVENT_OOC_LOS doesn´t really work.

useful links:

Surge Needle Teleporter http://www.wowhead.com/item=36747 - spellcast http://www.wowhead.com/spell=47097

Projections and Plans Kill Credit Bunny http://www.wowhead.com/npc=27853

Projections and Plans: Kill Credit http://www.wowhead.com/spell=49731

thank you in anticipation!

Paste code.


UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 27853;

-- SAI

DELETE FROM `smart_scripts` WHERE `entryorguid` = 27853;

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 

(27853, 0, 0, 0, 10, 0, 100, 0, 1, 50, 1, 1, 11, 49731, 0x02, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On OOC LOS give Kill Credit');

i don´t think so that another SAI can solve this. maybe you can help.

the quest progress:

( there is a missing display (model) http://www.wowwiki.com/Arcanomicon - not pertinent to the quest i think)

  • on LOS of 30 yards range get kill credit ( doesn´t work )

i found a picture where you can see the area http://s291.photobucket.com/albums/ll308/d_mcallister/?action=view&current=ProjectionsandPlansKillCreditBunny.jpg&newest=1

Awesome, I’ll hopefully fix it tonight.

ok i solved the problem.

bunny was flaged passive and invisible(flags_extra = 128)for LOS Event i think.

fix:

https://github.com/darkman1983/TrinityCore/blob/master/sql/updates/world/2011_04_23_lol_0_world_quest_12060_12061.sql

[CODE]-- ----------------------------------------------

– Fix Quest ‘Projection and Plans’ #12060 #12061


– Projections and Plans Kill Bunny

UPDATE creature_template SET AIName = ‘SmartAI’, unit_flags = 2, flags_extra = 0 WHERE entry = 27853;

– SAI

DELETE FROM smart_scripts WHERE source_type = 0 AND entryorguid = 27853;

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

(27853,0,0,0,10,0,100,0,1,30,1000,1000,11,49731,2,0,0,0,0,7,0,0,0,0,0,0,0,‘on LOS - give quest credit’);[/CODE]

Credit spell seems to be casted weather a player is near or not

My solution would look like this (added visual for Surge Needle Beam found in sniffs)

SET @ENTRY := 27853;
SET @GUID := 115101;

-- Remove old EAI and replace with proper SAI
DELETE FROM `creature_ai_scripts` WHERE `id`=2785301;
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY;

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,-109577,-109576,-109573);
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,1,0,100,0,3000,3000,3000,3000,11,49731,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Projections and Plans Kill Credit Bunny - OOC - Cast Projections and Plans: Kill Credit on self'),
(-109577,0,0,0,1,0,100,1,1000,1000,30000,30000,11,46906,2,0,0,0,0,10,@GUID,@ENTRY,0,0,0,0,0, 'Surge Needle Sorcerer - OOC - Cast Surge Needle Beam'),
(-109577,0,1,0,0,0,100,0,3000,4000,3000,5000,11,51797,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Surge Needle Sorcerer - Combat - Cast Arcane Blast on victim'),
(-109576,0,0,0,1,0,100,1,1000,1000,30000,30000,11,46906,2,0,0,0,0,10,@GUID,@ENTRY,0,0,0,0,0, 'Surge Needle Sorcerer - OOC - Cast Surge Needle Beam'),
(-109576,0,1,0,0,0,100,0,3000,4000,3000,5000,11,51797,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Surge Needle Sorcerer - Combat - Cast Arcane Blast on victim'),
(-109573,0,0,0,1,0,100,1,1000,1000,30000,30000,11,46906,2,0,0,0,0,10,@GUID,@ENTRY,0,0,0,0,0, 'Surge Needle Sorcerer - OOC - Cast Surge Needle Beam'),
(-109573,0,1,0,0,0,100,0,3000,4000,3000,5000,11,51797,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Surge Needle Sorcerer - Combat - Cast Arcane Blast on victim');
[/SQL]

ok, nice this works better than mine!

thank you very much