Help with guards

[swiftserver]

My server has a mall in neutral area so horde and alli are there. I tried upping the level of a booty bay guard and spawning him at mall but didn't work. Any Ideas? plz help.

[Tsai]

Ideas: Why dont you make it a sanctuary?
uhm, the bad part about this idea... Is that I don't know how, if I find out I'll edit this and tell you

[swiftserver]

Ya i tried to make it that but co8uldnt find it out.

[777devil777]

Sanctuary is complex DB editing, if you really want good guards dont modify level, modify their attack speed, run speed, and damage.

[havak]

but how do u get them to attack they only stand there =x

[Illidan1]

You will need to make a new Npc it is allot Easer i will do it for you in a Sql Query

They will Attack when a Alliance goes to a Horde one and when a horde goes to a Alliance one

Alliance Guard \/

INSERT INTO `creature_names` (`entry`,`creature_name`,`Subname`,`type`,`Family`,`Rank`,`unk4`,`displayid`,`unk2`,`unk3`,`unknown_float1`,`unknown_float2`,`Civilian`,`Leader`) VALUES ('505050','Stronge One','Mall Guard','7','0','0','0','3167','0','0','1','1','0','1')
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`mindamage`,`maxdamage`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`mountdisplayid`,`item1slotdisplay`,`item1info1`,`item1info2`,`item2slotdisplay`,`item2info1`,`item2info2`,`item3slotdisplay`,`item3info1`,`item3info2`,`respawntime`,`resistance0_armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`) VALUES ('505050','200','200','11','9999','9999','9999','1','1','10','9999','9999','0','0','0','0','0','0','0','0','0','0','0','0','0','15000','0','0','0','0','0','0','0','0','0','1','0','0','0','50','80','90','0')

.npc spawn 505050 For Alliance Guard

Horde Guard \/

INSERT INTO `creature_names` (`entry`,`creature_name`,`Subname`,`Flags1`,`type`,`Family`,`Rank`,`unk4`,`SpellDataID`,`displayid`,`unk2`,`unk3`,`unknown_float1`,`unknown_float2`,`Civilian`,`Leader`) VALUES ('606060','Grunter','Mall Guard','0','7','0','0','0','0','4259','0','0','0','0','0','1')
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`mindamage`,`maxdamage`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`mountdisplayid`,`item1slotdisplay`,`item1info1`,`item1info2`,`item2slotdisplay`,`item2info1`,`item2info2`,`item3slotdisplay`,`item3info1`,`item3info2`,`respawntime`,`resistance0_armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`) VALUES ('606060','200','200','85','9999','9999','9999','1','1','10','9999','9999','0','0','0','0','0','0','0','0','0','0','0','0','0','15000','0','0','0','0','0','0','0','0','0','1','0','0','0','50','80','90','0')

.npc spawn 606060 for Horde Guard

Good luck have fun

[swiftserver]

Thxs a lot for your help but is there any way to make a neutral one or do I have to move mall and everything?

[Illidan1]

yes, use one of my Npc i made and target him and press
.npc faction 475
that Faction will attack and kill any one that is PvPing or killing the vendors

[swiftserver]

You have a link to where I can upgrade my SQL .....my SQL cant take your data. Thxs sio much for the help !!!!!
You think we could talk to me in ventrilo or something?

[Illidan1]

Na dude i dont know were you could Update your Database you
could go to Ac-Web And download Repack 7.1
it has everything you need trust me Mangoes is really old

[swiftserver]

I have antrix ...but there is like a new rev out or something ...im 1 update behind.

[Illidan1]

New Rev :
Rev 1994
Download Link > Revsion 1994

Search for Rev 2035 i can't search because of Lazy
Leecher Bug