Who controls what?

[Chris]

There are 2 positions of Duke (1st and 2nd, but both are equal), this position is given to players with highest influence. Each duke controls 3 offices that he can give to any player (3 offices of 1st Duke and 3 offices of 2nd Duke). Each office stores ID of Duke (1st or 2nd Duke, not player ID) who controls it and ID of a player who currently is appointed to the office.

So far so good, but let's say a new player earned a lot of influence and got promoted to 1st Duke. The former 1st Duke falls to 2nd Duke and former 2nd duke is out. But who controls which offices now? Logically, the 1st Duke should take over all 1st Duke offices. But the 2nd Duke (who is former 1st) already gave offices of Duke 1st to players. So, now the 1st Duke should take away the offices and give to his favourites and the 2nd Duke should give the 2nd Duke offices to his old favourite players in the same way. A lot of chaos and confusion. Wouldn't it be better if the 2nd Duke keep the control of 1st Duke offices and the 1st Duke got offices of the former 2nd Duke who is out?

Another situation, what if 1st Duke and 2nd Duke switch places due to influence change?

I'm not sure how to bite it...

[SpaceDoG]

I would say have it so that the new 1st Dukes offices would continue to be filled by the personnel assigned by the old 1st Duke with the option to change. If that option is not provided then have it be provided for a limited duration so they can change or they don't. If they do change then the time expires. What would be the point of being appointed 1st Duke and utilizing 2nd Duke offices? You might as well be the 2nd Duke and not the 1st Duke.

[SpaceDoG]

Oh and you could also just bump out the 2nd Duke appoint the new 2nd Duke and moving his people to the offices of the 2nd Duke bumping the old offices and then the new 1st Duke gets empty offices. As for the swapping that would be easy. Just move offices with each duke ;-)

[Marek]

Wow. You used the word "duke" over 20 times.

A lot of chaos and confusion.

That's how I felt when I tried reading your post.

[Chris]

Wow. You used the word "duke" over 20 times.

Yes, this is my most confusing post so far, I doubt I would understand it if I were to read it Congratulations to SpaceDoG for understanding it

I will try to exlain it another way.
There are 2 departments A and B. Each department has a manager AM, BM and positions A1, A2, A3, B1, B2, B3.
So player #4 (AM position) gave position A1 to player #78 and A2 to player #130. Now there is a change, someone else became AM and #4 became BM. But his friends (#78 and #130) possess positions A1 and A2 while he is in control of B department now (B1, B2 positions).

Oh and you could also just bump out the 2nd Duke appoint the new 2nd Duke and moving his people to the offices of the 2nd Duke bumping the old offices and then the new 1st Duke gets empty offices. As for the swapping that would be easy. Just move offices with each duke ;-)

Yes, that could work...

[jannesiera]

I guess "1st Duke" or "2nd Duke" is just a title, as they are equal in power/offices?

Then when a new player is promoted to 1st Duke determine which duke has the least influence points (aka original 2nd Duke). Let the player take his place. Then just change the titles.

Or am i missing the point here completely?

[Chris]

Yes... It seems I will have to make a separate title table (with title_rank and title_id). I thought I would be making it via simple "sort users by influence" and assign titles based on it regardless of previous title.

OK, thanks for all replies, it helped me organize my thoughts