How can I recount Votes?

rcsmith · December 30th, 2007, 02:16 PM

Someone came along and did a bunch of 1's for for the top rated images screwing it all up so I went in and deleted them from mysql. Anyway to run a script to recount the vote totals? The images still show up as messed up. example 8 votes with 5 stars totals 4.5 average now.

Zachariah · December 30th, 2007, 06:29 PM

Try this:
admincp/vba_gallery_admin.php

Find:
// Update Image Post Info

Above Add:

Code:

Content visible to verified customers only.

Find:

Code:

Content visible to verified customers only.

Above Add:

Code:

Content visible to verified customers only.

Save

Login to:
AdminCP => vBGallery => Maintenance
- Update Ratings Counts
-- [Update Counters]

Push it

rcsmith · January 1st, 2008, 05:02 PM

awesome, but should ppgal_images be adv_gallery_images?

rcsmith · January 1st, 2008, 05:09 PM

works great, thanks!

rcsmith · January 1st, 2008, 10:51 PM

How can I use this to setup a cron job so people can vote everyday

Code:

Content visible to verified customers only.

glorify · January 2nd, 2008, 01:10 PM

Nice--should be standard.