Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Manually sort sections in article_custom
I have such code:
<ul><txp:article_custom limit="5000" form="sitemap" sort="Section asc, Title asc" /></ul>It calls forms sitemap:
<txp:if_different>
</ul><h3><txp:section title="1" link="1" /></h3><ul>
</txp:if_different>
<li><txp:permlink><txp:title /></txp:permlink></li>The result you can see here
I want to sort sections output manully: articles,clinics,about – like this. But attr section can handle only on section. I tried to use chh_article_custom – it can see more than one entry in section attr. But it doesn’t sort articles by sections order in attr section :(
If it doesn’t clear yet – i want something like this: <txp:article_custom section="articles,clinics,about" /> and this should output firstly articles from articles sections, than clinincs, and by end – about sections.
Last edited by the_ghost (2008-01-14 08:48:32)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Manually sort sections in article_custom
why not just three article_custom tags?
Offline
#3 2008-01-14 09:02:43
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Manually sort sections in article_custom
<ul><txp:article_custom limit="5000" form="sitemap" sort="field(Section, 'articles','clinics','about'), Title asc" /></ul>Offline
#4 2008-01-14 09:52:41
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Manually sort sections in article_custom
Wow Mary, this is great! Why did you devs keep this a secret? ;)
Offline
#5 2008-01-14 10:24:35
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: Manually sort sections in article_custom
the_ghost wrote:
If it doesn’t clear yet – i want something like this:
<txp:article_custom section="articles,clinics,about" />and this should output firstly articles fromarticlessections, thanclinincs, and by end –aboutsections.
If I remember well this feature will be present in the next txp release (4.06) which I think will be out soon
Offline
#6 2008-01-14 10:33:15
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Manually sort sections in article_custom
It’s not really a dev secret, but a MySQL feature that’s apparently not very well known. It’s used in the core in a few places, and I use it in upm_image and upm_file.
Offline
#7 2008-01-14 16:25:28
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Manually sort sections in article_custom
Mary, thanks for explaining. I think I understand, is it the same (or similar) feature that is used in <txp:section_list sections="section3,section5,section1" />?
Offline
Re: Manually sort sections in article_custom
Mary – does this restricts to entered sections or it only sorts them in a desired way?
Hm..
Els – i think you are right with comparison.
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Manually sort sections in article_custom
does this restricts to entered sections or it only sorts them in a desired way?
It’s at the sort-attribute, as sort’s value. What would you think? ;)
It sorts the entered sections by that order.
Cheers!
Last edited by Gocom (2008-01-14 18:21:58)
Offline
Re: Manually sort sections in article_custom
Something is wrong :\ I tried entirely Mary’s example but it produces error:
tag_error <txp:article_custom limit="5000" form="sitemap" sort="field(Section, 'articles','clinics','about'), Title asc" /> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'articles\',\'clinics\',\'about\'), Title asc limit 0, 5000' at line 1
select *, unix_timestamp(Posted) as uPosted from uro_textpattern as textpattern where 1 and Status = 4 and Posted <= now() order by field(Section, \'articles\',\'clinics\',\'about\'), Title asc limit 0, 5000 on line 84Look here …
(Edit: changed bq. to bc. for better readability… -Els)
Last edited by els (2008-01-14 18:57:37)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
#11 2008-01-16 10:41:35
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Manually sort sections in article_custom
Yes Els.
Crud, sort gets slashed (forgot about that), so that won’t work.
Offline
Re: Manually sort sections in article_custom
Mary – is there way to solve this problem? I tried single quotes, double, slashes – nothing helps. :(
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Manually sort sections in article_custom
Mary – is there way to solve this problem? I tried single quotes, double, slashes – nothing helps. :(
Well, textpattern returns the string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote (‘), double quote (“), backslash (\) and NUL (the NULL byte).
So simply. No.
Cheers!
Offline
Re: Manually sort sections in article_custom
Any positive news if Mary’s #3 example can be done now?
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
#15 2009-01-12 01:28:17
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Manually sort sections in article_custom
Maybe smd_query can do it?
Offline