function Get_Player_Stats_ByWorld($playerid, $worldid) { // Get ID of players whose names partially match the search parameter Use_DB("xray"); $sql_PlayerStats = "SELECT * FROM `x-stats`"; $sql_PlayerStats .= " WHERE `playerid` = {$playerid} AND `worldid` = {$worldid}"; //echo "SQL QUERY: <BR>" . $sql_PlayerIDexists . "<BR>"; $res_PlayerStats = mysql_query($sql_PlayerStats) or die("Get_Player_Stats_ByWorld: " . mysql_error()); while (($PlayerStatsArray[] = mysql_fetch_assoc($res_PlayerStats)) || array_pop($PlayerStatsArray)) { } if (mysql_num_rows($res_PlayerStats) > 0) { return $PlayerStatsArray; } else { return false; } }
function Add_NewBreaks() { // Detect datetime of most recent break // This prevents omitting any breaks that occurr during this script $datetime_now = new DateTime(); $sql_getdate = ""; foreach ($GLOBALS['worlds'] as $world_index => $world_item) { if ($world_index > 0) { $sql_getdate .= " UNION ALL"; } $sql_getdate .= " SELECT '" . $world_item["worldid"] . "' AS worldid, MAX(date) AS latest_break_date"; $sql_getdate .= " FROM `lb-" . $world_item["worldname"] . "`"; $sql_getdate .= " WHERE replaced = 1"; $sql_getdate .= " OR replaced = 15"; $sql_getdate .= " OR replaced = 14"; $sql_getdate .= " OR replaced = 56"; $sql_getdate .= " OR replaced = 25"; $sql_getdate .= " OR replaced = 48"; $sql_getdate .= " AND type = 0"; } //echo "SQL_QUERY: <br>". $sql_getdate . "<br>"; $res_getdate = mysql_query($sql_getdate) or die("World-LatestBreakDate: " . mysql_error()); while (($LatestDateArray[] = mysql_fetch_assoc($res_getdate)) || array_pop($LatestDateArray)) { } //echo "LATEST_DATE_ARRAY: <BR>"; print_r($LatestDateArray); echo "<BR>"; foreach ($GLOBALS['worlds'] as $world_index => $world_item) { echo "====================================================<br>"; echo "Processing World [" . $world_item["worldalias"] . "]<BR>"; // Check for latest date entry in X-Stats Table echo "...This world was last checked on: " . $world_item["last_date_processed"] . "<BR>"; //TODO: Change format to TIME AGO $found_break = false; foreach ($LatestDateArray as $wdate_item) { //echo "WORLD ID COMPARE [". $wdate_item["worldid"] . "] vs [" . $world_item["worldid"] . "]<BR>"; if ($wdate_item["worldid"] == $world_item["worldid"]) { $found_break = true; $latest_break_date = $wdate_item["latest_break_date"]; if ($latest_break_date == "") { $wdate_item["latest_break_date"] = "NEVER (No logs)"; $latest_break_date = $datetime_now->format('Y-m-d H:i:s'); } echo "...The last break in this world occurred on: " . $wdate_item["latest_break_date"] . "<BR>"; } } if (!$found_break) { echo "...This world has no mining history. Aborting scan.<br>"; } if ($latest_break_date == $world_item["last_date_processed"]) { echo "...There is no new information to process in this world. Skipping scan.<BR>"; } else { if ($found_break) { // Get ALL new breaks after latest_date_processed echo "...Beginning User Scan, Please Be Patient..."; Use_DB("xray"); $sql_newbreaks = "INSERT INTO `x-stats` "; $sql_newbreaks .= " (`playerid`, `worldid`, `diamond_count`, `gold_count`, `lapis_count`, `mossy_count`, `iron_count`, `stone_count`) "; $sql_newbreaks .= " SELECT p.playerid, '" . $world_item["worldid"] . "', IFNULL(diamond_info.cnt,0) AS diamond_count, IFNULL(gold_info.cnt,0) AS gold_count, "; $sql_newbreaks .= " \tIFNULL(lapis_info.cnt,0) AS lapis_count, IFNULL(mossy_info.cnt,0) AS mossy_count, IFNUlL(iron_info.cnt,0) AS iron_count, IFNULL(stone_info.cnt,0) AS stone_count"; $sql_newbreaks .= " FROM `lb-players`"; $sql_newbreaks .= " AS p"; $sql_newbreaks .= " INNER JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 1 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS stone_info ON p.playerid = stone_info.playerid"; $sql_newbreaks .= " LEFT JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 56 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS diamond_info ON p.playerid = diamond_info.playerid"; $sql_newbreaks .= " LEFT JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 14 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS gold_info ON p.playerid = gold_info.playerid"; $sql_newbreaks .= " LEFT JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 15 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS iron_info ON p.playerid = iron_info.playerid"; $sql_newbreaks .= " LEFT JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 48 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS mossy_info ON p.playerid = mossy_info.playerid"; $sql_newbreaks .= " LEFT JOIN (SELECT playerid, count(playerid) AS cnt FROM `lb-" . $world_item["worldname"] . "` "; $sql_newbreaks .= " \tWHERE ((date BETWEEN '" . $world_item["last_date_processed"] . "' AND '" . $latest_break_date . "') AND replaced = 21 AND type = 0 AND y <= 50) "; $sql_newbreaks .= " \tGROUP BY playerid) AS lapis_info ON p.playerid = lapis_info.playerid"; $sql_newbreaks .= " GROUP BY p.playerid"; $sql_newbreaks .= " ON DUPLICATE KEY UPDATE `diamond_count`=`diamond_count`+VALUES(diamond_count), `gold_count`=`gold_count`+VALUES(gold_count),"; $sql_newbreaks .= " \t `lapis_count`=`lapis_count`+VALUES(lapis_count), `iron_count`=`iron_count`+VALUES(iron_count), `stone_count`=`stone_count`+VALUES(stone_count)"; $res_newbreaks = mysql_query($sql_newbreaks); if (mysql_errno()) { die("SQL_QUERY[newbreaks]: " . $sql_newbreaks . "<BR> " . mysql_error() . "<BR>"); } else { echo "DONE!<BR>"; } //while(($BreaksArray[] = mysql_fetch_assoc($res_newbreaks)) || array_pop($BreaksArray)); $stats_sql = GetMySQL_ResultStats(); //echo "STATS_SQL: <BR>"; print_r($stats_sql); echo "<BR>"; echo "-----------------------------------------------<br>"; echo "Summary For World [" . $world_item["worldalias"] . "]<BR>"; echo "-----------------------------------------------<br>"; echo "..." . $stats_sql["records"] . " Users Processed.<BR>"; echo "..." . ($stats_sql["records"] - $stats_sql["duplicates"]) . " New Users Found.<BR>"; echo "..." . $stats_sql["duplicates"] . " Users Updated.<BR>"; echo "-----------------------------------------------<br>"; if ($latest_break_date != "") { // Update World's LAST_PROCESSED_DATE to curent time $sql_setdate = "UPDATE `x-worlds` SET `last_date_processed`='" . $latest_break_date . "' WHERE `worldid`='" . $world_item["worldid"] . "'"; //echo "SQL_QUERY: <br>". $sql_setdate . "<br>"; $res_setdate = mysql_query($sql_setdate) or die("SetDate([" . $world_item["worldalias"] . "] => '" . $latest_break_date . "'): " . mysql_error() . " SQL: [{$sql_setdate}]"); } } } } Update_Stats_RatioTotals(); }
<?php require_once '../core_xdetector.php'; Global_Init(); Use_DB("source"); $sql_Get_All_Players = "SELECT `playername` FROM " . $GLOBALS['db']['table_players'] . " WHERE `playername` LIKE '%" . $_GET['term'] . "%' LIMIT 10"; //echo "SQL QUERY: <BR>" . $sql_Get_All_Players . "<BR>"; $res_Get_All_Players = @mysql_query($sql_Get_All_Players) or die(json_encode(array())); $playername_array = array(); if (mysql_num_rows($res_Get_All_Players) > 0) { while (($Player_result[] = mysql_fetch_assoc($res_Get_All_Players)) || array_pop($Player_result)) { } foreach ($Player_result as $playername_item) { array_push($playername_array, $playername_item["playername"]); } //echo "Playernames: "; print_r($playername_array); echo "<BR>"; } else { echo json_encode(array()); } echo json_encode($playername_array);
function Do_Auth($ip_only = false) { //echo "FIRST SETUP (Config): " . FixOutput_Bool($GLOBALS['config_settings']['settings']['first_setup'], "YES", "NO", "UNDEFINED") . "<BR>"; // Force IP to match Failsafe IPs list if running setup for first time if (FixOutput_Bool($GLOBALS['config_settings']['settings']['first_setup'], true, false, true)) { session_unset(); session_start(); $_SESSION['first_setup'] = true; $ip_only = true; } else { if (!isset($_SESSION)) { session_start(); } $_SESSION['first_setup'] = false; } // Initialize variables if (count($_GET) > 0) { $_POST = $_GET; } if (!isset($_POST['form'])) { $_POST['form'] = ""; } if (!isset($_POST['submit'])) { $_POST['submit'] = ""; } $IP_Users_list = array(); $login_error = ""; $logout_success = ""; $_SESSION['auth_is_valid'] = false; $_SESSION['first_setup'] = FixOutput_Bool($GLOBALS['config_settings']['settings']['first_setup'], true, false, true); if (!$ip_only) { //echo "IP-Only Authentication is OFF.<BR>"; if ($_SESSION['auth_is_valid'] == true) { /* echo "You are logged in!<br>"; echo "User ID: " . $_SESSION['viewer_id'] . "<br>"; echo "User Name: " . $_SESSION['viewer_name'] . "<br>"; echo "Password: "******"<br>"; */ } else { Use_DB("source"); //mysql_select_db($GLOBALS['db']['db_source']['base'], $GLOBALS['db']['s_resource']); $query_IP_Users = sprintf("SELECT * FROM `" . DB_Type_PlayersTable($GLOBALS['db']['type']) . "` WHERE ip LIKE %s ORDER BY playername ASC", GetSQLValueString("%" . $_SERVER['REMOTE_ADDR'] . "%", "text")); //echo "SQL[query_IP_Users]: <BR>". $query_IP_Users. "<BR>"; $res_IP_Users = mysql_query($query_IP_Users, $GLOBALS['db']['s_resource']) or die(mysql_error()); $totalRows_IP_Users = mysql_num_rows($res_IP_Users); // VALIDATE IP $ip_valid = false; if ($totalRows_IP_Users > 0) { while (($IP_Users_list[] = mysql_fetch_assoc($res_IP_Users)) || array_pop($IP_Users_list)) { } } else { //echo "WARNING: There are no known users with your IP.<BR>"; } if ($_POST['form'] == "loginform") { //echo "Login form detected...<BR>"; if ($GLOBALS['config_settings']['auth']['mode'] == "username") { // VALIDATE IP $ip_valid = false; if ($totalRows_IP_Users > 0) { //$playerid = $IP_Users_list[0]["playerid"]; $auth_allow_guest_users = FixInput_Bool($auth_allow_guest_users); $auth_admin_usernames_exploded = explode(",", $GLOBALS['config']['auth']['admin_usernames']); foreach ($auth_admin_usernames_exploded as &$input_fix_item) { $input_fix_item = trim($input_fix_item); } $auth_mod_usernames_exploded = explode(",", $GLOBALS['config']['auth']['mod_usernames']); foreach ($auth_mod_usernames_exploded as &$input_fix_item) { $input_fix_item = trim($input_fix_item); } $auth_user_usernames_exploded = explode(",", $GLOBALS['config']['auth']['user_usernames']); foreach ($auth_user_usernames_exploded as &$input_fix_item) { $input_fix_item = trim($input_fix_item); } //echo "AUTH_ADMIN_USERNAMES: "; print_r($auth_admin_usernames_exploded); echo "<BR>"; //echo "AUTH_MOD_USERNAMES: "; print_r($auth_mod_usernames_exploded); echo "<BR>"; //echo "AUTH_USER_USERNAMES: "; print_r($auth_user_usernames_exploded); echo "<BR>"; foreach ($IP_Users_list as $auth_test_item) { $ip_valid = true; if ($auth_test_item["playername"] == $_GET['my_username']) { foreach ($auth_admin_usernames_exploded as $admin_name_item) { if (!strnatcasecmp($admin_name_item, $auth_test_item["playername"])) { //echo "AUTH: VALID ADMINISTRATOR!<BR>"; $_SESSION["auth_admin"] = true; $_SESSION["auth_level"] = "Administrator"; break; $_SESSION["auth_username"] = $auth_test_item["playername"]; } } foreach ($auth_mod_usernames_exploded as $mod_name_item) { if (!strnatcasecmp($mod_name_item, $auth_test_item["playername"])) { //echo "AUTH: VALID MODERATOR!<BR>"; $_SESSION["auth_mod"] = true; $_SESSION["auth_level"] = "Moderator"; break; } } foreach ($auth_user_usernames_exploded as $user_name_item) { if (!strnatcasecmp($user_name_item, $auth_test_item["playername"])) { //echo "AUTH: VALID USER!<BR>"; $_SESSION["auth_user"] = true; $_SESSION["auth_level"] = "User"; break; } } if ($_SESSION["auth_admin"] || $_SESSION["auth_mod"] || $_SESSION["auth_user"]) { $_SESSION["auth_type"] = $GLOBALS['config_settings']['auth']['mode']; $_SESSION["account"] = $auth_test_item; $_SESSION['auth_is_valid'] = true; } } } } else { $login_error .= "ERROR: You do not have access to this page!<br>"; $_SESSION['auth_is_valid'] = false; } } elseif ($GLOBALS['config_settings']['auth']['mode'] == "password") { if ($_POST['login_password'] == "") { $login_error .= "ERROR: Password cannot be blank!<br>"; } if (!strnatcasecmp($GLOBALS['config']['auth']['admin_password'], $_POST['login_password'])) { //echo "AUTH: VALID ADMINISTRATOR!<BR>"; $_SESSION["auth_admin"] = true; $_SESSION["auth_level"] = "Administrator"; } elseif (!strnatcasecmp($GLOBALS['config']['auth']['mod_password'], $_POST['login_password'])) { //echo "AUTH: VALID MODERATOR!<BR>"; $_SESSION["auth_mod"] = true; $_SESSION["auth_level"] = "Moderator"; } elseif (!strnatcasecmp($GLOBALS['config']['auth']['user_password'], $_POST['login_password'])) { //echo "AUTH: VALID USER!<BR>"; $_SESSION["auth_user"] = true; $_SESSION["auth_level"] = "User"; } if ($_SESSION["auth_admin"] || $_SESSION["auth_mod"] || $_SESSION["auth_user"]) { $_SESSION["auth_type"] = $GLOBALS['config_settings']['auth']['mode']; $_SESSION["account"] = false; $_SESSION['auth_is_valid'] = true; } else { $login_error .= "ERROR: Incorrect password!<br>"; $_SESSION['auth_is_valid'] = false; } } } if ($GLOBALS['config_settings']['auth']['mode'] == "none") { $_SESSION["auth_user"] = true; $_SESSION["auth_level"] = "Administrator"; $_SESSION["auth_username"] = NULL; } } } if (!isset($_SESSION['auth_is_valid']) || !$_SESSION['auth_is_valid'] || $ip_only) { $auth_failsafe_ips_exploded = explode(",", $GLOBALS['config']['auth']['failsafe_ips']); foreach ($auth_failsafe_ips_exploded as &$input_fix_item) { $input_fix_item = trim($input_fix_item); } array_push($auth_failsafe_ips_exploded, "127.0.0.1", "::1"); //echo "FAILSAFE_IPS: "; print_r($auth_failsafe_ips_exploded); echo "<BR>"; foreach ($auth_failsafe_ips_exploded as $auth_test_item) { if ($_SERVER['REMOTE_ADDR'] == $auth_test_item) { $_SESSION["auth_admin"] = true; $_SESSION["auth_level"] = "Administrator"; $_SESSION["auth_type"] = "ip"; $_SESSION["account"] = false; $_SESSION['auth_is_valid'] = true; break; } } } if ($_POST['form'] == "logoutform" && $_POST['Submit'] == "Logout") { session_unset(); $logout_success .= "You have been logged off successfully.<br>"; $_SESSION['auth_is_valid'] = false; $_SESSION['first_setup'] = FixOutput_Bool($GLOBALS['config_settings']['settings']['first_setup'], true, false, true); $_SESSION['IP_Users_List'] = $IP_Users_list; } $GLOBALS['auth']['IP_Users_list'] = $IP_Users_list; //echo "FIRST SETUP (Session - Final): " . FixOutput_Bool($_SESSION['first_setup'], "YES", "NO", "UNDEFINED") . "<BR>"; //echo "AUTH VALID (Session - Final): " . FixOutput_Bool($_SESSION['auth_is_valid'], "YES", "NO", "UNDEFINED") . "<BR>"; return array("valid_ips" => $IP_Users_list, "login_error" => $login_error, "logout_success" => $logout_success); }