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 |
|
} |