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]