Daily Activity

[grey_goose]

So I whipped this up a plugin which spits out the total new threads, new posts, and new social group message counts -- which all works fine and dandy.

Does anyone know the URL/link for searching for new threads? Not getdaily, because I don't want to include 'bumps' or old threads with new replies. I've searched high and low and every time the question is asked it seems to get answered with ways that include old threads.

Also, including the plugin code just in case anyone else wanted to display this stuff and have vb:raw variables to drop in.

• {vb:raw newactivity.threadcount}
• {vb:raw newactivity.postcount}
• {vb:raw newactivity.groupmessagecount}

PHP Code:

if (THIS_SCRIPT == 'index')
{
$newactivity = $db->query_read("SELECT COUNT(post.dateline) AS postcount, COUNT(thread.dateline) AS threadcount, COUNT(groupmessage.dateline) AS groupmessagecount FROM post JOIN postlog ON (postlog.postid = post.postid) LEFT JOIN thread ON (thread.dateline = postlog.dateline) LEFT JOIN groupmessage ON (groupmessage.dateline = postlog.dateline) WHERE UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 DAY)) <= postlog.dateline"); 

$newactivity = $db->fetch_array($newactivity);

vB_Template::preRegister('FORUMHOME', array(
'newactivity' => $newactivity
));
}