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; }