[Release] Mall Guard - Included LUA and SQL

[Syrup]

[Release: Mall Guard]

This Guard is only for if you dont want to have any pvp around. Of course you can mod it the way you want.

This Guard is an overpower NPC.. Arround level 120.. Which does that he can easliy detect other enemies around the area.

IMPORTANT NOTICE: No media files are hosted on these forums. By clicking the link below you agree to view content from an external website. We can not be held responsible for the suitability or legality of this material.

Video Link: YouTube - Mall Guard (http://www.youtube.com/watch?v=DO-h0EIqMAU)


By the way, This video is a little laggy but good enough to show you guys what the guard does.


Info about this NPC:

*Level : 120
*Health : 100000
*Damage with Meele: 100000-200000
*AttackTime: 1800 (1.8 secs)
*Weapons : Both Illidan swords
*Other Attacks : 1 Charge when enter Area. Arcane Explosion 10 time thats makes you fly.. And die.
*Entry : 600001

How to set this up:

1. Open up your TRUNK
2. There should be an folder called "scripts" if not creat one.
3. Take the lua file from the RAR and put it into "scripts"
4. Open up your Navicat/SQLYog or what you use
5. Extract the SQL File into your world DB

The faction is "2" at the moment which is Horde.
If you want him to be an ally guard simple :

1. Mark him
2. Write .MOD FACTION 1

If you want him to walk arround :

1. Stand at the spot you want him to go to
2. Write .WAYPOINT ADD

It will add an waypoint there..
NOTE! If you want him to go anywere else repeat what i just wrote.
That will make him go around and "patrol".

DOWNLOAD: Filebeam - Free Fast File Hosting (http://filebeam.com/1d9aa1a386f5899005de25300b809e74)

Credits: FinnZor

[Gnome]

Does it do so if you PvP It Kills them?

Like Gadgetzan Guards etc.

[Syrup]

Does it do so if you PvP It Kills them?

Like Gadgetzan Guards etc.

No, that's why there, uber guards.

[Neddy]

Leeeeeeeeeeeeeeeerooooooooooooooooy jeeeeennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnkins Says bump

[Syrup]

Bump.

[mrx3666]

Lol Syrup is Leeroy Jenkins. I'll try this out after I rerereformat my computer >< stupid virus scan taking for EVER to find this spyware

[Syrup]

Lol Syrup is Leeroy Jenkins. I'll try this out after I rerereformat my computer >< stupid virus scan taking for EVER to find this spyware

Thank you, I love Leeroy, his a beast!

[icecoldkilla187]

Nice i need this trying to make something cool with guards and other stuff Thanks!!!

[Zenro45]

awesome this would do great in my new City i made :)

[Syrup]

awesome this would do great in my new City i made :)

Hope it does well. :)

[cheer]

nice +rep

[QQrofl]

Nice!!! < Bump >

[xerex]

Nice work! +rep is it possible to use him in an nevtral area? i have 1 mall for horde and alli together and is it possible to make that he kills ppl only when they pvp?

[Syrup]

Bump.

[Myerz]

Bump + Rep great LUA!

[Syrup]

Bump.

[kadava]

Hiya mate! i love your guard! i used it on my last database, but i just updated my db last night and my core to 'ArcEmu r965 & WhyDb r219' ive tried everything, but its not working now.

Its saying this error when i add it.

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('600001', '120', '120', '1', '100000', '100000', '100000', '1', '0', '1800', '0', '100000', '200000', '0', '0', '0', '0', '45479', '50267138', '768', '45479', '50267138', '768', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully

Edit: its not my core, db, compile, etc.. as its all up to date! i just think your guard wont work for the latest core etc... can you update it and send me? thanks mate.

Oh and Rep+ for the cool guard in the first place.

[Copestetic]

Hiya mate! i love your guard! i used it on my last database, but i just updated my db last night and my core to 'ArcEmu r965 & WhyDb r219' ive tried everything, but its not working now.

Its saying this error when i add it.



Edit: its not my core, db, compile, etc.. as its all up to date! i just think your guard wont work for the latest core etc... can you update it and send me? thanks mate.

Oh and Rep+ for the cool guard in the first place.

Its too easy, I received the same error when trying to execute the .sql but you can do it manually. Just open Navicat or Hiedisql, open your world, then creature_proto and insert new row. then just manually insert the values 1 by one, save, restart server. works like a charm. Also dont forget to make sure that his faction is set to 2, and not 1 or you will be raped when you spawn him! Here is the query in case you dont have it:

INSERT INTO `creature_proto` VALUES ('600001', '120', '120', '1', '100000', '100000', '100000', '1', '0', '1800', '0', '100000', '200000', '0', '0', '0', '0', '45479', '50267138', '768', '45479', '50267138', '768', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0');

[faddix]

Hiya mate! i love your guard! i used it on my last database, but i just updated my db last night and my core to 'ArcEmu r965 & WhyDb r219' ive tried everything, but its not working now.
Its saying this error when i add it.

Edit: its not my core, db, compile, etc.. as its all up to date! i just think your guard wont work for the latest core etc... can you update it and send me? thanks mate.

Oh and Rep+ for the cool guard in the first place.


try this one:

INSERT INTO `creature_proto` VALUES ('600001', '120', '120', '1', '100000', '100000', '100000', '1', '0', '1800', '0', '100000', '200000', '0', '0', '0', '0', '45479', '50267138', '768', '45479', '50267138', '768', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

-------------------------------------------------------------------------

[kadava]

Thanx it worked! to both of you that is, lol.

Any chance also for this guard to work on gm island! BUT... not kill GM's! only to kill unwanted people who come to there, as some of my players have VIP which they can use antrix teleporter!

So when they come to GM island, they can use the gm vendors no problem! i dont want them to use it! lol

Thanx.

[nickp2011]

bumpage.. and u rock syrup

[Cybernaut]

free bump.

i'm a little confused by this guard. i would assume the idea is that the guard only attacks if a player attacks/kills another? but from the video it seems as if he just attacks if you're within his agro range, regardless. (if it's a horde or alliance guard as it appears, *IS* there a way to do what I asked? the gadgetzan guard thing sorta works like someone else mentioned. i'd love to have a neutral PK guard.)

clarify?

thx and merry christmas!

[kaato]

I belive that that you can use "Booty Bay" or "Argent Dawn" faction if you wanna try this out on a neutral mall.

[maxelocked]

No, that's why there, uber guards.

Man, how i can put the guard to only attack when the player are fighting??