pic_count

[danp]

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?

[danp]

Should my pic_count be updating everytime a picture is uploaded?

[danp]

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

[kegobeer]

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.

[kegobeer]

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.

[danp]

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.

[kegobeer]

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)

[danp]

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.

[kegobeer]

I was thinking you might have some photos that needed to be approved.  Glad it was something simple.