UBB.Developers Forums UBB.threads 7 Development How Do I? where are the ratings logs(?) kept?

got a user that i think is going through and modding everyones user rating down, I'd like to know where to check this?

You can either allow or dis-allow user ratings.

Edit config settings > User settings > Do you want to enable the User Rating system?

Select NO to turn it off.

right, but where would i find out *who* is rating who what? been trolling through this board for awhile- haven't been able to find it.

I'm assuming it's not something i can look at via the interface itself, so i'm just wondering if there's some sort of input log i can look at? maybe on the SQL side?

For me running 6.4.2

Go to the admin panel and run the following sql command (always backup your database beforehand, although this is purely a read only query):

SELECT * FROM `w3t_Ratings`

(This assumes you did leave the default table prefix as w3t.)

The output table shows which user numbers rated which user number and what rating they gave. It also shows thread rates as well.

Just scroll through until you see the same number rating 1's for everyone.

Thats just sneaky....
I Love It...

works great thanks.

anyway to get the output to username rather than number?

How about trying this:

SELECT t1.*,t2.U_Username
FROM w3t_Ratings as t1, w3t_users as t2
WHERE t1.R_Rater = t2.U_Number

Worked on my test board.