WoW-Info — информационный World of Warcraft портал

Этот sql файл заливаем в базу.

INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('Ally Bouncer', '', '', '7', '0', '1', '18718', '0', '0', NULL, '50000');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('80', '80', '1054', '100000', '100000', '10000', '1', '0', '1500', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '36000', '0', '0', '0', '50000');
INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('Horde Bouncer', '', '', '7', '0', '1', '18718', '0', '0', NULL, '50001');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('80', '80', '1034', '100000', '100000', '10000', '1', '0', '1500', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '36000', '0', '0', '0', '50001');

Этот скрипт lua кидаем в папку scripts

function Bouncer_OnSpawn(unit, event)
Unit:CastSpell(18950)
end

function Bouncer_OnCombat(unit, event)
Unit:SendChatMessage(14,0,You are not allowed here. LEAVE NOW!!)
Unit:CastSpell(36812)
end

RegisterUnitEvent(50000,1,Bouncer_OnSpawn)
RegisterUnitEvent(50001,2,Bouncer_OnSpawn)
RegisterU nitEvent(50000,3,Bouncer_OnCombat)
RegisterUnitEvent(50001,4,Bouncer_OnCombat)

Скрипт на lua(гварды кастуют и защищают город от pvp)
Поместить в папку script.
Заменить это:
Guard = имя гвардов
Npc Id = ИД гвардов.

function guard_OnCombat(Unit, Event)
Unit:RegisterEvent(guard_Charge, 111, 1)
Unit:RegisterEvent(guard_MortalStrike, 30000, 0)
Unit:RegisterEvent(guard_Whirlwind, 40000, 0)
end

function guard_Charge(pUnit, Event)
pUnit:FullCastSpellOnTarget(22911, pUnit:GetMainTank())
end

function guard_MortalStrike(pUnit, Event)
pUnit:FullCastSpellOnTarget(16856, pUnit:GetMainTank())
end

function guard_Whirlwind(pUnit, Event)
pUnit:FullCastSpellOnTarget(15578, pUnit:GetMainTank())
end

function guard_OnLeaveCombat(Unit, Event)
Unit:RemoveEvents()
end

function guard_OnDied(Unit, Event)
Unit:RemoveEvents()
end

function guard_OnKilledTarget(Unit, Event)
Unit:SendChatMessage(11, 0, Stay out of This mall!)
end

RegisterUnitEvent(npc id, 1, guard_OnCombat)
RegisterUnitEvent(npc id, 2, guard_OnLeaveCombat)
RegisterUnitEvent(npc id, 3, guard_OnKilledTarget)
RegisterUnitEvent(npc id, 4, guard_OnDied)