private function createNewPowerTrail() { if (!isset($_SESSION['user_id'])) { /* user is not logged in */ return false; } $this->action = 'createNewSerie'; if (isset($_POST['powerTrailName']) && $_POST['powerTrailName'] != '' && $_POST['type'] != 0 && $_POST['status'] != 0 && $_SESSION['powerTrail']['userFounds'] >= powerTrailBase::userMinimumCacheFoundToSetNewPowerTrail()) { $query = "INSERT INTO `PowerTrail`(`name`, `type`, `status`, `dateCreated`, `cacheCount`, `description`, `perccentRequired`) VALUES (:1,:2,:3,NOW(),0,:4,:5)"; $db = OcDb::instance(); $db->multiVariableQuery($query, strip_tags($_POST['powerTrailName']), (int) $_POST['type'], (int) $_POST['status'], htmlspecialchars($_POST['description']), (int) $_POST['dPercent']); $newProjectId = $db->lastInsertId(); // exit; $query = "INSERT INTO `PowerTrail_owners`(`PowerTrailId`, `userId`, `privileages`) VALUES (:1,:2,:3)"; $db->multiVariableQuery($query, $newProjectId, $this->user['userid'], 1); $logQuery = 'INSERT INTO `PowerTrail_actionsLog`(`PowerTrailId`, `userId`, `actionDateTime`, `actionType`, `description`) VALUES (:1,:2,NOW(),1,:3)'; $db->multiVariableQuery($logQuery, $newProjectId, $this->user['userid'], $this->ptAPI->logActionTypes[1]['type']); header("location: powerTrail.php?ptAction=showSerie&ptrail={$newProjectId}"); return true; } else { return false; } }
tpl_set_var('showMapsWhenMore', CacheMap3Lib::GenerateShowMapsWhenMore()); if (!$usr) { tpl_set_var('ptMenu', 'none'); } $ptMenu = new powerTrailMenu($usr); tpl_set_var("powerTrailMenu", buildPowerTrailMenu($ptMenu->getPowerTrailsMenu())); $pt = new powerTrailController($usr); $result = $pt->run(); $actionPerformed = $pt->getActionPerformed(); switch ($actionPerformed) { case 'createNewSerie': if ($usr['userFounds'] >= powerTrailBase::userMinimumCacheFoundToSetNewPowerTrail()) { tpl_set_var('displayCreateNewPowerTrailForm', 'block'); } else { tpl_set_var('displayToLowUserFound', 'block'); tpl_set_var('CFrequirment', powerTrailBase::userMinimumCacheFoundToSetNewPowerTrail()); } break; case 'selectCaches': //$userPowerTrails = $pt->getUserPowerTrails(); tpl_set_var('displayUserCaches', 'block'); tpl_set_var("keszynki", displayCaches($result, $pt->getUserPowerTrails())); break; case 'showAllSeries': $ptListData = displayPTrails($pt->getpowerTrails(), $pt->getPowerTrailOwn()); tpl_set_var('filtersTrDisplay', 'table-row'); tpl_set_var('ptTypeSelector2', displayPtTypesSelector('filter', $_REQUEST['filter'], true)); tpl_set_var('sortSelector', getSortBySelector($_REQUEST['sortBy'])); tpl_set_var('sortDirSelector', getSortDirSelector($_REQUEST['sortDir'])); tpl_set_var('displayedPowerTrailsCount', $pt->getDisplayedPowerTrailsCount()); tpl_set_var('mapCenterLat', $main_page_map_center_lat);