/** * just for recalculate all points in powerTrail_caches if any problem occur * or points algo were changed. */ function recalculateOnce() { $allCachesQuery = 'SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE 1)'; $db = \lib\Database\DataBaseSingleton::Instance(); $db->multiVariableQuery($allCachesQuery); $allCaches = $db->dbResultFetchAll(); foreach ($allCaches as $cache) { $cachePoints = powerTrailBase::getCachePoints($cache); $updateQuery = 'UPDATE `powerTrail_caches` SET `points`=:1 WHERE `cacheId`=:2'; $db->multiVariableQuery($updateQuery, $cachePoints, $cache['cache_id']); print $cache['wp_oc'] . ' updated ' . $cachePoints . '<br/>'; } // print '<pre>'; // print_r($allCaches); }
/** * just for recalculate all points in powerTrail_caches if any problem occur * or points algo were changed. */ function recalculateOnce() { $db = OcDb::instance(); $stmt = $db->multiVariableQuery('SELECT * FROM `caches` where `cache_id` IN (SELECT `cacheId` FROM `powerTrail_caches` WHERE 1)'); $allCaches = $db->dbResultFetchAll($stmt); foreach ($allCaches as $cache) { $cachePoints = powerTrailBase::getCachePoints($cache); $db->multiVariableQuery('UPDATE `powerTrail_caches` SET `points`=:1 WHERE `cacheId`=:2', $cachePoints, $cache['cache_id']); print $cache['wp_oc'] . ' updated ' . $cachePoints . '<br/>'; } }