core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 718-725 (lines=8) @@
|
| 715 |
|
return $nests; |
| 716 |
|
} |
| 717 |
|
|
| 718 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) { |
| 719 |
|
$req = "SELECT COUNT(*) as total |
| 720 |
|
FROM spawnpoints |
| 721 |
|
WHERE lat >= ".$minLatitude." AND lat < ".$maxLatitude." AND lon >= ".$minLongitude." AND lon < ".$maxLongitude; |
| 722 |
|
$result = $this->mysqli->query($req); |
| 723 |
|
$data = $result->fetch_object(); |
| 724 |
|
return $data; |
| 725 |
|
} |
| 726 |
|
|
| 727 |
|
} |
| 728 |
|
|
core/process/queries/QueryManagerMysqlRocketmap.php 1 location
|
@@ 705-712 (lines=8) @@
|
| 702 |
|
return $nests; |
| 703 |
|
} |
| 704 |
|
|
| 705 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) { |
| 706 |
|
$req = "SELECT COUNT(*) as total |
| 707 |
|
FROM spawnpoint |
| 708 |
|
WHERE latitude >= ".$minLatitude." AND latitude < ".$maxLatitude." AND longitude >= ".$minLongitude." AND longitude < ".$maxLongitude; |
| 709 |
|
$result = $this->mysqli->query($req); |
| 710 |
|
$data = $result->fetch_object(); |
| 711 |
|
return $data; |
| 712 |
|
} |
| 713 |
|
|
| 714 |
|
} |
core/process/queries/QueryManagerPostgresqlMonocleAlternate.php 1 location
|
@@ 722-729 (lines=8) @@
|
| 719 |
|
return $nests; |
| 720 |
|
} |
| 721 |
|
|
| 722 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) { |
| 723 |
|
$req = "SELECT COUNT(*) as total |
| 724 |
|
FROM spawnpoints |
| 725 |
|
WHERE lat >= ".$minLatitude." AND lat < ".$maxLatitude." AND lon >= ".$minLongitude." AND lon < ".$maxLongitude; |
| 726 |
|
$result = $this->mysqli->query($req); |
| 727 |
|
$data = $result->fetch_object(); |
| 728 |
|
return $data; |
| 729 |
|
} |
| 730 |
|
|
| 731 |
|
} |
| 732 |
|
|