Global Mob changes

[Webblazer]

Greetings all. I've been playing on eqemu servers for a few years now and finally got around to starting my own. Got it up and running but and started messing with some things. I see how to edit npcs, but is there a way to do a mass editing? I'm going for a more solo route and was hoping I could say reduce all mob hp by 30% without having to go through each mob individually. Thanks in advance for any assistance!

[cavedude]

SQL queries would do it. In your example, at a MySQL prompt do:

update npc_types set hp = hp - hp*.3;

If you only wanted to do this for mobs higher than say level 19, you'd do:

update npc_types set hp = hp - hp*.3 where level > 19;

For all undead mobs higher than level 19, you'd do:

update npc_types set hp = hp - hp*.3 where level > 19 and bodytype = 3;

Etc, etc.

That's the basic syntax you can use for most mass npc editing, browse around the forums for more examples and advanced functions.

[Webblazer]

Thanks so much! That was exactly what I was looking for

[Khahan]

Is there a place where a large collection of mysql queries are located? Or better yet a program with a UI to edit servers? The wiki and the forums have a wealth of information regarding getting a server running, but I'm having one hell of a time finding information regarding editing the content of a server.

[Diuretic]

These forums are rife with queries, but I still think a wiki page might be valuable to add.

If you are going to look for SQL queries rather than learning how to build them yourself, that's cool. Please make a backup of your database though. Most typos will cause the SQL query to error and do nothing, but you'd particularly want to avoid using a global query, accidentally picking the wrong bodytype, and then granting the wrong bodytype the effect you intended for undead.

You'd get a query successful message, but you'd hate to discover your error only after closing out your query window to discover you have no idea what you just did or how widespread the damage.

It happens to us all.

Anyway, best of luck!

D.

[Khahan]

I'm not opposed to learning how to do my own queries, but I guess I don't know where to start.

[Diuretic]

Well, I'm of the mind that it's best to learn what's in your database before trying to modify it, so I'd recommend getting comfortable with either the PEQ or Angelox DB and the SELECT syntax described here:

http://dev.mysql.com/doc/refman/5.0/en/select.html

[rojadruid]

and always, always back up your database. I lost count in the first 6months my server was running that I ended up trashing my database and forgetting. now its second nature. I repeat back it up always.