coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: danp on October 11, 2003, 02:31:21 AM

Title: pic_count
Post by: danp on October 11, 2003, 02:31:21 AM
Is there a way to update the pic count for each album?  I made a script that lists each album and how many photos are in it by getting the pic_count from each album in mysql but they aren't accurate.  What makes them update, even when I upload photos to that album they do not change.  Is there some way to change them or someone have a script to do it?
Title: pic_count
Post by: danp on October 12, 2003, 09:37:59 PM
Should my pic_count be updating everytime a picture is uploaded?
Title: pic_count
Post by: danp on October 13, 2003, 08:08:33 PM
What does it take to get a responce around here??? I think something is wrong, it should be updating the pic_count correct?  It hasn't updated in a week, almost all the galleries are wrong.

http://www.correct-proportion.com
user: nimrod
pass: guitar
version 1.1D in phpnuke
Title: pic_count
Post by: kegobeer on October 13, 2003, 08:14:10 PM
If you've looked at the cpg_albums table you'd know that cpg calculates the number of pics in the album on the fly.
Title: pic_count
Post by: kegobeer on October 13, 2003, 08:33:58 PM
I looked at your site.  I looked in a few albums and counted the number of pics, the counts cpg show at the bottom of each page appear to be correct.  If you're referring to the script you wrote not reporting the correct numbers, it's because your script isn't correct.  Look in index.php and you'll see how cpg counts (hint, $count) pictures in each album.

And since your original post was Friday, October 10, and it's now the 13th, I don't think that's too long of a wait to get a response, especially since it doesn't look (at first glance) that there's anything wrong with cpg.
Title: pic_count
Post by: danp on October 13, 2003, 09:48:33 PM
The numbers on the left menu are from a script that I wrote, thats not what I'm talking about, those are correct.  I'm talking about cpg's main menu where it lists the categories and the albums not under any categories.

Look at "user uploads" and "user artwork gallery" both are not under any categories.  The uploads has 4 pictures in it, the script on the left says 4, cpg says it has 3.  The artwork gallery has 1, the script on the left says 1, cpg says 0.  

I started using cpg on oct. 1st which is when I uploaded almost all of the pictures.  I'm pretty sure that anything uploaded after then has not been counted correctly.
Title: pic_count
Post by: kegobeer on October 13, 2003, 10:57:38 PM
User uploads:
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.kazebeer.com%2Ficon%2Fuloads.jpg&hash=a992094ad0eca485fb7359d9e8942f8d6c133c22)
User artwork:
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.kazebeer.com%2Ficon%2Fuart.jpg&hash=1c2104616c56eb19a3fdf9f8b6717173d78d574c)
Title: pic_count
Post by: danp on October 14, 2003, 12:26:21 AM
OMG, I have to approve photos!@$  I've always been in admin mode where they show up as soon as they upload them.  Well thanks for replying.
Title: pic_count
Post by: kegobeer on October 14, 2003, 12:34:14 AM
I was thinking you might have some photos that needed to be approved.  Glad it was something simple.