Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [SSmeredith] restart popular ranks

Quote Reply
Re: [SSmeredith] restart popular ranks In reply to
Hi. You would probably need to just reset "Hits", "Votes" and "Ratings".

Something like this in MySQLMonitor;

UPDATE lsql_Links SET Hits = 0, Votes = 0, Ratings = 0;

This will DELETE ALL YOUR VOTES/HITS, so please be sure you want to do this, before running the command =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread restart popular ranks SSmeredith 3062 Aug 11, 2004, 7:15 AM
Thread Re: [SSmeredith] restart popular ranks
Andy 2979 Aug 11, 2004, 7:55 AM
Thread Re: [Andy] restart popular ranks
SSmeredith 3003 Aug 11, 2004, 7:58 AM
Post Re: [SSmeredith] restart popular ranks
Andy 2958 Aug 11, 2004, 8:03 AM
Thread Re: [SSmeredith] restart popular ranks
afinlr 2973 Aug 11, 2004, 11:40 AM
Thread Re: [afinlr] restart popular ranks
anup123 2962 Aug 11, 2004, 1:09 PM
Post Re: [anup123] restart popular ranks
afinlr 2954 Aug 11, 2004, 1:17 PM