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: Remove votes one-by-one from table "cpg_votes"  (Read 2744 times)

0 Members and 1 Guest are viewing this topic.

cmead

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Remove votes one-by-one from table "cpg_votes"
« on: December 18, 2009, 10:56:48 pm »

I accidentally left ANONYMOUS voting on.  This allowed submitters to vote for themselves more than once, easily.  I checked the IP votes through the "cpg_votes_stats" table and was able to discover the unique IP addresses that had voted were lower than the total presented on the site (http://www.chrismead.com/holidaygallery/index.php).

Total votes for the example image = 2093.  Unique IP votes = 107.  So, I am going to make their vote total = 107.

Again, I want to REDUCE the amount of votes for an individual picture. I can't take it to ZERO and start over.

So, I thought I could just DELETE individual records tied to the picture number 34 in the "cpg_votes" table until I go to the correct number (in my case, the correct number is the number of unique IP addresses that had voted for the picture).

I was able to delete a number of records to test if this would work and it did NOT.  I cannot understand why.  I've tried running update.php and all other manner of refreshes...nothing seems to work.

Help!  I'm not a coder but play one on TV.
Logged

Nibbler

  • Guest
Re: Remove votes one-by-one from table "cpg_votes"
« Reply #1 on: December 18, 2009, 11:34:05 pm »

The number of votes and the current rating are stored in the pictures table.
Logged

cmead

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Remove votes one-by-one from table "cpg_votes"
« Reply #2 on: December 18, 2009, 11:39:10 pm »

I did find that, actually...and of course right after I posted!  Thanks so much.  How is the total built then if not from those other tables I referenced. Or is the total updated incrementally by the logged individual records?  IN other words, the total only increases as new votes come in.
Logged
Pages: [1]   Go Up
 

Page created in 0.045 seconds with 20 queries.