Hi Jason,
can I bring the other issue we were discussing by PM into the public arena incase there are other people in the same position?
Basically before we installed Jason's excellent hack for vB2, we manually kept records of trader ratings.
Our users naturally want to keep these points.
In the vB2 system, I just incremented their points in the user table the once and that was all that was needed.
Now, however, with the groovy list of ratings, I think an explanation as to where the extra points are from is neccessary.
To test this I have created a dummy entry in the rating table assigning 20 points to myself with the explanation that they were carried over from the manual system.
These points are shown in the posts for users - (excellent!) but not, however, in the ratings page for that user.
Now I appreciate that this might be difficult to achieve with the extra data like 'members who left a positive' and 'members whi left a negative' type statistics.
But would it be possible to make the feedback score at the top be
Quote:
SELECT sum(userrating) FROM user_rate_trade WHERE rateduser = the_user_id
|