Place these in your 'functions.php' script if you wish.
Basically, this will give you some very handy timestamps, relative to the current viewer.... espeically good for statistics, relative to the current users time/date.
PHP Code:
// Get datelines, relative to user
// ********
// user local time
$user_time = mktime(date("H"),date("i"),date("s") + ($bbuserinfo[timezoneoffset] * 3600), date("m"), date("d"), date("Y"));
// today (start of day) dateline, relative to user
$ut_sod = (($user_time - (date("H", $user_time) * 3600)) - (date("i", $user_time) * 60)) - date("s", $user_time);
// this month (start of month) dateline, relative to user
$ut_som = mktime(0,0,0, date("m", $user_time), 1, date("Y", $user_time));
// this year (start of year) dateline, relative to user
$ut_soy = mktime(0,0,0,1,1, date("Y", $user_time));
// last year (start of last year) dateline, relative to user
$ut_soly = mktime(0,0,0,1,1, date("Y", $user_time)-1);
For example :
PHP Code:
// Number Of Posts So Far Today
// ********
$getpoststoday = $DB_forum->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$ut_sod'");
$postsToday = number_format($getpoststoday[count]);
// Number Of Posts Last Year
// ********
$getpostsLastYear = $DB_forum->query_first("SELECT count(*) AS count FROM post WHERE dateline<'$ut_soy' AND dateline>='$ut_soly'");
$postsLastYear = number_format($getpostsLastYear[count]);
.... possibilities endless.
09-07-2002, 04:27 PM
Handy Time Pieces
Linear Mode
