brusselopole / Worldopole

core/process/aru.php

Switch Indentation +340 added lines, -340 removed lines

@@ -58,150 +58,150 @@ 
 	//
 	############################
 
-	case 'home_update':
-		// Right now
-		// ---------
+		case 'home_update':
+			// 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
-		// -----------
+			// 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
-		// -----------
+			// 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
+			// 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;
+			// 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;
+			// 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;
+			// 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;
+			// Neutral
+			$values[] = $data->total;
 
 
-		header('Content-Type: application/json');
-		$json = json_encode($values);
+			header('Content-Type: application/json');
+			$json = json_encode($values);
 
-		echo $json;
+			echo $json;
 
 
-		break;
+			break;
 
 
 
-	####################################
-	//
-	// Update latests spawn on homepage
-	//
-	####################################
+		####################################
+		//
+		// Update latests spawn on homepage
+		//
+		####################################
 
-	case 'spawnlist_update':
-		// Recent spawn
-		// ------------
-		$total_spawns = array();
-		$last_uid_param = "";
-		if (isset($_GET['last_uid'])) {
-			$last_uid_param = $_GET['last_uid'];
-		}
-		if ($config->system->recents_filter) {
-			// get all mythic pokemon ids
-			$mythic_pokemons = array();
-			foreach ($pokemons->pokemon as $id => $pokemon) {
-				if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
-					$mythic_pokemons[] = $id;
-				}
+		case 'spawnlist_update':
+			// Recent spawn
+			// ------------
+			$total_spawns = array();
+			$last_uid_param = "";
+			if (isset($_GET['last_uid'])) {
+				$last_uid_param = $_GET['last_uid'];
 			}
+			if ($config->system->recents_filter) {
+				// get all mythic pokemon ids
+				$mythic_pokemons = array();
+				foreach ($pokemons->pokemon as $id => $pokemon) {
+					if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
+						$mythic_pokemons[] = $id;
+					}
+				}
 
-			// 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
+				// 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
                         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";
-		}
-		$result = $mysqli->query($req);
-		while ($data = $result->fetch_object()) {
-			$new_spawn = array();
-			$pokeid = $data->pokemon_id;
-			$pokeuid = $data->encounter_id;
-
-			if ($last_uid_param != $pokeuid) {
-				$last_seen = strtotime($data->disappear_time_real);
-
-				$last_location = new stdClass();
-				$last_location->latitude = $data->latitude;
-				$last_location->longitude = $data->longitude;
-
-				if ($config->system->recents_show_iv) {
-					$iv = new stdClass();
-					$iv->attack = $data->individual_attack;
-					$iv->defense = $data->individual_defense;
-					$iv->stamina = $data->individual_stamina;
-					if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
-						$iv->available = true;
-					} else {
-						$iv->available = false;
+			} 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";
+			}
+			$result = $mysqli->query($req);
+			while ($data = $result->fetch_object()) {
+				$new_spawn = array();
+				$pokeid = $data->pokemon_id;
+				$pokeuid = $data->encounter_id;
+
+				if ($last_uid_param != $pokeuid) {
+					$last_seen = strtotime($data->disappear_time_real);
+
+					$last_location = new stdClass();
+					$last_location->latitude = $data->latitude;
+					$last_location->longitude = $data->longitude;
+
+					if ($config->system->recents_show_iv) {
+						$iv = new stdClass();
+						$iv->attack = $data->individual_attack;
+						$iv->defense = $data->individual_defense;
+						$iv->stamina = $data->individual_stamina;
+						if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
+							$iv->available = true;
+						} else {
+							$iv->available = false;
+						}
 					}
-				}
 
-				$html = '
+					$html = '
 			    <div class="col-md-1 col-xs-4 pokemon-single" data-pokeid="'.$pokeid.'" data-pokeuid="'.$pokeuid.'" style="display: none;">
 				<a href="pokemon/'.$pokeid.'"><img src="core/pokemons/'.$pokeid.$config->system->pokeimg_suffix.'" alt="'.$pokemons->pokemon->$pokeid->name.'" class="img-responsive"></a>
 				<a href="pokemon/'.$pokeid.'"><p class="pkmn-name">'.$pokemons->pokemon->$pokeid->name.'</p></a>
 				<a href="https://maps.google.com/?q='.$last_location->latitude.','.$last_location->longitude.'&ll='.$last_location->latitude.','.$last_location->longitude.'&z=16" target="_blank">
 				    <small class="pokemon-timer">00:00:00</small>
 				</a>';
-				if ($config->system->recents_show_iv) {
-					if ($iv->available) {
-						if ($config->system->iv_numbers) {
-							$html .= '
+					if ($config->system->recents_show_iv) {
+						if ($iv->available) {
+							if ($config->system->iv_numbers) {
+								$html .= '
 							<div class="progress" style="height: 15px; margin-bottom: 0">
 								<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/3)  .'%; line-height: 16px";>
 									<span class="sr-only">Attack IV: '. $iv->attack .'</span>'. $iv->attack .'
@@ -213,8 +213,8 @@ 
 									<span class="sr-only">Stamina IV: '. $iv->stamina .'</span>'. $iv->stamina .'
 								</div>
 							</div>';
-						} else {
-							$html .= '
+							} else {
+								$html .= '
 							<div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto;">
 					    		<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>
@@ -226,10 +226,10 @@ 
 									<span class="sr-only">Stamina IV: '. $iv->stamina .'</span>
 					    		</div>
 							</div>';
-						}
-					} else {
-						if ($config->system->iv_numbers) {
-							$html .= '
+							}
+						} else {
+							if ($config->system->iv_numbers) {
+								$html .= '
 							<div class="progress" style="height: 15px; margin-bottom: 0">
 								<div title="Attack IV: not available" 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">Attack IV: not available</span>?
@@ -241,125 +241,125 @@ 
 									<span class="sr-only">Stamina IV: not available</span>?
 								</div>
 							</div>';
-						} else {
-						$html .= '
+							} else {
+							$html .= '
 					    <div class="progress" style="height: 6px; width: 80%; margin: 5px auto 15px auto;">
 						    <div title="IV not available" class="progress-bar" role="progressbar" style="width: 100%; background-color: rgb(210,210,210);" aria-valuenow="1" aria-valuemin="0" aria-valuemax="1">
 							    <span class="sr-only">IV not available</span>
 						    </div>
 					    </div>';
+							}
 						}
 					}
-				}
-				$html .= '
+					$html .= '
 			    </div>';
-				$new_spawn['html'] = $html;
-				$countdown = $last_seen - time();
-				$new_spawn['countdown'] = $countdown;
-				$new_spawn['pokemon_uid'] = $pokeuid;
-				$total_spawns[] = $new_spawn;
-			} else {
-				break;
+					$new_spawn['html'] = $html;
+					$countdown = $last_seen - time();
+					$new_spawn['countdown'] = $countdown;
+					$new_spawn['pokemon_uid'] = $pokeuid;
+					$total_spawns[] = $new_spawn;
+				} else {
+					break;
+				}
 			}
-		}
-		header('Content-Type: application/json');
-		echo json_encode($total_spawns);
-		break;
+			header('Content-Type: application/json');
+			echo json_encode($total_spawns);
+			break;
 
 
 
-	####################################
-	//
-	// List Pokestop
-	//
-	####################################
+		####################################
+		//
+		// List Pokestop
+		//
+		####################################
 
-	case 'pokestop':
-		$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
-		$result 	= $mysqli->query($req);
+		case 'pokestop':
+			$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
+			$result 	= $mysqli->query($req);
 
-		$i=0;
+			$i=0;
 
-		while ($data = $result->fetch_object()) {
-			if ($data->lure_expiration >= $data->now) {
-				$icon = 'pokestap_lured.png';
-				$text = 'Lured expire @ '.date('H:i:s', strtotime($data->lure_expiration_real)) ;
-			} else {
-				$icon = 'pokestap.png';
-				$text = 'Normal stop';
-			}
+			while ($data = $result->fetch_object()) {
+				if ($data->lure_expiration >= $data->now) {
+					$icon = 'pokestap_lured.png';
+					$text = 'Lured expire @ '.date('H:i:s', strtotime($data->lure_expiration_real)) ;
+				} else {
+					$icon = 'pokestap.png';
+					$text = 'Normal stop';
+				}
 
-			$temp[$i][] = $text;
-			$temp[$i][] = $icon;
-			$temp[$i][] = $data->latitude;
-			$temp[$i][] = $data->longitude;
-			$temp[$i][] = $i;
+				$temp[$i][] = $text;
+				$temp[$i][] = $icon;
+				$temp[$i][] = $data->latitude;
+				$temp[$i][] = $data->longitude;
+				$temp[$i][] = $i;
 
-			$temp_json[] = json_encode($temp[$i]);
+				$temp_json[] = json_encode($temp[$i]);
 
 
-			$i++;
-		}
+				$i++;
+			}
 
-		$return = json_encode($temp_json);
+			$return = json_encode($temp_json);
 
-		echo $return;
+			echo $return;
 
-		break;
+			break;
 
 
 
-	####################################
-	//
-	// Update data for the gym battle
-	//
-	####################################
+		####################################
+		//
+		// Update data for the gym battle
+		//
+		####################################
 
-	case 'update_gym':
-		$teams			= new stdClass();
-		$teams->mystic 		= 1;
-		$teams->valor 		= 2;
-		$teams->instinct 	= 3;
+		case 'update_gym':
+			$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();
+			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();
 
-			$return[] 	= $data->total;
-			$return[]	= $data->average_points;
-		}
+				$return[] 	= $data->total;
+				$return[]	= $data->average_points;
+			}
 
-		$json = json_encode($return);
+			$json = json_encode($return);
 
-		header('Content-Type: application/json');
-		echo $json;
+			header('Content-Type: application/json');
+			echo $json;
 
 
-		break;
+			break;
 
-	####################################
-	//
-	// Get datas for the gym map
-	//
-	####################################
+		####################################
+		//
+		// Get datas for the gym map
+		//
+		####################################
 
 
-	case 'gym_map':
-		$req 		= "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) as last_scanned FROM gym";
-		$result 	= $mysqli->query($req);
+		case 'gym_map':
+			$req 		= "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) as last_scanned FROM gym";
+			$result 	= $mysqli->query($req);
 
 
-		$i=0;
+			$i=0;
 
-		while ($data = $result->fetch_object()) {
-			// Team
-			// 1 = bleu
-			// 2 = rouge
-			// 3 = jaune
+			while ($data = $result->fetch_object()) {
+				// Team
+				// 1 = bleu
+				// 2 = rouge
+				// 3 = jaune
 
-			switch ($data->team_id) {
+				switch ($data->team_id) {
 				case 0:
 					$icon	= 'map_white.png';
 					$team	= 'No Team (yet)';
@@ -383,7 +383,7 @@ 
 					$team	= 'Team Instinct';
 					$color	= 'rgba(254, 217, 40, .6)';
 					break;
-			}
+				}
 
 			// Set gym level
 			$data->gym_level=0;
@@ -455,65 +455,65 @@ 
 	//
 	####################################
 
-	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_scanned, '+00:00', '".$time_offset."')) as last_scanned, 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;
-			$gymData['gymDetails']['gymInfos']['description'] = $data->description;
-			if ($data->url == null) {
-				$gymData['gymDetails']['gymInfos']['url'] = '';
-			} else {
-				$gymData['gymDetails']['gymInfos']['url'] = $data->url;
-			}
-			$gymData['gymDetails']['gymInfos']['points'] = $data->points;
-			$gymData['gymDetails']['gymInfos']['level'] = 0;
-			$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
-			$gymData['gymDetails']['gymInfos']['team'] = $data->team;
-			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
-			if ($data->points < 2000) {
-				$gymData['gymDetails']['gymInfos']['level']=1;
-			} elseif ($data->points < 4000) {
-				$gymData['gymDetails']['gymInfos']['level']=2;
-			} elseif ($data->points < 8000) {
-				$gymData['gymDetails']['gymInfos']['level']=3;
-			} elseif ($data->points < 12000) {
-				$gymData['gymDetails']['gymInfos']['level']=4;
-			} elseif ($data->points < 16000) {
-				$gymData['gymDetails']['gymInfos']['level']=5;
-			} elseif ($data->points < 20000) {
-				$gymData['gymDetails']['gymInfos']['level']=6;
-			} elseif ($data->points < 30000) {
-				$gymData['gymDetails']['gymInfos']['level']=7;
-			} elseif ($data->points < 40000) {
-				$gymData['gymDetails']['gymInfos']['level']=8;
-			} elseif ($data->points < 50000) {
-				$gymData['gymDetails']['gymInfos']['level']=9;
-			} else {
-				$gymData['gymDetails']['gymInfos']['level']=10;
+		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_scanned, '+00:00', '".$time_offset."')) as last_scanned, 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;
+				$gymData['gymDetails']['gymInfos']['description'] = $data->description;
+				if ($data->url == null) {
+					$gymData['gymDetails']['gymInfos']['url'] = '';
+				} else {
+					$gymData['gymDetails']['gymInfos']['url'] = $data->url;
+				}
+				$gymData['gymDetails']['gymInfos']['points'] = $data->points;
+				$gymData['gymDetails']['gymInfos']['level'] = 0;
+				$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
+				$gymData['gymDetails']['gymInfos']['team'] = $data->team;
+				$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
+				if ($data->points < 2000) {
+					$gymData['gymDetails']['gymInfos']['level']=1;
+				} elseif ($data->points < 4000) {
+					$gymData['gymDetails']['gymInfos']['level']=2;
+				} elseif ($data->points < 8000) {
+					$gymData['gymDetails']['gymInfos']['level']=3;
+				} elseif ($data->points < 12000) {
+					$gymData['gymDetails']['gymInfos']['level']=4;
+				} elseif ($data->points < 16000) {
+					$gymData['gymDetails']['gymInfos']['level']=5;
+				} elseif ($data->points < 20000) {
+					$gymData['gymDetails']['gymInfos']['level']=6;
+				} elseif ($data->points < 30000) {
+					$gymData['gymDetails']['gymInfos']['level']=7;
+				} elseif ($data->points < 40000) {
+					$gymData['gymDetails']['gymInfos']['level']=8;
+				} elseif ($data->points < 50000) {
+					$gymData['gymDetails']['gymInfos']['level']=9;
+				} else {
+					$gymData['gymDetails']['gymInfos']['level']=10;
+				}
 			}
-		}
-		//print_r($gymData);
-		$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."' ORDER BY cp DESC";
-		$result 	= $mysqli->query($req);
-		$i=0;
+			//print_r($gymData);
+			$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."' ORDER BY cp DESC";
+			$result 	= $mysqli->query($req);
+			$i=0;
 
 
 
-		$gymData['infoWindow'] = '
+			$gymData['infoWindow'] = '
 			<div class="gym_defenders">
 			';
-		while ($data = $result->fetch_object()) {
-			$gymData['gymDetails']['pokemons'][] = $data;
-			if ($data != false) {
-				if ($config->system->iv_numbers) {
-					$gymData['infoWindow'] .= '
+			while ($data = $result->fetch_object()) {
+				$gymData['gymDetails']['pokemons'][] = $data;
+				if ($data != false) {
+					if ($config->system->iv_numbers) {
+						$gymData['infoWindow'] .= '
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
 						<a href="pokemon/'.$data->pokemon_id.'">
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -531,9 +531,9 @@ 
 								</div>
 							</div>
 						</div>';
-				}
-				else {
-					$gymData['infoWindow'] .= '
+					}
+					else {
+						$gymData['infoWindow'] .= '
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
 						<a href="pokemon/'.$data->pokemon_id.'">
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -551,50 +551,50 @@ 
 							</div>
 						</div>
 					</div>'
-						; }
-			} else {
-				$gymData['infoWindow'] .= '
+							; }
+				} else {
+					$gymData['infoWindow'] .= '
 				<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
 					<a href="pokemon/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].'">
 					<img src="core/pokemons/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
 					</a>
 					<p class="pkmn-name">???</p>
 				</div>'
-				;
+					;
+				}
+				$i++;
 			}
-			$i++;
-		}
-		$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
-		$return = json_encode($gymData);
+			$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
+			$return = json_encode($gymData);
 
-		echo $return;
+			echo $return;
 
 
-		break;
+			break;
 
-	case 'trainer':
-		$name = "";
-		$page = "0";
-		$where = "";
-		$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) {
-			$team = mysqli_real_escape_string($mysqli, $_GET['team']);
-			$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
-		}
-		if (isset($_GET['page'])) {
-			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
-		}
-		if (isset($_GET['ranking'])) {
-			$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
-		}
+		case 'trainer':
+			$name = "";
+			$page = "0";
+			$where = "";
+			$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) {
+				$team = mysqli_real_escape_string($mysqli, $_GET['team']);
+				$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
+			}
+			if (isset($_GET['page'])) {
+				$page = mysqli_real_escape_string($mysqli, $_GET['page']);
+			}
+			if (isset($_GET['ranking'])) {
+				$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
+			}
 
-		switch ($ranking) {
+			switch ($ranking) {
 			case 1:
 				$order=" ORDER BY active DESC ";
 				break;
@@ -603,7 +603,7 @@ 
 				break;
 			default:
 				$order=" ORDER BY level DESC, active DESC ";
-		}
+			}
 
 		$limit = " LIMIT ".($page*10).",10 ";
 
@@ -660,100 +660,100 @@ 
 
 		break;
 
-	case 'pokemon_slider_init':
-		$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
-		$result 	= $mysqli->query($req);
-		$data 		= $result->fetch_object();
-		$bounds 	= $data;
+		case 'pokemon_slider_init':
+			$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
+			$result 	= $mysqli->query($req);
+			$data 		= $result->fetch_object();
+			$bounds 	= $data;
 
-		header('Content-Type: application/json');
-		$json = json_encode($bounds);
+			header('Content-Type: application/json');
+			$json = json_encode($bounds);
 
-		echo $json;
-		break;
+			echo $json;
+			break;
 
-	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']);
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
-			$where = " WHERE pokemon.pokemon_id = ".$pokemon_id." "
-					. "AND pokemon.disappear_time BETWEEN '".$start."' AND '".$end."'";
-			$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
-			$result 	= $mysqli->query($req);
-			$points = array();
-			while ($result && $data = $result->fetch_object()) {
-				$points[] 	= $data;
+		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']);
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
+				$where = " WHERE pokemon.pokemon_id = ".$pokemon_id." "
+						. "AND pokemon.disappear_time BETWEEN '".$start."' AND '".$end."'";
+				$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
+				$result 	= $mysqli->query($req);
+				$points = array();
+				while ($result && $data = $result->fetch_object()) {
+					$points[] 	= $data;
+				}
+
+				$json = json_encode($points);
 			}
 
-			$json = json_encode($points);
-		}
+			header('Content-Type: application/json');
 
-		header('Content-Type: application/json');
+			echo $json;
 
-		echo $json;
+			break;
 
-		break;
+		case 'pokedex':
+			$json="";
+			if (isset($_GET['pokemon_id'])) {
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
+				$where = " WHERE pokemon.pokemon_id = ".$pokemon_id;
+				$req 		= "SELECT COUNT(encounter_id) as total FROM pokemon".$where;
+				$result 	= $mysqli->query($req);
+				$total = 0;
+				while ($result && $data = $result->fetch_object()) {
+					$total 	= $data;
+				}
 
-	case 'pokedex':
-		$json="";
-		if (isset($_GET['pokemon_id'])) {
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
-			$where = " WHERE pokemon.pokemon_id = ".$pokemon_id;
-			$req 		= "SELECT COUNT(encounter_id) as total FROM pokemon".$where;
-			$result 	= $mysqli->query($req);
-			$total = 0;
-			while ($result && $data = $result->fetch_object()) {
-				$total 	= $data;
+				$json = json_encode($total);
 			}
 
-			$json = json_encode($total);
-		}
-
-		header('Content-Type: application/json');
+			header('Content-Type: application/json');
 
-		echo $json;
+			echo $json;
 
-		break;
+			break;
 
 		case 'postRequest':
 		break;
 
-	case 'pokemon_graph_data':
-		$json="";
-		if (isset($_GET['pokemon_id'])) {
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
-			$where = " WHERE pokemonFiltered.pokemon_id = ".$pokemon_id;
-			$req 		= "SELECT COUNT(*) as total, "
-					. "HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_hour
+		case 'pokemon_graph_data':
+			$json="";
+			if (isset($_GET['pokemon_id'])) {
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
+				$where = " WHERE pokemonFiltered.pokemon_id = ".$pokemon_id;
+				$req 		= "SELECT COUNT(*) as total, "
+						. "HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_hour
 			FROM (SELECT * FROM pokemon WHERE pokemon_id = '".$pokemon_id."' LIMIT 10000) as pokemonFiltered
 			GROUP BY disappear_hour
 			ORDER BY disappear_hour";
-			$result 	= $mysqli->query($req);
-			$array = array();
-			while ($result && $data = $result->fetch_object()) {
-				$array[] = $data->total;
+				$result 	= $mysqli->query($req);
+				$array = array();
+				while ($result && $data = $result->fetch_object()) {
+					$array[] = $data->total;
+				}
+				$array[] = array_shift($array);
+				$json = json_encode($array);
 			}
-			$array[] = array_shift($array);
-			$json = json_encode($array);
-		}
 
-		header('Content-Type: application/json');
+			header('Content-Type: application/json');
 
-		echo $json;
+			echo $json;
 
-		break;
+			break;
 
 		case 'postRequest':
 		break;
 
 
-	default:
-		echo "What do you mean?";
-		exit();
+		default:
+			echo "What do you mean?";
+			exit();
 
-	break;
+		break;
 }
 if ($postRequest!=""){
 	switch ($postRequest) {

Spacing +137 added lines, -137 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 	= 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));
 
 
 
@@ -37,19 +37,19 @@ 
 
 
 # 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 = "";
-if (isset($_GET['type'])){
-$request 	= $_GET['type'];
+if (isset($_GET['type'])) {
+$request = $_GET['type'];
 }
 $postRequest = "";
-if (isset($_POST['type'])){
+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;
@@ -159,12 +159,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()) {
@@ -203,27 +203,27 @@ 
 						if ($config->system->iv_numbers) {
 							$html .= '
 							<div class="progress" style="height: 15px; margin-bottom: 0">
-								<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/3)  .'%; line-height: 16px";>
-									<span class="sr-only">Attack IV: '. $iv->attack .'</span>'. $iv->attack .'
+								<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 / 3).'%; line-height: 16px";>
+									<span class="sr-only">Attack IV: '. $iv->attack.'</span>'.$iv->attack.'
 								</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/3)  .'%; line-height: 16px";>
-									<span class="sr-only">Defense IV: '. $iv->defense .'</span>'. $iv->defense .'
+								<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 / 3).'%; line-height: 16px";>
+									<span class="sr-only">Defense IV: '. $iv->defense.'</span>'.$iv->defense.'
 								</div>
-								<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/3)  .'%; line-height: 16px";>
-									<span class="sr-only">Stamina IV: '. $iv->stamina .'</span>'. $iv->stamina .'
+								<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 / 3).'%; line-height: 16px";>
+									<span class="sr-only">Stamina IV: '. $iv->stamina.'</span>'.$iv->stamina.'
 								</div>
 							</div>';
 						} else {
 							$html .= '
 							<div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto;">
-					    		<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 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>';
 						}
@@ -231,13 +231,13 @@ 
 						if ($config->system->iv_numbers) {
 							$html .= '
 							<div class="progress" style="height: 15px; margin-bottom: 0">
-								<div title="Attack IV: not available" 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";>
+								<div title="Attack IV: not available" 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">Attack IV: not available</span>?
 								</div>
-								<div title="Defense IV: not available" 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";>
+								<div title="Defense IV: not available" 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">Defense IV: not available</span>?
 								</div>
-								<div title="Stamina IV: not available" 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";>
+								<div title="Stamina IV: not available" 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">Stamina IV: not available</span>?
 								</div>
 							</div>';
@@ -275,15 +275,15 @@ 
 	####################################
 
 	case 'pokestop':
-		$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
-		$result 	= $mysqli->query($req);
+		$req = "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
+		$result = $mysqli->query($req);
 
-		$i=0;
+		$i = 0;
 
 		while ($data = $result->fetch_object()) {
 			if ($data->lure_expiration >= $data->now) {
 				$icon = 'pokestap_lured.png';
-				$text = 'Lured expire @ '.date('H:i:s', strtotime($data->lure_expiration_real)) ;
+				$text = 'Lured expire @ '.date('H:i:s', strtotime($data->lure_expiration_real));
 			} else {
 				$icon = 'pokestap.png';
 				$text = 'Normal stop';
@@ -316,19 +316,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);
@@ -347,11 +347,11 @@ 
 
 
 	case 'gym_map':
-		$req 		= "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) as last_scanned FROM gym";
-		$result 	= $mysqli->query($req);
+		$req = "SELECT gym_id, team_id, guard_pokemon_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) as last_scanned FROM gym";
+		$result = $mysqli->query($req);
 
 
-		$i=0;
+		$i = 0;
 
 		while ($data = $result->fetch_object()) {
 			// Team
@@ -363,50 +363,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.
@@ -457,8 +457,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_scanned, '+00:00', '".$time_offset."')) as last_scanned, 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_scanned, '+00:00', '".$time_offset."')) as last_scanned, 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;
@@ -474,35 +474,35 @@ 
 			$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 DISTINCT gympokemon.pokemon_uid, "
+		$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."' ORDER BY cp DESC";
-		$result 	= $mysqli->query($req);
-		$i=0;
+		$result = $mysqli->query($req);
+		$i = 0;
 
 
 
@@ -520,14 +520,14 @@ 
 						</a>
 						<p class="pkmn-name">'.$data->cp.'</p>
 						<div class="progress" style="height: 12px; margin-bottom: 0">
-							<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/3)  .'%; line-height: 13px; font-size: 11px">
-								<span class="sr-only">Angriff IV : '. $data->iv_attack .'</span>'.$data->iv_attack.'
+							<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 / 3).'%; line-height: 13px; font-size: 11px">
+								<span class="sr-only">Angriff IV : '. $data->iv_attack.'</span>'.$data->iv_attack.'
 								</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/3)  .'%; line-height: 13px; font-size: 11px">
-									<span class="sr-only">Verteidigung IV : '. $data->iv_defense .'</span>'. $data->iv_defense .'
+								<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 / 3).'%; line-height: 13px; font-size: 11px">
+									<span class="sr-only">Verteidigung IV : '. $data->iv_defense.'</span>'.$data->iv_defense.'
 								</div>
-								<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/3) .'%; line-height: 13px; font-size: 11px">
-									<span class="sr-only">KP IV : '. $data->iv_stamina .'</span>'. $data->iv_stamina .'
+								<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 / 3).'%; line-height: 13px; font-size: 11px">
+									<span class="sr-only">KP IV : '. $data->iv_stamina.'</span>'.$data->iv_stamina.'
 								</div>
 							</div>
 						</div>';
@@ -540,13 +540,13 @@ 
 						</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="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 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>
@@ -576,16 +576,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']);
@@ -596,16 +596,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 ".
@@ -624,7 +624,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, '1' as active ".
 				"FROM gympokemon INNER JOIN ".
@@ -634,7 +634,7 @@ 
 
 			$resultPkms = $mysqli->query($req);
 			$trainer->pokemons = array();
-			$active_gyms=0;
+			$active_gyms = 0;
 			$pkmCount = 0;
 			while ($resultPkms && $dataPkm = $resultPkms->fetch_object()) {
 				$active_gyms++;
@@ -661,9 +661,9 @@ 
 		break;
 
 	case 'pokemon_slider_init':
-		$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
+		$req = "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
 		$result 	= $mysqli->query($req);
-		$data 		= $result->fetch_object();
+		$data = $result->fetch_object();
 		$bounds 	= $data;
 
 		header('Content-Type: application/json');
@@ -673,18 +673,18 @@ 
 		break;
 
 	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.pokemon_id = ".$pokemon_id." "
 					. "AND pokemon.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);
@@ -697,7 +697,7 @@ 
 		break;
 
 	case 'pokedex':
-		$json="";
+		$json = "";
 		if (isset($_GET['pokemon_id'])) {
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
 			$where = " WHERE pokemon.pokemon_id = ".$pokemon_id;
@@ -721,7 +721,7 @@ 
 		break;
 
 	case 'pokemon_graph_data':
-		$json="";
+		$json = "";
 		if (isset($_GET['pokemon_id'])) {
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
 			$where = " WHERE pokemonFiltered.pokemon_id = ".$pokemon_id;
@@ -730,7 +730,7 @@ 
 			FROM (SELECT * FROM pokemon WHERE pokemon_id = '".$pokemon_id."' LIMIT 10000) as pokemonFiltered
 			GROUP BY disappear_hour
 			ORDER BY disappear_hour";
-			$result 	= $mysqli->query($req);
+			$result = $mysqli->query($req);
 			$array = array();
 			while ($result && $data = $result->fetch_object()) {
 				$array[] = $data->total;
@@ -755,30 +755,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.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 pokemon.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.") ";
 				}
@@ -786,12 +786,12 @@ 
 						. " (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, "
 						. " individual_attack, individual_defense, individual_stamina "
 						. "FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 5000";
-				$result 	= $mysqli->query($req);
+				$result = $mysqli->query($req);
 				$points = array();
 				while ($result && $data = $result->fetch_object()) {
-					$pokeid=$data->pokemon_id;
+					$pokeid = $data->pokemon_id;
 					$data->name = $pokemons->pokemon->$pokeid->name;
-					$points[] 	= $data;
+					$points[] = $data;
 				}
 
 				$json = json_encode($points);

Braces +4 added lines, -5 removed lines

@@ -43,11 +43,11 @@ 
 }
 $mysqli->set_charset('utf8');
 $request = "";
-if (isset($_GET['type'])){
+if (isset($_GET['type'])) {
 $request 	= $_GET['type'];
 }
 $postRequest = "";
-if (isset($_POST['type'])){
+if (isset($_POST['type'])) {
 	$postRequest = $_POST['type'];
 	$request= "postRequest";
 }
@@ -531,8 +531,7 @@ 
 								</div>
 							</div>
 						</div>';
-				}
-				else {
+				} else {
 					$gymData['infoWindow'] .= '
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
 						<a href="pokemon/'.$data->pokemon_id.'">
@@ -755,7 +754,7 @@ 
 
 	break;
 }
-if ($postRequest!=""){
+if ($postRequest!="") {
 	switch ($postRequest) {
 		case 'pokemon_live':
 			$json="";