Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Apr 2004
Posts: 12
Ahz
Offline
Newbie
Newbie
Offline
Joined: Apr 2004
Posts: 12
got a user that i think is going through and modding everyones user rating down, I'd like to know where to check this?

Sponsored Links
Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
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.

Joined: Apr 2004
Posts: 12
Ahz
Offline
Newbie
Newbie
Offline
Joined: Apr 2004
Posts: 12
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?

Joined: Sep 2003
Posts: 67
Power User
Power User
Joined: Sep 2003
Posts: 67
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.

Joined: Sep 2003
Posts: 803
Coder
Coder
Offline
Joined: Sep 2003
Posts: 803
Thats just sneaky....
I Love It...

Sponsored Links
Joined: Apr 2004
Posts: 12
Ahz
Offline
Newbie
Newbie
Offline
Joined: Apr 2004
Posts: 12
works great thanks.

Joined: Apr 2004
Posts: 12
Ahz
Offline
Newbie
Newbie
Offline
Joined: Apr 2004
Posts: 12
anyway to get the output to username rather than number?

Joined: Mar 2001
Posts: 644
Member
Member
Offline
Joined: Mar 2001
Posts: 644
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.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)