core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 807-814 (lines=8) @@
|
804 |
|
return $nests; |
805 |
|
} |
806 |
|
|
807 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
808 |
|
{ |
809 |
|
$req = 'SELECT COUNT(*) as total |
810 |
|
FROM spawnpoints |
811 |
|
WHERE lat >= '.$minLatitude.' AND lat < '.$maxLatitude.' AND lon >= '.$minLongitude.' AND lon < '.$maxLongitude; |
812 |
|
$result = $this->mysqli->query($req); |
813 |
|
$data = $result->fetch_object(); |
814 |
|
|
815 |
|
return $data; |
816 |
|
} |
817 |
|
} |
core/process/queries/QueryManagerMysqlRealDeviceMap.php 1 location
|
@@ 569-578 (lines=10) @@
|
566 |
|
return $nests; |
567 |
|
} |
568 |
|
|
569 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
570 |
|
{ |
571 |
|
$req = 'SELECT COUNT(*) as total |
572 |
|
FROM spawnpoint |
573 |
|
WHERE lat >= '.$minLatitude.' AND lat < '.$maxLatitude.' AND lon >= '.$minLongitude.' AND lon < '.$maxLongitude; |
574 |
|
$result = $this->mysqli->query($req); |
575 |
|
$data = $result->fetch_object(); |
576 |
|
|
577 |
|
return $data; |
578 |
|
} |
579 |
|
} |
580 |
|
|
core/process/queries/QueryManagerMysqlRocketmap.php 1 location
|
@@ 844-851 (lines=8) @@
|
841 |
|
return $nests; |
842 |
|
} |
843 |
|
|
844 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
845 |
|
{ |
846 |
|
$req = 'SELECT COUNT(*) as total |
847 |
|
FROM spawnpoint |
848 |
|
WHERE latitude >= '.$minLatitude.' AND latitude < '.$maxLatitude.' AND longitude >= '.$minLongitude.' AND longitude < '.$maxLongitude; |
849 |
|
$result = $this->mysqli->query($req); |
850 |
|
$data = $result->fetch_object(); |
851 |
|
|
852 |
|
return $data; |
853 |
|
} |
854 |
|
} |