/** * Method to build the query WHERE segment * * @access protected * @param null * @return string */ protected function buildQueryWhere() { $category_id = (int) $this->getFilter('category_id'); if ($category_id > 0) { $this->addWhere('item.id IN (SELECT `id` FROM `#__simplelists_categories` WHERE `category_id`=' . $category_id . ')'); } $link_type = $this->getFilter('link_type'); if (!empty($link_type)) { $this->addWhere('item.link_type =' . $this->_db->Quote($link_type)); } return parent::buildQueryWhere(); }
/** * Method to build the query WHERE segment * * @access protected * @param null * @return string */ protected function buildQueryWhere() { $this->addWhere('plugin.type = "plugin"'); $this->addWhere('plugin.folder = "simplelistslink"'); return parent::buildQueryWhere(); }
/** * Method to build the query WHERE segment * * @access protected * @param null * @return string */ protected function buildQueryWhere() { if (YireoHelper::isJoomla15()) { $this->addWhere('`category`.`section`="com_simplelists"'); } else { $this->addWhere('`category`.`extension`="com_simplelists"'); } if ($this->_parent_id > 0) { $this->addWhere('`category`.`parent_id`=' . (int) $this->_parent_id); } return parent::buildQueryWhere(); }
/** * Method to build the query WHERE segment * * @access protected * @param null * @return string */ protected function buildQueryWhere() { $this->addWhere('category.published = 1'); // Apply the category-filter $category_id = (int) $this->getId(); if ($category_id > 0) { $this->addWhere('relation.category_id = ' . $category_id); } // Apply the character-filter if ($this->getState('no_char_filter') != 1) { $character = JRequest::getCmd('char'); if (!empty($character) && preg_match('/^([a-z]{1})$/', $character)) { $this->addWhere('item.title LIKE ' . $this->_db->Quote($character . '%')); } } return parent::buildQueryWhere(); }