brusselopole / Worldopole

core/process/aru.php

Spacing +87 added lines, -87 removed lines

@@ -17,8 +17,8 @@ 
 // Include & load the variables
 // ############################
 
-$variables 	= SYS_PATH.'/core/json/variables.json';
-$config 	= json_decode(file_get_contents($variables));
+$variables = SYS_PATH.'/core/json/variables.json';
+$config = json_decode(file_get_contents($variables));
 
 // Manage Time Interval
 // #####################
@@ -37,7 +37,7 @@ 
 include_once(SYS_PATH.'/functions.php');
 
 # MySQL
-$mysqli 	= new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
+$mysqli = new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
 if ($mysqli->connect_error != '') {
 	exit('Error MySQL Connect');
 }
@@ -49,7 +49,7 @@ 
 $postRequest = "";
 if (isset($_POST['type'])) {
 	$postRequest = $_POST['type'];
-	$request= "postRequest";
+	$request = "postRequest";
 }
 switch ($request) {
 	############################
@@ -62,64 +62,64 @@ 
 		// Right now
 		// ---------
 
-		$req 		= "SELECT COUNT(*) AS total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
-		$result 	= $mysqli->query($req);
-		$data 		= $result->fetch_object();
+		$req = "SELECT COUNT(*) AS total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
-		$values[] 	= $data->total;
+		$values[] = $data->total;
 
 
 		// Lured stops
 		// -----------
 
-		$req 		= "SELECT COUNT(*) AS total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
-		$result 	= $mysqli->query($req);
-		$data 		= $result->fetch_object();
+		$req = "SELECT COUNT(*) AS total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
-		$values[] 	= $data->total;
+		$values[] = $data->total;
 
 
 
 		// Team battle
 		// -----------
 
-		$req 		= "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym";
-		$result 	= $mysqli->query($req);
-		$data 		= $result->fetch_object();
+		$req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
-		$values[] 	= $data->total;
+		$values[] = $data->total;
 
 		// Team
 		// 1 = bleu
 		// 2 = rouge
 		// 3 = jaune
 
-		$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '2'";
-		$result	= $mysqli->query($req);
-		$data	= $result->fetch_object();
+		$req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '2'";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
 		// Red
 		$values[] = $data->total;
 
 
-		$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '1'";
-		$result	= $mysqli->query($req);
-		$data	= $result->fetch_object();
+		$req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '1'";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
 		// Blue
 		$values[] = $data->total;
 
 
-		$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '3'";
-		$result	= $mysqli->query($req);
-		$data	= $result->fetch_object();
+		$req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '3'";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
 		// Yellow
 		$values[] = $data->total;
 
-		$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '0'";
-		$result	= $mysqli->query($req);
-		$data	= $result->fetch_object();
+		$req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE team_id = '0'";
+		$result = $mysqli->query($req);
+		$data = $result->fetch_object();
 
 		// Neutral
 		$values[] = $data->total;
@@ -207,13 +207,13 @@ 
 							$html .= '
 							<div class="progress" style="height: 15px; margin-bottom: 0">
 								<div title="'.$locales->IV_ATTACK.': '.$iv->attack.'" class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="'.$iv->attack.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(100 / 3).'%; line-height: 16px">
-									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack .'
+									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack.'
 								</div>
 								<div title="'.$locales->IV_DEFENSE.': '.$iv->defense.'" class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="'.$iv->defense.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(100 / 3).'%; line-height: 16px">
-									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>'.$iv->defense .'
+									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>'.$iv->defense.'
 								</div>
 								<div title="'.$locales->IV_STAMINA.': '.$iv->stamina.'" class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="'.$iv->stamina.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(100 / 3).'%; line-height: 16px">
-									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina .'
+									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina.'
 								</div>
 							</div>';
 						} else {
@@ -222,10 +222,10 @@ 
 					    		<div title="'.$locales->IV_ATTACK.': '.$iv->attack.'" class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="'.$iv->attack.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $iv->attack) / 3).'%">
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>
 					    		</div>
-					    		<div title="'.$locales->IV_DEFENSE.': '.$iv->defense .'" class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="'.$iv->defense.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $iv->defense) / 3).'%">
+					    		<div title="'.$locales->IV_DEFENSE.': '.$iv->defense.'" class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="'.$iv->defense.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $iv->defense) / 3).'%">
 									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>
 					    		</div>
-					    		<div title="'.$locales->IV_STAMINA.': '.$iv->stamina .'" class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="'.$iv->stamina.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $iv->stamina) / 3).'%">
+					    		<div title="'.$locales->IV_STAMINA.': '.$iv->stamina.'" class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="'.$iv->stamina.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $iv->stamina) / 3).'%">
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>
 					    		</div>
 							</div>';
@@ -325,19 +325,19 @@ 
 	####################################
 
 	case 'update_gym':
-		$teams			= new stdClass();
-		$teams->mystic 		= 1;
-		$teams->valor 		= 2;
-		$teams->instinct 	= 3;
+		$teams = new stdClass();
+		$teams->mystic = 1;
+		$teams->valor = 2;
+		$teams->instinct = 3;
 
 
 		foreach ($teams as $team_name => $team_id) {
-			$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total, ROUND(AVG(total_cp),0) AS average_points FROM gym WHERE team_id = '".$team_id."'";
-			$result	= $mysqli->query($req);
-			$data	= $result->fetch_object();
+			$req = "SELECT COUNT(DISTINCT(gym_id)) AS total, ROUND(AVG(total_cp),0) AS average_points FROM gym WHERE team_id = '".$team_id."'";
+			$result = $mysqli->query($req);
+			$data = $result->fetch_object();
 
-			$return[] 	= $data->total;
-			$return[]	= $data->average_points;
+			$return[] = $data->total;
+			$return[] = $data->average_points;
 		}
 
 		header('Content-Type: application/json');
@@ -354,7 +354,7 @@ 
 
 
 	case 'gym_map':
-		$req	= "SELECT gym_id, team_id, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned, (6 - slots_available) AS level FROM gym";
+		$req = "SELECT gym_id, team_id, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned, (6 - slots_available) AS level FROM gym";
 		$result = $mysqli->query($req);
 
 		$gyms = [];
@@ -369,25 +369,25 @@ 
 				case 0:
 					$icon	= 'map_white.png';
 					$team	= 'No Team (yet)';
-					$color	= 'rgba(0, 0, 0, .6)';
+					$color = 'rgba(0, 0, 0, .6)';
 					break;
 
 				case 1:
 					$icon	= 'map_blue_';
 					$team	= 'Team Mystic';
-					$color	= 'rgba(74, 138, 202, .6)';
+					$color = 'rgba(74, 138, 202, .6)';
 					break;
 
 				case 2:
 					$icon	= 'map_red_';
 					$team	= 'Team Valor';
-					$color	= 'rgba(240, 68, 58, .6)';
+					$color = 'rgba(240, 68, 58, .6)';
 					break;
 
 				case 3:
 					$icon	= 'map_yellow_';
 					$team	= 'Team Instinct';
-					$color	= 'rgba(254, 217, 40, .6)';
+					$color = 'rgba(254, 217, 40, .6)';
 					break;
 			}
 
@@ -417,7 +417,7 @@ 
 
 	case 'gym_defenders':
 		$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
-		$req	= "SELECT gymdetails.name AS name, gymdetails.description AS description, gymdetails.url AS url, gym.team_id AS team,
+		$req = "SELECT gymdetails.name AS name, gymdetails.description AS description, gymdetails.url AS url, gym.team_id AS team,
 					(CONVERT_TZ(gym.last_scanned, '+00:00', '".$time_offset."')) AS last_scanned, gym.guard_pokemon_id AS guard_pokemon_id, gym.total_cp AS total_cp, (6 - gym.slots_available) AS level
 					FROM gymdetails
 					LEFT JOIN gym ON gym.gym_id = gymdetails.gym_id
@@ -441,7 +441,7 @@ 
 			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
 		}
 
-		$req 	= "SELECT DISTINCT gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) AS cp, gymmember.gym_id
+		$req = "SELECT DISTINCT gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) AS cp, gymmember.gym_id
 					FROM gympokemon INNER JOIN gymmember ON gympokemon.pokemon_uid=gymmember.pokemon_uid
 					GROUP BY gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, gym_id
 					HAVING gymmember.gym_id='".$gym_id."'
@@ -468,10 +468,10 @@ 
 								<span class="sr-only">'.$locales->IV_ATTACK.' : '.$data->iv_attack.'</span>'.$data->iv_attack.'
 								</div>
 								<div title="'.$locales->IV_DEFENSE.': '.$data->iv_defense.'" class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="'.$data->iv_defense.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(100 / 3).'%; line-height: 13px; font-size: 11px">
-									<span class="sr-only">'.$locales->IV_DEFENSE.' : '.$data->iv_defense.'</span>'. $data->iv_defense .'
+									<span class="sr-only">'.$locales->IV_DEFENSE.' : '.$data->iv_defense.'</span>'.$data->iv_defense.'
 								</div>
 								<div title="'.$locales->IV_STAMINA.': '.$data->iv_stamina.'" class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="'.$data->iv_stamina.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(100 / 3).'%; line-height: 13px; font-size: 11px">
-									<span class="sr-only">'.$locales->IV_STAMINA.' : '.$data->iv_stamina.'</span>'. $data->iv_stamina .'
+									<span class="sr-only">'.$locales->IV_STAMINA.' : '.$data->iv_stamina.'</span>'.$data->iv_stamina.'
 								</div>
 							</div>
 						</div>';
@@ -544,16 +544,16 @@ 
 		$name = "";
 		$page = "0";
 		$where = "";
-		$order="";
-		$team=0;
-		$ranking=0;
+		$order = "";
+		$team = 0;
+		$ranking = 0;
 		if (isset($_GET['name'])) {
 			$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
 			$where = " HAVING name LIKE '%".$trainer_name."%'";
 		}
-		if (isset($_GET['team']) && $_GET['team']!=0) {
+		if (isset($_GET['team']) && $_GET['team'] != 0) {
 			$team = mysqli_real_escape_string($mysqli, $_GET['team']);
-			$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
+			$where .= ($where == "" ? " HAVING" : "AND ")." team = ".$team;
 		}
 		if (isset($_GET['page'])) {
 			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
@@ -564,16 +564,16 @@ 
 
 		switch ($ranking) {
 			case 1:
-				$order=" ORDER BY active DESC ";
+				$order = " ORDER BY active DESC ";
 				break;
 			case 2:
-				$order=" ORDER BY maxCp DESC ";
+				$order = " ORDER BY maxCp DESC ";
 				break;
 			default:
-				$order=" ORDER BY level DESC, active DESC ";
+				$order = " ORDER BY level DESC, active DESC ";
 		}
 
-		$limit = " LIMIT ".($page*10).",10 ";
+		$limit = " LIMIT ".($page * 10).",10 ";
 
 
 		$req = "SELECT trainer.*, COUNT(actives_pokemons.trainer_name) AS active, max(actives_pokemons.cp) AS maxCp
@@ -594,7 +594,7 @@ 
 			$reqRanking = "SELECT COUNT(1) AS rank FROM trainer WHERE trainer.level >= ".$trainer->level;
 			$resultRanking = $mysqli->query($reqRanking);
 			while ($data = $resultRanking->fetch_object()) {
-				$trainer->rank = $data->rank ;
+				$trainer->rank = $data->rank;
 			}
 			$req = "(SELECT DISTINCT gympokemon.pokemon_id, gympokemon.pokemon_uid, gympokemon.cp, DATEDIFF(UTC_TIMESTAMP(), gympokemon.last_seen) AS last_scanned, gympokemon.trainer_name, gympokemon.iv_defense, gympokemon.iv_stamina, gympokemon.iv_attack, filtered_gymmember.gym_id, filtered_gymmember.deployment_time as deployment_time, '1' AS active
 					FROM gympokemon INNER JOIN
@@ -605,7 +605,7 @@ 
 
 			$resultPkms = $mysqli->query($req);
 			$trainer->pokemons = array();
-			$active_gyms=0;
+			$active_gyms = 0;
 			$pkmCount = 0;
 			while ($resultPkms && $dataPkm = $resultPkms->fetch_object()) {
 				$active_gyms++;
@@ -648,7 +648,7 @@ 
 			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
 		}
 
-		$limit = " LIMIT ".($page*10).",10";
+		$limit = " LIMIT ".($page * 10).",10";
 
 		$req = "SELECT raid.gym_id, raid.level, raid.pokemon_id, raid.cp, raid.move_1, raid.move_2, CONVERT_TZ(raid.spawn, '+00:00', '".$time_offset."') AS spawn, CONVERT_TZ(raid.start, '+00:00', '".$time_offset."') AS start, CONVERT_TZ(raid.end, '+00:00', '".$time_offset."') AS end, CONVERT_TZ(raid.last_scanned, '+00:00', '".$time_offset."') AS last_scanned, gymdetails.name, gym.latitude, gym.longitude FROM raid
 				JOIN gymdetails ON gymdetails.gym_id = raid.gym_id
@@ -688,7 +688,7 @@ 
 		break;
 
 	case 'pokemon_slider_init':
-		$req 		= "SELECT MIN(disappear_time) AS min, MAX(disappear_time) AS max FROM pokemon";
+		$req = "SELECT MIN(disappear_time) AS min, MAX(disappear_time) AS max FROM pokemon";
 		$result 	= $mysqli->query($req);
 		$bounds		= $result->fetch_object();
 
@@ -699,18 +699,18 @@ 
 
 
 	case 'pokemon_heatmap_points':
-		$json="";
-		if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
-			$start = Date("Y-m-d H:i",(int)$_GET['start']);
-			$end = Date("Y-m-d H:i",(int)$_GET['end']);
+		$json = "";
+		if (isset($_GET['start']) && isset($_GET['end']) && isset($_GET['pokemon_id'])) {
+			$start = Date("Y-m-d H:i", (int) $_GET['start']);
+			$end = Date("Y-m-d H:i", (int) $_GET['end']);
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
 			$where = " WHERE pokemon_id = ".$pokemon_id." "
 					. "AND disappear_time BETWEEN '".$start."' AND '".$end."'";
 			$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
-			$result 	= $mysqli->query($req);
+			$result = $mysqli->query($req);
 			$points = array();
 			while ($result && $data = $result->fetch_object()) {
-				$points[] 	= $data;
+				$points[] = $data;
 			}
 
 			$json = json_encode($points);
@@ -722,9 +722,9 @@ 
 
 
 	case 'maps_localization_coordinates':
-		$json="";
-		$req 		 = "SELECT MAX(latitude) AS max_latitude, MIN(latitude) AS min_latitude, MAX(longitude) AS max_longitude, MIN(longitude) as min_longitude FROM spawnpoint";
-		$result 	 = $mysqli->query($req);
+		$json = "";
+		$req = "SELECT MAX(latitude) AS max_latitude, MIN(latitude) AS min_latitude, MAX(longitude) AS max_longitude, MIN(longitude) as min_longitude FROM spawnpoint";
+		$result = $mysqli->query($req);
 		$coordinates = $result->fetch_object();
 
 		header('Content-Type: application/json');
@@ -734,7 +734,7 @@ 
 
 
 	case 'pokemon_graph_data':
-		$json="";
+		$json = "";
 		if (isset($_GET['pokemon_id'])) {
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
 			$req = "SELECT COUNT(*) AS total,
@@ -742,7 +742,7 @@ 
 					FROM (SELECT disappear_time FROM pokemon WHERE pokemon_id = '".$pokemon_id."' ORDER BY disappear_time LIMIT 10000) AS pokemonFiltered
 					GROUP BY disappear_hour
 					ORDER BY disappear_hour";
-			$result	= $mysqli->query($req);
+			$result = $mysqli->query($req);
 			$array = array_fill(0, 24, 0);
 			while ($result && $data = $result->fetch_object()) {
 				$array[$data->disappear_hour] = $data->total;
@@ -768,30 +768,30 @@ 
 	break;
 }
 
-if ($postRequest!="") {
+if ($postRequest != "") {
 	switch ($postRequest) {
 		case 'pokemon_live':
-			$json="";
-			if (isset( $_POST['pokemon_id'])) {
+			$json = "";
+			if (isset($_POST['pokemon_id'])) {
 				$pokemon_id = mysqli_real_escape_string($mysqli, $_POST['pokemon_id']);
-				$inmap_pkms_filter="";
+				$inmap_pkms_filter = "";
 				$where = " WHERE disappear_time >= UTC_TIMESTAMP() AND pokemon_id = ".$pokemon_id;
 
 				$reqTestIv = "SELECT MAX(individual_attack) AS iv FROM pokemon ".$where;
-				$resultTestIv 	= $mysqli->query($reqTestIv);
+				$resultTestIv = $mysqli->query($reqTestIv);
 				$testIv = $resultTestIv->fetch_object();
-				if (isset( $_POST['inmap_pokemons'])&&( $_POST['inmap_pokemons']!="")) {
+				if (isset($_POST['inmap_pokemons']) && ($_POST['inmap_pokemons'] != "")) {
 					foreach ($_POST['inmap_pokemons'] as $inmap) {
 						$inmap_pkms_filter .= "'".$inmap."',";
 					}
 					$inmap_pkms_filter = rtrim($inmap_pkms_filter, ",");
 					$where .= " AND encounter_id NOT IN (".$inmap_pkms_filter.") ";
 				}
-				if ($testIv->iv!=null && isset( $_POST['ivMin'])&&( $_POST['ivMin']!="")) {
+				if ($testIv->iv != null && isset($_POST['ivMin']) && ($_POST['ivMin'] != "")) {
 					$ivMin = mysqli_real_escape_string($mysqli, $_POST['ivMin']);
 					$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) >= (".$ivMin.") ";
 				}
-				if ($testIv->iv!=null && isset( $_POST['ivMax'])&&( $_POST['ivMax']!="")) {
+				if ($testIv->iv != null && isset($_POST['ivMax']) && ($_POST['ivMax'] != "")) {
 					$ivMax = mysqli_real_escape_string($mysqli, $_POST['ivMax']);
 					$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) <=(".$ivMax.") ";
 				}
@@ -805,12 +805,12 @@ 
 				$json = array();
 				$json['points'] = array();
 				$locale = array();
-				$locale["ivAttack"] =  $locales->IV_ATTACK;
+				$locale["ivAttack"] = $locales->IV_ATTACK;
 				$locale["ivDefense"] = $locales->IV_DEFENSE;
-				$locale["ivStamina"] =  $locales->IV_STAMINA;
+				$locale["ivStamina"] = $locales->IV_STAMINA;
 				$json['locale'] = $locale;
 				while ($result && $data = $result->fetch_object()) {
-					$pokeid=$data->pokemon_id;
+					$pokeid = $data->pokemon_id;
 					$data->name = $pokemons->pokemon->$pokeid->name;
 					if (isset($data->move_1)) {
 						$move1 = $data->move_1;
@@ -824,7 +824,7 @@ 
 					} else {
 						$data->charge_move = "?";
 					}
-					$json['points'][] 	= $data;
+					$json['points'][] = $data;
 				}
 
 				$json = json_encode($json);