Reputation System a bit Lacking?

[Milez]

Originally Posted by Milez

I should also point out that after unning the first query:

UPDATE user SET reputation= posts/500

...all of the users reputation scores were adjusted properly however none of the users reputation power scores were changed at all. I know the rep power scores are calculated at run time but so I don;t see how these values don't get adjusted.

As an example here is a list of users both before and after running the above query:

BEFORE:
User		            |  Reputation  |  Rep Power
-------------------------+----------------+--------------------
user1                          10		7
user2                          1000		10
user3                          30		11
user4                          10		16		
user5                          10		7
user6                          10		4
user7                          10		10
user8                          10		0
user9                          10		8

AFTER:
user1                          14		7
user2                          1004		10
user3                          43		11
user4                          34		16		
user5                          17		7
user6                          10		4
user7                          20		10
user8                          12		10
user9                          17		8

...Hope this helps!

This query will work for seeding the reputation scores based on joindate. In my example I give a user a rep point for every 180 days registered:

UPDATE user SET reputation = reputation + ((UNIX_TIMESTAMP()-joindate)/(86400))/90)

Anyone know why the rep power scores are not relecting the adjustments made by these 2 queries?