$conn = sql_domain();
$stmt = $conn->prepare('select count(*) as aantal from messages where receiver = :uid and message_read = "0000-00-00 00:00:00"');
$stmt->bindParam(':uid', $user_id);
$stmt->execute();
$result = $stmt->fetchAll();
if ($result[0]) {
$message_count = $result[0]['aantal'];
} else {
$message_count = 0;
}
//Set logged in timestamp
$stmt = $conn->prepare('update users set last_login = :date where id = :uid');
$stmt->bindParam(':uid', $user_id);
$stmt->bindParam(':date', date('Y-m-d H:i:s'));
$stmt->execute();
if (GetPlatformInfo('enable_login') == 0) {
session_destroy();
}
$stmt = $conn->prepare('select last_login from users');
$stmt->execute();
$logged_in = $stmt->fetchAll();
$count_active = 0;
foreach ($logged_in as $logged_in_) {
$last_active = strtotime($logged_in_['last_login']);
$time_for_active = strtotime(date('Y-m-d H:i:s')) - 180;
if ($last_active > $time_for_active) {
$counter++;
}
}
?>
<ul class="nav navbar-nav">
function CreateOpgg($username)
{
$username = explode(' ', $username);
$u_string = "http://" . GlobalGetRegion(GetPlatformInfo('region_select')) . ".op.gg/summoner/userName=";
foreach ($username as $u) {
$u_string .= $u . '+';
}
return $u_string;
}
