Album.php Mysql Select


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?

Subject: Re: Album.php Mysql Select
have you had a look at root/includes/album/album_hierarchy_sql.php ?????

Subject: 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...

Subject: Re: Album.php Mysql Select
I guess root/includes/album/album_hierarchy_functions.php ?????

What do you want to do?

Profile PM  
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...

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

Profile PM  
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. :(

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.

Profile PM  
Subject: 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.


: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 :( )

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

Profile PM  
Subject: 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... :P

Subject: Re: Album.php Mysql Select
block_category is the loop.

Profile PM  
Subject: 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?

Subject: Re: Album.php Mysql Select
We can use that in the if statement.

Profile PM  

Page 1 of 1


  
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

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.3042s (PHP: 7% SQL: 93%)
SQL queries: 15 - Debug Off - GZIP Enabled