UBB.threads PHP Forum Software Community Forums General Suggestions and Feedback Rating system

My users have been asking for a "sunset" provission in the user rating system.

Could such a thing be quickly added to the code to allow the admin to set in a certain ammount of time after which a user could change their rating of a user?

OR a simple way to have the database prune all ratings older then 6 months?

the date a person or topic was rated isn't tracked in the database - we only track what was rated, who rated it, the rating itself, and the type of data (content or user) that was rated....

so, that said... the best you could do is run a SQL query on your database to clear out all of the rating entries in the database every so often. obviously, this would mean that ratings from 6 months ago and ratings from yesterday would be deleted just the same, but it might be better than nothing...

if you want to do this, you can run this query from the SQL query box of your control panel's database management area:

DELETE FROM `w3t_Ratings` WHERE `R_Type` = 'u'

this will delete all user ratings. (note that the 'w3t' part needs to be edited to reflect your database table prefix, found in your configuration/primary settings)

Yes, I did do that, delete the rating data...

I also changed the code to generate the number of stars by adding:



to the software where it sets the users "U_RealRating"

Otherwise when a user drops below 5 stars they can never get it back.