Passed
Pull Request — master (#265)
by Markus
06:27
created
core/cron/crontabs.include.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -3,7 +3,7 @@  discard block
 block discarded – undo
3 3
 // This file only include other files to have only 1 entry in your crontabs. 
4 4
 // ------------------------------------------------------------------------	
5 5
 
6
-$config_file	= dirname(__FILE__).'/../../config.php';
6
+$config_file = dirname(__FILE__).'/../../config.php';
7 7
 
8 8
 include_once($config_file);
9 9
 
@@ -23,7 +23,7 @@  discard block
 block discarded – undo
23 23
 
24 24
 
25 25
 # MySQL 
26
-$mysqli		= new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
26
+$mysqli = new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
27 27
 
28 28
 if ($mysqli->connect_error != '') {
29 29
 	die('MySQL connect error');
@@ -32,10 +32,10 @@  discard block
 block discarded – undo
32 32
 
33 33
 // Update dashboard data
34 34
 // the following files are updated every run
35
-$gym_file	= SYS_PATH.'/core/json/gym.stats.json';
36
-$pokestop_file	= SYS_PATH.'/core/json/pokestop.stats.json';
37
-$pokemonstats_file	= SYS_PATH.'/core/json/pokemon.stats.json';
38
-$pokedex_counts_file	= SYS_PATH.'/core/json/pokedex.counts.json';
35
+$gym_file = SYS_PATH.'/core/json/gym.stats.json';
36
+$pokestop_file = SYS_PATH.'/core/json/pokestop.stats.json';
37
+$pokemonstats_file = SYS_PATH.'/core/json/pokemon.stats.json';
38
+$pokedex_counts_file = SYS_PATH.'/core/json/pokedex.counts.json';
39 39
 
40 40
 if (is_file($gym_file)) {
41 41
 	$gymsdatas	= json_decode(file_get_contents($gym_file), true);
Please login to merge, or discard this patch.
core/process/aru.php 2 patches
Switch Indentation   +332 added lines, -332 removed lines patch added patch discarded remove patch
@@ -58,150 +58,150 @@  discard block
 block discarded – undo
58 58
 	//
59 59
 	############################
60 60
 
61
-	case 'home_update':
62
-		// Right now
63
-		// ---------
61
+		case 'home_update':
62
+			// Right now
63
+			// ---------
64 64
 
65
-		$req 		= "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
66
-		$result 	= $mysqli->query($req);
67
-		$data 		= $result->fetch_object();
65
+			$req 		= "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
66
+			$result 	= $mysqli->query($req);
67
+			$data 		= $result->fetch_object();
68 68
 
69
-		$values[] 	= $data->total;
69
+			$values[] 	= $data->total;
70 70
 
71 71
 
72
-		// Lured stops
73
-		// -----------
72
+			// Lured stops
73
+			// -----------
74 74
 
75
-		$req 		= "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
76
-		$result 	= $mysqli->query($req);
77
-		$data 		= $result->fetch_object();
75
+			$req 		= "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
76
+			$result 	= $mysqli->query($req);
77
+			$data 		= $result->fetch_object();
78 78
 
79
-		$values[] 	= $data->total;
79
+			$values[] 	= $data->total;
80 80
 
81 81
 
82 82
 
83
-		// Team battle
84
-		// -----------
83
+			// Team battle
84
+			// -----------
85 85
 
86
-		$req 		= "SELECT count( DISTINCT(gym_id) ) as total FROM gym";
87
-		$result 	= $mysqli->query($req);
88
-		$data 		= $result->fetch_object();
86
+			$req 		= "SELECT count( DISTINCT(gym_id) ) as total FROM gym";
87
+			$result 	= $mysqli->query($req);
88
+			$data 		= $result->fetch_object();
89 89
 
90
-		$values[] 	= $data->total;
90
+			$values[] 	= $data->total;
91 91
 
92
-		// Team
93
-		// 1 = bleu
94
-		// 2 = rouge
95
-		// 3 = jaune
92
+			// Team
93
+			// 1 = bleu
94
+			// 2 = rouge
95
+			// 3 = jaune
96 96
 
97
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '2'  ";
98
-		$result	= $mysqli->query($req);
99
-		$data	= $result->fetch_object();
97
+			$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '2'  ";
98
+			$result	= $mysqli->query($req);
99
+			$data	= $result->fetch_object();
100 100
 
101
-		// Red
102
-		$values[] = $data->total;
101
+			// Red
102
+			$values[] = $data->total;
103 103
 
104 104
 
105
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '1'  ";
106
-		$result	= $mysqli->query($req);
107
-		$data	= $result->fetch_object();
105
+			$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '1'  ";
106
+			$result	= $mysqli->query($req);
107
+			$data	= $result->fetch_object();
108 108
 
109
-		// Blue
110
-		$values[] = $data->total;
109
+			// Blue
110
+			$values[] = $data->total;
111 111
 
112 112
 
113
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '3'  ";
114
-		$result	= $mysqli->query($req);
115
-		$data	= $result->fetch_object();
113
+			$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '3'  ";
114
+			$result	= $mysqli->query($req);
115
+			$data	= $result->fetch_object();
116 116
 
117
-		// Yellow
118
-		$values[] = $data->total;
117
+			// Yellow
118
+			$values[] = $data->total;
119 119
 
120
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '0'  ";
121
-		$result	= $mysqli->query($req);
122
-		$data	= $result->fetch_object();
120
+			$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '0'  ";
121
+			$result	= $mysqli->query($req);
122
+			$data	= $result->fetch_object();
123 123
 
124
-		// Neutral
125
-		$values[] = $data->total;
124
+			// Neutral
125
+			$values[] = $data->total;
126 126
 
127 127
 
128
-		header('Content-Type: application/json');
129
-		$json = json_encode($values);
128
+			header('Content-Type: application/json');
129
+			$json = json_encode($values);
130 130
 
131
-		echo $json;
131
+			echo $json;
132 132
 
133 133
 
134
-		break;
134
+			break;
135 135
 
136 136
 
137 137
 
138
-	####################################
139
-	//
140
-	// Update latests spawn on homepage
141
-	//
142
-	####################################
138
+		####################################
139
+		//
140
+		// Update latests spawn on homepage
141
+		//
142
+		####################################
143 143
 
144
-	case 'spawnlist_update':
145
-		// Recent spawn
146
-		// ------------
147
-		$total_spawns = array();
148
-		$last_uid_param = "";
149
-		if (isset($_GET['last_uid'])) {
150
-			$last_uid_param = $_GET['last_uid'];
151
-		}
152
-		if ($config->system->recents_filter) {
153
-			// get all mythic pokemon ids
154
-			$mythic_pokemons = array();
155
-			foreach ($pokemons->pokemon as $id => $pokemon) {
156
-				if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
157
-					$mythic_pokemons[] = $id;
158
-				}
144
+		case 'spawnlist_update':
145
+			// Recent spawn
146
+			// ------------
147
+			$total_spawns = array();
148
+			$last_uid_param = "";
149
+			if (isset($_GET['last_uid'])) {
150
+				$last_uid_param = $_GET['last_uid'];
159 151
 			}
152
+			if ($config->system->recents_filter) {
153
+				// get all mythic pokemon ids
154
+				$mythic_pokemons = array();
155
+				foreach ($pokemons->pokemon as $id => $pokemon) {
156
+					if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
157
+						$mythic_pokemons[] = $id;
158
+					}
159
+				}
160 160
 
161
-			// get last mythic pokemon
162
-			$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
161
+				// get last mythic pokemon
162
+				$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
163 163
                         WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
164 164
                         ORDER BY last_modified DESC LIMIT 0,12";
165
-		} else {
166
-			// get last pokemon
167
-			$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";
168
-		}
169
-		$result = $mysqli->query($req);
170
-		while ($data = $result->fetch_object()) {
171
-			$new_spawn = array();
172
-			$pokeid = $data->pokemon_id;
173
-			$pokeuid = $data->encounter_id;
174
-
175
-			if ($last_uid_param != $pokeuid) {
176
-				$last_seen = strtotime($data->disappear_time_real);
177
-
178
-				$last_location = new stdClass();
179
-				$last_location->latitude = $data->latitude;
180
-				$last_location->longitude = $data->longitude;
181
-
182
-				if ($config->system->recents_show_iv) {
183
-					$iv = new stdClass();
184
-					$iv->attack = $data->individual_attack;
185
-					$iv->defense = $data->individual_defense;
186
-					$iv->stamina = $data->individual_stamina;
187
-					if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
188
-						$iv->available = true;
189
-					} else {
190
-						$iv->available = false;
165
+			} else {
166
+				// get last pokemon
167
+				$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";
168
+			}
169
+			$result = $mysqli->query($req);
170
+			while ($data = $result->fetch_object()) {
171
+				$new_spawn = array();
172
+				$pokeid = $data->pokemon_id;
173
+				$pokeuid = $data->encounter_id;
174
+
175
+				if ($last_uid_param != $pokeuid) {
176
+					$last_seen = strtotime($data->disappear_time_real);
177
+
178
+					$last_location = new stdClass();
179
+					$last_location->latitude = $data->latitude;
180
+					$last_location->longitude = $data->longitude;
181
+
182
+					if ($config->system->recents_show_iv) {
183
+						$iv = new stdClass();
184
+						$iv->attack = $data->individual_attack;
185
+						$iv->defense = $data->individual_defense;
186
+						$iv->stamina = $data->individual_stamina;
187
+						if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
188
+							$iv->available = true;
189
+						} else {
190
+							$iv->available = false;
191
+						}
191 192
 					}
192
-				}
193 193
 
194
-				$html = '
194
+					$html = '
195 195
 			    <div class="col-md-1 col-xs-4 pokemon-single" data-pokeid="'.$pokeid.'" data-pokeuid="'.$pokeuid.'" style="display: none;">
196 196
 				<a href="pokemon/'.$pokeid.'"><img src="core/pokemons/'.$pokeid.$config->system->pokeimg_suffix.'" alt="'.$pokemons->pokemon->$pokeid->name.'" class="img-responsive"></a>
197 197
 				<a href="pokemon/'.$pokeid.'"><p class="pkmn-name">'.$pokemons->pokemon->$pokeid->name.'</p></a>
198 198
 				<a href="https://maps.google.com/?q='.$last_location->latitude.','.$last_location->longitude.'&ll='.$last_location->latitude.','.$last_location->longitude.'&z=16" target="_blank">
199 199
 				    <small class="pokemon-timer">00:00:00</small>
200 200
 				</a>';
201
-				if ($config->system->recents_show_iv) {
202
-					if ($iv->available) {
203
-						if ($config->system->iv_numbers) {
204
-							$html .= '
201
+					if ($config->system->recents_show_iv) {
202
+						if ($iv->available) {
203
+							if ($config->system->iv_numbers) {
204
+								$html .= '
205 205
 							<div class="progress" style="height: 15px; margin-bottom: 0">
206 206
 								<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";>
207 207
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack .'
@@ -213,8 +213,8 @@  discard block
 block discarded – undo
213 213
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina .'
214 214
 								</div>
215 215
 							</div>';
216
-						} else {
217
-							$html .= '
216
+							} else {
217
+								$html .= '
218 218
 							<div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto;">
219 219
 					    		<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).'%">
220 220
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>
@@ -226,10 +226,10 @@  discard block
 block discarded – undo
226 226
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>
227 227
 					    		</div>
228 228
 							</div>';
229
-						}
230
-					} else {
231
-						if ($config->system->iv_numbers) {
232
-							$html .= '
229
+							}
230
+						} else {
231
+							if ($config->system->iv_numbers) {
232
+								$html .= '
233 233
 							<div class="progress" style="height: 15px; margin-bottom: 0">
234 234
 								<div title="'.$locales->IV_ATTACK.': 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";>
235 235
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$locales->NOT_AVAILABLE.'</span>
@@ -241,129 +241,129 @@  discard block
 block discarded – undo
241 241
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$locales->NOT_AVAILABLE.'</span>
242 242
 								</div>
243 243
 							</div>';
244
-						} else {
245
-						$html .= '
244
+							} else {
245
+							$html .= '
246 246
 					    <div class="progress" style="height: 6px; width: 80%; margin: 5px auto 15px auto;">
247 247
 						    <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">
248 248
 							    <span class="sr-only">IV '.$locales->NOT_AVAILABLE.'</span>
249 249
 						    </div>
250 250
 					    </div>';
251
+							}
251 252
 						}
252 253
 					}
253
-				}
254
-				$html .= '
254
+					$html .= '
255 255
 			    </div>';
256
-				$new_spawn['html'] = $html;
257
-				$countdown = $last_seen - time();
258
-				$new_spawn['countdown'] = $countdown;
259
-				$new_spawn['pokemon_uid'] = $pokeuid;
260
-				$total_spawns[] = $new_spawn;
261
-			} else {
262
-				break;
256
+					$new_spawn['html'] = $html;
257
+					$countdown = $last_seen - time();
258
+					$new_spawn['countdown'] = $countdown;
259
+					$new_spawn['pokemon_uid'] = $pokeuid;
260
+					$total_spawns[] = $new_spawn;
261
+				} else {
262
+					break;
263
+				}
263 264
 			}
264
-		}
265
-		header('Content-Type: application/json');
266
-		echo json_encode($total_spawns);
267
-		break;
268
-
269
-
265
+			header('Content-Type: application/json');
266
+			echo json_encode($total_spawns);
267
+			break;
270 268
 
271
-	####################################
272
-	//
273
-	// List Pokestop
274
-	//
275
-	####################################
276 269
 
277
-	case 'pokestop':
278
-		if (!($config->system->only_lured_pokestops)) {
279
-			$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
280
-		} else {
281
-			$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop WHERE lure_expiration > UTC_TIMESTAMP()";
282
-		}
283
-		$result 	= $mysqli->query($req);
284 270
 
285
-		$i=0;
271
+		####################################
272
+		//
273
+		// List Pokestop
274
+		//
275
+		####################################
286 276
 
287
-		while ($data = $result->fetch_object()) {
288
-			if ($data->lure_expiration >= $data->now) {
289
-				$icon = 'pokestap_lured.png';
290
-				$text = sprintf($locales->POKESTOPS_MAP_LURED, date('H:i:s', strtotime($data->lure_expiration_real)));
277
+		case 'pokestop':
278
+			if (!($config->system->only_lured_pokestops)) {
279
+				$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop";
291 280
 			} else {
292
-				$icon = 'pokestap.png';
293
-				$text = $locales->POKESTOPS_MAP_REGULAR;
281
+				$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop WHERE lure_expiration > UTC_TIMESTAMP()";
294 282
 			}
283
+			$result 	= $mysqli->query($req);
295 284
 
296
-			$temp[$i][] = $text;
297
-			$temp[$i][] = $icon;
298
-			$temp[$i][] = $data->latitude;
299
-			$temp[$i][] = $data->longitude;
300
-			$temp[$i][] = $i;
285
+			$i=0;
301 286
 
302
-			$temp_json[] = json_encode($temp[$i]);
287
+			while ($data = $result->fetch_object()) {
288
+				if ($data->lure_expiration >= $data->now) {
289
+					$icon = 'pokestap_lured.png';
290
+					$text = sprintf($locales->POKESTOPS_MAP_LURED, date('H:i:s', strtotime($data->lure_expiration_real)));
291
+				} else {
292
+					$icon = 'pokestap.png';
293
+					$text = $locales->POKESTOPS_MAP_REGULAR;
294
+				}
303 295
 
296
+				$temp[$i][] = $text;
297
+				$temp[$i][] = $icon;
298
+				$temp[$i][] = $data->latitude;
299
+				$temp[$i][] = $data->longitude;
300
+				$temp[$i][] = $i;
304 301
 
305
-			$i++;
306
-		}
302
+				$temp_json[] = json_encode($temp[$i]);
307 303
 
308
-		$return = json_encode($temp_json);
309 304
 
310
-		echo $return;
305
+				$i++;
306
+			}
311 307
 
312
-		break;
308
+			$return = json_encode($temp_json);
313 309
 
310
+			echo $return;
314 311
 
312
+			break;
315 313
 
316
-	####################################
317
-	//
318
-	// Update data for the gym battle
319
-	//
320
-	####################################
321 314
 
322
-	case 'update_gym':
323
-		$teams			= new stdClass();
324
-		$teams->mystic 		= 1;
325
-		$teams->valor 		= 2;
326
-		$teams->instinct 	= 3;
327 315
 
316
+		####################################
317
+		//
318
+		// Update data for the gym battle
319
+		//
320
+		####################################
328 321
 
329
-		foreach ($teams as $team_name => $team_id) {
330
-			$req	= "SELECT COUNT(DISTINCT(gym_id)) as total, ROUND(AVG(gym_points),0) as average_points FROM gym WHERE team_id = '".$team_id."'  ";
331
-			$result	= $mysqli->query($req);
332
-			$data	= $result->fetch_object();
322
+		case 'update_gym':
323
+			$teams			= new stdClass();
324
+			$teams->mystic 		= 1;
325
+			$teams->valor 		= 2;
326
+			$teams->instinct 	= 3;
333 327
 
334
-			$return[] 	= $data->total;
335
-			$return[]	= $data->average_points;
336
-		}
337 328
 
338
-		$json = json_encode($return);
329
+			foreach ($teams as $team_name => $team_id) {
330
+				$req	= "SELECT COUNT(DISTINCT(gym_id)) as total, ROUND(AVG(gym_points),0) as average_points FROM gym WHERE team_id = '".$team_id."'  ";
331
+				$result	= $mysqli->query($req);
332
+				$data	= $result->fetch_object();
339 333
 
340
-		header('Content-Type: application/json');
341
-		echo $json;
334
+				$return[] 	= $data->total;
335
+				$return[]	= $data->average_points;
336
+			}
342 337
 
338
+			$json = json_encode($return);
343 339
 
344
-		break;
340
+			header('Content-Type: application/json');
341
+			echo $json;
345 342
 
346
-	####################################
347
-	//
348
-	// Get datas for the gym map
349
-	//
350
-	####################################
351 343
 
344
+			break;
352 345
 
353
-	case 'gym_map':
354
-		$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";
355
-		$result 	= $mysqli->query($req);
346
+		####################################
347
+		//
348
+		// Get datas for the gym map
349
+		//
350
+		####################################
356 351
 
357 352
 
358
-		$i=0;
353
+		case 'gym_map':
354
+			$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";
355
+			$result 	= $mysqli->query($req);
359 356
 
360
-		while ($data = $result->fetch_object()) {
361
-			// Team
362
-			// 1 = bleu
363
-			// 2 = rouge
364
-			// 3 = jaune
365 357
 
366
-			switch ($data->team_id) {
358
+			$i=0;
359
+
360
+			while ($data = $result->fetch_object()) {
361
+				// Team
362
+				// 1 = bleu
363
+				// 2 = rouge
364
+				// 3 = jaune
365
+
366
+				switch ($data->team_id) {
367 367
 				case 0:
368 368
 					$icon	= 'map_white.png';
369 369
 					$team	= 'No Team (yet)';
@@ -387,7 +387,7 @@  discard block
 block discarded – undo
387 387
 					$team	= 'Team Instinct';
388 388
 					$color	= 'rgba(254, 217, 40, .6)';
389 389
 					break;
390
-			}
390
+				}
391 391
 
392 392
 			// Set gym level
393 393
 			$data->gym_level=0;
@@ -459,65 +459,65 @@  discard block
 block discarded – undo
459 459
 	//
460 460
 	####################################
461 461
 
462
-	case 'gym_defenders':
463
-		$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
464
-		$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."'";
465
-		$result 	= $mysqli->query($req);
466
-		$gymData['gymDetails']['gymInfos'] = false;
467
-		while ($data = $result->fetch_object()) {
468
-			$gymData['gymDetails']['gymInfos']['name'] = $data->name;
469
-			$gymData['gymDetails']['gymInfos']['description'] = $data->description;
470
-			if ($data->url == null) {
471
-				$gymData['gymDetails']['gymInfos']['url'] = '';
472
-			} else {
473
-				$gymData['gymDetails']['gymInfos']['url'] = $data->url;
474
-			}
475
-			$gymData['gymDetails']['gymInfos']['points'] = $data->points;
476
-			$gymData['gymDetails']['gymInfos']['level'] = 0;
477
-			$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
478
-			$gymData['gymDetails']['gymInfos']['team'] = $data->team;
479
-			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
480
-			if ($data->points < 2000) {
481
-				$gymData['gymDetails']['gymInfos']['level']=1;
482
-			} elseif ($data->points < 4000) {
483
-				$gymData['gymDetails']['gymInfos']['level']=2;
484
-			} elseif ($data->points < 8000) {
485
-				$gymData['gymDetails']['gymInfos']['level']=3;
486
-			} elseif ($data->points < 12000) {
487
-				$gymData['gymDetails']['gymInfos']['level']=4;
488
-			} elseif ($data->points < 16000) {
489
-				$gymData['gymDetails']['gymInfos']['level']=5;
490
-			} elseif ($data->points < 20000) {
491
-				$gymData['gymDetails']['gymInfos']['level']=6;
492
-			} elseif ($data->points < 30000) {
493
-				$gymData['gymDetails']['gymInfos']['level']=7;
494
-			} elseif ($data->points < 40000) {
495
-				$gymData['gymDetails']['gymInfos']['level']=8;
496
-			} elseif ($data->points < 50000) {
497
-				$gymData['gymDetails']['gymInfos']['level']=9;
498
-			} else {
499
-				$gymData['gymDetails']['gymInfos']['level']=10;
462
+		case 'gym_defenders':
463
+			$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
464
+			$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."'";
465
+			$result 	= $mysqli->query($req);
466
+			$gymData['gymDetails']['gymInfos'] = false;
467
+			while ($data = $result->fetch_object()) {
468
+				$gymData['gymDetails']['gymInfos']['name'] = $data->name;
469
+				$gymData['gymDetails']['gymInfos']['description'] = $data->description;
470
+				if ($data->url == null) {
471
+					$gymData['gymDetails']['gymInfos']['url'] = '';
472
+				} else {
473
+					$gymData['gymDetails']['gymInfos']['url'] = $data->url;
474
+				}
475
+				$gymData['gymDetails']['gymInfos']['points'] = $data->points;
476
+				$gymData['gymDetails']['gymInfos']['level'] = 0;
477
+				$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
478
+				$gymData['gymDetails']['gymInfos']['team'] = $data->team;
479
+				$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
480
+				if ($data->points < 2000) {
481
+					$gymData['gymDetails']['gymInfos']['level']=1;
482
+				} elseif ($data->points < 4000) {
483
+					$gymData['gymDetails']['gymInfos']['level']=2;
484
+				} elseif ($data->points < 8000) {
485
+					$gymData['gymDetails']['gymInfos']['level']=3;
486
+				} elseif ($data->points < 12000) {
487
+					$gymData['gymDetails']['gymInfos']['level']=4;
488
+				} elseif ($data->points < 16000) {
489
+					$gymData['gymDetails']['gymInfos']['level']=5;
490
+				} elseif ($data->points < 20000) {
491
+					$gymData['gymDetails']['gymInfos']['level']=6;
492
+				} elseif ($data->points < 30000) {
493
+					$gymData['gymDetails']['gymInfos']['level']=7;
494
+				} elseif ($data->points < 40000) {
495
+					$gymData['gymDetails']['gymInfos']['level']=8;
496
+				} elseif ($data->points < 50000) {
497
+					$gymData['gymDetails']['gymInfos']['level']=9;
498
+				} else {
499
+					$gymData['gymDetails']['gymInfos']['level']=10;
500
+				}
500 501
 			}
501
-		}
502
-		//print_r($gymData);
503
-		$req 		= "SELECT DISTINCT gympokemon.pokemon_uid, "
504
-				. "pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) as cp, gymmember.gym_id "
505
-				. "FROM gympokemon inner join gymmember on gympokemon.pokemon_uid=gymmember.pokemon_uid "
506
-				. "GROUP BY gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, gym_id"
507
-				. " HAVING gymmember.gym_id='".$gym_id."' ORDER BY cp DESC";
508
-		$result 	= $mysqli->query($req);
509
-		$i=0;
502
+			//print_r($gymData);
503
+			$req 		= "SELECT DISTINCT gympokemon.pokemon_uid, "
504
+					. "pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) as cp, gymmember.gym_id "
505
+					. "FROM gympokemon inner join gymmember on gympokemon.pokemon_uid=gymmember.pokemon_uid "
506
+					. "GROUP BY gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, gym_id"
507
+					. " HAVING gymmember.gym_id='".$gym_id."' ORDER BY cp DESC";
508
+			$result 	= $mysqli->query($req);
509
+			$i=0;
510 510
 
511 511
 
512 512
 
513
-		$gymData['infoWindow'] = '
513
+			$gymData['infoWindow'] = '
514 514
 			<div class="gym_defenders">
515 515
 			';
516
-		while ($data = $result->fetch_object()) {
517
-			$gymData['gymDetails']['pokemons'][] = $data;
518
-			if ($data != false) {
519
-				if ($config->system->iv_numbers) {
520
-					$gymData['infoWindow'] .= '
516
+			while ($data = $result->fetch_object()) {
517
+				$gymData['gymDetails']['pokemons'][] = $data;
518
+				if ($data != false) {
519
+					if ($config->system->iv_numbers) {
520
+						$gymData['infoWindow'] .= '
521 521
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
522 522
 						<a href="pokemon/'.$data->pokemon_id.'">
523 523
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -535,8 +535,8 @@  discard block
 block discarded – undo
535 535
 								</div>
536 536
 							</div>
537 537
 						</div>';
538
-				} else {
539
-					$gymData['infoWindow'] .= '
538
+					} else {
539
+						$gymData['infoWindow'] .= '
540 540
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
541 541
 						<a href="pokemon/'.$data->pokemon_id.'">
542 542
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -554,50 +554,50 @@  discard block
 block discarded – undo
554 554
 							</div>
555 555
 						</div>
556 556
 					</div>'
557
-						; }
558
-			} else {
559
-				$gymData['infoWindow'] .= '
557
+							; }
558
+				} else {
559
+					$gymData['infoWindow'] .= '
560 560
 				<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
561 561
 					<a href="pokemon/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].'">
562 562
 					<img src="core/pokemons/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
563 563
 					</a>
564 564
 					<p class="pkmn-name">???</p>
565 565
 				</div>'
566
-				;
566
+					;
567
+				}
568
+				$i++;
567 569
 			}
568
-			$i++;
569
-		}
570
-		$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
571
-		$return = json_encode($gymData);
570
+			$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
571
+			$return = json_encode($gymData);
572 572
 
573
-		echo $return;
573
+			echo $return;
574 574
 
575 575
 
576
-		break;
576
+			break;
577 577
 
578
-	case 'trainer':
579
-		$name = "";
580
-		$page = "0";
581
-		$where = "";
582
-		$order="";
583
-		$team=0;
584
-		$ranking=0;
585
-		if (isset($_GET['name'])) {
586
-			$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
587
-			$where = " HAVING name LIKE '%".$trainer_name."%'";
588
-		}
589
-		if (isset($_GET['team']) && $_GET['team']!=0) {
590
-			$team = mysqli_real_escape_string($mysqli, $_GET['team']);
591
-			$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
592
-		}
593
-		if (isset($_GET['page'])) {
594
-			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
595
-		}
596
-		if (isset($_GET['ranking'])) {
597
-			$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
598
-		}
578
+		case 'trainer':
579
+			$name = "";
580
+			$page = "0";
581
+			$where = "";
582
+			$order="";
583
+			$team=0;
584
+			$ranking=0;
585
+			if (isset($_GET['name'])) {
586
+				$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
587
+				$where = " HAVING name LIKE '%".$trainer_name."%'";
588
+			}
589
+			if (isset($_GET['team']) && $_GET['team']!=0) {
590
+				$team = mysqli_real_escape_string($mysqli, $_GET['team']);
591
+				$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
592
+			}
593
+			if (isset($_GET['page'])) {
594
+				$page = mysqli_real_escape_string($mysqli, $_GET['page']);
595
+			}
596
+			if (isset($_GET['ranking'])) {
597
+				$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
598
+			}
599 599
 
600
-		switch ($ranking) {
600
+			switch ($ranking) {
601 601
 			case 1:
602 602
 				$order=" ORDER BY active DESC ";
603 603
 				break;
@@ -606,7 +606,7 @@  discard block
 block discarded – undo
606 606
 				break;
607 607
 			default:
608 608
 				$order=" ORDER BY level DESC, active DESC ";
609
-		}
609
+			}
610 610
 
611 611
 		$limit = " LIMIT ".($page*10).",10 ";
612 612
 
@@ -673,77 +673,77 @@  discard block
 block discarded – undo
673 673
 
674 674
 		break;
675 675
 
676
-	case 'pokemon_slider_init':
677
-		$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
678
-		$result 	= $mysqli->query($req);
679
-		$data 		= $result->fetch_object();
680
-		$bounds 	= $data;
676
+		case 'pokemon_slider_init':
677
+			$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
678
+			$result 	= $mysqli->query($req);
679
+			$data 		= $result->fetch_object();
680
+			$bounds 	= $data;
681 681
 
682
-		header('Content-Type: application/json');
683
-		$json = json_encode($bounds);
682
+			header('Content-Type: application/json');
683
+			$json = json_encode($bounds);
684 684
 
685
-		echo $json;
686
-		break;
685
+			echo $json;
686
+			break;
687 687
 
688
-	case 'pokemon_heatmap_points':
689
-		$json="";
690
-		if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
691
-			$start = Date("Y-m-d H:i",(int)$_GET['start']);
692
-			$end = Date("Y-m-d H:i",(int)$_GET['end']);
693
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
694
-			$where = " WHERE pokemon.pokemon_id = ".$pokemon_id." "
695
-					. "AND pokemon.disappear_time BETWEEN '".$start."' AND '".$end."'";
696
-			$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
697
-			$result 	= $mysqli->query($req);
698
-			$points = array();
699
-			while ($result && $data = $result->fetch_object()) {
700
-				$points[] 	= $data;
701
-			}
688
+		case 'pokemon_heatmap_points':
689
+			$json="";
690
+			if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
691
+				$start = Date("Y-m-d H:i",(int)$_GET['start']);
692
+				$end = Date("Y-m-d H:i",(int)$_GET['end']);
693
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
694
+				$where = " WHERE pokemon.pokemon_id = ".$pokemon_id." "
695
+						. "AND pokemon.disappear_time BETWEEN '".$start."' AND '".$end."'";
696
+				$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
697
+				$result 	= $mysqli->query($req);
698
+				$points = array();
699
+				while ($result && $data = $result->fetch_object()) {
700
+					$points[] 	= $data;
701
+				}
702 702
 
703
-			$json = json_encode($points);
704
-		}
703
+				$json = json_encode($points);
704
+			}
705 705
 
706
-		header('Content-Type: application/json');
706
+			header('Content-Type: application/json');
707 707
 
708
-		echo $json;
708
+			echo $json;
709 709
 
710
-		break;
710
+			break;
711 711
 
712
-	case 'pokemon_graph_data':
713
-		$json="";
714
-		if (isset($_GET['pokemon_id'])) {
715
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
716
-			$req 		= "SELECT COUNT(*) as total, "
717
-					. "HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_hour
712
+		case 'pokemon_graph_data':
713
+			$json="";
714
+			if (isset($_GET['pokemon_id'])) {
715
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
716
+				$req 		= "SELECT COUNT(*) as total, "
717
+						. "HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_hour
718 718
 			FROM (SELECT disappear_time FROM pokemon WHERE pokemon_id = '".$pokemon_id."' ORDER BY disappear_time LIMIT 10000) as pokemonFiltered
719 719
 			GROUP BY disappear_hour
720 720
 			ORDER BY disappear_hour";
721
-			$result 	= $mysqli->query($req);
722
-			$array = array_fill(0, 24, 0);
723
-			while ($result && $data = $result->fetch_object()) {
724
-				$array[$data->disappear_hour] = $data->total;
725
-			}
726
-			// shift array because AM/PM starts at 1AM not 0:00
727
-			$array[] = $array[0];
728
-			array_shift($array);
721
+				$result 	= $mysqli->query($req);
722
+				$array = array_fill(0, 24, 0);
723
+				while ($result && $data = $result->fetch_object()) {
724
+					$array[$data->disappear_hour] = $data->total;
725
+				}
726
+				// shift array because AM/PM starts at 1AM not 0:00
727
+				$array[] = $array[0];
728
+				array_shift($array);
729 729
 
730
-			$json = json_encode($array);
731
-		}
730
+				$json = json_encode($array);
731
+			}
732 732
 
733
-		header('Content-Type: application/json');
733
+			header('Content-Type: application/json');
734 734
 
735
-		echo $json;
735
+			echo $json;
736 736
 
737
-		break;
737
+			break;
738 738
 
739
-	case 'postRequest':
740
-		break;
739
+		case 'postRequest':
740
+			break;
741 741
 
742
-	default:
743
-		echo "What do you mean?";
744
-		exit();
742
+		default:
743
+			echo "What do you mean?";
744
+			exit();
745 745
 
746
-	break;
746
+		break;
747 747
 }
748 748
 if ($postRequest!="") {
749 749
 	switch ($postRequest) {
Please login to merge, or discard this patch.
Spacing   +118 added lines, -118 removed lines patch added patch discarded remove patch
@@ -6,7 +6,7 @@  discard block
 block discarded – undo
6 6
 
7 7
 $pos = !empty($_SERVER['HTTP_REFERER']) && strpos($_SERVER['HTTP_REFERER'], getenv('HTTP_HOST'));
8 8
 
9
-if ($pos===false) {
9
+if ($pos === false) {
10 10
 	http_response_code(401);
11 11
 	die('Restricted access');
12 12
 }
@@ -19,8 +19,8 @@  discard block
 block discarded – undo
19 19
 // Include & load the variables
20 20
 // ############################
21 21
 
22
-$variables 	= SYS_PATH.'/core/json/variables.json';
23
-$config 	= json_decode(file_get_contents($variables));
22
+$variables = SYS_PATH.'/core/json/variables.json';
23
+$config = json_decode(file_get_contents($variables));
24 24
 
25 25
 
26 26
 
@@ -37,19 +37,19 @@  discard block
 block discarded – undo
37 37
 
38 38
 
39 39
 # MySQL
40
-$mysqli 	= new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
40
+$mysqli = new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
41 41
 if ($mysqli->connect_error != '') {
42 42
 	exit('Error MySQL Connect');
43 43
 }
44 44
 $mysqli->set_charset('utf8');
45 45
 $request = "";
46 46
 if (isset($_GET['type'])) {
47
-$request 	= $_GET['type'];
47
+$request = $_GET['type'];
48 48
 }
49 49
 $postRequest = "";
50 50
 if (isset($_POST['type'])) {
51 51
 	$postRequest = $_POST['type'];
52
-	$request= "postRequest";
52
+	$request = "postRequest";
53 53
 }
54 54
 switch ($request) {
55 55
 	############################
@@ -62,64 +62,64 @@  discard block
 block discarded – undo
62 62
 		// Right now
63 63
 		// ---------
64 64
 
65
-		$req 		= "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
66
-		$result 	= $mysqli->query($req);
67
-		$data 		= $result->fetch_object();
65
+		$req = "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
66
+		$result = $mysqli->query($req);
67
+		$data = $result->fetch_object();
68 68
 
69
-		$values[] 	= $data->total;
69
+		$values[] = $data->total;
70 70
 
71 71
 
72 72
 		// Lured stops
73 73
 		// -----------
74 74
 
75
-		$req 		= "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
76
-		$result 	= $mysqli->query($req);
77
-		$data 		= $result->fetch_object();
75
+		$req = "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
76
+		$result = $mysqli->query($req);
77
+		$data = $result->fetch_object();
78 78
 
79
-		$values[] 	= $data->total;
79
+		$values[] = $data->total;
80 80
 
81 81
 
82 82
 
83 83
 		// Team battle
84 84
 		// -----------
85 85
 
86
-		$req 		= "SELECT count( DISTINCT(gym_id) ) as total FROM gym";
87
-		$result 	= $mysqli->query($req);
88
-		$data 		= $result->fetch_object();
86
+		$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym";
87
+		$result = $mysqli->query($req);
88
+		$data = $result->fetch_object();
89 89
 
90
-		$values[] 	= $data->total;
90
+		$values[] = $data->total;
91 91
 
92 92
 		// Team
93 93
 		// 1 = bleu
94 94
 		// 2 = rouge
95 95
 		// 3 = jaune
96 96
 
97
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '2'  ";
98
-		$result	= $mysqli->query($req);
99
-		$data	= $result->fetch_object();
97
+		$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '2'  ";
98
+		$result = $mysqli->query($req);
99
+		$data = $result->fetch_object();
100 100
 
101 101
 		// Red
102 102
 		$values[] = $data->total;
103 103
 
104 104
 
105
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '1'  ";
106
-		$result	= $mysqli->query($req);
107
-		$data	= $result->fetch_object();
105
+		$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '1'  ";
106
+		$result = $mysqli->query($req);
107
+		$data = $result->fetch_object();
108 108
 
109 109
 		// Blue
110 110
 		$values[] = $data->total;
111 111
 
112 112
 
113
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '3'  ";
114
-		$result	= $mysqli->query($req);
115
-		$data	= $result->fetch_object();
113
+		$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '3'  ";
114
+		$result = $mysqli->query($req);
115
+		$data = $result->fetch_object();
116 116
 
117 117
 		// Yellow
118 118
 		$values[] = $data->total;
119 119
 
120
-		$req	= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '0'  ";
121
-		$result	= $mysqli->query($req);
122
-		$data	= $result->fetch_object();
120
+		$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '0'  ";
121
+		$result = $mysqli->query($req);
122
+		$data = $result->fetch_object();
123 123
 
124 124
 		// Neutral
125 125
 		$values[] = $data->total;
@@ -159,12 +159,12 @@  discard block
 block discarded – undo
159 159
 			}
160 160
 
161 161
 			// get last mythic pokemon
162
-			$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
162
+			$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
163 163
                         WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
164 164
                         ORDER BY last_modified DESC LIMIT 0,12";
165 165
 		} else {
166 166
 			// get last pokemon
167
-			$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";
167
+			$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";
168 168
 		}
169 169
 		$result = $mysqli->query($req);
170 170
 		while ($data = $result->fetch_object()) {
@@ -204,13 +204,13 @@  discard block
 block discarded – undo
204 204
 							$html .= '
205 205
 							<div class="progress" style="height: 15px; margin-bottom: 0">
206 206
 								<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";>
207
-									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack .'
207
+									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack.'
208 208
 								</div>
209 209
 								<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";>
210
-									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>'.$iv->defense .'
210
+									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>'.$iv->defense.'
211 211
 								</div>
212 212
 								<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";>
213
-									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina .'
213
+									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina.'
214 214
 								</div>
215 215
 							</div>';
216 216
 						} else {
@@ -219,10 +219,10 @@  discard block
 block discarded – undo
219 219
 					    		<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).'%">
220 220
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>
221 221
 					    		</div>
222
-					    		<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).'%">
222
+					    		<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).'%">
223 223
 									<span class="sr-only">'.$locales->IV_DEFENSE.': '.$iv->defense.'</span>
224 224
 					    		</div>
225
-					    		<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).'%">
225
+					    		<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).'%">
226 226
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>
227 227
 					    		</div>
228 228
 							</div>';
@@ -280,9 +280,9 @@  discard block
 block discarded – undo
280 280
 		} else {
281 281
 			$req 		= "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() as now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) as lure_expiration_real FROM pokestop WHERE lure_expiration > UTC_TIMESTAMP()";
282 282
 		}
283
-		$result 	= $mysqli->query($req);
283
+		$result = $mysqli->query($req);
284 284
 
285
-		$i=0;
285
+		$i = 0;
286 286
 
287 287
 		while ($data = $result->fetch_object()) {
288 288
 			if ($data->lure_expiration >= $data->now) {
@@ -320,19 +320,19 @@  discard block
 block discarded – undo
320 320
 	####################################
321 321
 
322 322
 	case 'update_gym':
323
-		$teams			= new stdClass();
324
-		$teams->mystic 		= 1;
325
-		$teams->valor 		= 2;
326
-		$teams->instinct 	= 3;
323
+		$teams = new stdClass();
324
+		$teams->mystic = 1;
325
+		$teams->valor = 2;
326
+		$teams->instinct = 3;
327 327
 
328 328
 
329 329
 		foreach ($teams as $team_name => $team_id) {
330
-			$req	= "SELECT COUNT(DISTINCT(gym_id)) as total, ROUND(AVG(gym_points),0) as average_points FROM gym WHERE team_id = '".$team_id."'  ";
331
-			$result	= $mysqli->query($req);
332
-			$data	= $result->fetch_object();
330
+			$req = "SELECT COUNT(DISTINCT(gym_id)) as total, ROUND(AVG(gym_points),0) as average_points FROM gym WHERE team_id = '".$team_id."'  ";
331
+			$result = $mysqli->query($req);
332
+			$data = $result->fetch_object();
333 333
 
334
-			$return[] 	= $data->total;
335
-			$return[]	= $data->average_points;
334
+			$return[] = $data->total;
335
+			$return[] = $data->average_points;
336 336
 		}
337 337
 
338 338
 		$json = json_encode($return);
@@ -351,11 +351,11 @@  discard block
 block discarded – undo
351 351
 
352 352
 
353 353
 	case 'gym_map':
354
-		$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";
355
-		$result 	= $mysqli->query($req);
354
+		$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";
355
+		$result = $mysqli->query($req);
356 356
 
357 357
 
358
-		$i=0;
358
+		$i = 0;
359 359
 
360 360
 		while ($data = $result->fetch_object()) {
361 361
 			// Team
@@ -367,50 +367,50 @@  discard block
 block discarded – undo
367 367
 				case 0:
368 368
 					$icon	= 'map_white.png';
369 369
 					$team	= 'No Team (yet)';
370
-					$color	= 'rgba(0, 0, 0, .6)';
370
+					$color = 'rgba(0, 0, 0, .6)';
371 371
 					break;
372 372
 
373 373
 				case 1:
374 374
 					$icon	= 'map_blue_';
375 375
 					$team	= 'Team Mystic';
376
-					$color	= 'rgba(74, 138, 202, .6)';
376
+					$color = 'rgba(74, 138, 202, .6)';
377 377
 					break;
378 378
 
379 379
 				case 2:
380 380
 					$icon	= 'map_red_';
381 381
 					$team	= 'Team Valor';
382
-					$color	= 'rgba(240, 68, 58, .6)';
382
+					$color = 'rgba(240, 68, 58, .6)';
383 383
 					break;
384 384
 
385 385
 				case 3:
386 386
 					$icon	= 'map_yellow_';
387 387
 					$team	= 'Team Instinct';
388
-					$color	= 'rgba(254, 217, 40, .6)';
388
+					$color = 'rgba(254, 217, 40, .6)';
389 389
 					break;
390 390
 			}
391 391
 
392 392
 			// Set gym level
393
-			$data->gym_level=0;
393
+			$data->gym_level = 0;
394 394
 			if ($data->gym_points < 2000) {
395
-				$data->gym_level=1;
395
+				$data->gym_level = 1;
396 396
 			} elseif ($data->gym_points < 4000) {
397
-				$data->gym_level=2;
397
+				$data->gym_level = 2;
398 398
 			} elseif ($data->gym_points < 8000) {
399
-				$data->gym_level=3;
399
+				$data->gym_level = 3;
400 400
 			} elseif ($data->gym_points < 12000) {
401
-				$data->gym_level=4;
401
+				$data->gym_level = 4;
402 402
 			} elseif ($data->gym_points < 16000) {
403
-				$data->gym_level=5;
403
+				$data->gym_level = 5;
404 404
 			} elseif ($data->gym_points < 20000) {
405
-				$data->gym_level=6;
405
+				$data->gym_level = 6;
406 406
 			} elseif ($data->gym_points < 30000) {
407
-				$data->gym_level=7;
407
+				$data->gym_level = 7;
408 408
 			} elseif ($data->gym_points < 40000) {
409
-				$data->gym_level=8;
409
+				$data->gym_level = 8;
410 410
 			} elseif ($data->gym_points < 50000) {
411
-				$data->gym_level=9;
411
+				$data->gym_level = 9;
412 412
 			} else {
413
-				$data->gym_level=10;
413
+				$data->gym_level = 10;
414 414
 			}
415 415
 
416 416
 			## I know, I revert commit 6e8d2e7 from @kiralydavid but the way it was done broke the page.
@@ -461,8 +461,8 @@  discard block
 block discarded – undo
461 461
 
462 462
 	case 'gym_defenders':
463 463
 		$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
464
-		$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."'";
465
-		$result 	= $mysqli->query($req);
464
+		$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."'";
465
+		$result = $mysqli->query($req);
466 466
 		$gymData['gymDetails']['gymInfos'] = false;
467 467
 		while ($data = $result->fetch_object()) {
468 468
 			$gymData['gymDetails']['gymInfos']['name'] = $data->name;
@@ -478,35 +478,35 @@  discard block
 block discarded – undo
478 478
 			$gymData['gymDetails']['gymInfos']['team'] = $data->team;
479 479
 			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
480 480
 			if ($data->points < 2000) {
481
-				$gymData['gymDetails']['gymInfos']['level']=1;
481
+				$gymData['gymDetails']['gymInfos']['level'] = 1;
482 482
 			} elseif ($data->points < 4000) {
483
-				$gymData['gymDetails']['gymInfos']['level']=2;
483
+				$gymData['gymDetails']['gymInfos']['level'] = 2;
484 484
 			} elseif ($data->points < 8000) {
485
-				$gymData['gymDetails']['gymInfos']['level']=3;
485
+				$gymData['gymDetails']['gymInfos']['level'] = 3;
486 486
 			} elseif ($data->points < 12000) {
487
-				$gymData['gymDetails']['gymInfos']['level']=4;
487
+				$gymData['gymDetails']['gymInfos']['level'] = 4;
488 488
 			} elseif ($data->points < 16000) {
489
-				$gymData['gymDetails']['gymInfos']['level']=5;
489
+				$gymData['gymDetails']['gymInfos']['level'] = 5;
490 490
 			} elseif ($data->points < 20000) {
491
-				$gymData['gymDetails']['gymInfos']['level']=6;
491
+				$gymData['gymDetails']['gymInfos']['level'] = 6;
492 492
 			} elseif ($data->points < 30000) {
493
-				$gymData['gymDetails']['gymInfos']['level']=7;
493
+				$gymData['gymDetails']['gymInfos']['level'] = 7;
494 494
 			} elseif ($data->points < 40000) {
495
-				$gymData['gymDetails']['gymInfos']['level']=8;
495
+				$gymData['gymDetails']['gymInfos']['level'] = 8;
496 496
 			} elseif ($data->points < 50000) {
497
-				$gymData['gymDetails']['gymInfos']['level']=9;
497
+				$gymData['gymDetails']['gymInfos']['level'] = 9;
498 498
 			} else {
499
-				$gymData['gymDetails']['gymInfos']['level']=10;
499
+				$gymData['gymDetails']['gymInfos']['level'] = 10;
500 500
 			}
501 501
 		}
502 502
 		//print_r($gymData);
503
-		$req 		= "SELECT DISTINCT gympokemon.pokemon_uid, "
503
+		$req = "SELECT DISTINCT gympokemon.pokemon_uid, "
504 504
 				. "pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) as cp, gymmember.gym_id "
505 505
 				. "FROM gympokemon inner join gymmember on gympokemon.pokemon_uid=gymmember.pokemon_uid "
506 506
 				. "GROUP BY gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, gym_id"
507 507
 				. " HAVING gymmember.gym_id='".$gym_id."' ORDER BY cp DESC";
508
-		$result 	= $mysqli->query($req);
509
-		$i=0;
508
+		$result = $mysqli->query($req);
509
+		$i = 0;
510 510
 
511 511
 
512 512
 
@@ -528,10 +528,10 @@  discard block
 block discarded – undo
528 528
 								<span class="sr-only">'.$locales->IV_ATTACK.' : '.$data->iv_attack.'</span>'.$data->iv_attack.'
529 529
 								</div>
530 530
 								<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">
531
-									<span class="sr-only">'.$locales->IV_DEFENSE.' : '.$data->iv_defense.'</span>'. $data->iv_defense .'
531
+									<span class="sr-only">'.$locales->IV_DEFENSE.' : '.$data->iv_defense.'</span>'.$data->iv_defense.'
532 532
 								</div>
533 533
 								<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">
534
-									<span class="sr-only">'.$locales->IV_STAMINA.' : '.$data->iv_stamina.'</span>'. $data->iv_stamina .'
534
+									<span class="sr-only">'.$locales->IV_STAMINA.' : '.$data->iv_stamina.'</span>'.$data->iv_stamina.'
535 535
 								</div>
536 536
 							</div>
537 537
 						</div>';
@@ -579,16 +579,16 @@  discard block
 block discarded – undo
579 579
 		$name = "";
580 580
 		$page = "0";
581 581
 		$where = "";
582
-		$order="";
583
-		$team=0;
584
-		$ranking=0;
582
+		$order = "";
583
+		$team = 0;
584
+		$ranking = 0;
585 585
 		if (isset($_GET['name'])) {
586 586
 			$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
587 587
 			$where = " HAVING name LIKE '%".$trainer_name."%'";
588 588
 		}
589
-		if (isset($_GET['team']) && $_GET['team']!=0) {
589
+		if (isset($_GET['team']) && $_GET['team'] != 0) {
590 590
 			$team = mysqli_real_escape_string($mysqli, $_GET['team']);
591
-			$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
591
+			$where .= ($where == "" ? " HAVING" : "AND ")." team = ".$team;
592 592
 		}
593 593
 		if (isset($_GET['page'])) {
594 594
 			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
@@ -599,16 +599,16 @@  discard block
 block discarded – undo
599 599
 
600 600
 		switch ($ranking) {
601 601
 			case 1:
602
-				$order=" ORDER BY active DESC ";
602
+				$order = " ORDER BY active DESC ";
603 603
 				break;
604 604
 			case 2:
605
-				$order=" ORDER BY maxCp DESC ";
605
+				$order = " ORDER BY maxCp DESC ";
606 606
 				break;
607 607
 			default:
608
-				$order=" ORDER BY level DESC, active DESC ";
608
+				$order = " ORDER BY level DESC, active DESC ";
609 609
 		}
610 610
 
611
-		$limit = " LIMIT ".($page*10).",10 ";
611
+		$limit = " LIMIT ".($page * 10).",10 ";
612 612
 
613 613
 
614 614
 		$req = "SELECT trainer.*, count(actives_pokemons.trainer_name) as active, max(actives_pokemons.cp) as maxCp ".
@@ -627,7 +627,7 @@  discard block
 block discarded – undo
627 627
 			$reqRanking = "SELECT count(1) as rank FROM trainer where trainer.level >= ".$trainer->level;
628 628
 			$resultRanking = $mysqli->query($reqRanking);
629 629
 			while ($data = $resultRanking->fetch_object()) {
630
-				$trainer->rank = $data->rank ;
630
+				$trainer->rank = $data->rank;
631 631
 			}
632 632
 			$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 ".
633 633
 				"FROM gympokemon INNER JOIN ".
@@ -637,7 +637,7 @@  discard block
 block discarded – undo
637 637
 
638 638
 			$resultPkms = $mysqli->query($req);
639 639
 			$trainer->pokemons = array();
640
-			$active_gyms=0;
640
+			$active_gyms = 0;
641 641
 			$pkmCount = 0;
642 642
 			while ($resultPkms && $dataPkm = $resultPkms->fetch_object()) {
643 643
 				$active_gyms++;
@@ -674,9 +674,9 @@  discard block
 block discarded – undo
674 674
 		break;
675 675
 
676 676
 	case 'pokemon_slider_init':
677
-		$req 		= "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
677
+		$req = "SELECT MIN(pokemon.disappear_time) as min, MAX(pokemon.disappear_time) as max from pokemon";
678 678
 		$result 	= $mysqli->query($req);
679
-		$data 		= $result->fetch_object();
679
+		$data = $result->fetch_object();
680 680
 		$bounds 	= $data;
681 681
 
682 682
 		header('Content-Type: application/json');
@@ -686,18 +686,18 @@  discard block
 block discarded – undo
686 686
 		break;
687 687
 
688 688
 	case 'pokemon_heatmap_points':
689
-		$json="";
690
-		if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
691
-			$start = Date("Y-m-d H:i",(int)$_GET['start']);
692
-			$end = Date("Y-m-d H:i",(int)$_GET['end']);
689
+		$json = "";
690
+		if (isset($_GET['start']) && isset($_GET['end']) && isset($_GET['pokemon_id'])) {
691
+			$start = Date("Y-m-d H:i", (int) $_GET['start']);
692
+			$end = Date("Y-m-d H:i", (int) $_GET['end']);
693 693
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
694 694
 			$where = " WHERE pokemon.pokemon_id = ".$pokemon_id." "
695 695
 					. "AND pokemon.disappear_time BETWEEN '".$start."' AND '".$end."'";
696 696
 			$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
697
-			$result 	= $mysqli->query($req);
697
+			$result = $mysqli->query($req);
698 698
 			$points = array();
699 699
 			while ($result && $data = $result->fetch_object()) {
700
-				$points[] 	= $data;
700
+				$points[] = $data;
701 701
 			}
702 702
 
703 703
 			$json = json_encode($points);
@@ -710,15 +710,15 @@  discard block
 block discarded – undo
710 710
 		break;
711 711
 
712 712
 	case 'pokemon_graph_data':
713
-		$json="";
713
+		$json = "";
714 714
 		if (isset($_GET['pokemon_id'])) {
715 715
 			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
716
-			$req 		= "SELECT COUNT(*) as total, "
716
+			$req = "SELECT COUNT(*) as total, "
717 717
 					. "HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_hour
718 718
 			FROM (SELECT disappear_time FROM pokemon WHERE pokemon_id = '".$pokemon_id."' ORDER BY disappear_time LIMIT 10000) as pokemonFiltered
719 719
 			GROUP BY disappear_hour
720 720
 			ORDER BY disappear_hour";
721
-			$result 	= $mysqli->query($req);
721
+			$result = $mysqli->query($req);
722 722
 			$array = array_fill(0, 24, 0);
723 723
 			while ($result && $data = $result->fetch_object()) {
724 724
 				$array[$data->disappear_hour] = $data->total;
@@ -745,30 +745,30 @@  discard block
 block discarded – undo
745 745
 
746 746
 	break;
747 747
 }
748
-if ($postRequest!="") {
748
+if ($postRequest != "") {
749 749
 	switch ($postRequest) {
750 750
 		case 'pokemon_live':
751
-			$json="";
752
-			if (isset( $_POST['pokemon_id'])) {
751
+			$json = "";
752
+			if (isset($_POST['pokemon_id'])) {
753 753
 				$pokemon_id = mysqli_real_escape_string($mysqli, $_POST['pokemon_id']);
754
-				$inmap_pkms_filter="";
754
+				$inmap_pkms_filter = "";
755 755
 				$where = " WHERE disappear_time >= UTC_TIMESTAMP() AND pokemon.pokemon_id = ".$pokemon_id;
756 756
 
757 757
 				$reqTestIv = "SELECT MAX(individual_attack) as iv FROM pokemon ".$where;
758
-				$resultTestIv 	= $mysqli->query($reqTestIv);
758
+				$resultTestIv = $mysqli->query($reqTestIv);
759 759
 				$testIv = $resultTestIv->fetch_object();
760
-				if (isset( $_POST['inmap_pokemons'])&&( $_POST['inmap_pokemons']!="")) {
760
+				if (isset($_POST['inmap_pokemons']) && ($_POST['inmap_pokemons'] != "")) {
761 761
 					foreach ($_POST['inmap_pokemons'] as $inmap) {
762 762
 						$inmap_pkms_filter .= "'".$inmap."',";
763 763
 					}
764 764
 					$inmap_pkms_filter = rtrim($inmap_pkms_filter, ",");
765 765
 					$where .= " AND pokemon.encounter_id NOT IN (".$inmap_pkms_filter.") ";
766 766
 				}
767
-				if ($testIv->iv!=null && isset( $_POST['ivMin'])&&( $_POST['ivMin']!="")) {
767
+				if ($testIv->iv != null && isset($_POST['ivMin']) && ($_POST['ivMin'] != "")) {
768 768
 					$ivMin = mysqli_real_escape_string($mysqli, $_POST['ivMin']);
769 769
 					$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) >= (".$ivMin.") ";
770 770
 				}
771
-				if ($testIv->iv!=null && isset( $_POST['ivMax'])&&( $_POST['ivMax']!="")) {
771
+				if ($testIv->iv != null && isset($_POST['ivMax']) && ($_POST['ivMax'] != "")) {
772 772
 					$ivMax = mysqli_real_escape_string($mysqli, $_POST['ivMax']);
773 773
 					$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) <=(".$ivMax.") ";
774 774
 				}
@@ -776,16 +776,16 @@  discard block
 block discarded – undo
776 776
 						. " (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, "
777 777
 						. " individual_attack, individual_defense, individual_stamina, move_1, move_2 "
778 778
 						. "FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 5000";
779
-				$result 	= $mysqli->query($req);
779
+				$result = $mysqli->query($req);
780 780
 				$json = array();
781 781
 				$json['points'] = array();
782 782
 				$locale = array();
783
-				$locale["ivAttack"] =  $locales->IV_ATTACK;
783
+				$locale["ivAttack"] = $locales->IV_ATTACK;
784 784
 				$locale["ivDefense"] = $locales->IV_DEFENSE;
785
-				$locale["ivStamina"] =  $locales->IV_STAMINA;
785
+				$locale["ivStamina"] = $locales->IV_STAMINA;
786 786
 				$json['locale'] = $locale;
787 787
 				while ($result && $data = $result->fetch_object()) {
788
-					$pokeid=$data->pokemon_id;
788
+					$pokeid = $data->pokemon_id;
789 789
 					$data->name = $pokemons->pokemon->$pokeid->name;
790 790
 					if (isset($data->move_1)) {
791 791
 						$move1 = $data->move_1;
@@ -799,7 +799,7 @@  discard block
 block discarded – undo
799 799
 					} else {
800 800
 						$data->charge_move = "?";
801 801
 					}
802
-					$json['points'][] 	= $data;
802
+					$json['points'][] = $data;
803 803
 				}
804 804
 
805 805
 				$json = json_encode($json);
Please login to merge, or discard this patch.
core/process/data.loader.php 1 patch
Spacing   +72 added lines, -72 removed lines patch added patch discarded remove patch
@@ -3,8 +3,8 @@  discard block
 block discarded – undo
3 3
 // Include & load the variables
4 4
 // ############################
5 5
 
6
-$variables 	= SYS_PATH.'/core/json/variables.json';
7
-$config 	= json_decode(file_get_contents($variables));
6
+$variables = SYS_PATH.'/core/json/variables.json';
7
+$config = json_decode(file_get_contents($variables));
8 8
 
9 9
 if (!defined('SYS_PATH')) {
10 10
 	echo 'Error: config.php does not exist or failed to load.<br>';
@@ -38,7 +38,7 @@  discard block
 block discarded – undo
38 38
 #################
39 39
 
40 40
 
41
-$mysqli 	= new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
41
+$mysqli = new mysqli(SYS_DB_HOST, SYS_DB_USER, SYS_DB_PSWD, SYS_DB_NAME, SYS_DB_PORT);
42 42
 
43 43
 
44 44
 if ($mysqli->connect_error != '') {
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
 			// Current Pokemon datas
97 97
 			// ---------------------
98 98
 
99
-			$pokemon_id 			= mysqli_real_escape_string($mysqli, $_GET['id']);
99
+			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['id']);
100 100
 
101 101
 			if (!is_object($pokemons->pokemon->$pokemon_id)) {
102 102
 				header('Location:/404');
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
106 106
 
107 107
 			$pokemon			= new stdClass();
108 108
 			$pokemon			= $pokemons->pokemon->$pokemon_id;
109
-			$pokemon->id			= $pokemon_id;
109
+			$pokemon->id = $pokemon_id;
110 110
 
111 111
 
112 112
 			// Some math
@@ -122,9 +122,9 @@  discard block
 block discarded – undo
122 122
 
123 123
 			// Total gym protected
124 124
 
125
-			$req 		= "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE guard_pokemon_id = '".$pokemon_id."'  ";
126
-			$result 	= $mysqli->query($req);
127
-			$data 		= $result->fetch_object();
125
+			$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE guard_pokemon_id = '".$pokemon_id."'  ";
126
+			$result = $mysqli->query($req);
127
+			$data = $result->fetch_object();
128 128
 
129 129
 			$pokemon->protected_gyms = $data->total;
130 130
 
@@ -138,21 +138,21 @@  discard block
 block discarded – undo
138 138
 
139 139
 			// Last seen
140 140
 
141
-			$req 		= "SELECT disappear_time, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude
141
+			$req = "SELECT disappear_time, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) as disappear_time_real, latitude, longitude
142 142
 			FROM pokemon
143 143
 			WHERE pokemon_id = '".$pokemon_id."'
144 144
 			ORDER BY disappear_time DESC
145 145
 			LIMIT 0,1";
146
-			$result 	= $mysqli->query($req);
147
-			$data 		= $result->fetch_object();
146
+			$result = $mysqli->query($req);
147
+			$data = $result->fetch_object();
148 148
 
149 149
 			if (isset($data)) {
150
-				$last_spawn 				= $data;
150
+				$last_spawn = $data;
151 151
 
152
-				$pokemon->last_seen			= strtotime($data->disappear_time_real);
153
-				$pokemon->last_position			= new stdClass();
154
-				$pokemon->last_position->latitude 	= $data->latitude;
155
-				$pokemon->last_position->longitude 	= $data->longitude;
152
+				$pokemon->last_seen = strtotime($data->disappear_time_real);
153
+				$pokemon->last_position = new stdClass();
154
+				$pokemon->last_position->latitude = $data->latitude;
155
+				$pokemon->last_position->longitude = $data->longitude;
156 156
 			}
157 157
 
158 158
 			// Related Pokemons
@@ -236,16 +236,16 @@  discard block
 block discarded – undo
236 236
 			// --------------------------------
237 237
 
238 238
 			$max 		= $config->system->max_pokemon;
239
-			$pokedex 	= new stdClass();
239
+			$pokedex = new stdClass();
240 240
 
241
-			for ($i= 1; $i <= $max; $i++) {
242
-				$pokedex->$i			= new stdClass();
241
+			for ($i = 1; $i <= $max; $i++) {
242
+				$pokedex->$i = new stdClass();
243 243
 				$pokedex->$i->id 		= $i;
244
-				$pokedex->$i->permalink 	= 'pokemon/'.$i;
244
+				$pokedex->$i->permalink = 'pokemon/'.$i;
245 245
 				$pokedex->$i->img		= 'core/pokemons/'.$i.$config->system->pokeimg_suffix;
246
-				$pokedex->$i->name		= $pokemons->pokemon->$i->name;
247
-				$pokedex->$i->spawn 		= ($pokemons->pokemon->$i->spawn_count > 0) ? 1 : 0;
248
-				$pokedex->$i->spawn_count	= $pokemons->pokemon->$i->spawn_count;
246
+				$pokedex->$i->name = $pokemons->pokemon->$i->name;
247
+				$pokedex->$i->spawn = ($pokemons->pokemon->$i->spawn_count > 0) ? 1 : 0;
248
+				$pokedex->$i->spawn_count = $pokemons->pokemon->$i->spawn_count;
249 249
 			}
250 250
 
251 251
 
@@ -256,17 +256,17 @@  discard block
 block discarded – undo
256 256
 		############
257 257
 
258 258
 		case 'pokestops':
259
-			$pokestop 	= new stdClass();
259
+			$pokestop = new stdClass();
260 260
 
261
-			$req 		= "SELECT COUNT(*) as total FROM pokestop";
262
-			$result 	= $mysqli->query($req);
263
-			$data 		= $result->fetch_object();
261
+			$req = "SELECT COUNT(*) as total FROM pokestop";
262
+			$result = $mysqli->query($req);
263
+			$data = $result->fetch_object();
264 264
 
265 265
 			$pokestop->total = $data->total;
266 266
 
267
-			$req 		= "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
268
-			$result 	= $mysqli->query($req);
269
-			$data 		= $result->fetch_object();
267
+			$req = "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
268
+			$result = $mysqli->query($req);
269
+			$data = $result->fetch_object();
270 270
 
271 271
 			$pokestop->lured = $data->total;
272 272
 
@@ -283,36 +283,36 @@  discard block
 block discarded – undo
283 283
 			// 3 Teams (teamm rocket is neutral)
284 284
 			// 1 Fight
285 285
 
286
-			$teams 				= new stdClass();
286
+			$teams = new stdClass();
287 287
 
288
-			$teams->mystic 			= new stdClass();
289
-			$teams->mystic->guardians 	= new stdClass();
290
-			$teams->mystic->id 		= 1;
288
+			$teams->mystic = new stdClass();
289
+			$teams->mystic->guardians = new stdClass();
290
+			$teams->mystic->id = 1;
291 291
 
292
-			$teams->valor 			= new stdClass();
293
-			$teams->valor->guardians 	= new stdClass();
294
-			$teams->valor->id 		= 2;
292
+			$teams->valor = new stdClass();
293
+			$teams->valor->guardians = new stdClass();
294
+			$teams->valor->id = 2;
295 295
 
296
-			$teams->instinct 		= new stdClass();
297
-			$teams->instinct->guardians 	= new stdClass();
298
-			$teams->instinct->id 		= 3;
296
+			$teams->instinct = new stdClass();
297
+			$teams->instinct->guardians = new stdClass();
298
+			$teams->instinct->id = 3;
299 299
 
300
-			$teams->rocket 			= new stdClass();
301
-			$teams->rocket->guardians 	= new stdClass();
302
-			$teams->rocket->id 		= 0;
300
+			$teams->rocket = new stdClass();
301
+			$teams->rocket->guardians = new stdClass();
302
+			$teams->rocket->id = 0;
303 303
 
304 304
 
305 305
 
306 306
 			foreach ($teams as $team_key => $team_values) {
307 307
 				// Team Guardians
308 308
 
309
-				$req 	= "SELECT COUNT(*) as total, guard_pokemon_id FROM gym WHERE team_id = '".$team_values->id."' GROUP BY guard_pokemon_id ORDER BY total DESC LIMIT 0,3 ";
309
+				$req = "SELECT COUNT(*) as total, guard_pokemon_id FROM gym WHERE team_id = '".$team_values->id."' GROUP BY guard_pokemon_id ORDER BY total DESC LIMIT 0,3 ";
310 310
 				$result = $mysqli->query($req);
311 311
 
312
-				$i=0;
312
+				$i = 0;
313 313
 
314 314
 				while ($data = $result->fetch_object()) {
315
-					$teams->$team_key->guardians->$i	= $data->guard_pokemon_id;
315
+					$teams->$team_key->guardians->$i = $data->guard_pokemon_id;
316 316
 
317 317
 					$i++;
318 318
 				}
@@ -324,8 +324,8 @@  discard block
 block discarded – undo
324 324
 				$result = $mysqli->query($req);
325 325
 				$data	= $result->fetch_object();
326 326
 
327
-				$teams->$team_key->gym_owned	= $data->total;
328
-				$teams->$team_key->average	= $data->average_points;
327
+				$teams->$team_key->gym_owned = $data->total;
328
+				$teams->$team_key->average = $data->average_points;
329 329
 			}
330 330
 
331 331
 
@@ -338,7 +338,7 @@  discard block
 block discarded – undo
338 338
 		case 'dashboard':
339 339
 			// This case is only used for test purpose.
340 340
 
341
-			$stats_file	= SYS_PATH.'/core/json/gym.stats.json';
341
+			$stats_file = SYS_PATH.'/core/json/gym.stats.json';
342 342
 
343 343
 			if (!is_file($stats_file)) {
344 344
 				echo "Sorry, no Gym stats file was found. <br> Did you enable cron? ";
@@ -346,7 +346,7 @@  discard block
 block discarded – undo
346 346
 			}
347 347
 
348 348
 
349
-			$stats_file	= SYS_PATH.'/core/json/pokemon.stats.json';
349
+			$stats_file = SYS_PATH.'/core/json/pokemon.stats.json';
350 350
 
351 351
 			if (!is_file($stats_file)) {
352 352
 				echo "Sorry, no Pokémon stats file was found. <br> Did you enabled cron?";
@@ -354,7 +354,7 @@  discard block
 block discarded – undo
354 354
 			}
355 355
 
356 356
 
357
-			$stats_file	= SYS_PATH.'/core/json/pokestop.stats.json';
357
+			$stats_file = SYS_PATH.'/core/json/pokestop.stats.json';
358 358
 
359 359
 			if (!is_file($stats_file)) {
360 360
 				echo "Sorry, no Pokéstop stats file was found. <br> Did you enabled cron?";
@@ -362,7 +362,7 @@  discard block
 block discarded – undo
362 362
 			}
363 363
 
364 364
 			if ($config->system->captcha_support) {
365
-				$stats_file	= SYS_PATH.'/core/json/captcha.stats.json';
365
+				$stats_file = SYS_PATH.'/core/json/captcha.stats.json';
366 366
 
367 367
 				if (!is_file($stats_file)) {
368 368
 					echo "Sorry, no Captcha stats file were found  <br> Have you enable cron?";
@@ -382,9 +382,9 @@  discard block
 block discarded – undo
382 382
 	// Right now
383 383
 	// ---------
384 384
 
385
-	$req 		= "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
386
-	$result 	= $mysqli->query($req);
387
-	$data 		= $result->fetch_object();
385
+	$req = "SELECT COUNT(*) as total FROM pokemon WHERE disappear_time >= UTC_TIMESTAMP()";
386
+	$result = $mysqli->query($req);
387
+	$data = $result->fetch_object();
388 388
 
389 389
 
390 390
 	$home->pokemon_now = $data->total;
@@ -393,9 +393,9 @@  discard block
 block discarded – undo
393 393
 	// Lured stops
394 394
 	// -----------
395 395
 
396
-	$req 		= "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
397
-	$result 	= $mysqli->query($req);
398
-	$data 		= $result->fetch_object();
396
+	$req = "SELECT COUNT(*) as total FROM pokestop WHERE lure_expiration >= UTC_TIMESTAMP()";
397
+	$result = $mysqli->query($req);
398
+	$data = $result->fetch_object();
399 399
 
400 400
 	$home->pokestop_lured = $data->total;
401 401
 
@@ -403,9 +403,9 @@  discard block
 block discarded – undo
403 403
 	// Gyms
404 404
 	// ----
405 405
 
406
-	$req 		= "SELECT COUNT(DISTINCT(gym_id)) as total FROM gym";
407
-	$result 	= $mysqli->query($req);
408
-	$data 		= $result->fetch_object();
406
+	$req = "SELECT COUNT(DISTINCT(gym_id)) as total FROM gym";
407
+	$result = $mysqli->query($req);
408
+	$data = $result->fetch_object();
409 409
 
410 410
 	$home->gyms = $data->total;
411 411
 
@@ -415,19 +415,19 @@  discard block
 block discarded – undo
415 415
 
416 416
 	if ($config->system->recents_filter) {
417 417
 		// get all mythic pokemon ids
418
-		$mythic_pokemons  = array();
418
+		$mythic_pokemons = array();
419 419
 		foreach ($pokemons->pokemon as $id => $pokemon) {
420 420
 			if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
421 421
 				$mythic_pokemons[] = $id;
422 422
 			}
423 423
 		}
424 424
 		// get all mythic pokemon
425
-		$req 		= "SELECT DISTINCT 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
425
+		$req = "SELECT DISTINCT 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
426 426
 				   WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
427 427
 				   ORDER BY last_modified DESC LIMIT 0,12";
428 428
 	} else {
429 429
 		// get all pokemon
430
-		$req		= "SELECT DISTINCT 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
430
+		$req = "SELECT DISTINCT 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
431 431
 				   ORDER BY last_modified DESC LIMIT 0,12";
432 432
 	}
433 433
 	$result 	= $mysqli->query($req);
@@ -473,28 +473,28 @@  discard block
 block discarded – undo
473 473
 
474 474
 	$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '1'  ";
475 475
 	$result = $mysqli->query($req);
476
-	$data 	= $result->fetch_object();
476
+	$data = $result->fetch_object();
477 477
 
478
-	$home->teams->mystic 	= $data->total;
478
+	$home->teams->mystic = $data->total;
479 479
 
480 480
 
481 481
 	$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '2'  ";
482 482
 	$result = $mysqli->query($req);
483
-	$data 	= $result->fetch_object();
483
+	$data = $result->fetch_object();
484 484
 
485
-	$home->teams->valor 	= $data->total;
485
+	$home->teams->valor = $data->total;
486 486
 
487 487
 
488 488
 	$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '3'  ";
489 489
 	$result = $mysqli->query($req);
490
-	$data 	= $result->fetch_object();
490
+	$data = $result->fetch_object();
491 491
 
492
-	$home->teams->instinct 	= $data->total;
492
+	$home->teams->instinct = $data->total;
493 493
 
494 494
 
495 495
 	$req = "SELECT count( DISTINCT(gym_id) ) as total FROM gym WHERE team_id = '0'  ";
496 496
 	$result = $mysqli->query($req);
497
-	$data 	= $result->fetch_object();
497
+	$data = $result->fetch_object();
498 498
 
499
-	$home->teams->rocket 	= $data->total;
499
+	$home->teams->rocket = $data->total;
500 500
 }
Please login to merge, or discard this patch.