--Banshee's Revenge (he is not spawning if players click object) so i spawn it in his location)


INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(374568, 31016, 571, 0, 0, 1, 1, 0, 1, 7071.21, 4309.75, 870.943, 1.36179, 300, 0, 0, 252000, 3994, 0, 0, 0, 0, 0);




-- The ocular  (THIS npc fall from sky so i add him FLY aura)

INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES ('29747', '0', '0', '0', '0', '0', '34873');




--- THIS is companion he sell food / poisons /regards    SO add ONLY  2 custom things MANA food + option to repair gear  is more PRO  :D


UPDATE  `creature_template` SET  `npcflag` =  '4226' WHERE  `creature_template`.`entry` =33238;



INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES
(33238, 21, 33445, 0, 0, 0, 0);