Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Album.php Mysql Select 
 
Hi all!

Where can I find the mysql select of album categories that list all categories in album.php index?
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
have you had a look at root/includes/album/album_hierarchy_sql.php ?????
 




____________
Driving me and my PC crazy, trying to create some pluggins
Icy-Mods.com ( IP 2.0 RC-1)
 
spydie - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
spydie wrote: [View Post]
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...
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
TheSteffen - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post 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...
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
TheSteffen - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
Informpro - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
Informpro wrote: [View Post]
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 )
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post 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.
Code: [Download] [Hide]
  1. <!-- IF block_category.ITERATION < 20 --><li>{block_category.NAME}</li> 
  2. <!-- ELSE --> 
  3. <!-- IF block_category.ITERATION == 20 --><li><!-- ENDIF --> 
  4. <!-- IF block_category.ITERATION > 20 -->,&nbsp;<!-- ENDIF --> <!-- comma to separate --> 
  5. {block_category.NAME} 
  6. <!-- IF block_category.LAST --></li><!-- ENDIF --> 
  7. <!-- 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.
 



 
Informpro - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
Informpro wrote: [View Post]
O.K., I see :p. I don't know if actual blocks have an "iteration counter", else you could probably do something like.
Code: [Download] [Hide]
  1. <!-- IF block_category.ITERATION < 20 --><li>{block_category.NAME}</li> 
  2. <!-- ELSE --> 
  3. <!-- IF block_category.ITERATION == 20 --><li><!-- ENDIF --> 
  4. <!-- IF block_category.ITERATION > 20 -->,&nbsp;<!-- ENDIF --> <!-- comma to separate --> 
  5. {block_category.NAME} 
  6. <!-- IF block_category.LAST --></li><!-- ENDIF --> 
  7. <!-- 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...
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
block_category is the loop.
 



 
Informpro - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
Informpro wrote: [View Post]
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?
 



 
Gianni PB - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album.php Mysql Select 
 
We can use that in the if statement.
 



 
Informpro - View user's profileSend private message 
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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