The reputation system has a central role at my site. We have been using it from 2005 and it has done wonders for my site.
Along time members got a higher and higher reputation power and kept giving out max reputation points. Until the ratings became so ridiculously high that it was impossible to base promotions and other important factors on it. So we needed to cap the number of reputation points that could be given by setting out guidelines. That works well.
But to level current ratings with old ratings, I want to edit all old ratings higher than 30 points and make them 30 point ratings.
Can this be done with a query?
Along time members got a higher and higher reputation power and kept giving out max reputation points. Until the ratings became so ridiculously high that it was impossible to base promotions and other important factors on it. So we needed to cap the number of reputation points that could be given by setting out guidelines. That works well.
But to level current ratings with old ratings, I want to edit all old ratings higher than 30 points and make them 30 point ratings.
Can this be done with a query?
Comment