Dyaark: Taxation effect on loyalty

[Mirviriam]

Since I am thinking of playing with different persons on different timezone, a temporary table with the adjustment would be great, so if there is more than 1 DM, we can play/adjust without being live.

Run the query for every Rulers with at least one holding

and thanks a lot

Okay, I'm examining the situation...

To implement this you want a function which can be called when the player on the webpage submits a modification to the tax level?

OR

You want a function to be called by when the DM hits a button to process turns. Where this function will be called & cycle through every province in the Province table.

I reference TaxLevel (in Province table) to find the if the taxes are light (add one to loyalty), severe (minus one from loyalty) or other (no action required). Creating a temporary table which lists the ProvinceID as it's key.

The disadvantage I see is you then need a commit function to put this all back in to the province's Loyalty or LoyaltyModifier after the other DM see's it.