Handy Time Pieces

[tHE DSS]

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.


// 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 :


// 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.

[JulianD]

Thanks man... This could be usefull for some projects I'm working on!