Album and picture stats

[setishock]

I have a boat load of albums and mucho pictures in most of the albums. It's either reviewing something or a build log. I think it would be real neat to have a stat that shows total albums and total pictures. The rest of my stats look like a pile of poop so it would be nice to have something that has some way up there numbers. I figure it would need to go right under the main stat line.

My pics go to the file system if that makes any difference. I have no clue how to code this complex or I'd take a shot at it. I'm doing good programming my Arduino's.

So is there a mod that does this or is there a simple template edit that would do it?

[MarkFL]

From what I can tell, you would have to query the "album" table to get the number of albums, and then query the "attachment" table to get the number of images uploaded to the albums. An attachment whose "contenttypeid" is 8 is an album picture. (edit: I now see after creating an album that the "album" table has a column that indicates how many pictures are in that album.)

Do you simply want a division in the WGO block that says something like "There are x user albums containing a total of y pictures"?

[setishock]

YES PLEASE!!!
I would imagine the first run through is going to smack the server pretty hard. I would venture after the initial run have it run at a set interval to keep from banging the server.

[MarkFL]

Originally Posted by setishock

YES PLEASE!!!
I would imagine the first run through is going to smack the server pretty hard. I would venture after the initial run have it run at a set interval to keep from banging the server.

I have a couple of other projects in progress, but I have added this to my list. I will have something for you soon.

[MarkFL]

I have attached a product .XML file that you can import. Upon installation, the db is queried to obtain the total number of albums and the total number of images in the albums. This data is written to a .TXT file in your root directory: album_stats.txt

Then this file is read and its contents displayed at the top of the WGO block:



Once a day, the database is queried to update the album stats, which are written to the .TXT file.

To Install:

1. Download the attached .XML file.
2. Follow AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product.
3. Click on "Choose File" and browse to the product .xml file that you downloaded.
4. Click "Import."

That's it...there are no settings to configure, once installed, it is active. Please let me know if there are any changes you would like made.

If you uninstall the product, then the .TXT file is removed from your file system.

[setishock]

Works great. I thought I had a lot more pictures than I do. I'm going to have to fatten up those numbers.

Thank you Mark. Your response to a question with the speed you did is impressive. Thanks for the plug in. I'm sure others will down load this and try it out.
Thanks again.

Merry Christmas and a happy new year.