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 PBSend 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 ?????
 




____________
Out of Order
 
spydieSend 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 PBSend 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
 
TheSteffenSend 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 PBSend 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
 
TheSteffenSend 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 PBSend 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.
 



 
InformproSend 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 PBSend 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.
 



 
InformproSend 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 PBSend 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.
 



 
InformproSend 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 PBSend 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.
 



 
InformproSend 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


  

 

  cron