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: Most viewed pictures  (Read 4134 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.021 seconds with 19 queries.