Clearing and resetting user ratings - UBB.threads Community

Site Links

Top Posters (30 Days)

Latest Photos

Topic Options

Rate This Topic

#216563 - 08/21/08 12:23 PM Clearing and resetting user ratings
MattUK enthusiast Registered: 06/25/06 Posts: 274	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

#216565 - 08/21/08 12:57 PM Re: Clearing and resetting user ratings [Re: MattUK]
Rick Registered: 06/04/06 Posts: 7881 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' _________________________ UBB.threads™ Developer My Personal Website · StogieSmokers.com
Top

#216567 - 08/21/08 01:30 PM Re: Clearing and resetting user ratings [Re: Rick]
MattUK enthusiast Registered: 06/25/06 Posts: 274	Cheers! _________________________ Join Europes biggest BMW M Car owners site M-Torque - www.mtorque.co.uk
Top

Hop to:

Shout Box

Today's Birthdays

Recent Topics

Custom Island per Forum?
by unixpaul
Yesterday at 10:18 AM

SQL Corruption?
by Jason Carey
Yesterday at 05:52 AM

Forum Stats

4247 Members
33 Forums
30485 Topics
154645 Posts

Max Online: 978 @ 06/24/07 08:19 PM