query("SELECT * FROM `$dbname`.`job_check`")->fetchAll(PDO::FETCH_UNIQUE|PDO::FETCH_ASSOC); if((time() - $job_check['last_update']['timestamp']) < 259200 && !isset($_SESSION[$rspathhex.'upinfomsg'])) { if(!isset($err_msg)) { $err_msg = ''.sprintf($lang['upinf2'], date("Y-m-d H:i",$job_check['last_update']['timestamp']), '', ''); $err_lvl = 1; $_SESSION[$rspathhex.'upinfomsg'] = 1; } } if(isset($_POST['username'])) { $_GET["search"] = $_POST['usersuche']; $_GET["seite"] = 1; } $filter = $searchstring = NULL; if(isset($_GET["search"]) && $_GET["search"] != '') { $getstring = htmlspecialchars($_GET['search']); } if(isset($getstring) && strstr($getstring, 'filter:excepted:')) { if(str_replace('filter:excepted:','',$getstring)!='') { $searchstring = str_replace('filter:excepted:','',$getstring); } $filter .= " AND `except` IN ('2','3')"; } elseif(isset($getstring) && strstr($getstring, 'filter:nonexcepted:')) { if(str_replace('filter:nonexcepted:','',$getstring)!='') { $searchstring = str_replace('filter:nonexcepted:','',$getstring); } $filter .= " AND `except` IN ('0','1')"; } else { if(isset($getstring)) { $searchstring = $getstring; } else { $searchstring = ''; } if($cfg['stats_show_excepted_clients_switch'] == 0) { $filter .= " AND `except` IN ('0','1')"; } } if(isset($getstring) && strstr($getstring, 'filter:online:')) { $searchstring = preg_replace('/filter\:online\:/','',$searchstring); $filter .= " AND `online`='1'"; } elseif(isset($getstring) && strstr($getstring, 'filter:nononline:')) { $searchstring = preg_replace('/filter\:nononline\:/','',$searchstring); $filter .= " AND `online`='0'"; } if(isset($getstring) && strstr($getstring, 'filter:actualgroup:')) { preg_match('/filter\:actualgroup\:(.*)\:/',$searchstring,$grpvalue); $searchstring = preg_replace('/filter\:actualgroup\:(.*)\:/','',$searchstring); if(isset($grpvalue[1])) $filter .= " AND `grpid`='".$grpvalue[1]."'"; } if(isset($getstring) && strstr($getstring, 'filter:country:')) { preg_match('/filter\:country\:(.*)\:/',$searchstring,$country); $searchstring = preg_replace('/filter\:country\:(.*)\:/','',$searchstring); if(isset($country[1])) $filter .= " AND `nation`='".$country[1]."'"; } if(isset($getstring) && strstr($getstring, 'filter:lastseen:')) { preg_match('/filter\:lastseen\:(.*)\:(.*)\:/',$searchstring,$seenvalue); $searchstring = preg_replace('/filter\:lastseen\:(.*)\:(.*)\:/','',$searchstring); if(isset($seenvalue[2]) && is_numeric($seenvalue[2])) { $lastseen = $seenvalue[2]; } elseif(isset($seenvalue[2])) { $r = date_parse_from_format("Y-m-d H-i",$seenvalue[2]); $lastseen = mktime($r['hour'], $r['minute'], $r['second'], $r['month'], $r['day'], $r['year']); } else { $lastseen = 0; } if(isset($seenvalue[1]) && ($seenvalue[1] == '<' || $seenvalue[1] == '<')) { $operator = '<'; } elseif(isset($seenvalue[1]) && ($seenvalue[1] == '>' || $seenvalue[1] == '>')) { $operator = '>'; } elseif(isset($seenvalue[1]) && $seenvalue[1] == '!=') { $operator = '!='; } else { $operator = '='; } $filter .= " AND `lastseen`".$operator."'".$lastseen."'"; } $searchstring = htmlspecialchars_decode($searchstring); if(isset($getstring)) { $dbdata_full = $mysqlcon->prepare("SELECT COUNT(*) FROM `$dbname`.`user` WHERE (`uuid` LIKE :searchvalue OR `cldbid` LIKE :searchvalue OR `name` LIKE :searchvalue)$filter"); $dbdata_full->bindValue(':searchvalue', '%'.$searchstring.'%', PDO::PARAM_STR); $dbdata_full->execute(); $sumentries = $dbdata_full->fetch(PDO::FETCH_NUM); $getstring = rawurlencode($getstring); } else { $getstring = ''; $sumentries = $mysqlcon->query("SELECT COUNT(*) FROM `$dbname`.`user`")->fetch(PDO::FETCH_NUM); } if(!isset($_GET["seite"])) { $seite = 1; } else { $_GET["seite"] = preg_replace('/\D/', '', $_GET["seite"]); if($_GET["seite"] > 0) { $seite = $_GET["seite"]; } else { $seite = 1; } } $adminlogin = 0; $sortarr = array_flip(array("active","cldbid","count","grpid","grpsince","idle","lastseen","name","nation","nextup","platform","rank","uuid","version","count_day","count_week","count_month","idle_day","idle_week","idle_month","active_day","active_week","active_month")); if(isset($_GET['sort']) && isset($sortarr[$_GET['sort']])) { $keysort = $_GET['sort']; } else { $keysort = $cfg['stats_column_default_sort']; } if(isset($_GET['order']) && $_GET['order'] == 'desc') { $keyorder = 'desc'; } elseif(isset($_GET['order']) && $_GET['order'] == 'asc') { $keyorder = 'asc'; } else { $keyorder = $cfg['stats_column_default_order']; } if(isset($_GET['admin'])) { if(hash_equals($_SESSION[$rspathhex.'username'], $cfg['webinterface_user']) && hash_equals($_SESSION[$rspathhex.'password'], $cfg['webinterface_pass']) && hash_equals($_SESSION[$rspathhex.'clientip'], getclientip())) { $adminlogin = 1; } } if(!isset($_GET["user"])) { $user_pro_seite = 25; } elseif($_GET['user'] == "all") { if($sumentries[0] > 1000) { $user_pro_seite = 1000; } else { $user_pro_seite = $sumentries[0]; } } else { $_GET["user"] = preg_replace('/\D/', '', $_GET["user"]); if($_GET["user"] > 1000) { $user_pro_seite = 1000; } elseif($_GET["user"] > 0) { $user_pro_seite = $_GET["user"]; } else { $user_pro_seite = 25; } } ?> TSN Ranksystem - ts-ranksystem.com '; } switch(basename($_SERVER['SCRIPT_NAME'])) { case "index.php": ?> '; } if(isset($cfg['stats_show_site_navigation_switch']) && $cfg['stats_show_site_navigation_switch'] == 0) { ?>
'; } ?>