I wrecked pets... oops

[lerxst2112]

Yes, you would need to open the large database file in something like Notepad++, find the statements you're interested in, save those into a different file, drop the existing table, then source that new file.

Since you used an absolute value like that instead of something like 25% of the original there's not really a formula that will get you back to how it was before you ran the query.

To do the same thing while excluding pets you could do something like:

SET npc_types hp = level * 10 where level < 50 && id NOT IN (SELECT npcid FROM pets);

Or, if you just wanted to try changing pets to a different multiplier, something like:

SET npc_types hp = level * 50 where level < 50 && id IN (SELECT npcid FROM pets);

As always, make backups, and run your queries with a select first to make sure you're going to hit the right rows.

[Rhodan]

Don't forget that you can always source the default database into a different database on your machine. If you're "live" database is "peq" then create another database with "peqoffline". Once that's done and you've done all the updates etc you can do a dump and save an untouched but up to date database for emergencies.

Once that is done you can dump the untouched npc_types table, delete the npc_types from your live database then source in the untouched npc_types table.

Before I start making changes to a table I usually dump the table to disk. I also write every query into a text file so if I've done twenty changes then mess up all I have to do is drop the broken table, source in the untouched backup, then source in the text file with the successful queries to get back to where I was before I messed up. Total time lost is at most 5 minutes.

[bodi]

what command would you use to set mob hp at 50% instead of set to level x5?
It would be nice to be able to just drop it by 25% or 50% of live but i didnt know the syntax