"Most Viewed" abused "Most Viewed" abused
 

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]

Main Menu

"Most Viewed" abused

Started by merletweb, April 10, 2005, 11:00:28 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

merletweb

April 10, 2005, 11:00:28 PM
I suspect someone is trying to maniplulate my "most viewed" totals by hitting certain images over and over again. Is there a way that I can edit the totals for a given image on "most viewed"? The visitor(s) comes in on a dial-up service so blocking the ip address wouldn't work very well. Has anyone else experienced this problem?

http://www.espanolaonline.com/imagegallery/

Nibbler

#1
April 10, 2005, 11:15:14 PM
You can manually edit the `hits` column in the pictures table using a db admin tool such as phpmyadmin.

merletweb

#2
April 11, 2005, 04:39:10 AM
Quote from: Nibbler on April 10, 2005, 11:15:14 PM
You can manually edit the `hits` column in the pictures table using a db admin tool such as phpmyadmin.

Arrrgh! Ok, I just don't know anything about mysql. I was hoping there was an easy way of doing this without learning databases. I'm willing to learn though...

tomrock

#3
April 12, 2005, 03:26:02 PM
You could also go into Admin mode, click "Edit Files" for the abused gallery and check Reset View Counter. that might be easier but of course will set the views to zero.

merletweb

#4
April 12, 2005, 04:23:25 PM
That's what I was looking for! I hadn't seen that before. Thanks! ;D

Joachim Müller

#5
April 14, 2005, 10:17:28 AM
Quote from: tomrock on April 12, 2005, 03:26:02 PM
You could also go into Admin mode, click "Edit Files" for the abused gallery and check Reset View Counter. that might be easier but of course will set the views to zero.
Quote from: merletweb on April 12, 2005, 04:23:25 PM
That's what I was looking for! I hadn't seen that before. Thanks! ;D
This feature only exists in cpg1.4.x (devel version), it's not in the stable cpg1.3.2 yet.

Joachim

Nibbler

#6
April 14, 2005, 10:59:50 AM
It is actually in 1.3, although I hadn't realised it either :)

Joachim Müller

#7
April 14, 2005, 11:09:55 AM
ok, sorry for the confusion I caused:
  • both in cpg1.3.x and cpg1.4.x, you can reset the views counter per file when in editpics.php
  • only in cpg1.4.x, but not in cpg1.3.x, you can reset the views counter for all files within a particular album with one click when editing the album properties (in modifyalb.php)
HTH

Joachim

merletweb

#8
April 14, 2005, 11:28:01 PM
Quote from: tomrock on April 12, 2005, 03:26:02 PM
You could also go into Admin mode, click "Edit Files" for the abused gallery and check Reset View Counter. that might be easier but of course will set the views to zero.

Did this but ran into a problem. If the album has more than 100 photos how do you get beyond 100. Edit files only shows up to 100. ???

Nibbler

#9
April 14, 2005, 11:34:46 PM
That's why there is a new option in the next version. :)

If you can get yourself into phpmyadmin, you can run:

Code Select
UPDATE cpg_pictures SET `hits` = 0 WHERE aid = x

chaging cpg_ to the actual prefix chosen during installation and x to the id of the album you want to reset viewcount in. Backup your db before you do this of course :)
Print
Go Up Pages1
User actions