public function indexAction() { // Start with row 0 at the beginning... $range = 0; /** * Feed Pagination */ if ($this->config->feed_pagination) { /** * If the config option, feed_pagination is set, we will spit up the feed into pages. */ // Get total number of publically available posts $sql = "SELECT count(`id`) FROM `pixelpost` WHERE `published` <= '{$this->config->current_time}'"; $this->total_posts = (int) Pixelpost_DB::get_var($sql); // Determine the total number of pages Pixelpost_Uri::$total_pages = (int) ceil($this->total_posts / $this->config->posts_per_page); // Verify that we're on a legitimate page to start with if (Pixelpost_Uri::$total_pages < Pixelpost_Uri::$page) { // @todo this error displays if the database call doesn't work. throw new Exception("Sorry, we don't have anymore pages to show!"); } // The database needs to know which row we need to start with: $range = (int) (Pixelpost_Uri::$page - 1) * $this->config->posts_per_page; } $posts_sql = "SELECT * FROM `pixelpost` WHERE `published` <= '{$this->config->current_time}' ORDER BY `published` DESC LIMIT {$range}, {$this->config->feed_items}"; // Grab the data object from the DB. $this->posts = (array) Pixelpost_DB::get_results($posts_sql); /** * The RSS feed can't have altered published dates, * so we need to completely nuke "filter_published" * before we can run processPosts(). */ Pixelpost_Plugin::removeFilterHook('filter_published'); /** * Run the posts through the Plugin system, and apply any * necessary data before sending the array to the view. */ $this->processPosts(); /** * If index is called, without specifying a feed type, * auto-run the default rss method. */ if (empty($this->feed_type) || !method_exists($this, $this->feed_type . 'Action')) { $this->rssAction(); } }
public function indexAction() { if (!is_array($this->posts)) { // Page Title $this->view->title = 'The Past'; if ($this->config->posts_per_page > 0) { /** * If the config option, posts_per_page is set, we will spit up the archive into pages. */ // Get total number of publically available posts $sql = "SELECT count(`id`) FROM `pixelpost` WHERE `published` <= '{$this->config->current_time}'"; $this->total_posts = (int) Pixelpost_DB::get_var($sql); // Determine the total number of pages Pixelpost_Uri::$total_pages = (int) ceil($this->total_posts / $this->config->posts_per_page); // Verify that we're on a legitimate page to start with if (Pixelpost_Uri::$total_pages < Pixelpost_Uri::$page) { throw new Exception("Sorry, we don't have anymore pages to show!"); } // The database needs to know which row we need to start with: $range = (int) (Pixelpost_Uri::$page - 1) * $this->config->posts_per_page; $sql = "SELECT * FROM `pixelpost` WHERE `published` <= '{$this->config->current_time}' ORDER BY `published` DESC LIMIT {$range}, {$this->config->posts_per_page}"; } else { /** * the config option, posts_per_page, isn't set, so display ALL the posts */ $sql = "SELECT * FROM `pixelpost` WHERE `published` <= '{$this->config->current_time}' ORDER BY `published` DESC"; } /** * The posts to list: */ $this->posts = (array) Pixelpost_DB::get_results($sql); } // !is_array($this->posts) /** * Run the posts through the Plugin system, and apply any * necessary data before sending the array to the view. */ $this->processPosts(); /** * Assign the variables to be used in the view * $this->view->myVar can be accessed in the template as $myVar */ $this->view->thumbnails = $this->_thumbnails(); $this->view->posts = $this->posts; }
/** * Attempt to login, and set the session */ public function login($username = '', $password = '') { // convert the plaintext password to a SHA1 encoded string $password = hash('sha1', $password); $username = Pixelpost_DB::escape($username); $old_sess_id = session_id(); // First check if there is a session available with a login_hash. if ($this->session->get('login_vars')) { // There is login data present in the session so compare the username and password // with data stored in session $sess_loginarr = $this->session->get('login_vars'); if ($sess_loginarr['login'] == $username && $sess_loginarr['password'] == $password) { // The given data corresponds with the data stored in the session // Next step is to establish if the hash can be confirmed session_regenerate_id(); $this->session->db_destroy($old_sess_id); unset($old_sess_id); return $this->confirmAuth(); } else { // The given data is not the data in the session, do not login the user. // destroy the current session $this->logout(); return false; } } else { // If there isn't any session we need to check the given credentials against the database // In order to do so we select the status of a user. If that status == 1 then the user can login $status = (int) Pixelpost_DB::get_var("SELECT `status` FROM users WHERE username = '******' AND password = '******' LIMIT 1"); if ($status == 1) { // We're good to go! // Store the username, password and hash into the session session_regenerate_id(); $this->session->db_destroy($old_sess_id); unset($old_sess_id); $this->storeAuth($username, $password); return true; } else { // Login invalid, or the user is banned return false; } } }
/** * * @Add child node * @ adds a child to a node that has no children * @access public * @param string $node_name The node to add to * @param string $new_node The name of the new child node * @return array */ public function addChildNode($node_name, $node_permalink, $new_node) { try { $sql = "SELECT left_node FROM " . $this->tablename . " \n\t\t\t\tWHERE name='" . Pixelpost_DB::escape($node_name) . "'"; $myLeft = (int) Pixelpost_DB::get_var($sql); Pixelpost_DB::query("UPDATE " . $this->tablename . " SET right_node = right_node + 2 WHERE right_node > " . $myLeft); Pixelpost_DB::query("UPDATE " . $this->tablename . " SET left_node = left_node + 2 WHERE left_node > " . $myLeft); $new_left = $myLeft + 1; $new_right = $myLeft + 2; Pixelpost_DB::query("INSERT INTO " . $this->tablename . "(name, left_node, right_node, permalink) \n\t\t\t\tVALUES('{$new_node}', '{$new_left}', '{$new_right}', '{$node_permalink}')"); } catch (exception $e) { throw new Exception($e); } }