brusselopole /
Worldopole
| @@ 198-208 (lines=11) @@ | ||
| 195 | return $toptrainer; |
|
| 196 | } |
|
| 197 | ||
| 198 | public function getPokemonHeatmap($pokemon_id, $start, $end) { |
|
| 199 | $where = " WHERE pokemon_id = ".$pokemon_id." " |
|
| 200 | . "AND disappear_time BETWEEN '".$start."' AND '".$end."'"; |
|
| 201 | $req = "SELECT latitude, longitude FROM pokemon".$where." LIMIT 10000"; |
|
| 202 | $result = $this->mysqli->query($req); |
|
| 203 | $points = array(); |
|
| 204 | while ($data = $result->fetch_object()) { |
|
| 205 | $points[] = $data; |
|
| 206 | } |
|
| 207 | return $points; |
|
| 208 | } |
|
| 209 | ||
| 210 | public function getPokemonGraph($pokemon_id) { |
|
| 211 | $req = "SELECT COUNT(*) AS total, |
|
| @@ 203-213 (lines=11) @@ | ||
| 200 | return $toptrainer; |
|
| 201 | } |
|
| 202 | ||
| 203 | public function getPokemonHeatmap($pokemon_id, $start, $end) { |
|
| 204 | $where = " WHERE pokemon_id = ".$pokemon_id." " |
|
| 205 | . "AND FROM_UNIXTIME(expire_timestamp) BETWEEN '".$start."' AND '".$end."'"; |
|
| 206 | $req = "SELECT lat AS latitude, lon AS longitude FROM sightings".$where." LIMIT 100000"; |
|
| 207 | $result = $this->mysqli->query($req); |
|
| 208 | $points = array(); |
|
| 209 | while ($data = $result->fetch_object()) { |
|
| 210 | $points[] = $data; |
|
| 211 | } |
|
| 212 | return $points; |
|
| 213 | } |
|
| 214 | ||
| 215 | public function getPokemonGraph($pokemon_id) { |
|
| 216 | $req = "SELECT COUNT(*) AS total, HOUR(disappear_time) AS disappear_hour |
|
