Lightningcaller Soo-met

Is Currently not Spawned – have info from sniff + aura.

Question is, is this the best way of making him visible only for those who have the required rep or is there a betterway or core change that would make this easier to accomplish?

Note: This does work but to see the difference you need to leave the area and come back to see him appear/disappear

[SPOILER]-- From Sniff
SET @GUID=xxxxxx;
DELETE FROM creature WHERE id=28107;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(@GUID+0,28107,571,1,1,0,0,5116.647,5469.729,-91.70967,1.605703,300,0,0,117700,3809,0,0,0,0);

– Template updates for creature 28107 (Lightningcaller Soo-met)
– Model data 22607 (creature 28107 (Lightningcaller Soo-met))
UPDATE creature_model_info SET bounding_radius=1,combat_reach=1,gender=0 WHERE modelid=22607; – Lightningcaller Soo-met
– Addon data for creature 28107 (Lightningcaller Soo-met)
DELETE FROM creature_template_addon WHERE entry=28107;
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(28107,0,65536,1,0,‘52215’); – Lightningcaller Soo-met

DELETE FROM spell_area WHERE spell=52217;
INSERT INTO spell_area(spell,area,quest_start,quest_start_active,quest_end,aura_spell,racemask,gender,autocast) VALUES
(52217,4288,0,0,0,0,0,2,1);

DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry =52217;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(17,0,52217,0,5,1105,5,0,0,0,‘Only allow Kartak and Sparktouched: See Invisibility if Friendly with Oracles’),
(17,0,52217,1,5,1105,6,0,0,0,‘Only allow Kartak and Sparktouched: See Invisibility if Revered with Oracles’),
(17,0,52217,2,5,1105,7,0,0,0,‘Only allow Kartak and Sparktouched: See Invisibility if Exaulted with Oracles’);

-- Spawn Lightningcaller Soo-met

[/SPOILER]

I would do that in a similar way.

The bug with the spell_area/condition not being updated in the client is a core issue; same thing happens with the mounts in Argent Tournament (outside)

What’s wrong exactly?

Eh, the bug at AT mounts that I was talking about isn’t quite the same, sorry about that.

Now about the spell_area: if that spell_area has a, let’s say, quest_start requirement, you have to leave and re-enter the area so the spell is cast.

I guess the conditions are checked at player area enter…

The AT mounts bug I was talking about is related to npc_spellclick_spells and conditions. If you are next to a spellclick creature and you complete, e.g, a quest that meets that spellclick requirement you have to get far way from the npc and get back to it so you can “spellclick” it (I guess the core only then sends the CreateObject packet with the updated npcflag).

Now I deserve that to tracker canned message for reporting bugs in a forum post and not in the tracker /emoticons/default_wink.png

I hope that I am clear enough…