Failed Conditions
Pull Request — master (#275)
by Ramiro
02:40
created
core/process/aru.php 1 patch
Switch Indentation   +333 added lines, -333 removed lines patch added patch discarded remove patch
@@ -58,153 +58,153 @@  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
-		header('Content-Type: application/json');
128
-		echo json_encode($values);
127
+			header('Content-Type: application/json');
128
+			echo json_encode($values);
129 129
 
130
-		break;
130
+			break;
131 131
 
132 132
 
133
-	####################################
134
-	//
135
-	// Update latests spawn on homepage
136
-	//
137
-	####################################
133
+		####################################
134
+		//
135
+		// Update latests spawn on homepage
136
+		//
137
+		####################################
138 138
 
139
-	case 'spawnlist_update':
140
-		// Recent spawn
141
-		// ------------
142
-		$total_spawns = array();
143
-		$last_uid_param = "";
144
-		if (isset($_GET['last_uid'])) {
145
-			$last_uid_param = $_GET['last_uid'];
146
-		}
147
-		if ($config->system->recents_filter) {
148
-			// get all mythic pokemon ids
149
-			$mythic_pokemons = array();
150
-			foreach ($pokemons->pokemon as $id => $pokemon) {
151
-				if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
152
-					$mythic_pokemons[] = $id;
153
-				}
139
+		case 'spawnlist_update':
140
+			// Recent spawn
141
+			// ------------
142
+			$total_spawns = array();
143
+			$last_uid_param = "";
144
+			if (isset($_GET['last_uid'])) {
145
+				$last_uid_param = $_GET['last_uid'];
154 146
 			}
147
+			if ($config->system->recents_filter) {
148
+				// get all mythic pokemon ids
149
+				$mythic_pokemons = array();
150
+				foreach ($pokemons->pokemon as $id => $pokemon) {
151
+					if ($pokemon->spawn_rate < $config->system->recents_filter_rarity && $pokemon->rating >= $config->system->recents_filter_rating) {
152
+						$mythic_pokemons[] = $id;
153
+					}
154
+				}
155 155
 
156
-			// get last mythic pokemon
157
-			$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) AS disappear_time_real,
156
+				// get last mythic pokemon
157
+				$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) AS disappear_time_real,
158 158
 					latitude, longitude, cp, individual_attack, individual_defense, individual_stamina
159 159
 					FROM pokemon
160 160
 					WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
161 161
 					ORDER BY last_modified DESC
162 162
 					LIMIT 0,12";
163
-		} else {
164
-			// get last pokemon
165
-			$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) AS disappear_time_real,
163
+			} else {
164
+				// get last pokemon
165
+				$req = "SELECT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) AS disappear_time_real,
166 166
 					latitude, longitude, cp, individual_attack, individual_defense, individual_stamina
167 167
 					FROM pokemon
168 168
 					ORDER BY last_modified DESC
169 169
 					LIMIT 0,12";
170
-		}
171
-		$result = $mysqli->query($req);
172
-		while ($data = $result->fetch_object()) {
173
-			$new_spawn = array();
174
-			$pokeid = $data->pokemon_id;
175
-			$pokeuid = $data->encounter_id;
176
-
177
-			if ($last_uid_param != $pokeuid) {
178
-				$last_seen = strtotime($data->disappear_time_real);
179
-
180
-				$last_location = new stdClass();
181
-				$last_location->latitude = $data->latitude;
182
-				$last_location->longitude = $data->longitude;
183
-
184
-				if ($config->system->recents_show_iv) {
185
-					$iv = new stdClass();
186
-					$iv->cp = $data->cp;
187
-					$iv->attack = $data->individual_attack;
188
-					$iv->defense = $data->individual_defense;
189
-					$iv->stamina = $data->individual_stamina;
190
-					if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
191
-						$iv->available = true;
192
-					} else {
193
-						$iv->available = false;
170
+			}
171
+			$result = $mysqli->query($req);
172
+			while ($data = $result->fetch_object()) {
173
+				$new_spawn = array();
174
+				$pokeid = $data->pokemon_id;
175
+				$pokeuid = $data->encounter_id;
176
+
177
+				if ($last_uid_param != $pokeuid) {
178
+					$last_seen = strtotime($data->disappear_time_real);
179
+
180
+					$last_location = new stdClass();
181
+					$last_location->latitude = $data->latitude;
182
+					$last_location->longitude = $data->longitude;
183
+
184
+					if ($config->system->recents_show_iv) {
185
+						$iv = new stdClass();
186
+						$iv->cp = $data->cp;
187
+						$iv->attack = $data->individual_attack;
188
+						$iv->defense = $data->individual_defense;
189
+						$iv->stamina = $data->individual_stamina;
190
+						if (isset($iv->attack) && isset($iv->defense) && isset($iv->stamina)) {
191
+							$iv->available = true;
192
+						} else {
193
+							$iv->available = false;
194
+						}
194 195
 					}
195
-				}
196 196
 
197
-				$html = '
197
+					$html = '
198 198
 			    <div class="col-md-1 col-xs-4 pokemon-single" data-pokeid="'.$pokeid.'" data-pokeuid="'.$pokeuid.'" style="display: none;">
199 199
 				<a href="pokemon/'.$pokeid.'"><img src="core/pokemons/'.$pokeid.$config->system->pokeimg_suffix.'" alt="'.$pokemons->pokemon->$pokeid->name.'" class="img-responsive"></a>
200 200
 				<a href="pokemon/'.$pokeid.'"><p class="pkmn-name">'.$pokemons->pokemon->$pokeid->name.'</p></a>
201 201
 				<a href="https://maps.google.com/?q='.$last_location->latitude.','.$last_location->longitude.'&ll='.$last_location->latitude.','.$last_location->longitude.'&z=16" target="_blank">
202 202
 				    <small class="pokemon-timer">00:00:00</small>
203 203
 				</a>';
204
-				if ($config->system->recents_show_iv) {
205
-					if ($iv->available) {
206
-						if ($config->system->iv_numbers) {
207
-							$html .= '
204
+					if ($config->system->recents_show_iv) {
205
+						if ($iv->available) {
206
+							if ($config->system->iv_numbers) {
207
+								$html .= '
208 208
 							<div class="progress" style="height: 15px; margin-bottom: 0">
209 209
 								<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">
210 210
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>'.$iv->attack .'
@@ -216,8 +216,8 @@  discard block
 block discarded – undo
216 216
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>'.$iv->stamina .'
217 217
 								</div>
218 218
 							</div>';
219
-						} else {
220
-							$html .= '
219
+							} else {
220
+								$html .= '
221 221
 							<div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto">
222 222
 					    		<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).'%">
223 223
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$iv->attack.'</span>
@@ -229,11 +229,11 @@  discard block
 block discarded – undo
229 229
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$iv->stamina.'</span>
230 230
 					    		</div>
231 231
 							</div>';
232
-						}
233
-						$html .= '<small>'.$iv->cp.'</small>';
234
-					} else {
235
-						if ($config->system->iv_numbers) {
236
-							$html .= '
232
+							}
233
+							$html .= '<small>'.$iv->cp.'</small>';
234
+						} else {
235
+							if ($config->system->iv_numbers) {
236
+								$html .= '
237 237
 							<div class="progress" style="height: 15px; margin-bottom: 0">
238 238
 								<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">
239 239
 									<span class="sr-only">'.$locales->IV_ATTACK.': '.$locales->NOT_AVAILABLE.'</span>?
@@ -245,127 +245,127 @@  discard block
 block discarded – undo
245 245
 									<span class="sr-only">'.$locales->IV_STAMINA.': '.$locales->NOT_AVAILABLE.'</span>?
246 246
 								</div>
247 247
 							</div>';
248
-						} else {
249
-						$html .= '
248
+							} else {
249
+							$html .= '
250 250
 					    <div class="progress" style="height: 6px; width: 80%; margin: 5px auto 0 auto">
251 251
 						    <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">
252 252
 							    <span class="sr-only">IV '.$locales->NOT_AVAILABLE.'</span>
253 253
 						    </div>
254 254
 					    </div>';
255
+							}
256
+							$html .= '<small>???</small>';
255 257
 						}
256
-						$html .= '<small>???</small>';
257 258
 					}
258
-				}
259
-				$html .= '
259
+					$html .= '
260 260
 			    </div>';
261
-				$new_spawn['html'] = $html;
262
-				$countdown = $last_seen - time();
263
-				$new_spawn['countdown'] = $countdown;
264
-				$new_spawn['pokemon_uid'] = $pokeuid;
265
-				$total_spawns[] = $new_spawn;
266
-			} else {
267
-				break;
261
+					$new_spawn['html'] = $html;
262
+					$countdown = $last_seen - time();
263
+					$new_spawn['countdown'] = $countdown;
264
+					$new_spawn['pokemon_uid'] = $pokeuid;
265
+					$total_spawns[] = $new_spawn;
266
+				} else {
267
+					break;
268
+				}
268 269
 			}
269
-		}
270 270
 
271
-		header('Content-Type: application/json');
272
-		echo json_encode($total_spawns);
271
+			header('Content-Type: application/json');
272
+			echo json_encode($total_spawns);
273 273
 
274
-		break;
274
+			break;
275 275
 
276 276
 
277
-	####################################
278
-	//
279
-	// List Pokestop
280
-	//
281
-	####################################
277
+		####################################
278
+		//
279
+		// List Pokestop
280
+		//
281
+		####################################
282 282
 
283
-	case 'pokestop':
284
-		$where = "";
285
-		if ($config->system->only_lured_pokestops) {
286
-			$where = "WHERE lure_expiration > UTC_TIMESTAMP() ORDER BY lure_expiration";
287
-		}
288
-		$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."";
283
+		case 'pokestop':
284
+			$where = "";
285
+			if ($config->system->only_lured_pokestops) {
286
+				$where = "WHERE lure_expiration > UTC_TIMESTAMP() ORDER BY lure_expiration";
287
+			}
288
+			$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."";
289 289
 
290
-		//show all stops if no lure active
291
-		if (!$mysqli->query($req)->fetch_object()) {
292
-			$req = "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() AS now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) AS lure_expiration_real FROM pokestop";
293
-		}
294
-		$result = $mysqli->query($req);
290
+			//show all stops if no lure active
291
+			if (!$mysqli->query($req)->fetch_object()) {
292
+				$req = "SELECT latitude, longitude, lure_expiration, UTC_TIMESTAMP() AS now, (CONVERT_TZ(lure_expiration, '+00:00', '".$time_offset."')) AS lure_expiration_real FROM pokestop";
293
+			}
294
+			$result = $mysqli->query($req);
295 295
 
296
-		$pokestops = [];
296
+			$pokestops = [];
297 297
 
298
-		while ($data = $result->fetch_object()) {
299
-			if ($data->lure_expiration >= $data->now) {
300
-				$icon = 'pokestap_lured.png';
301
-				$text = sprintf($locales->POKESTOPS_MAP_LURED, date('H:i:s', strtotime($data->lure_expiration_real)));
302
-			} else {
303
-				$icon = 'pokestap.png';
304
-				$text = $locales->POKESTOPS_MAP_REGULAR;
298
+			while ($data = $result->fetch_object()) {
299
+				if ($data->lure_expiration >= $data->now) {
300
+					$icon = 'pokestap_lured.png';
301
+					$text = sprintf($locales->POKESTOPS_MAP_LURED, date('H:i:s', strtotime($data->lure_expiration_real)));
302
+				} else {
303
+					$icon = 'pokestap.png';
304
+					$text = $locales->POKESTOPS_MAP_REGULAR;
305
+				}
306
+
307
+				$pokestops[] = [
308
+					$text,
309
+					$icon,
310
+					$data->latitude,
311
+					$data->longitude
312
+				];
305 313
 			}
306 314
 
307
-			$pokestops[] = [
308
-				$text,
309
-				$icon,
310
-				$data->latitude,
311
-				$data->longitude
312
-			];
313
-		}
315
+			header('Content-Type: application/json');
316
+			echo json_encode($pokestops);
314 317
 
315
-		header('Content-Type: application/json');
316
-		echo json_encode($pokestops);
318
+			break;
317 319
 
318
-		break;
319 320
 
321
+		####################################
322
+		//
323
+		// Update data for the gym battle
324
+		//
325
+		####################################
320 326
 
321
-	####################################
322
-	//
323
-	// Update data for the gym battle
324
-	//
325
-	####################################
326
-
327
-	case 'update_gym':
328
-		$teams			= new stdClass();
329
-		$teams->mystic 		= 1;
330
-		$teams->valor 		= 2;
331
-		$teams->instinct 	= 3;
327
+		case 'update_gym':
328
+			$teams			= new stdClass();
329
+			$teams->mystic 		= 1;
330
+			$teams->valor 		= 2;
331
+			$teams->instinct 	= 3;
332 332
 
333 333
 
334
-		foreach ($teams as $team_name => $team_id) {
335
-			$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total, ROUND(AVG(gym_points),0) AS average_points FROM gym WHERE team_id = '".$team_id."'";
336
-			$result	= $mysqli->query($req);
337
-			$data	= $result->fetch_object();
334
+			foreach ($teams as $team_name => $team_id) {
335
+				$req	= "SELECT COUNT(DISTINCT(gym_id)) AS total, ROUND(AVG(gym_points),0) AS average_points FROM gym WHERE team_id = '".$team_id."'";
336
+				$result	= $mysqli->query($req);
337
+				$data	= $result->fetch_object();
338 338
 
339
-			$return[] 	= $data->total;
340
-			$return[]	= $data->average_points;
341
-		}
339
+				$return[] 	= $data->total;
340
+				$return[]	= $data->average_points;
341
+			}
342 342
 
343
-		header('Content-Type: application/json');
344
-		echo json_encode($return);
343
+			header('Content-Type: application/json');
344
+			echo json_encode($return);
345 345
 
346
-		break;
346
+			break;
347 347
 
348 348
 
349
-	####################################
350
-	//
351
-	// Get datas for the gym map
352
-	//
353
-	####################################
349
+		####################################
350
+		//
351
+		// Get datas for the gym map
352
+		//
353
+		####################################
354 354
 
355 355
 
356
-	case 'gym_map':
357
-		$req	= "SELECT gym_id, team_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned FROM gym";
358
-		$result = $mysqli->query($req);
356
+		case 'gym_map':
357
+			$req	= "SELECT gym_id, team_id, gym_points, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned FROM gym";
358
+			$result = $mysqli->query($req);
359 359
 
360
-		$gyms = [];
360
+			$gyms = [];
361 361
 
362
-		while ($data = $result->fetch_object()) {
363
-			// Team
364
-			// 1 = bleu
365
-			// 2 = rouge
366
-			// 3 = jaune
362
+			while ($data = $result->fetch_object()) {
363
+				// Team
364
+				// 1 = bleu
365
+				// 2 = rouge
366
+				// 3 = jaune
367 367
 
368
-			switch ($data->team_id) {
368
+				switch ($data->team_id) {
369 369
 				case 0:
370 370
 					$icon	= 'map_white.png';
371 371
 					$team	= 'No Team (yet)';
@@ -389,7 +389,7 @@  discard block
 block discarded – undo
389 389
 					$team	= 'Team Instinct';
390 390
 					$color	= 'rgba(254, 217, 40, .6)';
391 391
 					break;
392
-			}
392
+				}
393 393
 
394 394
 			// Set gym level
395 395
 			$gym_level = gym_level($data->gym_points);
@@ -418,50 +418,50 @@  discard block
 block discarded – undo
418 418
 	//
419 419
 	####################################
420 420
 
421
-	case 'gym_defenders':
422
-		$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
423
-		$req	= "SELECT gymdetails.name AS name, gymdetails.description AS description, gym.gym_points AS points, gymdetails.url AS url, gym.team_id AS team,
421
+		case 'gym_defenders':
422
+			$gym_id = $mysqli->real_escape_string($_GET['gym_id']);
423
+			$req	= "SELECT gymdetails.name AS name, gymdetails.description AS description, gym.gym_points AS points, gymdetails.url AS url, gym.team_id AS team,
424 424
 					(CONVERT_TZ(gym.last_scanned, '+00:00', '".$time_offset."')) AS last_scanned, gym.guard_pokemon_id AS guard_pokemon_id
425 425
 					FROM gymdetails
426 426
 					LEFT JOIN gym ON gym.gym_id = gymdetails.gym_id
427 427
 					WHERE gym.gym_id='".$gym_id."'";
428
-		$result = $mysqli->query($req);
428
+			$result = $mysqli->query($req);
429 429
 		
430
-		$gymData['gymDetails']['gymInfos'] = false;
430
+			$gymData['gymDetails']['gymInfos'] = false;
431 431
 
432
-		while ($data = $result->fetch_object()) {
433
-			$gymData['gymDetails']['gymInfos']['name'] = $data->name;
434
-			$gymData['gymDetails']['gymInfos']['description'] = $data->description;
435
-			if ($data->url == null) {
436
-				$gymData['gymDetails']['gymInfos']['url'] = '';
437
-			} else {
438
-				$gymData['gymDetails']['gymInfos']['url'] = $data->url;
432
+			while ($data = $result->fetch_object()) {
433
+				$gymData['gymDetails']['gymInfos']['name'] = $data->name;
434
+				$gymData['gymDetails']['gymInfos']['description'] = $data->description;
435
+				if ($data->url == null) {
436
+					$gymData['gymDetails']['gymInfos']['url'] = '';
437
+				} else {
438
+					$gymData['gymDetails']['gymInfos']['url'] = $data->url;
439
+				}
440
+				$gymData['gymDetails']['gymInfos']['points'] = $data->points;
441
+				$gymData['gymDetails']['gymInfos']['level'] = 0;
442
+				$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
443
+				$gymData['gymDetails']['gymInfos']['team'] = $data->team;
444
+				$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
445
+				$gymData['gymDetails']['gymInfos']['level'] = gym_level($data->points);
439 446
 			}
440
-			$gymData['gymDetails']['gymInfos']['points'] = $data->points;
441
-			$gymData['gymDetails']['gymInfos']['level'] = 0;
442
-			$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
443
-			$gymData['gymDetails']['gymInfos']['team'] = $data->team;
444
-			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
445
-			$gymData['gymDetails']['gymInfos']['level'] = gym_level($data->points);
446
-		}
447 447
 
448
-		$req 	= "SELECT DISTINCT gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) AS cp, gymmember.gym_id
448
+			$req 	= "SELECT DISTINCT gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) AS cp, gymmember.gym_id
449 449
 					FROM gympokemon INNER JOIN gymmember ON gympokemon.pokemon_uid=gymmember.pokemon_uid
450 450
 					GROUP BY gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, gym_id
451 451
 					HAVING gymmember.gym_id='".$gym_id."'
452 452
 					ORDER BY cp DESC";
453
-		$result = $mysqli->query($req);
453
+			$result = $mysqli->query($req);
454 454
 
455
-		$i = 0;
455
+			$i = 0;
456 456
 
457
-		$gymData['infoWindow'] = '
457
+			$gymData['infoWindow'] = '
458 458
 			<div class="gym_defenders">
459 459
 			';
460
-		while ($data = $result->fetch_object()) {
461
-			$gymData['gymDetails']['pokemons'][] = $data;
462
-			if ($data != false) {
463
-				if ($config->system->iv_numbers) {
464
-					$gymData['infoWindow'] .= '
460
+			while ($data = $result->fetch_object()) {
461
+				$gymData['gymDetails']['pokemons'][] = $data;
462
+				if ($data != false) {
463
+					if ($config->system->iv_numbers) {
464
+						$gymData['infoWindow'] .= '
465 465
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
466 466
 						<a href="pokemon/'.$data->pokemon_id.'">
467 467
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -479,8 +479,8 @@  discard block
 block discarded – undo
479 479
 								</div>
480 480
 							</div>
481 481
 						</div>';
482
-				} else {
483
-					$gymData['infoWindow'] .= '
482
+					} else {
483
+						$gymData['infoWindow'] .= '
484 484
 					<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
485 485
 						<a href="pokemon/'.$data->pokemon_id.'">
486 486
 						<img src="core/pokemons/'.$data->pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
@@ -498,76 +498,76 @@  discard block
 block discarded – undo
498 498
 							</div>
499 499
 						</div>
500 500
 					</div>'
501
-						; }
502
-			} else {
503
-				$gymData['infoWindow'] .= '
501
+							; }
502
+				} else {
503
+					$gymData['infoWindow'] .= '
504 504
 				<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
505 505
 					<a href="pokemon/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].'">
506 506
 					<img src="core/pokemons/'.$gymData['gymDetails']['gymInfos']['guardPokemonId'].$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
507 507
 					</a>
508 508
 					<p class="pkmn-name">???</p>
509 509
 				</div>'
510
-				;
510
+					;
511
+				}
512
+				$i++;
511 513
 			}
512
-			$i++;
513
-		}
514 514
 
515
-		// check whether we could retrieve gym infos, otherwise use basic gym info
516
-		if (!$gymData['gymDetails']['gymInfos']) {
517
-			$req = "SELECT gym_id, team_id, gym_points, guard_pokemon_id, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned
515
+			// check whether we could retrieve gym infos, otherwise use basic gym info
516
+			if (!$gymData['gymDetails']['gymInfos']) {
517
+				$req = "SELECT gym_id, team_id, gym_points, guard_pokemon_id, latitude, longitude, (CONVERT_TZ(last_scanned, '+00:00', '".$time_offset."')) AS last_scanned
518 518
 				FROM gym WHERE gym_id='".$gym_id."'";
519
-			$result = $mysqli->query($req);
520
-			$data = $result->fetch_object();
521
-
522
-			$gymData['gymDetails']['gymInfos']['name'] = $locales->NOT_AVAILABLE;
523
-			$gymData['gymDetails']['gymInfos']['description'] = $locales->NOT_AVAILABLE;
524
-			$gymData['gymDetails']['gymInfos']['url'] = 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/86/Solid_grey.svg/200px-Solid_grey.svg.png';
525
-			$gymData['gymDetails']['gymInfos']['points'] = $data->gym_points;
526
-			$gymData['gymDetails']['gymInfos']['level'] = 0;
527
-			$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
528
-			$gymData['gymDetails']['gymInfos']['team'] = $data->team_id;
529
-			$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
530
-			$gymData['gymDetails']['gymInfos']['level'] = gym_level($data->gym_points);
531
-
532
-			$gymData['infoWindow'] .= '
519
+				$result = $mysqli->query($req);
520
+				$data = $result->fetch_object();
521
+
522
+				$gymData['gymDetails']['gymInfos']['name'] = $locales->NOT_AVAILABLE;
523
+				$gymData['gymDetails']['gymInfos']['description'] = $locales->NOT_AVAILABLE;
524
+				$gymData['gymDetails']['gymInfos']['url'] = 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/86/Solid_grey.svg/200px-Solid_grey.svg.png';
525
+				$gymData['gymDetails']['gymInfos']['points'] = $data->gym_points;
526
+				$gymData['gymDetails']['gymInfos']['level'] = 0;
527
+				$gymData['gymDetails']['gymInfos']['last_scanned'] = $data->last_scanned;
528
+				$gymData['gymDetails']['gymInfos']['team'] = $data->team_id;
529
+				$gymData['gymDetails']['gymInfos']['guardPokemonId'] = $data->guard_pokemon_id;
530
+				$gymData['gymDetails']['gymInfos']['level'] = gym_level($data->gym_points);
531
+
532
+				$gymData['infoWindow'] .= '
533 533
 				<div style="text-align: center; width: 50px; display: inline-block; margin-right: 3px">
534 534
 					<a href="pokemon/'.$data->guard_pokemon_id.'">
535 535
 					<img src="core/pokemons/'.$data->guard_pokemon_id.$config->system->pokeimg_suffix.'" height="50" style="display:inline-block" >
536 536
 					</a>
537 537
 					<p class="pkmn-name">???</p>
538 538
 				</div>';
539
-		}
540
-		$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
539
+			}
540
+			$gymData['infoWindow'] = $gymData['infoWindow'].'</div>';
541 541
 
542
-		header('Content-Type: application/json');
543
-		echo json_encode($gymData);
542
+			header('Content-Type: application/json');
543
+			echo json_encode($gymData);
544 544
 
545
-		break;
545
+			break;
546 546
 
547 547
 
548
-	case 'trainer':
549
-		$name = "";
550
-		$page = "0";
551
-		$where = "";
552
-		$order="";
553
-		$team=0;
554
-		$ranking=0;
555
-		if (isset($_GET['name'])) {
556
-			$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
557
-			$where = " HAVING name LIKE '%".$trainer_name."%'";
558
-		}
559
-		if (isset($_GET['team']) && $_GET['team']!=0) {
560
-			$team = mysqli_real_escape_string($mysqli, $_GET['team']);
561
-			$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
562
-		}
563
-		if (isset($_GET['page'])) {
564
-			$page = mysqli_real_escape_string($mysqli, $_GET['page']);
565
-		}
566
-		if (isset($_GET['ranking'])) {
567
-			$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
568
-		}
548
+		case 'trainer':
549
+			$name = "";
550
+			$page = "0";
551
+			$where = "";
552
+			$order="";
553
+			$team=0;
554
+			$ranking=0;
555
+			if (isset($_GET['name'])) {
556
+				$trainer_name = mysqli_real_escape_string($mysqli, $_GET['name']);
557
+				$where = " HAVING name LIKE '%".$trainer_name."%'";
558
+			}
559
+			if (isset($_GET['team']) && $_GET['team']!=0) {
560
+				$team = mysqli_real_escape_string($mysqli, $_GET['team']);
561
+				$where .= ($where==""?" HAVING":"AND ")." team = ".$team;
562
+			}
563
+			if (isset($_GET['page'])) {
564
+				$page = mysqli_real_escape_string($mysqli, $_GET['page']);
565
+			}
566
+			if (isset($_GET['ranking'])) {
567
+				$ranking = mysqli_real_escape_string($mysqli, $_GET['ranking']);
568
+			}
569 569
 
570
-		switch ($ranking) {
570
+			switch ($ranking) {
571 571
 			case 1:
572 572
 				$order=" ORDER BY active DESC ";
573 573
 				break;
@@ -576,7 +576,7 @@  discard block
 block discarded – undo
576 576
 				break;
577 577
 			default:
578 578
 				$order=" ORDER BY level DESC, active DESC ";
579
-		}
579
+			}
580 580
 
581 581
 		$limit = " LIMIT ".($page*10).",10 ";
582 582
 
@@ -648,85 +648,85 @@  discard block
 block discarded – undo
648 648
 		break;
649 649
 
650 650
 
651
-	case 'pokemon_slider_init':
652
-		$req 		= "SELECT MIN(disappear_time) AS min, MAX(disappear_time) AS max FROM pokemon";
653
-		$result 	= $mysqli->query($req);
654
-		$bounds		= $result->fetch_object();
651
+		case 'pokemon_slider_init':
652
+			$req 		= "SELECT MIN(disappear_time) AS min, MAX(disappear_time) AS max FROM pokemon";
653
+			$result 	= $mysqli->query($req);
654
+			$bounds		= $result->fetch_object();
655
+
656
+			header('Content-Type: application/json');
657
+			echo json_encode($bounds);
655 658
 
656
-		header('Content-Type: application/json');
657
-		echo json_encode($bounds);
659
+			break;
658 660
 
659
-		break;
660 661
 
662
+		case 'pokemon_heatmap_points':
663
+			$json="";
664
+			if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
665
+				$start = Date("Y-m-d H:i",(int)$_GET['start']);
666
+				$end = Date("Y-m-d H:i",(int)$_GET['end']);
667
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
668
+				$where = " WHERE pokemon_id = ".$pokemon_id." "
669
+						. "AND disappear_time BETWEEN '".$start."' AND '".$end."'";
670
+				$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
671
+				$result 	= $mysqli->query($req);
672
+				$points = array();
673
+				while ($result && $data = $result->fetch_object()) {
674
+					$points[] 	= $data;
675
+				}
661 676
 
662
-	case 'pokemon_heatmap_points':
663
-		$json="";
664
-		if (isset($_GET['start'])&&isset($_GET['end']) && isset($_GET['pokemon_id'])) {
665
-			$start = Date("Y-m-d H:i",(int)$_GET['start']);
666
-			$end = Date("Y-m-d H:i",(int)$_GET['end']);
667
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
668
-			$where = " WHERE pokemon_id = ".$pokemon_id." "
669
-					. "AND disappear_time BETWEEN '".$start."' AND '".$end."'";
670
-			$req 		= "SELECT latitude, longitude FROM pokemon".$where." ORDER BY disappear_time DESC LIMIT 10000";
671
-			$result 	= $mysqli->query($req);
672
-			$points = array();
673
-			while ($result && $data = $result->fetch_object()) {
674
-				$points[] 	= $data;
677
+				$json = json_encode($points);
675 678
 			}
676 679
 
677
-			$json = json_encode($points);
678
-		}
679
-
680
-		header('Content-Type: application/json');
681
-		echo $json;
682
-		break;
680
+			header('Content-Type: application/json');
681
+			echo $json;
682
+			break;
683 683
 
684 684
 
685
-	case 'maps_localization_coordinates':
686
-		$json="";
687
-		$req 		 = "SELECT MAX(latitude) AS max_latitude, MIN(latitude) AS min_latitude, MAX(longitude) AS max_longitude, MIN(longitude) as min_longitude FROM spawnpoint";
688
-		$result 	 = $mysqli->query($req);
689
-		$coordinates = $result->fetch_object();
685
+		case 'maps_localization_coordinates':
686
+			$json="";
687
+			$req 		 = "SELECT MAX(latitude) AS max_latitude, MIN(latitude) AS min_latitude, MAX(longitude) AS max_longitude, MIN(longitude) as min_longitude FROM spawnpoint";
688
+			$result 	 = $mysqli->query($req);
689
+			$coordinates = $result->fetch_object();
690 690
 		
691
-		header('Content-Type: application/json');
692
-		echo json_encode($coordinates);
691
+			header('Content-Type: application/json');
692
+			echo json_encode($coordinates);
693 693
 
694
-		break;
694
+			break;
695 695
 
696 696
 
697
-	case 'pokemon_graph_data':
698
-		$json="";
699
-		if (isset($_GET['pokemon_id'])) {
700
-			$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
701
-			$req = "SELECT COUNT(*) AS total,
697
+		case 'pokemon_graph_data':
698
+			$json="";
699
+			if (isset($_GET['pokemon_id'])) {
700
+				$pokemon_id = mysqli_real_escape_string($mysqli, $_GET['pokemon_id']);
701
+				$req = "SELECT COUNT(*) AS total,
702 702
 					HOUR(CONVERT_TZ(disappear_time, '+00:00', '".$time_offset."')) AS disappear_hour
703 703
 					FROM (SELECT disappear_time FROM pokemon WHERE pokemon_id = '".$pokemon_id."' ORDER BY disappear_time LIMIT 10000) AS pokemonFiltered
704 704
 					GROUP BY disappear_hour
705 705
 					ORDER BY disappear_hour";
706
-			$result	= $mysqli->query($req);
707
-			$array = array_fill(0, 24, 0);
708
-			while ($result && $data = $result->fetch_object()) {
709
-				$array[$data->disappear_hour] = $data->total;
706
+				$result	= $mysqli->query($req);
707
+				$array = array_fill(0, 24, 0);
708
+				while ($result && $data = $result->fetch_object()) {
709
+					$array[$data->disappear_hour] = $data->total;
710
+				}
711
+				// shift array because AM/PM starts at 1AM not 0:00
712
+				$array[] = $array[0];
713
+				array_shift($array);
714
+
715
+				$json = json_encode($array);
710 716
 			}
711
-			// shift array because AM/PM starts at 1AM not 0:00
712
-			$array[] = $array[0];
713
-			array_shift($array);
714 717
 
715
-			$json = json_encode($array);
716
-		}
718
+			header('Content-Type: application/json');
719
+			echo $json;
720
+			break;
717 721
 
718
-		header('Content-Type: application/json');
719
-		echo $json;
720
-		break;
721 722
 
723
+		case 'postRequest':
724
+			break;
722 725
 
723
-	case 'postRequest':
726
+		default:
727
+			echo "What do you mean?";
728
+			exit();
724 729
 		break;
725
-
726
-	default:
727
-		echo "What do you mean?";
728
-		exit();
729
-	break;
730 730
 }
731 731
 
732 732
 if ($postRequest!="") {
Please login to merge, or discard this patch.