Quote:
Originally Posted by MajorFm.com
Any idea? i still get a blank spot..
|
Yeah, actually, it might be a small error in what I posted above - I notice a couple of of the quotation marks are doubles, when they ought to be singles (it was done in a hurry

);
The two to change are hilighted below (on the WHERE line) ;
Code:
{
$getstats_thread[isdeleted] = true;
}
eval('$stats_threads .= "' . fetch_template('forumhome_stats_thread') . '";');
}
// Who Regeistered Today - using Paul Marsden's code
require_once('./includes/functions_misc.php');
$cutoff = vbmktime(0, 0, 0, vbdate('m', $now. false, false), vbdate('d', $now. false, false), vbdate('Y', $now. false, false));
// $cutoff = $now - 86400 ; // Uncomment this line if you want a rolling last 24 hours.
$whousers = $DB_site->query_first('
SELECT COUNT(*) AS count
FROM ' . TABLE_PREFIX . 'user
WHERE joindate >= " .$cutoff. "
');
$newmembers = number_format($whousers['count']);
// Who Regeistered Today - using Paul Marsden's code
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###
eval('$vbpopup = "' . fetch_template('forumhome_vbpopup') . '";');
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('FORUMHOME') . '");');
Change them both to single quote marks ;
Code:
WHERE joindate >= ' .$cutoff. '