function recalculate($projectId)
{
$db = OcDb::instance();
$stmt = $db->multiVariableQuery('SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )', $projectId);
$allCaches = $db->dbResultFetchAll($stmt);
$newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
$db->multiVariableQuery('UPDATE `PowerTrail` SET `cacheCount`= :1, `centerLatitude` = :3, `centerLongitude` = :4, `points` = :5 WHERE `id` = :2', $newData['cacheCount'], $projectId, $newData['avgLat'], $newData['avgLon'], $newData['points']);
}
function recalculate($projectId)
{
$allCachesQuery = 'SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )';
$db = \lib\Database\DataBaseSingleton::Instance();
$db->multiVariableQuery($allCachesQuery, $projectId);
$allCaches = $db->dbResultFetchAll();
$newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
$updateQuery = 'UPDATE `PowerTrail` SET `cacheCount`= :1, `centerLatitude` = :3, `centerLongitude` = :4, `points` = :5 WHERE `id` = :2';
$db->multiVariableQuery($updateQuery, $newData['cacheCount'], $projectId, $newData['avgLat'], $newData['avgLon'], $newData['points']);
}
<?php
use Utils\Database\OcDb;
session_start();
if (!isset($_SESSION['user_id'])) {
print 'no hacking please!';
exit;
}
require_once __DIR__ . '/../lib/ClassPathDictionary.php';
$ptAPI = new powerTrailBase();
$db = OcDb::instance();
$projectId = $_REQUEST['projectId'];
$allCachesQuery = 'SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE `PowerTrailId` =:1 )';
$s = $db->multiVariableQuery($allCachesQuery, $projectId);
$allCaches = $db->dbResultFetchAll($s);
$newData = powerTrailBase::recalculateCenterAndPoints($allCaches);
$query = 'SELECT count( `cacheId` ) AS cacheCount FROM `powerTrail_caches` WHERE `PowerTrailId` =:1';
$s = $db->multiVariableQuery($query, $projectId);
$cacheCountResult = $db->dbResultFetchOneRowOnly($s);
$cacheCountResult = $cacheCountResult['cacheCount'];
$updateQuery = 'UPDATE `PowerTrail` SET `cacheCount`= :1,
`centerLatitude` = ' . $newData['avgLat'] . ',
`centerLongitude` = ' . $newData['avgLon'] . ',
`points` = ' . $newData['points'] . '
WHERE `id` = :2';
$db->multiVariableQuery($updateQuery, $cacheCountResult, $projectId);
// $result = json_encode($cacheCountResult);
echo $cacheCountResult;