COMPLETE [Quest/Azuremyst Isle] Inoculation [9303]

Tome · January 16, 2011, 12:07pm

Small workaround since DUMMY EFFECT EVENT isn’t handled in core again atm.

[CODE]-- quest fix inoculation (q9303)
SET @OWL := 16518; – Nestlewood Owlkin
SET @IOWL := 16534; – Inoculated Nestlewood Owlkin
UPDATE creature_template SET AIName= ‘SmartAI’, ScriptName=‘’ WHERE entry=@OWL;
DELETE FROM creature_ai_scripts WHERE creature_id=@OWL;
DELETE FROM smart_scripts WHERE source_type=0 ANDentryorguid=@OWL;
DELETE FROM smart_scripts WHERE source_type=9 ANDentryorguid=@OWL100;
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
(@OWL,0,0,0,8,0,100,0,29528,0,3000,3000,80,@OWL100,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘on spellhit run script’),
(@OWL100,9,0,0,0,0,100,0,3000,3000,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,‘face player’),
(@OWL100,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘say random text from groupid 0’),
(@OWL100,9,2,0,0,0,100,0,0,0,0,0,36,@IOWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘morph to entry’),
(@OWL100,9,3,0,0,0,100,0,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags’),
(@OWL100,9,4,0,0,0,100,0,300,300,0,0,33,@IOWL,0,0,0,0,0,7,0,0,0,0,0,0,0,‘give quest credit’),
(@OWL100,9,5,0,0,0,100,0,500,500,0,0,89,15,0,0,0,0,0,1,0,0,0,0,0,0,0,‘random movement’),
(@OWL100,9,6,0,0,0,100,0,9000,9000,0,0,36,@OWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change entry back’),
(@OWL100,9,7,0,0,0,100,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags back’),
(@OWL*100,9,8,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘despawn’);

– NPC talk text insert from sniff for quest inoculation (9303)
DELETE FROM creature_text WHERE entry=16518;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(16518,0,0, ‘The %s seems overjoyed.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,1, ‘The %s seems disoriented.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,2, ‘The %s doesn’‘t look like it minds the crystal’‘s effects.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,3, ‘The %s didn’‘t like what just happened.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,4, ‘The %s looks confused.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,5, ‘The %s nods appreciatively.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’);[/sql]

EDIT: small note, finish casting or you don’t get credit

[/CODE]

Leviathan · January 16, 2011, 8:42pm

After adding this into the DB (TDB 335.11.36+ / Core 11040) this pops up in the DB error log:

“Script named ‘npc_nestlewood_owlkin’ does not have a script name assigned in database.”

Paradox · January 16, 2011, 9:36pm

You’d have to remove the c++ script to get rid of that message, but, it won’t hurt to just ignore it.

katsumi · January 17, 2011, 4:58pm

i am not getting credit although i have casted the spell completely.

i get credit very rarely

any fixes?

daVirus · January 17, 2011, 11:38pm

it works only on the nestlewood owlkin, not on the enraged or whatever they are called

btw thx Tome for diggin that out, had it totally forgotten /emoticons/default_biggrin.png

katsumi · January 18, 2011, 12:17am

yes i did cast the spell on nestlewood owlkin.

u cant cast spell on others

unholy · January 18, 2011, 7:34am

topic has been relocated to development until fully working and tested.

LordPsyan · January 22, 2011, 11:50pm

first time I tried this it worked perfectly. I was able to complete the quest. then about a week later, without any updates or changes to DB or core, it stopped working and is back where it was.

Malcrom · February 14, 2011, 6:44pm

Try this:

[CODE]-- Quest 9303 “Inoculation”
SET @OWL := 16518; – Nestlewood Owlkin
SET @IOWL := 16534; – Inoculated Nestlewood Owlkin
UPDATE creature_template SET AIName= ‘SmartAI’, ScriptName=‘’ WHERE entry=@OWL;
DELETE FROM creature_ai_scripts WHERE creature_id=@OWL;
DELETE FROM smart_scripts WHERE source_type=0 ANDentryorguid=@OWL;
DELETE FROM smart_scripts WHERE source_type=9 ANDentryorguid=@OWL100;
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
(@OWL,0,0,0,8,0,100,0,29528,0,3000,3000,80,@OWL100,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘on spellhit run script’),
(@OWL100,9,0,0,0,0,100,0,3000,3000,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,‘face player’),
(@OWL100,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘say random text from groupid 0’),
(@OWL100,9,2,0,0,0,100,0,0,0,0,0,36,@IOWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘morph to entry’),
(@OWL100,9,3,0,0,0,100,0,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags’),
(@OWL100,9,4,0,0,0,100,0,300,300,0,0,33,@IOWL,0,0,0,0,0,7,0,0,0,0,0,0,0,‘give quest credit’),
(@OWL100,9,5,0,0,0,100,0,500,500,0,0,89,15,0,0,0,0,0,1,0,0,0,0,0,0,0,‘random movement’),
(@OWL100,9,6,0,0,0,100,0,9000,9000,0,0,36,@OWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change entry back’),
(@OWL100,9,7,0,0,0,100,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags back’),
(@OWL*100,9,8,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘despawn’);

– NPC talk text insert from sniff
DELETE FROM creature_text WHERE entry=16518;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(16518,0,0, ‘The %s seems overjoyed.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,1, ‘The %s seems disoriented.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,2, ‘The %s doesn’‘t look like it minds the crystal’‘s effects.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,3, ‘The %s didn’‘t like what just happened.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,4, ‘The %s looks confused.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,5, ‘The %s nods appreciatively.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’);

– Condition for Spell 29528
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry IN (29528);
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(13,0,29528,0,18,1,16518,0,0, ‘’, ‘Spell 29528 target Nestlewood Owlkin’);[/sql]
[/CODE]

unholy · February 14, 2011, 10:18pm

add this to SAI post #9 and then its working perfectly again.


-- spell does not target the innoculated owlkin and it is not spawned, so take spell requirement out of equation
UPDATE `quest_template` SET `ReqSpellCast1`=0 WHERE `entry`=9303;
[/sql]

dont need condition

2011-02-14 16:15:23 ERROR: SourceEntry 29528 in `condition` table does not have any implicit target TARGET_UNIT_NEARBY_ENTRY(38) or TARGET_DST_NEARBY_ENTRY (46),TARGET_UNIT_AREA_ENTRY_SRC(7), TARGET_UNIT_AREA_ENTRY_DST(8), TARGET_UNIT_CONE_ENTRY(60), TARGET_GAMEOBJECT_NEARBY_ENTRY(40)TARGET_GAMEOBJECT_AREA_SRC(51), TARGET_GAMEOBJECT_AREA_DST(52)

Malcrom · February 15, 2011, 2:40am

add this to SAI post #9 and then its working perfectly again.


-- spell does not target the innoculated owlkin and it is not spawned, so take spell requirement out of equation
UPDATE `quest_template` SET `ReqSpellCast1`=0 WHERE `entry`=9303;
[/sql]

dont need condition

2011-02-14 16:15:23 ERROR: SourceEntry 29528 in `condition` table does not have any implicit target TARGET_UNIT_NEARBY_ENTRY(38) or TARGET_DST_NEARBY_ENTRY (46),TARGET_UNIT_AREA_ENTRY_SRC(7), TARGET_UNIT_AREA_ENTRY_DST(8), TARGET_UNIT_CONE_ENTRY(60), TARGET_GAMEOBJECT_NEARBY_ENTRY(40)TARGET_GAMEOBJECT_AREA_SRC(51), TARGET_GAMEOBJECT_AREA_DST(52)

Edit WDB data?

Svannon · February 15, 2011, 4:35am

Last Time i checked that was not WDB data. I think we need to repost the list of WDB fields.

unholy · February 15, 2011, 5:42am

sure as hell is not or i wouldnt offered it… now you know that. http://www.trinitycore.org/f/public/style_emoticons/default/angry.gif

unholy · February 15, 2011, 5:49am

stop and think also… even if it was wdb… how can a spell that is hard coded to target a given npc work when the npc is not spawned and yet that npc is the kill credit… so some idiot puts in a spellcast requirement and then quests dont work because you cant cast the spell on a non existing npc… sounds like to me and i proved it before… the old udb shit needs to seriously be gotten rid of and sniffs need to be deciphered correctly… ppl dont get youre tempers up… my example is… in venomspite… there are 2 of Lovely Lidia and 2 Molders… why? because someones sniff caught them on path but wasnt correctly figured out to be a path but as 2 spawns of the npcs.

so change the spellcast to where it is suppose to be and the quest events are perfect.

Nay · February 15, 2011, 9:11am

RewSpellCast is indeed WDB data. http://www.madx.dk/wowdev/wiki/index.php?title=QuestCache.wdb (also found in 4.x wdbs).

BUT in 4.0.3 RewSpellCast = 0 for the quest 9303 (and I’m pretty sure it did not change since 3.5.5).

The most probably thing that happened is that it was (wrongly) changed in the past.

unholy · February 15, 2011, 2:00pm

but we are not talking about rewardspellcasting here… we are talking about requiredspellcast… Brian tried that trick on me way back in the day and didnt succeed. TrinityCore

Malcrom · February 15, 2011, 2:04pm

so:

[CODE]-- Quest 9303 “Inoculation”
SET @OWL := 16518; – Nestlewood Owlkin
SET @IOWL := 16534; – Inoculated Nestlewood Owlkin
UPDATE creature_template SET AIName= ‘SmartAI’, ScriptName=‘’ WHERE entry=@OWL;
DELETE FROM creature_ai_scripts WHERE creature_id=@OWL;
DELETE FROM smart_scripts WHERE source_type=0 ANDentryorguid=@OWL;
DELETE FROM smart_scripts WHERE source_type=9 ANDentryorguid=@OWL100;
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
(@OWL,0,0,0,8,0,100,0,29528,0,3000,3000,80,@OWL100,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘on spellhit run script’),
(@OWL100,9,0,0,0,0,100,0,3000,3000,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,‘face player’),
(@OWL100,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘say random text from groupid 0’),
(@OWL100,9,2,0,0,0,100,0,0,0,0,0,36,@IOWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘morph to entry’),
(@OWL100,9,3,0,0,0,100,0,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags’),
(@OWL100,9,4,0,0,0,100,0,300,300,0,0,33,@IOWL,0,0,0,0,0,7,0,0,0,0,0,0,0,‘give quest credit’),
(@OWL100,9,5,0,0,0,100,0,500,500,0,0,89,15,0,0,0,0,0,1,0,0,0,0,0,0,0,‘random movement’),
(@OWL100,9,6,0,0,0,100,0,9000,9000,0,0,36,@OWL,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change entry back’),
(@OWL100,9,7,0,0,0,100,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,‘change unitflags back’),
(@OWL*100,9,8,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘despawn’);

– NPC talk text insert from sniff
DELETE FROM creature_text WHERE entry=16518;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(16518,0,0, ‘The %s seems overjoyed.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,1, ‘The %s seems disoriented.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,2, ‘The %s doesn’‘t look like it minds the crystal’‘s effects.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,3, ‘The %s didn’‘t like what just happened.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,4, ‘The %s looks confused.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’),
(16518,0,5, ‘The %s nods appreciatively.’,2,0,100,0,0,0, ‘Inoculated Nestlewood Owlkin’);

– spell does not target the innoculated owlkin and it is not spawned, so take spell requirement out of equation
UPDATE quest_template SET ReqSpellCast1=0 WHERE entry=9303;[/sql]
[/CODE]

Nay · February 15, 2011, 2:05pm

Ups. self slap

And no, ReqSpellCastX is not WDB (Why do we need to “make-up” that data, anyway? The other Req fields aren’t enough?)

unholy · February 15, 2011, 2:21pm

i suspect back in early days of developing the sniffs and trying to translate them, the info was designated as a certain field only to find out later, we do not need it… so you are correct, but, if the info is, (was) sent by blizz, its there for a reason, just need to put it in the correct place instead of guessing… but its all in learning…

Brian · February 15, 2011, 5:32pm

The ReqSpellCastX fields are legacy from the original questing system before advanced AI was added.

You have ReqCreatureOrGoIdX and ReqSpellCastX – you must cast spell on creature or GO instead of killing it (this was back in the EARLY days of the quest system and ReqSpellCastX WAS sent by blizz. When they moved to more advanced quests where the NPCs were scripted, they stopped sending that field).

To sum up – we could pull ReqSpellCast and script the 143 quests that are in the DB that use it. I am sure that most of those 143 quests are hacks and not even remotely blizz like.

– Brian