core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 546-550 (lines=5) @@
|
| 543 |
|
|
| 544 |
|
public function getHistoryForGym($page, $gym_id) |
| 545 |
|
{ |
| 546 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 547 |
|
$pageSize = 25; |
| 548 |
|
} else { |
| 549 |
|
$pageSize = 10; |
| 550 |
|
} |
| 551 |
|
$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 |
| 552 |
|
FROM fort_sightings fs |
| 553 |
|
LEFT JOIN forts f ON f.id = fs.fort_id |
core/process/queries/QueryManagerMysqlRocketmap.php 1 location
|
@@ 538-542 (lines=5) @@
|
| 535 |
|
|
| 536 |
|
public function getHistoryForGym($page, $gym_id) |
| 537 |
|
{ |
| 538 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 539 |
|
$pageSize = 25; |
| 540 |
|
} else { |
| 541 |
|
$pageSize = 10; |
| 542 |
|
} |
| 543 |
|
$req = "SELECT gym_id, team_id, total_cp, pokemon_uids, pokemon_count, |
| 544 |
|
CONVERT_TZ(last_modified, '+00:00', '".self::$time_offset."') as last_modified |
| 545 |
|
FROM gymhistory |
core/process/queries/QueryManagerPostgresqlMonocleAlternate.php 1 location
|
@@ 525-529 (lines=5) @@
|
| 522 |
|
|
| 523 |
|
public function getHistoryForGym($page, $gym_id) |
| 524 |
|
{ |
| 525 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 526 |
|
$pageSize = 25; |
| 527 |
|
} else { |
| 528 |
|
$pageSize = 10; |
| 529 |
|
} |
| 530 |
|
$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 |
| 531 |
|
FROM fort_sightings fs |
| 532 |
|
LEFT JOIN forts f ON f.id = fs.fort_id |
brusselopole /
Worldopole
