brusselopole /
Worldopole
| @@ 464-468 (lines=5) @@ | ||
| 461 | ||
| 462 | public function getHistoryForGym($page, $gym_id) |
|
| 463 | { |
|
| 464 | if (isset(self::$config->system->gymhistory_hide_cp_changes) && self::$config->system->gymhistory_hide_cp_changes === true) { |
|
| 465 | $pageSize = 25; |
|
| 466 | } else { |
|
| 467 | $pageSize = 10; |
|
| 468 | } |
|
| 469 | $req = "SELECT f.id as gym_id, fs.team as team_id, total_cp, FROM_UNIXTIME(fs.last_modified) as last_modified, last_modified as last_modified_real |
|
| 470 | FROM fort_sightings fs |
|
| 471 | LEFT JOIN forts f ON f.id = fs.fort_id |
|
| @@ 429-433 (lines=5) @@ | ||
| 426 | } |
|
| 427 | ||
| 428 | public function getHistoryForGym($page, $gym_id) { |
|
| 429 | if (isset(self::$config->system->gymhistory_hide_cp_changes) && self::$config->system->gymhistory_hide_cp_changes === true) { |
|
| 430 | $pageSize = 25; |
|
| 431 | } else { |
|
| 432 | $pageSize = 10; |
|
| 433 | } |
|
| 434 | $req = "SELECT gym_id, team_id, total_cp, pokemon_uids, pokemon_count, (CONVERT_TZ(last_modified, '+00:00', '".self::$time_offset."')) as last_modified |
|
| 435 | FROM gymhistory |
|
| 436 | WHERE gym_id='".$gym_id."' |
|
| @@ 443-447 (lines=5) @@ | ||
| 440 | ||
| 441 | public function getHistoryForGym($page, $gym_id) |
|
| 442 | { |
|
| 443 | if (isset(self::$config->system->gymhistory_hide_cp_changes) && self::$config->system->gymhistory_hide_cp_changes === true) { |
|
| 444 | $pageSize = 25; |
|
| 445 | } else { |
|
| 446 | $pageSize = 10; |
|
| 447 | } |
|
| 448 | $req = "SELECT f.id as gym_id, fs.team as team_id, total_cp, TO_TIMESTAMP(fs.last_modified) as last_modified, last_modified as last_modified_real |
|
| 449 | FROM fort_sightings fs |
|
| 450 | LEFT JOIN forts f ON f.id = fs.fort_id |
|
