core/process/queries/QueryManagerMysqlMAD.php 1 location
|
@@ 826-835 (lines=10) @@
|
| 823 |
|
return $nests; |
| 824 |
|
} |
| 825 |
|
|
| 826 |
|
public function getSpawnpointCount($minLatitude, $maxLatitude, $minLongitude, $maxLongitude) |
| 827 |
|
{ |
| 828 |
|
$req = 'SELECT COUNT(*) as total |
| 829 |
|
FROM trs_spawn |
| 830 |
|
WHERE latitude >= '.$minLatitude.' AND latitude < '.$maxLatitude.' AND longitude >= '.$minLongitude.' AND longitude < '.$maxLongitude; |
| 831 |
|
$result = $this->mysqli->query($req); |
| 832 |
|
$data = $result->fetch_object(); |
| 833 |
|
|
| 834 |
|
return $data; |
| 835 |
|
} |
| 836 |
|
} |
| 837 |
|
|
core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location
|
@@ 807-816 (lines=10) @@
|
| 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 |
|
} |
| 818 |
|
|
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-853 (lines=10) @@
|
| 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 |
|
} |
| 855 |
|
|
brusselopole /
Worldopole
