0k, now try this:
PHP Code:
$cutoff=time()-86400;
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo[$userid]."' AND dateline >= $cutoff");
if that one doesnt do the trick, try this one:
PHP Code:
$cutoff=time()-86400;
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo['$userid']."' AND dateline >= $cutoff");