Пример #1
0
 protected function _modTopicList($data)
 {
     $result = array();
     $catid = intval($data);
     $user = KunenaFactory::getuser();
     if ($catid && $user->isModerator($catid)) {
         $query = "SELECT id, subject\n\t\t\t\t\t\t\tFROM #__kunena_messages\n\t\t\t\t\t\t\tWHERE catid={$this->_db->Quote($catid)} AND parent=0 AND moved=0\n\t\t\t\t\t\t\tORDER BY id DESC";
         $this->_db->setQuery($query, 0, 15);
         $topics_list = $this->_db->loadObjectlist();
         if ($this->_db->getErrorNum()) {
             $result = array('status' => '-1', 'error' => KunenaError::getDatabaseError());
         } else {
             $result['status'] = '1';
             $result['topiclist'] = $topics_list;
         }
     } else {
         $result['status'] = '0';
         $result['error'] = 'Error';
     }
     return $result;
 }