Template conditional for post count

[Mum]

I am wanting to show something to people who have made over 5 posts in the last 24 hours. For inside a template.

Can anyone help please?

[Boofo]

Try ths:

<if condition="$post['postcount'] > '5'">
do this
<else />
do that
</if>

or

<if condition="$post['postcount'] > '5'">
do this
</if>

[Mum]

Boofo - isn't that only going to do if they have more than 5 posts? I want to know if they ahve done 5 posts in the last 24 hours.

[Boofo]

Ahh, ok, my bad. You are going to have do do a plugin for that to figure out the time portion of it, I think.

[Mum]

How would i go about that? Is there somewhere else i ask?

[Boofo]

No, you're in the right place.

First of all, what templates are you wanting to do this in?

[Mum]

I have used https://vborg.vbsupport.ru/showthrea...t=subscription to make my own page. And i ahve 2 items on the page, i want to do an if else for it.

if more than 5 posts in the last 24 hours show this

else

show that

[akanevsky]

You could use a plugin with the following code:

PHP Code:

$getposts = $db->query_first("
    SELECT COUNT(*) as count 
    FROM " . TABLE_PREFIX . "post 
    WHERE userid = {$vbulletin->userinfo['userid']} 
    AND (" . TIMENOW . " - dateline) < 432000"
);
$show['something'] = ($getposts['count'] >= 5 ? true : false); 


Where 432000 is the number of seconds in 24 hours, and something can be replaced with anything you want, as long as it's a proper variable name. Which hook you choose depends on where it is to be used. Or, since you are using it in the "how to create your pages" hack, you can just place the code before $navbits = construct_navbits($navbits); in the php code.

And once you add the plugin (or the code into the page), you can use $show['something'] in your template.

[Mum]

The 'something' that i want to show is html code - how do i fix that? (sorry i am a noob at this side of things)

[akanevsky]

<if condition="$show['something']">your html code</if>

Or, if you need alternate code if $show['something'] is false, use this:

<if condition="$show['something']">your html code<else />alternate html code</if>