[Dave]

You have to use query_first if you want it to fetch the first row.

$start = TIMENOW - 3600 * 24; 

$q = $vbulletin->db->query_first("SELECT COUNT(*) AS postcount FROM " . TABLE_PREFIX . "post WHERE dateline > " . $start);
$dailypostcount = $q['postcount'];