forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: mustang_lex on July 01, 2005, 10:54:34 pm

Title: need SQL query to reset cpg133_votes
Post by: mustang_lex on July 01, 2005, 10:54:34 pm
I have the SQL query that resets votes and ratings for cpg133_pictures, now I need the query that sets all the tables in cpg133_votes to 0 as well. Whats happening is I want to reset votes and ratings every month and let the members revote again as the new months come. But they can't because cpg133_votes logs their votes.

I already did reset the table through PHPMYADMIN , but I just want to be able to run a simple query like the one that resets the votes and ratings.

Thank you
Title: Re: need SQL query to reset cpg133_votes
Post by: Nibbler on July 02, 2005, 05:17:15 pm
Code: [Select]
TRUNCATE TABLE `cpg133_votes`
Title: Re: need SQL query to reset cpg133_votes
Post by: mustang_lex on July 11, 2005, 02:41:00 pm
Thank You!!!!