Announcement

#1 2014-11-15 21:52:41

Spiritbear
Member
1970-01-01
18

Albums - how to count lowest level

Hello,

Is there an easy way to count the number of sub-albums at the lowest level?

My site displays cemetery photos: they are structured as follows.

example:US Cemeteries/Colorado/Grand County/Fraser Cemetery (4 levels)

example:UK Cemeteries/Somerset/St Mary-Laverton (3 levels)

In the cases above, Fraser and St Mary-Laverton are the lowest level sub-albums.

Is there a plug-in or an easy way to count just the lowest level of sub-albums - not the individual photos within each, just the albums themselves.

Thanks

        Piwigo 2.6.1
       
        Operating system: Linux
        PHP: 5.3.29 (Show info) [2014-11-15 15:45:25]
        MySQL: 5.5.40-percona-sure1-log [2014-11-15 15:45:25]
        Graphics Library: External ImageMagick 6.7.7-10

Offline

 

#2 2014-12-13 21:12:00

Spiritbear
Member
1970-01-01
18

Re: Albums - how to count lowest level

*one bump, in case anyone can help

Thanks

Offline

 

#3 2014-12-13 21:15:32

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Albums - how to count lowest level

dig into the the piwigo_categories table, especially the uppercats and global_rank fields

didn't understand what you want to achieve though

Offline

 

#4 2014-12-13 23:08:48

Spiritbear
Member
1970-01-01
18

Re: Albums - how to count lowest level

Thanks - what's the path for those tables?

I would just like to be able to find, and if possible display, a count for the lowest level categories/albums in the db.

Offline

 

#5 2014-12-13 23:11:08

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Albums - how to count lowest level

what do you mean by "path" ?
you have a database and there are tables into it.

the way to access data is up to you depending on which programming language you want to use, and sorry but this is not the purpose of this forum, I can only explain you what the data mean if you don't figure it out

Offline

 

#6 2014-12-16 19:05:17

Spiritbear
Member
1970-01-01
18

Re: Albums - how to count lowest level

Path meaning the location of those tables, I was unable to locate them in my site File Manager...but I think I'll continue to do this count manually.

Thanks, anyway. Have a good day.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact