core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 769-776 (lines=8) @@
|
| 766 |
|
return $nests; |
| 767 |
|
} |
| 768 |
|
|
| 769 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
| 770 |
|
{ |
| 771 |
|
$req = 'SELECT COUNT(*) as total |
| 772 |
|
FROM spawnpoints |
| 773 |
|
WHERE lat >= '.$minLatitude.' AND lat < '.$maxLatitude.' AND lon >= '.$minLongitude.' AND lon < '.$maxLongitude; |
| 774 |
|
$result = $this->mysqli->query($req); |
| 775 |
|
$data = $result->fetch_object(); |
| 776 |
|
|
| 777 |
|
return $data; |
| 778 |
|
} |
| 779 |
|
} |
core/process/queries/QueryManagerMysqlRocketmap.php 1 location
|
@@ 802-809 (lines=8) @@
|
| 799 |
|
return $nests; |
| 800 |
|
} |
| 801 |
|
|
| 802 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
| 803 |
|
{ |
| 804 |
|
$req = 'SELECT COUNT(*) as total |
| 805 |
|
FROM spawnpoint |
| 806 |
|
WHERE latitude >= '.$minLatitude.' AND latitude < '.$maxLatitude.' AND longitude >= '.$minLongitude.' AND longitude < '.$maxLongitude; |
| 807 |
|
$result = $this->mysqli->query($req); |
| 808 |
|
$data = $result->fetch_object(); |
| 809 |
|
|
| 810 |
|
return $data; |
| 811 |
|
} |
| 812 |
|
} |