core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 518-522 (lines=5) @@
|
| 515 |
|
|
| 516 |
|
public function getHistoryForGym($page, $gym_id) |
| 517 |
|
{ |
| 518 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 519 |
|
$pageSize = 25; |
| 520 |
|
} else { |
| 521 |
|
$pageSize = 10; |
| 522 |
|
} |
| 523 |
|
$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 |
| 524 |
|
FROM fort_sightings fs |
| 525 |
|
LEFT JOIN forts f ON f.id = fs.fort_id |
core/process/queries/QueryManagerMysqlRocketmap.php 1 location
|
@@ 510-514 (lines=5) @@
|
| 507 |
|
|
| 508 |
|
public function getHistoryForGym($page, $gym_id) |
| 509 |
|
{ |
| 510 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 511 |
|
$pageSize = 25; |
| 512 |
|
} else { |
| 513 |
|
$pageSize = 10; |
| 514 |
|
} |
| 515 |
|
$req = "SELECT gym_id, team_id, total_cp, pokemon_uids, pokemon_count, |
| 516 |
|
CONVERT_TZ(last_modified, '+00:00', '".self::$time_offset."') as last_modified |
| 517 |
|
FROM gymhistory |
core/process/queries/QueryManagerPostgresqlMonocleAlternate.php 1 location
|
@@ 497-501 (lines=5) @@
|
| 494 |
|
|
| 495 |
|
public function getHistoryForGym($page, $gym_id) |
| 496 |
|
{ |
| 497 |
|
if (isset(self::$config->system->gymhistory_hide_cp_changes) && true === self::$config->system->gymhistory_hide_cp_changes) { |
| 498 |
|
$pageSize = 25; |
| 499 |
|
} else { |
| 500 |
|
$pageSize = 10; |
| 501 |
|
} |
| 502 |
|
$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 |
| 503 |
|
FROM fort_sightings fs |
| 504 |
|
LEFT JOIN forts f ON f.id = fs.fort_id |
brusselopole /
Worldopole
