Code Duplication    Length = 12-16 lines in 2 locations

core/process/queries/QueryManagerMysqlRocketmap.php 2 locations

@@ 121-136 (lines=16) @@
118
		return $data;
119
	}
120
121
	function getRecentMythic($mythic_pokemons) {
122
		$req = "SELECT DISTINCT pokemon_id, encounter_id, disappear_time, last_modified, (CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_time_real,
123
					latitude, longitude, cp, individual_attack, individual_defense, individual_stamina
124
					FROM pokemon
125
					WHERE pokemon_id IN (".implode(",", $mythic_pokemons).")
126
					ORDER BY last_modified DESC
127
					LIMIT 0,12";
128
		$result = $this->mysqli->query($req);
129
		$data = array();
130
		if ($result->num_rows > 0) {
131
			while ($row = $result->fetch_object()) {
132
				$data[] = $row;
133
			}
134
		}
135
		return $data;
136
	}
137
138
	///////////////////
139
	// Single Pokemon
@@ 464-475 (lines=12) @@
461
		return array("last_page" => $last_page, "data" => $history);
462
	}
463
464
	private function getHistoryForGymPokemon($pkm_uids) {
465
		$req = "SELECT DISTINCT pokemon_uid, pokemon_id, cp, trainer_name
466
								FROM gympokemon
467
								WHERE pokemon_uid IN ('".implode("','", $pkm_uids)."')
468
								ORDER BY FIND_IN_SET(pokemon_uid, '".implode(",", $pkm_uids)."')";
469
		$result = $this->mysqli->query($req);
470
		$pokemons = array();
471
		while ($data = $result->fetch_object()) {
472
			$pokemons[$data->pokemon_uid] = $data;
473
		}
474
		return $pokemons;
475
	}
476
477
478
	///////////