sql_fetchrow($db->sql_query("SELECT Version_Num FROM $prefix"._config.""));
list($lastuser) = $db->sql_fetchrow($db->sql_query("SELECT username FROM $user_prefix"._users." ORDER BY user_id DESC LIMIT 0,1"));
list($newid) = $db->sql_fetchrow($db->sql_query("SELECT user_id FROM $user_prefix"._users." WHERE username='$lastuser'"));
list($numrows) = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) FROM ".$user_prefix."_users"));
$memres = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest=0");
$member_online_num = $db->sql_numrows($memres);
$who_online_now = "";
if ($Show_Whos_Online == 1) {
for($i = 1; $i <= $member_online_num; $i++) {
$session = $db->sql_fetchrow($memres);
list($username, $user_color_gc) = $db->sql_fetchrow($db->sql_query("SELECT username, user_color_gc FROM $user_prefix"._users." WHERE username='$session[uname]'"));
if(!empty($user_color_gc)) $username = UsernameColor($user_color_gc, $username);
else $username = $session[uname];
list($uid) = $db->sql_fetchrow($db->sql_query("SELECT user_id FROM $user_prefix"._users." WHERE username='$session[uname]'"));
if (isset($session["guest"]) and $session["guest"] == 0) {
if ($i < 10) {
$who_online_now .= "![](\"blocks/user_online2.gif\")
$username
\n";
} else {
$who_online_now .= "$username
\n";
}
}
}
}
$Today = getdate();
//Formatting Current Date
$month = $Today['month'];
$mday = $Today['mday'];
$year = $Today['year'];
$yright = "yright";
//Formatting Previous Date
$pmonth = $Today['month'];
$pmday = $Today['mday'];
$pmday = $mday-1;
$pyear = $Today['year'];
//Month conversion into numeric mode
if ($pmonth=="January") { $pmonth=1; } else
if ($pmonth=="February") { $pmonth=2; } else
if ($pmonth=="March") { $pmonth=3; } else
if ($pmonth=="April") { $pmonth=4; } else
if ($pmonth=="May") { $pmonth=5; } else
if ($pmonth=="June") { $pmonth=6; } else
if ($pmonth=="July") { $pmonth=7; } else
if ($pmonth=="August") { $pmonth=8; } else
if ($pmonth=="September") { $pmonth=9; } else
if ($pmonth=="October") { $pmonth=10; } else
if ($pmonth=="November") { $pmonth=11; } else
if ($pmonth=="December") { $pmonth=12; };
$test = mktime (0,0,0,$pmonth,$pmday,$pyear,1);
//Creating SQL parameter
$curDate2 = "%".$month[0].$month[1].$month[2]."%".$mday."%".$year."%";
$preday = strftime ("%d",$test);
$premonth = strftime ("%B",$test);
$preyear = strftime ("%Y",$test);
$cop = "cop";
$curDateP = "%".$premonth[0].$premonth[1].$premonth[2]."%".$preday."%".$preyear."%";
//Executing SQL Today
list($userCount) = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDate2'"));
//end
//Executing SQL Yesterday
list($userCount2) = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDateP'"));
//end
list($guest_online_num) = $db->sql_fetchrow($db->sql_query("SELECT COUNT(uname) FROM ".$prefix."_session WHERE guest=1"));
if ($Show_Hits == 1) {
//Count total hits
list($total_hits) = $db->sql_fetchrow($db->sql_query("SELECT count FROM ".$prefix."_counter WHERE type='total' AND var='hits'"));
//Today hits
list($today_hits) = $db->sql_fetchrow($db->sql_query("SELECT hits FROM ".$prefix."_stats_date WHERE year='$year' AND month='$pmonth' AND date='$mday'"));
}
$who_online_num = $guest_online_num + $member_online_num;
$content .= "";
?>