Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: need SQL query to reset cpg133_votes  (Read 2196 times)

0 Members and 1 Guest are viewing this topic.

mustang_lex

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 34
    • Stangette.com
need SQL query to reset cpg133_votes
« 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
« Last Edit: July 11, 2005, 02:42:28 pm by Nibbler »
Logged
Alex
www.stangette.com/showcase
my Coppermine Gallery!

Nibbler

  • Guest
Re: need SQL query to reset cpg133_votes
« Reply #1 on: July 02, 2005, 05:17:15 pm »

Code: [Select]
TRUNCATE TABLE `cpg133_votes`
Logged

mustang_lex

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 34
    • Stangette.com
Re: need SQL query to reset cpg133_votes
« Reply #2 on: July 11, 2005, 02:41:00 pm »

Thank You!!!!
Logged
Alex
www.stangette.com/showcase
my Coppermine Gallery!
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.