Print

[merletweb]

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]

You can manually edit the `hits` column in the pictures table using a db admin tool such as phpmyadmin.

[merletweb]

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]

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]

That's what I was looking for! I hadn't seen that before. Thanks!

[Joachim Müller]

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.

That's what I was looking for! I hadn't seen that before. Thanks!

This feature only exists in cpg1.4.x (devel version), it's not in the stable cpg1.3.2 yet.

Joachim

[Nibbler]

It is actually in 1.3, although I hadn't realised it either

[Joachim Müller]

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]

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]

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