In need of a mysql command for agro ranges

[slambs]

G'day guys,

been looking for a command so as we can set agro ranges on mobs across the board. If anyone could help out that would be fantastic.

I did see a similar command to drop loot coinage but cant seem to find it now.

thanks all

have fun

[sandy]

interesting =) post it in the request forum
yes it would be usefull =)

[Monrezz]

UPDATE npc_types SET aggroradius=50 WHERE (level <= 50);
UPDATE npc_types SET aggroradius=55 WHERE level=51;
UPDATE npc_types SET aggroradius=55 WHERE level=52;
UPDATE npc_types SET aggroradius=55 WHERE level=53;
UPDATE npc_types SET aggroradius=55 WHERE level=54;
UPDATE npc_types SET aggroradius=65 WHERE level=55;
UPDATE npc_types SET aggroradius=65 WHERE level=56;
UPDATE npc_types SET aggroradius=65 WHERE level=57;
UPDATE npc_types SET aggroradius=65 WHERE level=58;
UPDATE npc_types SET aggroradius=65 WHERE level=59;
UPDATE npc_types SET aggroradius=70 WHERE level=60;
UPDATE npc_types SET aggroradius=75 WHERE level=61;
UPDATE npc_types SET aggroradius=80 WHERE level=62;
UPDATE npc_types SET aggroradius=85 WHERE level=63;
UPDATE npc_types SET aggroradius=90 WHERE level=64;
UPDATE npc_types SET aggroradius=100 WHERE level=65;

This is what I've come up with, not sure if this is what you meant though?

[slambs]

exactly what I needed =)

thanks muchly Monrezz /salute

[Monrezz]

Not a problem :)

[sandy]

aggroradius is not proportional to the level
but is specific to each npc for gameplay purpose

[Monrezz]

It is not meant to be accurate, it is a simply there to make it a little easier for newbies in low level zones, and make it harder for high levels with high level mobs.

I suppose aggro is based on level, class, race and location etc in live. But I wouldn't know where to start. The above works fine for me, though. Works well in befallen, works well in hate. :)

Anyway, the code's there just need to customize the numbers to however you like. Post it if you get something good :)

[samandhi]

If you are wanting to set different aggro for differnent mobs even of the same level, (you can use MySQL statements for this but I use MySQLFront because it is a point and click thing) just find the ID of the mob in question and change the aggroradius of it. Or in MySQL statement something like this (assuming you want to change mobs with the ID of #1)
UPDATE npc_types SET aggroradius=65 WHERE id=1;


The solution Monrezz gave is a good one, but is a generic fix of aggro accross the board, meaning that ALL mobs lvl 65 will have a agroradius of 100.....And the way I am telling you, is VERY tedious, as you would have to change 71775 (and climbing) records....