Global Mob changes

[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.