Unix Time

Posted: Sun Apr 27, 2003 6:59 pm

Hello,

I've added a monthly/yearly stat mod to my forum. The mod work fine except the stat for the year is 1969. I need to fix this to show 2003. What I don't know is where the Unix Time is being called from. This is the code that grab the Unix Time

Code:

$sql = "SELECT YEAR(FROM_UNIXTIME(user_regdate)) as aar, MONTH(FROM_UNIXTIME(user_regdate)) as mnd, COUNT(*) AS ant
FROM " . USERS_TABLE . "
WHERE (user_id <> " . ANONYMOUS . " )
GROUP BY YEAR(FROM_UNIXTIME(user_regdate)), MONTH(FROM_UNIXTIME(user_regdate))
ORDER BY user_regdate";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Couldn\'t retrieve users data', '', __LINE__, __FILE__, $sql);
}

$user_count = $db->sql_numrows($result);
$user_data = $db->sql_fetchrowset($result);

for ($i = 0; $i < $user_count; $i=$i+$k)
{
$class = ( !($i+1 % 2) ) ? $theme['td_class2'] : $theme['td_class1'];

$year = $user_data[$i]['aar'];
$k = 0;
for ($j = 0; $j < 12; $j++)
{
   $m[$j+1] = 0;
}
for ($j = 0; $j < 12; $j++)
{
   if ($year == $user_data[$i+$j]['aar'])
   {
      $month = $user_data[$i+$j]['mnd'];
      $m[$month] = $user_data[$i+$j]['ant'];
      $k = $k + 1;
   }
}
$template->assign_block_vars('signup', array(
   'CLASS' => $class,
   'YEAR' => $year,
   'M01' => $m[1],
   'M02' => $m[2],
   'M03' => $m[3],
   'M04' => $m[4],
   'M05' => $m[5],
   'M06' => $m[6],
   'M07' => $m[7],
   'M08' => $m[8],
   'M09' => $m[9],
   'M10' => $m[10],
   'M11' => $m[11],
   'M12' => $m[12])
);
}

$template->assign_vars(array(
'L_SIGNUPBYMONTH' => $lang['Signup_month'],
'L_YEAR' => $lang['Year'],
'L_MONTH' => $lang['Month'],
'L_NUMBER' => $lang['Number'],
'L_JAN' => $lang['Month_jan'],
'L_FEB' => $lang['Month_feb'],
'L_MAR' => $lang['Month_mar'],
'L_APR' => $lang['Month_apr'],
'L_MAY' => $lang['Month_may'],
'L_JUN' => $lang['Month_jun'],
'L_JUL' => $lang['Month_jul'],
'L_AUG' => $lang['Month_aug'],
'L_SEP' => $lang['Month_sep'],
'L_OCT' => $lang['Month_oct'],
'L_NOV' => $lang['Month_nov'],
'L_DEC' => $lang['Month_dec'])
);

What do I need to edit in the code or myphpadmin?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

He uses a MySQL function FROM_UNIXTIME. Read up on it here http://www.mysql.com/doc/en/Date_and_time_functions.html