Simple Database Question
 

Good day,

I used the peq daily dump provided by cavedude in a very recent new install. I have begun to make simple alterations to the database in areas such as npc_type, spawnentry, loottables, etc. If I update the database with the daily dump in the future, will I lose the alterations I made?

EDIT:
Is there a way to make blanket changes to mob hp/damage? For example, increasing all mob hp by 4 per level no matter the mob type. Or is working with the database in this manner just going to be extremely tedious?

I'm green to all this but I'm having a blast customizing all this stuff. I see a vacation in my future...

Question 1: Yes, it would, that's why the repository has SQL updates for new columns, etc.

Question 2: Yes, run a query in Navicat of HeidiSQL, code below.

Thanks, something to work on and figure out...

Did I tell you I was a little wet behind the ears? ~

I've altered the the rule_values table for a particular ruleset_ID and changed the ruleset in the zones table to match. How do I apply a particular ruleset onto this server? For example, using the ruleset_ID 10 for which I made the changes in rules_values.

Thanks

EDIT:
I figured it out. Disregard previous question.

New questions:

1. In npc_types, I've made it so some npcs spawn with variable levels by changing the 'maxlevel.' It seems the 'scalerate' affects the hp accordingly but not damage. For example, a_gnoll at level 3 will hit for 6 max and will hit for the same at level 5. Is there a way to make the damage scale along with the hp so I can avoid making multiple entries for a single spawn?

2. A level 1 player attacking a red dings level 2 upon killing the mob. I'd like to cut off xp at a certain % or amount per level. Aside from changing the rules and level_xp_mods, is this possible and how?

Thanks

Bumped for edit and new question ^ ^ ^