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 [2]   Go Down

Author Topic: Reset views in an album  (Read 13028 times)

0 Members and 1 Guest are viewing this topic.

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #20 on: April 15, 2005, 06:39:45 am »

I guess this is too difficult to be explained simply.  Thanks for your help.  I gotta go change my car oil.
Logged

OmegaGOD

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • I approve.
Re: Reset views in an album
« Reply #21 on: April 15, 2005, 06:39:59 am »

First back-up your database before attempting this just in case. Using phpMyAdmin, there is an option to execute an SQL statement, ie. the code below.

This will reset the view counter for all the albums in your gallery.
Code: [Select]
UPDATE `cpg11d_pictures` SET `hits` = '0' WHERE `hits` > 0;
This will reset the view counter for a select album. Simply replace *** in the code below with the aid number of the selected album you want to reset. You can get the AID number by looking at the album's URL.
Code: [Select]
UPDATE `cpg11d_pictures` SET `hits` = '0' WHERE `aid` = ***;

I guess this is too difficult to be explained simply. Thanks for your help. I gotta go change my car oil.
Actually, it was explained simply earlier in this thread.

Hope this helps,
--OmegaGOD
Logged
Please do not PM me with support questions. Please read the manual and then if posting questions please place them in the proper sub-boards.

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #22 on: April 15, 2005, 06:41:47 am »

I saw that in the explanation above.  I dont know where this is done.
Logged

OmegaGOD

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • I approve.
Re: Reset views in an album
« Reply #23 on: April 15, 2005, 06:53:28 am »

I've explained it as clearly as I could. If you are not sure how to utilize phpMyAdmin, then I would suggest finding someone who does.

Launch phpMyAdmin
In the left hand side of the screen, select the CPG database from the drop down menu
Click on the SQL tab from the top menu
Enter the SQL queries I supplied you from my previous post into the box that says "Run SQL query/queries on database"

This is step-by-step and as elementary as it gets. I would highly recommend that you find someone who is familiar with phpMyAdmin and mySQL databases to do this for you since you clearly don't understand what a SQL query is.
Logged
Please do not PM me with support questions. Please read the manual and then if posting questions please place them in the proper sub-boards.

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #24 on: April 15, 2005, 06:56:33 am »

Perhaps you could tell me where "phpMyAdmin" is located?  Is it the Admin Tools link when I'm in Admin Mode? Or somewhere else?  Perhaps that's part of my prolem.  I cant find phpMyAdmin.  Remeber, I'm using CPG 1.3
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Reset views in an album
« Reply #25 on: April 15, 2005, 07:00:31 am »

phpMyAdmin is not a part of coppermine. It's another server-driven app written in PHP. Either your webhost has installed it for you (many have), or you have to download and install it. Get it from http://www.phpmyadmin.net/ .

Joachim

P.S. Google is your friend
Logged

OmegaGOD

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • I approve.
Re: Reset views in an album
« Reply #26 on: April 15, 2005, 07:00:59 am »

phpMyAdmin is not part of CPG. It is a set of PHP scripts to modify mySQL databases. Check with your web-host to see if it is included with your hosting plan.
Logged
Please do not PM me with support questions. Please read the manual and then if posting questions please place them in the proper sub-boards.

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Reset views in an album
« Reply #27 on: April 15, 2005, 07:02:30 am »

Funny how similar your replies are. :D
Logged

OmegaGOD

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • I approve.
Re: Reset views in an album
« Reply #28 on: April 15, 2005, 07:05:48 am »

 ;D Looks like GauGau beat me to the post by 28 seconds.  ;)
Logged
Please do not PM me with support questions. Please read the manual and then if posting questions please place them in the proper sub-boards.

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #29 on: April 15, 2005, 07:06:03 am »

Now you may understand why I'm confused.  Nobody bothered to mention that until now and just assumed I knew that, which I did not.  I've been searching Coppermine for phpmyadmin for 45 minutes.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Reset views in an album
« Reply #30 on: April 15, 2005, 07:13:34 am »

Funny how similar your replies are. :D
Yeah, it's amazing. ;D
I think we've been holding ebonyhunter's hand long enough on this thread - if you (E.H.) still can't manage to solve this on your own, I suggest you wait for cpg1.4.x to be released. After all, newbies shouldn't be messing directly with the database, and it's obvious that ebonyhunter is not a mysql expert yet. As a side-note: before running queries on phpMyAdmin, it's strongly recommended to do a backup (dump) of the database. Those little queries (even if the appear to be "innocent") can wreak havoc on your coppermine install if not done properly (especially if you have no idea what you're doing).

You say
Now you may understand why I'm confused. Nobody bothered to mention that until now and just assumed I knew that, which I did not. I've been searching Coppermine for phpmyadmin for 45 minutes.
although just some postings above you said
yes...and do what? "execute an SQL statement". What does that mean? I didnt see anything in phpAdmin that says "execute an SQL statement."
-> this suggested that you already had phpMyAdmin, don't you think.

Joachim
Logged

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #31 on: April 15, 2005, 07:21:01 am »

No. it merely meant that where I was looking...which was in CPG Admin Tools....there wasnt anything about "executing an SQL Statement".  And in my version of phpmyadmin, which I've located now, I dont see that option either.

And you're correct.  I'm not an SQL expert or even an intermediate.  I have no problem admitting that.  If this is an advanced function, I shouldn't be messing around with it, which is what I said with my initial inquiry.
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Reset views in an album
« Reply #32 on: April 15, 2005, 07:27:11 am »

Yeah, one of the things on the to do list is to enable sql statement execution from within cpg's admin tools. Would make things a lot easier. Though there is the danger in making it easier to do damage. :-\\
Logged

ebonyhunter

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Reset views in an album
« Reply #33 on: April 15, 2005, 07:36:16 am »

I can suggest something far easier.  Just have a button somewhere that says "Reset All Image Views to 0" and when you click on it, it resets all of them to zero.

Sound easy?

Actually, I found CPG to be an oustanding and very user-friendly tool, even for elementary dunderheads like me.  I have no complaints.  And because its so great, I just ASSUMED there was a simple button to hit to reset everything.  See what happens when you make a great product?  We just assume it MUST do anything we want on demand.

Not always the case, as this example proved.
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Reset views in an album
« Reply #34 on: April 15, 2005, 07:40:00 am »

Well, yes, we could do that. But we also have to decide how many people will benefit from features we add. I don't think majority of users want to reset their views to 0; they would want to have increasing view counts. If we have too many features, it becomes overwhelming and cluttered. It also increases chances for bugs.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Reset views in an album
« Reply #35 on: April 15, 2005, 08:11:38 am »

erm, may I remind you what thread you're in: the request for a "reset all views" button is what this thread is all about, and I posted (although on page 1 of the thread) that the feature will be there in the next version (cpg1.4.x), along with a screenshot. I think it was Nibbler who pointed out that this option exists in the admin tools of version cpg1.4.x as well ("Reset view counters"), and you can choose there what album to apply this for, or even the whole gallery.
So what you're suggesting has already been discussed and even implemented by the dev team, there's no point in further suggesting those features. If you can't wait for cpg1.4.x to be released, you're welcome to get a copy of it right now and play with it (although I have to remind everybody that it's not yet recommended for production sites and comes without support).

Joachim
Logged
Pages: 1 [2]   Go Up
 

Page created in 0.023 seconds with 20 queries.