UBB.Developers Forums UBB.threads 7 Development Addons and Modifications [7.1] Forum Stats: Posts in the last 24 hours.

$smarty->assign("maxonline",$maxonline);

$query = "
	SELECT count(POST_ID)
	FROM {$config['TABLE_PREFIX']}POSTS
	WHERE POST_POSTED_TIME > ?
";

$sth = $dbh->do_placeholder_query( $query, array( $html->get_date() - 86400 ), __LINE__, __FILE__ );
list( $posts_24hrs ) = $dbh->fetch_array( $sth );

$smarty->assign("recentposts", $posts_24hrs );

$ubbt_lang['TOP_POSTERS'] = "Top Posters";

$ubbt_lang['POST_24HRS'] = "posts in the last 24hrs";

<b>{$posts}</b> <?php echo $ubbt_lang['POSTS'] ?>

<b>{$recentposts}</b> <?php echo $ubbt_lang['POST_24HRS'] ?>