UBB.Dev
Posted By: Ahz where are the ratings logs(?) kept? - 05/21/2004 8:19 PM
got a user that i think is going through and modding everyones user rating down, I'd like to know where to check this?
Posted By: ericgtr Re: where are the ratings logs(?) kept? - 05/21/2004 8:25 PM
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.
Posted By: Ahz Re: where are the ratings logs(?) kept? - 05/21/2004 8:28 PM
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?
Posted By: Sapphy Re: where are the ratings logs(?) kept? - 05/21/2004 8:52 PM
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.
Posted By: DrChaos Re: where are the ratings logs(?) kept? - 05/21/2004 8:59 PM
Thats just sneaky....
I Love It...
Posted By: Ahz Re: where are the ratings logs(?) kept? - 05/22/2004 1:16 AM
works great thanks.
Posted By: Ahz Re: where are the ratings logs(?) kept? - 05/22/2004 1:39 AM
anyway to get the output to username rather than number?
Posted By: Zackary Re: where are the ratings logs(?) kept? - 05/22/2004 5:47 AM
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.
© UBB.Developers