コード例 #1
0
 /**
  *
  *
  * @param object		$params
  * @return array|null	
  */
 function getList($params)
 {
     $forums = array();
     $f_groups = explode("\n", $params->get('forums_groups', '0:10'));
     $all_forums_flag = false;
     foreach ($f_groups as $value) {
         @(list($f_group, $count) = explode(':', $value, 2));
         $f_group = explode(',', $f_group);
         JArrayHelper::toInteger($f_group, 0);
         // allow only single group for ALL forums
         if (in_array(0, $f_group) && $all_forums_flag) {
             continue;
         } else {
             if (in_array(0, $f_group)) {
                 $f_group = array(0);
                 $all_forums_flag = true;
             }
         }
         $forums[] = array('f_group' => $f_group, 'count' => $count ? abs((int) $count) : 1);
     }
     if (!$forums) {
         $forums[] = array('f_group' => array(0), 'count' => $count);
     }
     $exclude_forums = explode(',', $params->get('exclude_forums'));
     foreach ($exclude_forums as $key => $value) {
         if (!is_numeric($value)) {
             $value = -1;
         }
         $exclude_forums[$key] = (int) $value;
     }
     // Get forum database connection
     if ($params->def('forum_db', 'joomla') == 'joomla') {
         $config =& JFactory::getConfig();
         $options = array('driver' => $config->getValue('config.dbtype'), 'host' => $config->getValue('config.host'), 'database' => $config->getValue('config.db'), 'user' => $config->getValue('config.user'), 'password' => $config->getValue('config.password'));
     } else {
         $options = array('driver' => $params->get('phpbb_driver'), 'host' => $params->get('phpbb_host'), 'database' => $params->get('phpbb_database'), 'user' => $params->get('phpbb_user'), 'password' => $params->get('phpbb_password'));
     }
     $options['prefix'] = $params->get('phpbb_prefix');
     $forum_db =& JDatabase::getInstance($options);
     if (JError::isError($forum_db)) {
         JError::handleLog($forum_db, null);
         return array(null, null);
     }
     // Forums
     $query = 'SELECT forum_id, forum_name FROM #__forums';
     $forum_db->setQuery($query);
     $forums_list = $forum_db->loadAssocList('forum_id');
     if ($forum_db->getErrorMsg()) {
         JError::handleLog(JError::raiseWarning($forum_db->getErrorNum(), $forum_db->getErrorMsg()), null);
         return array(null, null);
     }
     $forums_list[0] = array('forum_id' => 0, 'forum_name' => JText::_('DPLT Forum'));
     // Topics
     $topics_list = array();
     foreach ($forums as $f_group) {
         $query = 'SELECT forum_id, topic_id, topic_title, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_subject, topic_last_post_time, topic_replies' . '	FROM #__topics' . '	WHERE topic_approved = 1 ';
         if (!in_array(0, $f_group['f_group'])) {
             $query .= '		AND forum_id IN (' . implode(',', $f_group['f_group']) . ')' . "\n";
         } else {
             if ($exclude_forums) {
                 $query .= '		AND forum_id NOT IN (' . implode(',', $exclude_forums) . ')' . "\n";
             }
         }
         $query .= '	ORDER BY topic_last_post_time DESC';
         $forum_db->setQuery($query, 0, $f_group['count']);
         $rows = $forum_db->loadAssocList();
         if ($forum_db->getErrorMsg()) {
             JError::handleLog(JError::raiseWarning($forum_db->getErrorNum(), $forum_db->getErrorMsg()), null);
             return array(null, null);
         }
         if ($rows) {
             foreach ($rows as $key => $row) {
                 $rows[$key]['forum_name'] = $forums_list[$row['forum_id']]['forum_name'];
             }
             $topics_list[current($f_group['f_group'])] = $rows;
         }
     }
     return array($forums_list, $topics_list);
 }