Gnomes does not despawn when on quest

While I do not support anything above MangosOne, I would like to ask still. Haven't you tried to cast the spell (i.e. to use the item) on another mob except the quest target? I do not have Cata Spell.dbc at hand to check, but I'm pretty sure such cast is enabled. If so, you can get QC on any mob, and since it will not despawn, as many QCs as you want.

Modifying quest_template should be avoided as much as possible (see WDB field concept on the TC wiki). The correct way is giving the quest credit by the quest target mob before despawned; it is just a single extra line in creature_ai_scripts.

the quest at this point does cast the spell but it does not count it thus this part

UPDATE `quest_template` SET `ReqSpellCast1` = 86264 WHERE `entry` = 27671;

secondly when you do cast the right spell the creature aka gnome just stands there this is not according to official the creature despawns thus this part

-- Creature id: 46268
UPDATE creature_template SET AIName='EventAI' WHERE entry=46268;
DELETE FROM creature_ai_scripts WHERE creature_id=46268;
INSERT INTO creature_ai_scripts VALUES 
('300000000','46268','8','0','100','0','86264','-1','0','0','41','1000','0','0','0','0','0','0','0','0','0','0','gnome despawn on hit');

to answer your question no this is the correct creature 

wowhead:

http://www.wowhead.com/npc=46268/survivor

I understood both the issue and your solution. In order to have your understanding of my questions, I repeat it:

after your fix applied, have you tried to use the item on any creature/NPC except the quest target dwarf-"survivor"? are you given quest credit for such use, if you have the quest incomplete?

oh i have used it on other creathures and it does not work on them only on the gnomes

ok so i loged into original  and i saw that you cant cast this on any other creature. however on core ya can how do s stop it from being able to cast on any other creture

Casting on other creatures was the only pitfall of the present solution I can think of. If it is disabled somewhere (a try to use the item gives an error message), then the proposed fix is ok.

WONT THAT JUST BE THE SPELL ITSELF THEN ILL LOOK ON THE SPELL TEMPLATE

I proposed the solution I consider as the correct one in my first post in the topic. Do not touch quest_template except learning what a QC type is required for the quest under discussion. If the QC is described there correctly, add to your EventAI command one more command, ACTION_T_KILLED_MONSTER or ACTION_T_CASTCREATUREGO, depending on the required QC type.

The fix for this can be found below.

MangosTHREE: REL21_14_21