private function getAllPowerTrails()
{
// sort by
if (isset($_REQUEST['sortBy'])) {
switch ($_REQUEST['sortBy']) {
case 'type':
$sortBy = 'type';
break;
case 'name':
$sortBy = 'name';
break;
case 'dateCreated':
$sortBy = 'dateCreated';
break;
case 'cacheCount':
$sortBy = 'cacheCount';
break;
case 'points':
$sortBy = 'points';
break;
case 'conquestedCount':
$sortBy = 'conquestedCount';
break;
default:
$sortBy = 'cacheCount';
break;
}
} else {
$sortBy = 'cacheCount';
}
// filters here
if (isset($_REQUEST['filter'])) {
$filterValue = (int) $_REQUEST['filter'];
switch ($_REQUEST['filter']) {
case '0':
$filter = ' ';
break;
default:
$filter = " AND type = {$filterValue} ";
break;
}
} else {
$filter = ' ';
}
// order (as var for future use)
if (isset($_REQUEST['sortDir'])) {
switch ($_REQUEST['sortDir']) {
case 'asc':
$sortOder = 'ASC';
break;
case 'desc':
$sortOder = 'DESC';
break;
default:
$sortOder = 'DESC';
break;
}
} else {
$sortOder = 'DESC';
}
if (isset($_REQUEST['historicLimit']) && $_REQUEST['historicLimit'] == 1) {
$cacheCountLimit = powerTrailBase::historicMinimumCacheCount();
} else {
$cacheCountLimit = powerTrailBase::minimumCacheCount();
}
$q = 'SELECT * FROM `PowerTrail` WHERE `status` = 1 and cacheCount >= :1 ' . $filter . ' ORDER BY ' . $sortBy . ' ' . $sortOder . ' ';
$db = OcDb::instance();
$s = $db->multiVariableQuery($q, $cacheCountLimit);
$this->allSeries = $db->dbResultFetchAll($s);
}
