[Nullifi3d]

White Snake, your codes have several errors. As Boofo said: the correct code would be $db->query_first, but it depends on the hook you're inserting this code into.

The following should work with most hooks:

PHP Code:

$datecut = TIMENOW - 86400;
$postcount = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "post WHERE userid = '{$vbulletin->userinfo['userid']}' AND dateline >= '$datecut'"); 


Display the count in a template with $postcount[total]