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
-
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
-
TRUNCATE TABLE `cpg133_votes`
-
Thank You!!!!