UBB.Developers Forums UBB.threads 7 Development How Do I? How do I find who is rating people at 1?

It looks ike someone is rating everyone he (she) does not like at a 1. How can I find out who is doing that?

AM I alone with this problem?

Thanks

Stan

That's the basic problem with this feature. I have ratings disabled (removed from the templates).

Here are some queries you could try:

SELECT * FROM w3t_Ratings WHERE R_Type='u' AND R_Rating='1'

SELECT * FROM w3t_Ratings WHERE R_Type='u' AND R_Rating<'3'

SELECT * FROM w3t_Ratings WHERE R_Type='u' AND R_Rating='1' AND R_What='Xyz'

In the last one, Xyz would be replaced with a username whose ratings you want to check. R_What is the user being rated, R_Rater is the user who did the rating.

Sorry to sound so Newbie.... but WHERE do I put that code?
I have a iMac the UBB is on a unix server...

Thanks

those are sql commands to be used from the admin area.

Here's some related posts:

https://www.ubbdev.com/threads/php/showflat.php?Cat=&Board=feedback&Number=48188

and is it possible to change these ratings?

You can use phpmyadmin to edit the ratings table. Removing the row with the rating you want to remove should do it. This would let them rate again though I think.