Only Count Number of Future Articles?

kevinpotts · 2011-05-20 03:34:42

Building a calendar-based website. Each event is assigned to a category. In the left nav, I have a list of categories with a count of events respective to that category.

For most applications, something like mdm_count is perfect. However, I only want to count FUTURE events. I just need to output the number.

I’ll take any clues you guys might have.

els · 2011-05-20 09:30:37

rah_function can probably do that.

Gocom · 2011-05-20 12:47:54

Els wrote:

rah_function can probably do that.

Yes it can, so probably could smd_query. With rah_function it should be relatively simple, something along the lines:

<txp:rah_function call="safe_count" table="textpattern" where='Status=4 and Posted > now() and (Category1="<txp:category />" or Category2="<txp:category />")' />

If the code is used in public scope and the category is user-changeable, basically taken directly from the requested URL (as category tag would do in public scope, outside category listings) you would need to additionally escape the input to prevent external injections. This could be done by using doSlash(), same code otherwise:

<txp:rah_function call="safe_count" table="textpattern" where='Status=4 and Posted > now() and (Category1="<txp:rah_function call="doSlash"><txp:category /></txp:rah_function>" or Category2="<txp:rah_function call="doSlash"><txp:category /></txp:rah_function>")' />

Last edited by Gocom (2011-05-20 13:33:10)

kevinpotts · 2011-05-20 20:57:45

rah_function code worked amazingly, perfectly well. Thank you so much.

Textpattern CMS

Textpattern CMS support forum

#1 2011-05-20 03:34:42

Only Count Number of Future Articles?

#2 2011-05-20 09:30:37

Re: Only Count Number of Future Articles?

#3 2011-05-20 12:47:54

Re: Only Count Number of Future Articles?

#4 2011-05-20 20:57:45

Re: Only Count Number of Future Articles?

Board footer