Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2009-08-25 20:50:54

jstubbs
Member
From: Hong Kong
Registered: 2004-12-13
Posts: 2,395
Website

Re: List problem

What about this? If it works, then there may be a better way of coding this:

<txp:category_list>
   <txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category="projects,testimonials" limit="1" />
   <txp:if_variable name="has_articles" value="">
   <txp:else />
   <div class="module">
   <h4><txp:category title="1" /></h4>
   <txp:article_custom section='<txp:section />' category="projects,testimonials" wraptag="ul" class="listing" break="li">
   <txp:permlink><txp:title /></txp:permlink>
   </txp:article_custom>
   </div>
   </txp:if_variable>
</txp:category_list>

Offline

#14 2009-08-26 10:41:14

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

Sorry guys, I just can’t get this to work! Even adding specific target calls to the section and category fields doesn’t change anything.

Just in case there was some kind of conflict with nested forms I dropped the code straight onto the bottom of the page using the following –

<txp:category_list>
	<div class="module">
	<h4><txp:category title="1" /></h4>
	<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
 		<txp:permlink><txp:title /></txp:permlink>
	</txp:article_custom>
	</div>
</txp:category_list>

Adding the variable info didn’t change anything to I went back to the original simplified version. Why it insists on showing headings for Articles, Biography and Published Articles (there are articles for these categories) I’m not sure – I’ll look at the way those articles are categorised in case there’s a pattern.

Offline

#15 2009-08-26 10:51:34

jstubbs
Member
From: Hong Kong
Registered: 2004-12-13
Posts: 2,395
Website

Re: List problem

Did you try the last code I posted?

Offline

#16 2009-08-26 11:30:44

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

Hi Jonathan,

Sorry, yes I did – it created a slightly different result. It listed the correct articles but bundled them together and repeated the process for the various category headings. Hard to explain – I’ll temporarily put the code in at the base of the page so you see what I mean.

Offline

#17 2009-08-26 12:16:01

jstubbs
Member
From: Hong Kong
Registered: 2004-12-13
Posts: 2,395
Website

Re: List problem

What about:

<txp:category_list>
   <txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category="projects,testimonials" limit="1" />
   <txp:if_variable name="has_articles" value="">
   <txp:else />
   <div class="module">
   <h4><txp:category title="1" /></h4>
   <txp:article_custom section="garden-projects" category="projects,testimonials" wraptag="ul" class="listing" break="li">
   <txp:permlink><txp:title /></txp:permlink>
   </txp:article_custom>
   </div>
   </txp:if_variable>
</txp:category_list>

Offline

#18 2009-08-26 12:20:50

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: List problem

decoderltd, you page source is showing txp tags. What Txp version are you using? Tags as attributes and the variable tags were only introduced in 4.0.7.

Offline

#19 2009-08-26 12:23:11

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

Hi Els, I’m using Textpattern version: 4.0.8 (r3085).

Offline

#20 2009-08-26 12:30:42

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

Hi Jonathan, thanks for the revised code but still no joy. Very strange.

Oh, you asked about how I created the favicon – I used Photoshop with a plug-in which is available from the telegraphics website.

Offline

#21 2009-08-26 12:31:40

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: List problem

In that case, can you please post the exact code you have on your page, and also a tag trace, because without it we can go on guessing what is wrong for a long time…

Offline

#22 2009-08-26 13:22:59

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

Thanks Els.

My code snippet is:

<txp:category_list>
	<div class="module">
	<h4><txp:category title="1" /></h4>
	<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
 		<txp:permlink><txp:title /></txp:permlink>
	</txp:article_custom>
	</div>
</txp:category_list>

Trace tag (edited down-ish) is:

<!-- Runtime:    0.0457 -->
<!-- Query time: 0.016301 -->
<!-- Queries: 45 -->
<!-- Memory: 4624Kb, <txp:title /> -->
<!-- txp tag trace: 
[SQL (0.0017759799957275): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.0009920597076416): select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (0.00036811828613281): select name,code,version from txp_plugin where status = 1 AND name='smd_lib']
[SQL (0.00056290626525879): select name from txp_section where `name` like 'garden-projects' limit 1]
[SQL (0.00013494491577148): select page, css from txp_section where name = 'garden-projects' limit 1]
[SQL (0.00029611587524414): select user_html from txp_page where name='garden-projects']
[Page: garden-projects]
<txp:if_individual_article>
	[<txp:if_individual_article>: false]
</txp:if_individual_article>
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:article_custom allowoverride="0" form="gbd_articleProject" limit="1" pgonly="0" section="garden-projects" sort="rand()" status="4" />
		[SQL (0.0015630722045898): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by rand() limit 0, 1]
		[article 10]
		[SQL (0.00021481513977051): select Form from txp_form where name='gbd_articleProject']
		[Form: gbd_articleProject]
		<txp:smd_if field="article_image" operator="isused">
			[<txp:smd_if field="article_image" operator="isused">: true]
			<txp:smd_gallery id="?article_image" wraptag="div" html_id="fade" class="pics" >
				[SQL (0.0011310577392578): 
			SELECT DISTINCT txp_image.name,txp_image.id,txp_image.alt,txp_image.caption,txp_image.category,txp_image.author,txp_image.date,txp_image.ext,txp_image.w,txp_image.h,txp_image.thumbnail, txp_category.title AS category_title
			FROM txp_image LEFT JOIN txp_category
			ON txp_image.category = txp_category.name
			WHERE (1=1 AND  (txp_image.id IN ('28','29','30')) ) ORDER BY txp_image.id asc
			LIMIT 0, 99999
		]
				<txp:image id="28" />
					[SQL (0.00022101402282715): select * from txp_image where id = 28 limit 1]
				<txp:image id="29" />
					[SQL (0.00014400482177734): select * from txp_image where id = 29 limit 1]
				<txp:image id="30" />
					[SQL (0.00013589859008789): select * from txp_image where id = 30 limit 1]
			</txp:smd_gallery>
		</txp:smd_if>
		<txp:title />
		<txp:body />
		<txp:output_form form="gbd_beforeAfter" />
			[SQL (0.00015783309936523): select Form from txp_form where name='gbd_beforeAfter']
			[Form: gbd_beforeAfter]
			<txp:smd_if field="before_after" operator="isused">
				[<txp:smd_if field="before_after" operator="isused">: false]
			</txp:smd_if>
		<txp:article_custom pgonly="0" section="garden-projects" form="gbd_articleSidebar_body" status="5" />
			[SQL (0.00047683715820312): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			[article 11]
			[SQL (0.00013399124145508): select Form from txp_form where name='gbd_articleSidebar_body']
			[Form: gbd_articleSidebar_body]
			<txp:body />
		<txp:article_custom pgonly="0" section="garden-projects" form="gbd_articleListing" status="4" />
			[SQL (0.00057101249694824): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			[article 25]
			[SQL (0.00013399124145508): select Form from txp_form where name='gbd_articleListing']
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
					[SQL (0.00014710426330566): select title from txp_category where name='testimonials' and type='article']
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 24]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 23]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 22]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 21]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
					[SQL (0.0001680850982666): select title from txp_category where name='projects' and type='article']
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 20]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 10]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 9]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
		<txp:category_list>
			[SQL (0.00025415420532227): select name, title from txp_category where type = 'article' and name not in('default','root')   order by name ASC]
			<txp:category title="1" />
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.00048613548278809): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('articles') or Category2 IN ('articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			</txp:article_custom>
			<txp:category title="1" />
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.00047802925109863): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('biography') or Category2 IN ('biography')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			</txp:article_custom>
			<txp:category title="1" />
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.0005488395690918): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('projects') or Category2 IN ('projects')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				[article 21]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 20]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 10]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 9]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
			</txp:article_custom>
			<txp:category title="1" />
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.00053000450134277): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('published-articles') or Category2 IN ('published-articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			</txp:article_custom>
			<txp:category title="1" />
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" status="4">
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.00055193901062012): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('testimonials') or Category2 IN ('testimonials')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				[article 25]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 24]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 23]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
				[article 22]
				<txp:permlink>
					<txp:title />
				</txp:permlink>
			</txp:article_custom>
		</txp:category_list>
		<txp:output_form form="enquiry_button" />
			[SQL (0.00019598007202148): select Form from txp_form where name='enquiry_button']
			[Form: enquiry_button]
			<txp:section link="1" title="1" name="rss">
				[SQL (0.0001060962677002): select title from txp_section where name='rss']
			</txp:section>
			<txp:section link="1" title="1" name="contact">
				[SQL (0.00010895729064941): select title from txp_section where name='contact']
			</txp:section>
</txp:if_article_list>
<txp:output_form form="footer" />
	[SQL (0.00015997886657715): select Form from txp_form where name='footer']
	[Form: footer]
	<txp:php>
	</txp:php>
	<txp:site_name />
[ ~~~ secondpass ~~~ ]
 -->

Last edited by decoderltd (2009-08-26 13:23:23)

Offline

#23 2009-08-26 20:40:31

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: List problem

Thanks decoderltd, but now you are not using the variable and if_variable tags, so I can’t see why those didn’t work. The code you are using now seems to work fine. What I’d really like to see is that you put my code example in your sidebar, and then post the tag trace of your page /garden-projects/. Sorry to have you go through all this trouble, but it’s the only way to find out what is wrong.

BTW, your site is showing ‘database unavailable’ at the moment.

Offline

#24 2009-08-27 09:26:39

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: List problem

No problem Els, I appreciate all your help.

I’ve put your code in and here’s the trace tag info:

<!-- Runtime:    0.0519 -->
<!-- Query time: 0.018787 -->
<!-- Queries: 47 -->
<!-- Memory: 4641Kb, <txp:title /> -->
<!-- txp tag trace: 
[SQL (0.0016589164733887): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.0008699893951416): select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (0.00039196014404297): select name,code,version from txp_plugin where status = 1 AND name='smd_lib']
[SQL (0.00034403800964355): select name from txp_section where `name` like 'garden-projects' limit 1]
[SQL (0.00016498565673828): select page, css from txp_section where name = 'garden-projects' limit 1]
[SQL (0.00015687942504883): select user_html from txp_page where name='garden-projects']
[Page: garden-projects]
<txp:output_form form="meta" />
	[SQL (0.00015687942504883): select Form from txp_form where name='meta']
	[Form: meta]
	<txp:if_section name="">
		[<txp:if_section name="">: false]
		<txp:if_individual_article>
			[<txp:if_individual_article>: false]
			<txp:article status="sticky" form="meta_dynamic" />
				[SQL (0.0004730224609375): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				[article 11]
				[SQL (0.00015521049499512): select Form from txp_form where name='meta_dynamic']
				[Form: meta_dynamic]
				<txp:if_article_list>
					[<txp:if_article_list>: true]
					<txp:if_category>
						[<txp:if_category>: false]
						<txp:if_section name="default">
							[<txp:if_section name="default">: false]
							<txp:section title="1" />
								[SQL (0.0001518726348877): select title from txp_section where name='garden-projects']
						</txp:if_section>
						<txp:site_name />
					</txp:if_category>
				</txp:if_article_list>
				<txp:if_individual_article>
					[<txp:if_individual_article>: false]
				</txp:if_individual_article>
				<txp:custom_field name="meta_desc" />
				<txp:keywords />
		</txp:if_individual_article>
	</txp:if_section>
	<txp:output_form form="meta_static" />
		[SQL (0.00017690658569336): select Form from txp_form where name='meta_static']
		[Form: meta_static]
		<txp:css n="reset" />
		<txp:css n="960" />
		<txp:css n="base" />
		<txp:css n="print" />
		<txp:feed_link flavor="atom" format="link" label="Atom" />
		<txp:feed_link flavor="rss" format="link" label="RSS" />
		<txp:rsd />
	<txp:output_form form="javascript_gridlayouts" />
		[SQL (0.00014495849609375): select Form from txp_form where name='javascript_gridlayouts']
		[Form: javascript_gridlayouts]
	<txp:output_form form="javascript_column" />
		[SQL (0.00012588500976562): select Form from txp_form where name='javascript_column']
		[Form: javascript_column]
	<txp:output_form form="javascript_cycle" />
		[SQL (0.00012493133544922): select Form from txp_form where name='javascript_cycle']
		[Form: javascript_cycle]
	<txp:if_section name="garden-projects">
		[<txp:if_section name="garden-projects">: true]
	</txp:if_section>
	<txp:if_section name=",profile">
		[<txp:if_section name=",profile">: false]
	</txp:if_section>
<txp:output_form form="header+nav" />
	[SQL (0.00013899803161621): select Form from txp_form where name='header+nav']
	[Form: header+nav]
	<txp:output_form form="header" />
		[SQL (0.00012397766113281): select Form from txp_form where name='header']
		[Form: header]
		<txp:image class="decoration" id="8" />
			[SQL (0.0001671314239502): select * from txp_image where id = 8 limit 1]
	<txp:output_form form="nav" />
		[SQL (0.00013494491577148): select Form from txp_form where name='nav']
		[Form: nav]
		<txp:section_list sections="profile,garden-projects,services,resources,garden-notebook,contact" wraptag="ul" break="li" include_default="1" default_title="Home" active_class="active"  />
			[SQL (0.00027298927307129): select name, title from txp_section where name in ('profile','garden-projects','services','resources','garden-notebook','contact') order by field(name, 'profile','garden-projects','services','resources','garden-notebook','contact')]
		<txp:feed_link>
		</txp:feed_link>
		<txp:output_form form="searchBox" />
			[SQL (0.0001671314239502): select Form from txp_form where name='searchBox']
			[Form: searchBox]
			<txp:search_input button="" label="" section="search" size="15" wraptag="" />
				[SQL (0.0001218318939209): select form from txp_form where `name` = 'search_input' limit 1]
<txp:if_individual_article>
	[<txp:if_individual_article>: false]
</txp:if_individual_article>
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:article_custom allowoverride="0" form="gbd_articleProject" limit="1" pgonly="0" section="garden-projects" sort="rand()" status="4" />
		[SQL (0.0016508102416992): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by rand() limit 0, 1]
		[article 9]
		[SQL (0.00023913383483887): select Form from txp_form where name='gbd_articleProject']
		[Form: gbd_articleProject]
		<txp:smd_if field="article_image" operator="isused">
			[<txp:smd_if field="article_image" operator="isused">: true]
			<txp:smd_gallery id="?article_image" wraptag="div" html_id="fade" class="pics" >
				[SQL (0.0010519027709961): 
			SELECT DISTINCT txp_image.name,txp_image.id,txp_image.alt,txp_image.caption,txp_image.category,txp_image.author,txp_image.date,txp_image.ext,txp_image.w,txp_image.h,txp_image.thumbnail, txp_category.title AS category_title
			FROM txp_image LEFT JOIN txp_category
			ON txp_image.category = txp_category.name
			WHERE (1=1 AND  (txp_image.id IN ('11','10','12')) ) ORDER BY txp_image.id asc
			LIMIT 0, 99999
		]
				<txp:image id="10" />
					[SQL (0.00025105476379395): select * from txp_image where id = 10 limit 1]
				<txp:image id="11" />
					[SQL (0.00016593933105469): select * from txp_image where id = 11 limit 1]
				<txp:image id="12" />
					[SQL (0.00015997886657715): select * from txp_image where id = 12 limit 1]
			</txp:smd_gallery>
		</txp:smd_if>
		<txp:title />
		<txp:body />
		<txp:output_form form="gbd_beforeAfter" />
			[SQL (0.00086307525634766): select Form from txp_form where name='gbd_beforeAfter']
			[Form: gbd_beforeAfter]
			<txp:smd_if field="before_after" operator="isused">
				[<txp:smd_if field="before_after" operator="isused">: true]
				<txp:smd_gallery id="?before_after" wraptag="div" html_id="fade" class="pics" >
					[SQL (0.00044798851013184): 
			SELECT DISTINCT txp_image.name,txp_image.id,txp_image.alt,txp_image.caption,txp_image.category,txp_image.author,txp_image.date,txp_image.ext,txp_image.w,txp_image.h,txp_image.thumbnail, txp_category.title AS category_title
			FROM txp_image LEFT JOIN txp_category
			ON txp_image.category = txp_category.name
			WHERE (1=1 AND  (txp_image.id IN ('35')) ) ORDER BY txp_image.id asc
			LIMIT 0, 99999
		]
					<txp:image id="35" />
						[SQL (0.00020694732666016): select * from txp_image where id = 35 limit 1]
				</txp:smd_gallery>
			</txp:smd_if>
		<txp:article_custom pgonly="0" section="garden-projects" form="gbd_articleSidebar_body" status="5" />
			[SQL (0.00046396255493164): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			[article 11]
			[SQL (0.00015807151794434): select Form from txp_form where name='gbd_articleSidebar_body']
			[Form: gbd_articleSidebar_body]
			<txp:body />
		<txp:article_custom pgonly="0" section="garden-projects" form="gbd_articleListing" status="4" />
			[SQL (0.0006110668182373): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
			[article 25]
			[SQL (0.00018501281738281): select Form from txp_form where name='gbd_articleListing']
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
					[SQL (0.00017499923706055): select title from txp_category where name='testimonials' and type='article']
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 24]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 23]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 22]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 21]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
					[SQL (0.00019598007202148): select title from txp_category where name='projects' and type='article']
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 20]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 10]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
			[article 9]
			[Form: gbd_articleListing]
			<txp:if_different>
				[<txp:if_different>: true]
				<txp:category1 title="1" this_section="1" />
				[<txp:if_different>: false]
			</txp:if_different>
			<txp:permlink>
				<txp:title />
			</txp:permlink>
		<txp:category_list>
			[SQL (0.0002739429473877): select name, title from txp_category where type = 'article' and name not in('default','root')   order by name ASC]
			<txp:section />
			<txp:category />
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li">
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00058507919311523): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('articles') or Category2 IN ('articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				</txp:article_custom>
			</txp:if_variable>
			<txp:section />
			<txp:category />
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li">
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00058889389038086): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('biography') or Category2 IN ('biography')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				</txp:article_custom>
			</txp:if_variable>
			<txp:section />
			<txp:category />
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li">
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00066208839416504): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('projects') or Category2 IN ('projects')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
					[article 21]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 20]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 10]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 9]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
				</txp:article_custom>
			</txp:if_variable>
			<txp:section />
			<txp:category />
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li">
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00064301490783691): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('published-articles') or Category2 IN ('published-articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				</txp:article_custom>
			</txp:if_variable>
			<txp:section />
			<txp:category />
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li">
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00066685676574707): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('testimonials') or Category2 IN ('testimonials')) and Section IN ('garden-projects') order by Posted desc limit 0, 10]
					[article 25]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 24]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 23]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 22]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
				</txp:article_custom>
			</txp:if_variable>
		</txp:category_list>
		<txp:output_form form="enquiry_button" />
			[SQL (0.00023388862609863): select Form from txp_form where name='enquiry_button']
			[Form: enquiry_button]
			<txp:section link="1" title="1" name="rss">
				[SQL (0.00012397766113281): select title from txp_section where name='rss']
			</txp:section>
			<txp:section link="1" title="1" name="contact">
				[SQL (0.00013089179992676): select title from txp_section where name='contact']
			</txp:section>
</txp:if_article_list>
<txp:output_form form="footer" />
	[SQL (0.00017189979553223): select Form from txp_form where name='footer']
	[Form: footer]
	<txp:php>
	</txp:php>
	<txp:site_name />
[ ~~~ secondpass ~~~ ]
 -->

Offline

Board footer

Powered by FluxBB