$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; }