forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: whisky on December 25, 2005, 08:37:03 pm

Title: Most viewed pictures
Post by: whisky on December 25, 2005, 08:37:03 pm

This is kinda dumb, but lately people have been getting their images to be the most viewed by clearing their cache and history and re-viewing their pictures. That's just one or two of the guys who've got this trick. What I want to do is bring them back to a specific number of views. So is there any way to increase or decrease the views of an image?

Title: Re: Most viewed pictures
Post by: Tranz on December 25, 2005, 09:15:22 pm

CPG 1.4x will let you reset the view counter. Don't know about 1.3. If you want to change it to a specific number of views, you'd need to use a database editor like phpmyadmin. But if you reset the views to 0, that would likely deter those pranksters from doing it again in the future.

Title: Re: Most viewed pictures
Post by: whisky on December 26, 2005, 06:33:05 am

Thanks for the information. Oh, and what database do I edit using phpmyadmin ?

Title: Re: Most viewed pictures
Post by: whisky on December 29, 2005, 02:04:56 pm

The database I need to edit? Anyone?

Title: Re: Most viewed pictures
Post by: Nibbler on December 29, 2005, 02:07:08 pm

The database you installed Coppermine into.

Title: Re: Most viewed pictures
Post by: whisky on December 29, 2005, 07:52:48 pm

Yes, but under what table? I don't see anything that seems to be responsible for the number of views of the image  :(

Title: Re: Most viewed pictures
Post by: Nibbler on December 29, 2005, 08:20:08 pm

Looks at the 'hits' field of the prefix_pictures table

Title: Re: Most viewed pictures
Post by: whisky on December 30, 2005, 11:29:58 am

Solved! Thhank you very much  :)