UBB.Developers Forums UBB.threads 7 Development How Do I? remove/change user ratings

How do you remove or change the star ratings for a particular user?

You could try this SQL command... use at your own risk though.

UPDATE w3t_Ratings
SET R_Rating = '5'
WHERE R_Type = 'u'
AND R_What = '81'



Change 81 to the user number you wish to change.
Change 5 to the new rating you want. (if 6 people rated the user this will set all 6 ratings to 5)

I haven't tested this but I think it will work.