|
Page 1 of 1
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
Album.php Mysql Select
Hi all!
Where can I find the mysql select of album categories that list all categories in album.php index?
|
#1 Fri 10 Feb, 2012 11:31 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Album.php Mysql Select
have you had a look at root/includes/album/album_hierarchy_sql.php ?????
____________ Out of Order
|
#2 Fri 10 Feb, 2012 23:58 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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...
|
#3 Sat 11 Feb, 2012 12:53 |
|
TheSteffen
Joined: August 2006
Posts: 1625
Location: Magdeburg
|
Re: Album.php Mysql Select
I guess root/includes/album/album_hierarchy_functions.php ?????
What do you want to do?
____________ TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
|
#4 Sun 12 Feb, 2012 23:12 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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...
|
#5 Sun 12 Feb, 2012 23:17 |
|
TheSteffen
Joined: August 2006
Posts: 1625
Location: Magdeburg
|
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
____________ TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
|
#6 Sun 12 Feb, 2012 23:32 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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.
|
#7 Sun 12 Feb, 2012 23:41 |
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
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.
|
#8 Mon 13 Feb, 2012 10:01 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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.
No, i don't have 100 months, but I have a lot of categories in each year
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 )
|
#9 Mon 13 Feb, 2012 19:10 |
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
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.
|
#10 Mon 13 Feb, 2012 21:58 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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...
|
#11 Mon 13 Feb, 2012 22:35 |
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
Re: Album.php Mysql Select
block_category is the loop.
|
#12 Tue 14 Feb, 2012 12:14 |
|
Gianni PB
Joined: December 2006
Posts: 242
Location: New York
|
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?
|
#13 Tue 14 Feb, 2012 22:39 |
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
Re: Album.php Mysql Select
We can use that in the if statement.
|
#14 Thu 16 Feb, 2012 10:59 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|