public function setRadius($args) { $radius = $args->post['activity-radius']; $query = "\n SELECT\n id\n FROM\n preferences\n WHERE\n CodeName = 'ActivitiesNearMeRadius'\n LIMIT 1\n "; $row = $this->dao->query($query); $radiusPref = $row->fetch(PDB::FETCH_OBJ); if ($radiusPref === false) { return false; } $membersModel = new MembersModel(); $membersModel->set_preference($this->getLoggedInMember()->id, $radiusPref->id, $radius); }
/** * Set preference if comment guidelines have been read. */ public function setCommentGuidelinesRead() { $query = "\n SELECT\n id\n FROM\n preferences\n WHERE\n CodeName = 'ReadCommentGuidelines'\n LIMIT 1\n "; $row = $this->dao->query($query); $readCommentGuidlinesPref = $row->fetch(PDB::FETCH_OBJ); if ($readCommentGuidlinesPref === false) { return false; } $membersModel = new MembersModel(); $membersModel->set_preference($this->getLoggedInMember()->id, $readCommentGuidlinesPref->id, 1); }
public function adjustThreadsCountToShow($step = 1) { $MAX_THREADS = 1000; //An upper limit just in case if (!($member = $this->getLoggedInMember())) { return false; } $vars =& PPostHandler::getVars(); if (!isset($vars['agoragroupsthreadscountmoreless'])) { return false; } $command = $vars['agoragroupsthreadscountmoreless']; $layoutbits = new MOD_layoutbits(); $forumthreads = intval($layoutbits->getPreference("ForumThreadsOnLandingPage")); $groupsthreads = intval($layoutbits->getPreference("GroupsThreadsOnLandingPage")); $membersmodel = new MembersModel(); $query = "\r\n SELECT\r\n id\r\n FROM\r\n preferences\r\n WHERE\r\n CodeName = 'ForumThreadsOnLandingPage'\r\n LIMIT 1\r\n "; $row = $this->dao->query($query); $forumpref = $row->fetch(PDB::FETCH_OBJ); if ($forumpref === false) { throw new Exception('Database error: "ForumThreadsOnLandingPage"' . ' preference not found in "preferences" table'); } $query = "\r\n SELECT\r\n id\r\n FROM\r\n preferences\r\n WHERE\r\n CodeName = 'GroupsThreadsOnLandingPage'\r\n LIMIT 1\r\n "; $row = $this->dao->query($query); $groupspref = $row->fetch(PDB::FETCH_OBJ); if ($groupspref === false) { throw new Exception('Database error: "GroupsThreadsOnLandingPage"' . ' preference not found in "preferences" table'); } switch ($command) { case "moreagora": $membersmodel->set_preference($member->id, $forumpref->id, min($forumthreads + $step, $MAX_THREADS)); break; case "lessagora": $membersmodel->set_preference($member->id, $forumpref->id, max($forumthreads - $step, 1)); break; case "moregroups": $membersmodel->set_preference($member->id, $groupspref->id, min($groupsthreads + $step, $MAX_THREADS)); break; case "lessgroups": $membersmodel->set_preference($member->id, $groupspref->id, max($groupsthreads - $step, 1)); break; } return false; }