Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Most viewed pictures  (Read 4497 times)

0 Members and 1 Guest are viewing this topic.

whisky

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Most viewed pictures
« 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?
« Last Edit: December 30, 2005, 12:05:55 pm by GauGau »
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Most viewed pictures
« Reply #1 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.
Logged

whisky

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Most viewed pictures
« Reply #2 on: December 26, 2005, 06:33:05 am »

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

whisky

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Most viewed pictures
« Reply #3 on: December 29, 2005, 02:04:56 pm »

The database I need to edit? Anyone?
Logged

Nibbler

  • Guest
Re: Most viewed pictures
« Reply #4 on: December 29, 2005, 02:07:08 pm »

The database you installed Coppermine into.
Logged

whisky

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Most viewed pictures
« Reply #5 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  :(
Logged

Nibbler

  • Guest
Re: Most viewed pictures
« Reply #6 on: December 29, 2005, 08:20:08 pm »

Looks at the 'hits' field of the prefix_pictures table
Logged

whisky

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Most viewed pictures
« Reply #7 on: December 30, 2005, 11:29:58 am »

Solved! Thhank you very much  :)
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.