Icy Phoenix
Old Support Topics - Album.php Mysql Select
Gianni PB [ Fri 10 Feb, 2012 11:31 ]
Post subject: Album.php Mysql Select
Hi all! :)
Where can I find the mysql select of album categories that list all categories in album.php index?
spydie [ Fri 10 Feb, 2012 23:58 ]
Post subject: Re: Album.php Mysql Select
have you had a look at root/includes/album/album_hierarchy_sql.php ?????
Gianni PB [ Sat 11 Feb, 2012 12:53 ]
Post subject: Re: Album.php Mysql Select
have you had a look at root/includes/album/album_hierarchy_sql.php ?????
Yes! I tried to modify all selects in that page, but nothing...
TheSteffen [ Sun 12 Feb, 2012 23:12 ]
Post subject: Re: Album.php Mysql Select
I guess root/includes/album/album_hierarchy_functions.php ?????
What do you want to do?
Gianni PB [ Sun 12 Feb, 2012 23:17 ]
Post subject: Re: Album.php Mysql Select
I have a lot of categories and I want to divide them.
So I want to show first 20 categories and hide the rest. If someone want to see all, he has to click on show more or something like that
But I cannot find that select...
TheSteffen [ Sun 12 Feb, 2012 23:32 ]
Post subject: Re: Album.php Mysql Select
What do you think of creating sub Categories...
Maybe 20 Cats with a usefull title... 2012 2011 2010 2009 or others
And set your exist cats as sub-cats. If you understand what I mean.
Now you can set in ACP => Photo Album => Configuration => Album Index
Show subcategories in index table = NO
Gianni PB [ Sun 12 Feb, 2012 23:41 ]
Post subject: Re: Album.php Mysql Select
Ok, this can be a valid solution for years...but I have 100 categories in every year and I cannot divide months in categories. :(
Informpro [ Mon 13 Feb, 2012 10:01 ]
Post subject: Re: Album.php Mysql Select
You have 100 months per year ? I don't get your problem really. I know what you want, but I don't get why you can't use months as categories.
Gianni PB [ Mon 13 Feb, 2012 19:10 ]
Post subject: Re: Album.php Mysql Select
You have 100 months per year ? I don't get your problem really. I know what you want, but I don't get why you can't use months as categories.
:mricy:
No, i don't have 100 months, but I have a lot of categories in each year :mricy:
I don't want to use sub cat for every month for a lot of reasons, 2 of these: not easy navigation and automatic category upload (this last is not easy to explain for my "beautiful" english :( )
Informpro [ Mon 13 Feb, 2012 21:58 ]
Post subject: Re: Album.php Mysql Select
O.K., I see :p. I don't know if actual blocks have an "iteration counter", else you could probably do something like.
- <!-- IF block_category.ITERATION < 20 --><li>{block_category.NAME}</li>
- <!-- ELSE -->
- <!-- IF block_category.ITERATION == 20 --><li><!-- ENDIF -->
- <!-- IF block_category.ITERATION > 20 -->, <!-- ENDIF --> <!-- comma to separate -->
- {block_category.NAME}
- <!-- IF block_category.LAST --></li><!-- ENDIF -->
- <!-- ENDIF -->
I'm really bad when it comes to IP templating engine :p.
So here : the 20 first ones will have a <li> for themselves (new line), whereas the others will be on an unique li, separated per a comma.
Gianni PB [ Mon 13 Feb, 2012 22:35 ]
Post subject: Re: Album.php Mysql Select
O.K., I see :p. I don't know if actual blocks have an "iteration counter", else you could probably do something like.
- <!-- IF block_category.ITERATION < 20 --><li>{block_category.NAME}</li>
- <!-- ELSE -->
- <!-- IF block_category.ITERATION == 20 --><li><!-- ENDIF -->
- <!-- IF block_category.ITERATION > 20 -->, <!-- ENDIF --> <!-- comma to separate -->
- {block_category.NAME}
- <!-- IF block_category.LAST --></li><!-- ENDIF -->
- <!-- ENDIF -->
I'm really bad when it comes to IP templating engine :p.
So here : the 20 first ones will have a <li> for themselves (new line), whereas the others will be on an unique li, separated per a comma.
Yes ;)
But I need that for loop... :P
Informpro [ Tue 14 Feb, 2012 12:14 ]
Post subject: Re: Album.php Mysql Select
block_category is the loop.
Gianni PB [ Tue 14 Feb, 2012 22:39 ]
Post subject: Re: Album.php Mysql Select
block_category is the loop.
uhm... i don't know if I understood.... are you talking about album_index_body.tpl? can we use "<, >, =" in tpl files?
Informpro [ Thu 16 Feb, 2012 10:59 ]
Post subject: Re: Album.php Mysql Select
We can use that in the if statement.