brusselopole / Worldopole

core/process/aru.php

Spacing +98 added lines, -98 removed lines

@@ -6,7 +6,7 @@ 
 
 $pos = !empty($_SERVER['HTTP_REFERER']) && strpos($_SERVER['HTTP_REFERER'], getenv('HTTP_HOST'));
 
-if ($pos===false) {
+if ($pos === false) {
 	http_response_code(401);
 	die('Restricted access');
 }
@@ -19,8 +19,8 @@ 
 // Include & load the variables
 // ############################
 
-$variables 	= realpath(dirname(__FILE__)).'/../json/variables.json';
-$config 	= json_decode(file_get_contents($variables));
+$variables = realpath(dirname(__FILE__)).'/../json/variables.json';
+$config = json_decode(file_get_contents($variables));
 
 
 
@@ -37,12 +37,12 @@ 
 
 
 # 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');
 }
 $mysqli->set_charset('utf8');
-$request 	= $_GET['type'];
+$request = $_GET['type'];
 
 switch ($request) {
 	############################
@@ -55,64 +55,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;
@@ -139,7 +139,7 @@ 
 		// ------------
 		$total_spawns = array();
 		$last_uid_param = "";
-		if(isset($_GET['last_uid'])) {
+		if (isset($_GET['last_uid'])) {
 			$last_uid_param = $_GET['last_uid'];
 		}
 		if ($config->system->mythic_recents) {
@@ -152,12 +152,12 @@ 
 			}
 
 			// get last mythic pokemon
-			$req		= "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude, individual_attack, individual_defense, individual_stamina FROM pokemon
+			$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude, individual_attack, individual_defense, individual_stamina FROM pokemon
                         WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
                         ORDER BY last_modified DESC LIMIT 0,12";
 		} else {
 			// get last pokemon
-			$req		= "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude, individual_attack, individual_defense, individual_stamina FROM pokemon ORDER BY last_modified DESC LIMIT 0,12";
+			$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude, individual_attack, individual_defense, individual_stamina FROM pokemon ORDER BY last_modified DESC LIMIT 0,12";
 		}
 		$result = $mysqli->query($req);
 		while ($data = $result->fetch_object()) {
@@ -195,14 +195,14 @@ 
 					if ($iv->available) {
 						$html .= '
 					<div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto;">
-					    <div title="Stamina IV: '. $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">Stamina IV: '. $iv->stamina .'</span>
+					    <div title="Stamina IV: '. $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">Stamina IV: '. $iv->stamina.'</span>
 					    </div>
-					    <div title="Attack IV: '. $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">Attack IV: '. $iv->attack .'</span>
+					    <div title="Attack IV: '. $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">Attack IV: '. $iv->attack.'</span>
 					    </div>
-					    <div title="Defense IV: '. $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">Defense IV: '. $iv->defense .'</span>
+					    <div title="Defense IV: '. $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">Defense IV: '. $iv->defense.'</span>
 					    </div>
 					</div>';
 					} else {
@@ -238,15 +238,15 @@ 
 	####################################
 
 	case 'pokestop':
-		$req 		= "SELECT latitude, longitude, lure_expiration FROM pokestop";
-		$result 	= $mysqli->query($req);
+		$req = "SELECT latitude, longitude, lure_expiration FROM pokestop";
+		$result = $mysqli->query($req);
 
-		$i=0;
+		$i = 0;
 
 		while ($data = $result->fetch_object()) {
 			if ($data->lure_expiration != '') {
 				$icon = 'pokestap_lured.png';
-				$text = 'Lured expire @ '.date('h:i:s', strtotime($data->lure_expiration)+(3600*2)) ;
+				$text = 'Lured expire @ '.date('h:i:s', strtotime($data->lure_expiration) + (3600 * 2));
 			} else {
 				$icon = 'pokestap.png';
 				$text = 'Normal stop';
@@ -279,19 +279,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(gym_points),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(gym_points),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;
 		}
 
 		$json = json_encode($return);
@@ -310,11 +310,11 @@ 
 
 
 	case 'gym_map':
-		$req 		= "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_modified, '+00:00', '".$time_offset."')) as last_modified FROM gym";
-		$result 	= $mysqli->query($req);
+		$req = "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_modified, '+00:00', '".$time_offset."')) as last_modified FROM gym";
+		$result = $mysqli->query($req);
 
 
-		$i=0;
+		$i = 0;
 
 		while ($data = $result->fetch_object()) {
 			// Team
@@ -326,50 +326,50 @@ 
 				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;
 			}
 
 			// Set gym level
-			$data->gym_level=0;
+			$data->gym_level = 0;
 			if ($data->gym_points < 2000) {
-				$data->gym_level=1;
+				$data->gym_level = 1;
 			} elseif ($data->gym_points < 4000) {
-				$data->gym_level=2;
+				$data->gym_level = 2;
 			} elseif ($data->gym_points < 8000) {
-				$data->gym_level=3;
+				$data->gym_level = 3;
 			} elseif ($data->gym_points < 12000) {
-				$data->gym_level=4;
+				$data->gym_level = 4;
 			} elseif ($data->gym_points < 16000) {
-				$data->gym_level=5;
+				$data->gym_level = 5;
 			} elseif ($data->gym_points < 20000) {
-				$data->gym_level=6;
+				$data->gym_level = 6;
 			} elseif ($data->gym_points < 30000) {
-				$data->gym_level=7;
+				$data->gym_level = 7;
 			} elseif ($data->gym_points < 40000) {
-				$data->gym_level=8;
+				$data->gym_level = 8;
 			} elseif ($data->gym_points < 50000) {
-				$data->gym_level=9;
+				$data->gym_level = 9;
 			} else {
-				$data->gym_level=10;
+				$data->gym_level = 10;
 			}
 
 			## I know, I revert commit 6e8d2e7 from @kiralydavid but the way it was done broke the page.
@@ -420,8 +420,8 @@ 
 
 	case 'gym_defenders':
 		$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
-		$req 		= "SELECT gymdetails.name as name, gymdetails.description as description, gym.gym_points as points, gymdetails.url as url, gym.team_id as team, (CONVERT_TZ(gym.last_modified, '+00:00', '".$time_offset."')) as last_modified, gym.guard_pokemon_id as guard_pokemon_id FROM gymdetails LEFT JOIN gym on gym.gym_id = gymdetails.gym_id WHERE gym.gym_id='".$gym_id."'";
-		$result 	= $mysqli->query($req);
+		$req = "SELECT gymdetails.name as name, gymdetails.description as description, gym.gym_points as points, gymdetails.url as url, gym.team_id as team, (CONVERT_TZ(gym.last_modified, '+00:00', '".$time_offset."')) as last_modified, gym.guard_pokemon_id as guard_pokemon_id FROM gymdetails LEFT JOIN gym on gym.gym_id = gymdetails.gym_id WHERE gym.gym_id='".$gym_id."'";
+		$result = $mysqli->query($req);
 		$gymData['gymDetails']['gymInfos'] = false;
 		while ($data = $result->fetch_object()) {
 			$gymData['gymDetails']['gymInfos']['name'] = $data->name;
@@ -437,31 +437,31 @@ 
 			$gymData['gymDetails']['gymInfos']['team'] = $data->team;
 			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
 			if ($data->points < 2000) {
-				$gymData['gymDetails']['gymInfos']['level']=1;
+				$gymData['gymDetails']['gymInfos']['level'] = 1;
 			} elseif ($data->points < 4000) {
-				$gymData['gymDetails']['gymInfos']['level']=2;
+				$gymData['gymDetails']['gymInfos']['level'] = 2;
 			} elseif ($data->points < 8000) {
-				$gymData['gymDetails']['gymInfos']['level']=3;
+				$gymData['gymDetails']['gymInfos']['level'] = 3;
 			} elseif ($data->points < 12000) {
-				$gymData['gymDetails']['gymInfos']['level']=4;
+				$gymData['gymDetails']['gymInfos']['level'] = 4;
 			} elseif ($data->points < 16000) {
-				$gymData['gymDetails']['gymInfos']['level']=5;
+				$gymData['gymDetails']['gymInfos']['level'] = 5;
 			} elseif ($data->points < 20000) {
-				$gymData['gymDetails']['gymInfos']['level']=6;
+				$gymData['gymDetails']['gymInfos']['level'] = 6;
 			} elseif ($data->points < 30000) {
-				$gymData['gymDetails']['gymInfos']['level']=7;
+				$gymData['gymDetails']['gymInfos']['level'] = 7;
 			} elseif ($data->points < 40000) {
-				$gymData['gymDetails']['gymInfos']['level']=8;
+				$gymData['gymDetails']['gymInfos']['level'] = 8;
 			} elseif ($data->points < 50000) {
-				$gymData['gymDetails']['gymInfos']['level']=9;
+				$gymData['gymDetails']['gymInfos']['level'] = 9;
 			} else {
-				$gymData['gymDetails']['gymInfos']['level']=10;
+				$gymData['gymDetails']['gymInfos']['level'] = 10;
 			}
 		}
 		//print_r($gymData);
-		$req 		= "SELECT * FROM gympokemon inner join gymmember on gympokemon.pokemon_uid=gymmember.pokemon_uid where gym_id='".$gym_id."' ORDER BY cp DESC";
-		$result 	= $mysqli->query($req);
-		$i=0;
+		$req = "SELECT * FROM gympokemon inner join gymmember on gympokemon.pokemon_uid=gymmember.pokemon_uid where gym_id='".$gym_id."' ORDER BY cp DESC";
+		$result = $mysqli->query($req);
+		$i = 0;
 
 
 
@@ -479,15 +479,15 @@ 
 					</a>
 					<p class="pkmn-name">'.$data->cp.'</p>
 					<div class="progress" style="height: 4px; width: 40px; margin-bottom: 10px; margin-top: 2px; margin-left: auto; margin-right: auto">
-						<div title="Stamina IV: '.$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/15)*$data->iv_stamina)/3).'%">
+						<div title="Stamina IV: '.$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 / 15) * $data->iv_stamina) / 3).'%">
 							<span class="sr-only">Stamina IV: '.$data->iv_stamina.'</span>
 						</div>
 
-						<div title="Attack IV: '.$data->iv_attack.'" class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="'.$data->iv_attack.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100/15)*$data->iv_attack)/3).'%">
+						<div title="Attack IV: '.$data->iv_attack.'" class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="'.$data->iv_attack.'" aria-valuemin="0" aria-valuemax="45" style="width: '.(((100 / 15) * $data->iv_attack) / 3).'%">
 							<span class="sr-only">Attack IV: '.$data->iv_attack.'</span>
 						</div>
 
-						<div title="Defense IV: '.$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/15)*$data->iv_defense)/3).'%">
+						<div title="Defense IV: '.$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 / 15) * $data->iv_defense) / 3).'%">
 							<span class="sr-only">Defense IV: '.$data->iv_defense.'</span>
 						</div>
 					</div>
@@ -517,16 +517,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']);
@@ -537,16 +537,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 ".
@@ -565,7 +565,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, gympokemon.trainer_name, gympokemon.iv_defense, gympokemon.iv_stamina, gympokemon.iv_attack, filtered_gymmember.gym_id, '1' as active ".
 				"FROM gympokemon INNER JOIN ".
@@ -575,7 +575,7 @@ 
 
 			$resultPkms = $mysqli->query($req);
 			$trainer->pokemons = array();
-			$active_gyms=0;
+			$active_gyms = 0;
 			$pkmCount = 0;
 			while ($resultPkms && $dataPkm = $resultPkms->fetch_object()) {
 				$active_gyms++;