aks_article : Extended article_custom tag

photonomad · 2014-04-30 00:58:33

Thank you for your reply, makss. I went back in and tried it again and it is working as it should. Now I see that my browser’s memory cache isn’t refreshing my custom article list in the write tab. (I’m using aks_custom in a page form that is displayed within the write page txptip ) After clearing the cache, articles are correctly sorted by position. I’m sorry to have bothered you with this question!

whocarez · 2017-04-13 16:36:04

Hello, has someone get this plugin working together with textpattern 4.6.2?
<txp:aks_article sort="custom_7 desc" wraptag="article" break="" limit="1" offset="0" section="article" form="some_form" where="DATEDIFF(NOW(),Posted) <= 7" />

Has no output and in debug mode I don’t see any notice or warning. The same code works fine in 4.5.7.

Last edited by whocarez (2017-04-13 16:44:04)

whocarez · 2017-04-13 20:27:22

This problem is also related to the Textpattern Error Unknown column 'NULLDATETIME'

if (!$expired) {	$time .= " and (now() <= Expires or Expires IS NULL)"; }

instead of

if (!$expired) {	$time .= " and (now() <= Expires or Expires = ".NULLDATETIME.")"; }

solves the problem.

whocarez · 2017-04-13 21:08:00

@makss
A nice feature would be to exclude articles by article id and also an export of the listed article ids into a variable to use it in a second run for excluding articles.

makss · 2017-04-15 07:35:14

@whocarez
Thanks for the bug report, in the near future I will fix it and add new features.

whocarez · 2017-04-15 17:22:31

ok, thank you, waiting for a new version :-)

makss · 2017-04-17 11:05:59

New version aks_article v0.3.1:

Txp 4.6 fix and Using SQL caching capabilities. Txp 4.6+
Added exclude attribute
Added aks_article_ids Txp variable – This is the ID of the articles that were displayed.

Show 3 random articles:
<txp:aks_article form="some_form" limit="3" sort="rand()" />
.
Show the rest of the article, excluding those already shown:
<txp:aks_article form="some_form" exclude='<txp:variable name="aks_article_ids"/>' />

Last edited by makss (2017-04-17 11:23:59)

whocarez · 2017-04-17 11:58:07

thanks for this new version …

Got this error message in debug with now article shown after removing the ‘@’ before aks_article_doArticles :


Tag error: <txp:aks_article sort="custom_7 desc" wraptag="" break="" offset="1" limit="1" section="article" form="default_others_article" where="DATEDIFF(NOW(),Posted) <= 7" exclude="<txp:variable name='aks_article_ids' />" /> ->  Notice: Undefined offset: 1 while parsing form None on page default

textpattern/lib/txplib_misc.php(1782) : eval()'d code:39 aks_article_doArticles()
aks_article()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:69 processTags()
adi_if_content()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_publish.php:463 processTags()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:83 parse()

The freshest article in this test environment is 11 days old.
In my form I build a top 3 of read articles with the help of aks_article, adi_if_content and dzd_counter_view. So aks_article should look first within the articles of the last week. If there is no article, than take the articles within the last month, if there is also no result take these within the last year. That’s the first run.
In the second run should aks_article look for the second most read article within the last week, month or year excluding the top 1 article from the first run. And in the end the third run, exclude the top 1 and top 2 articles. Maybe it is a little bit to complicated, but sometimes I do nothing on this website for more than a month, but I want to have a top 3 also in this time. But I cannot take the top 3 from the last year, because in this case the fresher ones are ignored, because of a lower read number.
Under some circumstances the the positions of some articles are the same, so one article can be doubled in this top 3, that’s why I want to exclude the earlier listed ones.
So, thats the “problem” in short.

Last edited by whocarez (2017-04-17 11:58:52)

makss · 2017-04-17 12:04:31

exclude="<txp:variable name='aks_article_ids' />" – Embedded tag, single quotes are needed: exclude='<txp:variable name="aks_article_ids" />'

whocarez · 2017-04-17 12:15:13

hm, I still get no output or better only output for the top 1 and the top 2

Tag error: <txp:aks_article sort="custom_7 desc" wraptag="article" break="" limit="1" section="article" form="default_first_article" where="DATEDIFF(NOW(),Posted) <= 7" /> ->  Notice: Undefined offset: 1 while parsing form None on page default

textpattern/lib/txplib_misc.php(1782) : eval()'d code:39 aks_article_doArticles()
aks_article()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:69 processTags()
adi_if_content()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_publish.php:463 processTags()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:83 parse()

Tag error: <txp:aks_article sort="custom_7 desc" wraptag="" break="" offset="1" limit="1" section="article" form="default_others_article" where="DATEDIFF(NOW(),Posted) <= 7" exclude='<txp:variable name="aks_article_ids" />' /> ->  Notice: Undefined offset: 1 while parsing form None on page default

textpattern/lib/txplib_misc.php(1782) : eval()'d code:39 aks_article_doArticles()
aks_article()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:69 processTags()
adi_if_content()
textpattern/vendors/Textpattern/Tag/Registry.php:83 call_user_func()
textpattern/lib/txplib_publish.php:514 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_publish.php:463 processTags()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:83 parse()

and in the source code of the rendered page I see this instead of the third article:
<txp:aks_article sort="custom_7 desc" wraptag="" break="" offset="2" limit="1" section="article" form="default_others_article" where="DATEDIFF(NOW(),Posted) <= 7" exclude='4609' />

Last edited by whocarez (2017-04-17 12:17:58)

makss · 2017-04-17 17:32:30

whocarez wrote #305367:

In my form I build a top 3 of read articles with the help of aks_article, adi_if_content and dzd_counter_view. So aks_article should look first within the articles of the last week. If there is no article, than take the articles within the last month, if there is also no result take these within the last year. That’s the first run.
In the second run should aks_article look for the second most read article within the last week, month or year excluding the top 1 article from the first run. And in the end the third run, exclude the top 1 and top 2 articles. Maybe it is a little bit to complicated, but sometimes I do nothing on this website for more than a month, but I want to have a top 3 also in this time. But I cannot take the top 3 from the last year, because in this case the fresher ones are ignored, because of a lower read number.
Under some circumstances the the positions of some articles are the same, so one article can be doubled in this top 3, that’s why I want to exclude the earlier listed ones.
So, thats the “problem” in short.

Can solve this problem using the IF operator in MySQL.

The first Top range is last week: DATEDIFF(NOW(),Posted)<=7 – Let’s set this range to 0.
Second Top Month: DATEDIFF(NOW(),Posted)<=30 – Assign the value 1
Third Annual Top: DATEDIFF(NOW(),Posted)<=365 – value 2
All the rest, more than one year – value 3

Now we need to sort by the range number (the smaller the number, the more priority), and then by the number of views (custom_7 desc).

Outputs the Top 3 in one block:
<txp:aks_article sort="IF(DATEDIFF(NOW(),Posted)<=7, 0, IF(DATEDIFF(NOW(),Posted)<=30, 1, IF(DATEDIFF(NOW(),Posted)<=365, 2, 3))), custom_7 desc" wraptag="" break="" section="article" form="default_others_article" limit="3" />

If you want to display articles from the Top in different places of the template, then use the Txp variables:

Set variables:
<txp:aks_article sort="IF(DATEDIFF(NOW(),Posted)<=7, 0, IF(DATEDIFF(NOW(),Posted)<=30, 1, IF(DATEDIFF(NOW(),Posted)<=365, 2, 3))), custom_7 desc" section="article"  limit="3">
	<txp:variable name='top_result_<txp:aks_article_count />'>
		<txp:aks_article_count />: <txp:title />
	</txp:variable>
</txp:aks_article>
...
Show first: <txp:variable name="top_result_1" />
Second: <txp:variable name="top_result_2" />
The third result: <txp:variable name="top_result_3" />

whocarez · 2017-04-18 11:51:28

Wow, impressive!! That simplifies the code considerably. Big thanks!

So for now I use it like that, because the first article uses another form for title, article_image etc.


<txp:aks_article sort="IF(DATEDIFF(NOW(),Posted)<=7, 0, IF(DATEDIFF(NOW(),Posted)<=30, 1, IF(DATEDIFF(NOW(),Posted)<=365, 2, 3))), custom_7 desc" section="article"  limit="3">
	<txp:variable name='top_result_<txp:aks_article_count />'>
		<txp:article_id />
	</txp:variable>
</txp:aks_article>

            <div class="general-art item-actual">
<!-- Nr.1 -->
                <txp:aks_article id='<txp:variable name="top_result_1" />' form="default_first_article" />
            </div>

            <div class="others-art item-actual">
<!-- Nr.2 -->
                <txp:aks_article id='<txp:variable name="top_result_2" />' form="default_others_article" />
<!-- Nr.3 -->
                <txp:aks_article id='<txp:variable name="top_result_3" />' form="default_others_article" />
            </div>

Textpattern CMS

Textpattern CMS support forum

#25 2014-04-30 00:58:33

Re: aks_article : Extended article_custom tag

#26 2017-04-13 16:36:04

Re: aks_article : Extended article_custom tag

#27 2017-04-13 20:27:22

Re: aks_article : Extended article_custom tag

#28 2017-04-13 21:08:00

Re: aks_article : Extended article_custom tag

#29 2017-04-15 07:35:14

Re: aks_article : Extended article_custom tag

#30 2017-04-15 17:22:31

Re: aks_article : Extended article_custom tag

#31 2017-04-17 11:05:59

Re: aks_article : Extended article_custom tag

#32 2017-04-17 11:58:07

Re: aks_article : Extended article_custom tag

#33 2017-04-17 12:04:31

Re: aks_article : Extended article_custom tag

#34 2017-04-17 12:15:13

Re: aks_article : Extended article_custom tag

#35 2017-04-17 17:32:30

Re: aks_article : Extended article_custom tag

whocarez wrote #305367:

#36 2017-04-18 11:51:28

Re: aks_article : Extended article_custom tag

Board footer