Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.76 KB | None | 0 0
  1.  function _buildQuery()
  2.     {
  3.         global $ccbConfig;
  4.         $user = &JFactory::getUser();
  5.         $where = array(
  6.             'p.topic_id = '.(int)$this->_topic_id ,
  7.             'p.hold = 0 ',
  8.             'f.view_for <= ' . $user->get('gid'),
  9.             'f.published = 1'
  10.         );
  11.  
  12.         $order = 'p.id '. $ccbConfig->postlistorder;
  13.  
  14.         $query = 'SELECT p.id, p.topic_id, p.forum_id, p.post_subject, p.post_text, '.
  15.                     'p.post_user, p.post_username, p.post_time, p.ip, ' .
  16.                     'p.modified_by, p.modified_time, p.modified_reason ' .
  17.                     'FROM #__ccb_posts AS p ' .
  18.                     'INNER JOIN #__ccb_forums AS f ON f.id = p.forum_id ' .
  19.                     'WHERE ' . implode(' AND ', $where) . ' ORDER BY ' . $order;
  20.  
  21.         return $query;
  22.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement