Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function _buildQuery()
- {
- global $ccbConfig;
- $user = &JFactory::getUser();
- $where = array(
- 'p.topic_id = '.(int)$this->_topic_id ,
- 'p.hold = 0 ',
- 'f.view_for <= ' . $user->get('gid'),
- 'f.published = 1'
- );
- $order = 'p.id '. $ccbConfig->postlistorder;
- $query = 'SELECT p.id, p.topic_id, p.forum_id, p.post_subject, p.post_text, '.
- 'p.post_user, p.post_username, p.post_time, p.ip, ' .
- 'p.modified_by, p.modified_time, p.modified_reason ' .
- 'FROM #__ccb_posts AS p ' .
- 'INNER JOIN #__ccb_forums AS f ON f.id = p.forum_id ' .
- 'WHERE ' . implode(' AND ', $where) . ' ORDER BY ' . $order;
- return $query;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement