NPC Instantly lootable?

[X-Savior]

Yes, this works perfect and has been fully tested.

Here is the flag required to use this feature:

UPDATE `creature_template` SET npcflag = 16777216 WHERE `entry` = XYZ

[yad02]

I use : 16777216

and it works... maybe it is not the blizzlike flag

[Stormedge]

Yeah, it works perfect! Big THX @ arrai and X-Savior

This is a big Step closer to a Blizzlike DB/Core *smile*

[VladimirMangos]

}

+void ObjectMgr::LoadNPCSpellClickSpells()

empty line need

UpdateForQuestsGO();

+ UpdateForQuestsNPC();

Maybe merge to UpdateForQuestWorldObjects()

Loop in both by same guid list.

I think http://www.youtube.com/ reference not required in to sources, Just clear note that example spell id aura confirmed as applied to vehicle fine.

In any case i think patch now look more ready

[subhuman_bob]

UPDATE `creature_template` SET npcflag = 16777216 WHERE `entry` = XYZ

UPDATE `creature_template` SET `npcflag` = `npcflag`|'16777216' WHERE `entry` = 'XYZ';

Much safer version.

[merlinus]

Seems like this patch is in mangos 7776. Good.

And now, mangos show this messages:

2009-05-07 10:44:36 Loading UNIT_NPC_FLAG_SPELLCLICK Data...
2009-05-07 10:44:36 
2009-05-07 10:44:36 ERROR:>> Loaded 0 spellclick spells. DB table `npc_spellclick_spells` is empty.

Maybe I need to put this to my database:

-

  INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
(28389, 51592, 12605, 1),
(28389, 51593, 12605, 3),
(27629, 49256, 0, 1);

But what about this:

UPDATE `creature_template` SET `npcflag` = `npcflag`|'16777216' WHERE `entry` = 'XYZ';

Please explain all this for the newbies.

[Stormedge]

Seems like this patch is in mangos 7776. Good.

And now, mangos show this messages:

2009-05-07 10:44:36 Loading UNIT_NPC_FLAG_SPELLCLICK Data...
2009-05-07 10:44:36 
2009-05-07 10:44:36 ERROR:>> Loaded 0 spellclick spells. DB table `npc_spellclick_spells` is empty.

Maybe I need to put this to my database:

-

  INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
(28389, 51592, 12605, 1),
(28389, 51593, 12605, 3),
(27629, 49256, 0, 1);

But what about this:

UPDATE `creature_template` SET `npcflag` = `npcflag`|'16777216' WHERE `entry` = 'XYZ';

Please explain all this for the newbies.

This npcflag allow you to "Spellclick" the NPC. If the Creature you want to "spellclick" don't have this Flag (16777216), then it doesn't work ;D

[LordPsyan]

Just a quick curiosity question.

cast_flags?

what is that, and how do I figure out the number to place there?

another question that I know isnt easy to answer, and I really don't expect this one answered, but how do I figure out which spell number to use. example, DK quest "Grand theft palomino" trying to figure out what spell to mount the horse. currently I am guessing at names on wowhead, and I come up with "mount mustang" which isnt the right spell.

[Stormedge]

cast_flags is a Type of Target Type^^ 0 = The Creature 1 = the Player

And your Problem..

this Mounting System don't work yet because it's not scriptet^^ If you steal the Horse from the Quest you become New Skills.. More Life etc .. and this must be coded :<

[erazare]

ok so wait.. this looks interesting... i was directed to this thread bc someone said the answer to the Gryphons might lie in spellclick as well, is that creditable?

[NoFantasy]

someone said the answer to the Gryphons might lie in spellclick as well, is that creditable?

If you talk about certain creatures that act similar to normal taxi master, then yes. Npcflag like the one mentioned and also check IconName in creature_template, this determine what icon appear when hovering mouse over creature.

[Grandres]

Is it possible to change faction/flag of creature after spellclick spells? For example quest http://www.wowhead.com/?quest=12629 after spellclik spell npc http://www.wowhead.com/?npc=29856 should attack us. I was trying with EventAI, but I didn't find out solution.

[Shadowhack]

there is also this quest that requires you to use an item on an NPC and then loot him while he is stuned.

http://www.wowhead.com/?quest=13654