protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query ->select('cc.title AS category'); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); if ($this->_state->source instanceof KDatabaseRowInterface || $this->_state->container) { $query->select('c.slug AS container'); } }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('categories.title AS category') ->select('users.name AS editor'); }
protected function _buildQueryColumns(KDatabaseQuery $query) { $query->select(array('person.*', 'tbl.*'))->select(array('IFNULL(person.posts, 0) AS posts', 'IFNULL(person.avatar, CONCAT(LOWER(\'/MEDIA/COM_NINJABOARD/IMAGES/AVATAR\'), LOWER(\'.PNG\'))) AS avatar', 'person.signature AS signature'))->select(array('(SELECT rank_file FROM #__ninjaboard_ranks WHERE IFNULL(person.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_icon', '(SELECT title FROM #__ninjaboard_ranks WHERE IFNULL(person.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_title')); parent::_buildQueryColumns($query); //Build query for the screen names KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'person', 'tbl', 'display_name'); }
protected function _buildQueryColumns(KDatabaseQuery $query) { if (!$this->_state->isUnique()) { $query->select('COUNT(relations.attachments_attachment_id) AS count')->select('table')->select('row'); } return parent::_buildQueryColumns($query); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); if ($this->_state->connect) { $query->select('trans.*'); $query->select('rel.*'); } }
protected function _buildQueryColumns(KDatabaseQuery $query) { if ($this->_state->distinct && !empty($this->_state->column)) { $query->distinct()->select($this->_state->column)->select($this->_state->column . ' AS logs_log_id'); } else { parent::_buildQueryColumns($query); $query->select('users.name AS created_by_name'); } }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('user.usertype')->select('person.posts AS person_posts')->select('tbl.ninjaboard_post_id AS id')->select("IFNULL(person.avatar, '/media/com_ninjaboard/images/avatar.png') AS avatar")->select("IF(topic.first_post_id = tbl.ninjaboard_post_id, tbl.subject, CONCAT('RE: ', first_post.subject)) AS subject")->select('person.signature')->select('(SELECT rank_file FROM #__ninjaboard_ranks WHERE person.posts >= min AND enabled = 1 ORDER BY min DESC LIMIT 1) AS rank_icon')->select('(SELECT title FROM #__ninjaboard_ranks WHERE person.posts >= min AND enabled = 1 ORDER BY min DESC LIMIT 1) AS rank_title'); //Build query for the screen names KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'person', 'user', 'display_name', 'IFNULL(tbl.guest_name, \'' . JText::_('Anonymous') . '\')'); if ($search = $this->_state->search) { $query->select(array('forum.title AS forum', 'topic.ninjaboard_topic_id AS topic', 'topic.hits')); } }
/** * Builds SELECT columns list for the query. * * @param KDatabaseQuery A query object. * @return void */ protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $state = $this->_state; $query->select('IF(session.session_id IS NOT NULL, 1, 0) AS loggedin'); $query->select('IF(tbl.block = 1, 0, 1) AS enabled'); if ($state->loggedin) { $query->select(array('session.client_id AS loggedin_client_id', 'session.time AS loggedin_on', 'session.session_id AS loggedin_session_id')); } }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); if ($this->_state->section) { if ($this->_state->section == 'com_content' || is_numeric($this->_state->section)) { $query->select('sections.title AS section_title')->select('SUM( IF(content.state <> -2,1,0)) activecount'); } else { $query->select('SUM(IF(child.catid,1,0)) activecount'); } } }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('section.title AS section_title') ->select('category.title AS category_title') ->select('user.name AS created_by_name') ->select('user.id AS created_by_id') ->select('IF(frontpage.content_id, 1, 0) AS featured') ->select('frontpage.ordering AS featured_ordering') ->select('group.name AS group_name'); }
/** * @param KDatabaseQuery $query */ protected function _buildQueryColumns(KDatabaseQuery $query) { $query->select('COUNT(crumbs.ancestor_id) AS level')->select('GROUP_CONCAT(crumbs.ancestor_id ORDER BY crumbs.level DESC SEPARATOR \'/\') AS path'); if ($this->getTable()->hasBehavior('orderable')) { if (!$query->count) { $query->select('o2.custom AS ordering'); } if (in_array($this->_state->sort, array('title', 'created_on', 'custom'))) { $column = sprintf('GROUP_CONCAT(LPAD(`o`.`%s`, 5, \'0\') ORDER BY crumbs.level DESC SEPARATOR \'/\') AS order_path', $this->_state->sort); $query->select($column); } } parent::_buildQueryColumns($query); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('tbl.*')->select('first_post.subject')->select('first_post.subject AS title')->select('first_post.subject AS alias')->select('last_post.subject AS last_post_subject')->select('first_post.created_time AS first_post_date')->select('first_post.created_user_id AS started_by')->select('tbl.last_post_by AS created_user_id')->select('tbl.last_post_on AS last_post_date'); // Do some joins here, to avoid unnecessary joins in count queries $query->join('LEFT', 'ninjaboard_posts AS first_post', 'first_post.ninjaboard_post_id = tbl.first_post_id')->join('LEFT', 'ninjaboard_posts AS last_post', 'last_post.ninjaboard_post_id = tbl.last_post_id')->join('LEFT', 'users AS last_post_user', 'last_post_user.id = tbl.last_post_by')->join('LEFT', 'ninjaboard_people AS last_post_person', 'last_post_person.ninjaboard_person_id = tbl.last_post_by'); //Build query for the screen names KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'last_post_person', 'last_post_user', 'last_post_username', 'IFNULL(last_post.guest_name, \'' . JText::_('Anonymous') . '\')'); if ($this->_state->forum) { $query->select('IF((symlink.ninjaboard_forum_id = ' . $this->_state->forum . '), forum.title, NULL) AS moved_to_forum_title'); } if (KFactory::get('lib.joomla.user')->guest) { $query->select(array('0 AS new', '1 AS unread')); } else { $me = KFactory::get('admin::com.ninjaboard.model.people')->getMe(); $table = KFactory::get('admin::com.ninjaboard.database.table.logtopicreads'); $select = KFactory::tmp('lib.koowa.database.query')->select('UNIX_TIMESTAMP(IFNULL(MIN(created_on), NOW()))')->where('created_by', '=', $me->id); if ($this->_state->forum) { $select->where('ninjaboard_forum_id', '=', $this->_state->forum); } $start = $table->select($select, KDatabase::FETCH_FIELD); $query->select(array('IF(UNIX_TIMESTAMP(tbl.last_post_on) > ' . (int) $start . ', 1, 0) AS new', 'IF(log.created_on > tbl.last_post_on || tbl.last_post_by = ' . (int) $me->id . ', 0, 1) AS unread')); } }
protected function _buildQueryColumns(KDatabaseQuery $query) { $query->columns[] = 'u.name AS user_name'; parent::_buildQueryColumns($query); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select(array('user.*', 'IFNULL(tbl.posts, 0) AS posts'))->select(array('(SELECT rank_file FROM #__ninjaboard_ranks WHERE IFNULL(tbl.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_icon', '(SELECT title FROM #__ninjaboard_ranks WHERE IFNULL(tbl.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_title')); $this->buildScreenNameQuery($query); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('categorycount') ->select('SUM( IF(active.state <> -2,1,0)) activecount'); }
/** * Builds SELECT fields list for the query */ protected function _buildQueryColumns(KDatabaseQuery $query) { $query->select('tbl.id'); $query->columns[] = 'CONCAT_WS( " / ",s.title, tbl.title ) AS title'; parent::_buildQueryColumns($query); }
/** * Builds SELECT fields list for the query */ protected function _buildQueryColumns(KDatabaseQuery $query) { $query->select('tbl.element AS value')->select('tbl.name AS title'); parent::_buildQueryColumns($query); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); $query->select('COUNT(weblinks.id) AS numlinks'); }
protected function _buildQueryColumns(KDatabaseQuery $query) { parent::_buildQueryColumns($query); //Build query for the screen names //KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'person', 'user', 'recipient'); }