none of em worked, hmmmm =/ what else can be the error, well, i think this one of this 2 should work:
PHP Code:
$cutoff=time()-86400;
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo[$userid]."' AND dateline >=".$cutoff."");
or
PHP Code:
$cutoff=time()-86400;
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo['$userid']."' AND dateline >=".$cutoff."");