Clearing and resetting user ratings - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Clearing and resetting user ratings

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	51
Gizmo	24
DennyP	24
Dunny	15
SteveS	13
AllenAyres	12
SD	10
dbremer	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#216563 - 08/21/08 03:23 PM

Clearing and resetting user ratings

MattUK Offline

enthusiast

Registered: 06/25/06
Posts: 275

Greetings all..

If I wanted to clear and reset the user ratings, is there a nice sql statement i could run?

_________________________
Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#216565 - 08/21/08 03:57 PM

Re: Clearing and resetting user ratings [Re: MattUK]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

Sql Query:

update ubbt_USER_PROFILE
set USER_RATING='0',
USER_TOTAL_RATES='0'

Sql Query:

delete from ubbt_RATINGS
where RATING_TYPE='u'

Top

#216567 - 08/21/08 04:30 PM

Re: Clearing and resetting user ratings [Re: Rick]

MattUK Offline

enthusiast

Registered: 06/25/06
Posts: 275

Cheers!

_________________________
Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk

Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: AllenAyres, Harold, Ian, Ron M

Shout Box

May
Su	M	Tu	W	Th	F	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Today's Birthdays

No Birthdays