IntegraMOD

* @see http://www.codemonkeyx.net */ class NewsDataAccess { // {{{ properties /** * phpBB Database Object. * * @var object */ var $db; /** * Path to phpbb. * * @var string */ var $root_path; /** * Php extension used on this server. i.e. .php, .php3. * * @var string */ var $phpEx; /** * The configuration array of phpBB. * * @var string */ var $config; /** * The default number of items to retrieve. * * @var integer */ var $num_items; // }}} // {{{ constructor /** * PhpbbNewsAccess Constructor. * * @access public **/ function NewsDataAccess( $phpbb_root ) { global $db, $phpEx, $board_config; $this->db = &$db; $this->root_path = $phpbb_root; $this->phpEx = $phpEx; $this->config = &$board_config; $this->setItemCount( DEFAULT_NUM_ITEMS ); } // }}} // {{{ setItemCount( ) /** * Sets the defualt number of topics to be retrieved. * * @access public * * @param integer $num_topics The number of topics. * * @return null **/ function setItemCount( $num_items ) { $num_items = intval( $num_items ); if( $num_items > 0 ) { $this->num_items = $num_items; } } // }}} // {{{ getItemCount( ) /** * Sets the defualt number of topics to be retrieved. * * @access public * * @return integer The number of items to return. **/ function getItemCount( ) { return $this->num_items; } // }}} // {{{ fetchCategories( ) /** * Fetches news categories from the phpBB database. * * @access public * * @param integer $sort (Optional) The sort order of the items. * SORT_ALPH_DEC - Sort by category name descending. * SORT_ALPH_ASC - Sort by category name ascending. * @param integer $start (Optional) The first news title to display. * @param integer $num_items (Optional) The number of items to retrieve. * * @return array A multi element array containing the requested information. **/ function fetchCategories( $sort = 0 ) { // Validate parameters. $sort = intval( $sort ); if( $sort <0>db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $cats = array(); while( $row = $this->db->sql_fetchrow($result) ) { $row['topic_count'] = $this->fetchArticlesCount( $row['news_id'] ); $cats[] = $row; } $this->db->sql_freeresult( $result ); return $cats; } // }}} // {{{ fetchRecentCategories( ) /** * Fetches news categories from the phpBB database. * * @access public * * @param integer $num_items (Optional) The number of items to retrieve. * * @return array A multi element array containing the requested information. **/ function fetchRecentCategories( $num_items = 0 ) { // Validate parameters. $num_items = intval( $num_items ); if( $num_items <0>num_items; } // Begin SQL Construction. $sql = 'SELECT n.* FROM ' . TOPICS_TABLE . ' AS t LEFT JOIN ' . NEWS_TABLE . ' AS n USING ( news_id ) WHERE t.news_id > 0 ORDER BY t.topic_time DESC'; // End SQL Construction. if( !($result = $this->db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $checked = array(); $recent = array(); while( $row = $this->db->sql_fetchrow($result) ) { if( count( $recent ) >= $num_items ) { break; } if( !in_array( $row['news_id'], $checked ) ) { $row['news_image'] = $this->root_path . $this->config['news_path'] . '/' . $row['news_image']; $recent[] = $row; $checked[] = $row['news_id']; } } $this->db->sql_freeresult( $result ); return $recent; } // }}} // {{{ fetchArticle( ) /** * Fetches a news article from the phpBB database. * * @access public * * @param integer $article_id ID of the article to be fetched. * * @return array A multi element array containing the requested information. **/ function fetchArticle( $article_id ) { $article_id = intval( $article_id ); if( $article_id <0>db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $article = array( ); if( $row = $this->db->sql_fetchrow($result) ) { $article[] = $row; } $this->db->sql_freeresult( $result ); return $article; } // }}} // {{{ fetchPosts( ) /** * Fetches a all posts under a topic. * * @access public * * @param integer $topic_id ID of the topic. * * @return array A multi element array containing the requested information. **/ function fetchPosts( $topic_id, $start = 0 ) { $topic_id = intval( $topic_id ); $start = intval( $start ); if( $topic_id < 0 ) { return array( ); } if( $start <0>num_items; // Begin SQL Construction. $sql = 'SELECT p.post_id, p.post_username, p.post_time, p.post_edit_time, pt.*, u.user_id, u.username, u.user_email, u.user_website, u.user_level, u.user_posts, u.user_rank FROM ' . TOPICS_TABLE . ' AS t LEFT OUTER JOIN ' . APPROVE_POSTS_TABLE . ' AS a ON (t.topic_first_post_id = a.post_id), ' . USERS_TABLE . ' AS u, ' . POSTS_TEXT_TABLE . ' AS pt, ' . POSTS_TABLE . ' AS p WHERE t.topic_id = ' . $topic_id . ' AND p.topic_id = t.topic_id AND p.post_id <> t.topic_first_post_id AND pt.post_id = p.post_id AND a.post_id is NULL AND p.poster_id = u.user_id ORDER BY p.post_time DESC LIMIT ' . $start . ', ' . $num_items; if( !($result = $this->db->sql_query($sql)) ) { echo $sql; return array( ); } $article = array( ); while( $row = $this->db->sql_fetchrow($result) ) { $article[] = $row; } $this->db->sql_freeresult( $result ); return $article; } // }}} // {{{ fetchPostsCount( ) /** * Fetches a all posts under a topic. * * @access public * * @param integer $topic_id ID of the topic. * * @return array A multi element array containing the requested information. **/ function fetchPostsCount( $topic_id ) { $topic_id = intval( $topic_id ); if( $topic_id <0>db->sql_query($sql)) ) { return array( ); } if( $row = $this->db->sql_fetchrow($result) ) { $this->db->sql_freeresult( $result ); return $row['news_count']; } $this->db->sql_freeresult( $result ); return 0; } // }}} // {{{ fetchDay( ) /** * Fetches all news articles for the given day. * * @access public * * @param integer $day Selected day. * @param integer $month Selected month. * @param integer $year Selected year. * * @return array A multi element array containing the requested information. **/ function fetchDay( $day, $month, $year ) { $interval_begin = gmmktime(0,0,0,$month,$day,$year); $interval_end = $interval_begin + 86400; $sql = 'SELECT t.topic_time FROM ' . TOPICS_TABLE . ' AS t LEFT OUTER JOIN ' . APPROVE_POSTS_TABLE . ' AS a ON (t.topic_first_post_id = a.post_id), ' . NEWS_TABLE . ' AS n WHERE n.news_id = t.news_id AND t.news_id > 0 AND a.post_id is NULL AND t.topic_time > ' . $interval_begin . ' AND t.topic_time <interval_end>db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $articles = array(); while( $row = $this->db->sql_fetchrow($result) ) { $articles[] = $row; } $this->db->sql_freeresult( $result ); return $articles; } // }}} // {{{ fetchDays( ) /** * Fetches days of the month which have news posts. * * @access public * * @param integer $month Selected month. * @param integer $year Selected year. * * @return array A multi element array containing the requested information. **/ function fetchDays( $month, $year ) { $interval_begin = mktime( 0, 0, 0, $month, 1, $year); $interval_end = mktime( 0, 0, 0, $month + 1, 1, $year); $sql = 'SELECT t.topic_time FROM ' . TOPICS_TABLE . ' AS t LEFT OUTER JOIN ' . APPROVE_POSTS_TABLE . ' AS a ON (t.topic_first_post_id = a.post_id), ' . NEWS_TABLE . ' AS n WHERE n.news_id = t.news_id AND t.news_id > 0 AND a.post_id is NULL AND t.topic_time > ' . $interval_begin . ' AND t.topic_time <interval_end>db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum news information', '', __LINE__, __FILE__, $sql); } for ( $i = 1; $i <32>db->sql_fetchrow($result) ) { $days[ intval( create_date('j', $row['topic_time'], 0)) ]++; } $this->db->sql_freeresult( $result ); return $days; } // }}} // {{{ fetchMonths( ) /** * Fetches months of the year which have news posts. * * @access public * * @param integer $year Selected year. * * @return array A multi element array containing the requested information. **/ function fetchMonths( $year ) { $interval_begin = mktime( 0, 0, 0, 1, 1, $year); $interval_end = mktime( 0, 0, 0, 1, 1, $year+1); $sql = 'SELECT t.topic_time FROM ' . TOPICS_TABLE . ' AS t LEFT OUTER JOIN ' . APPROVE_POSTS_TABLE . ' AS a ON (t.topic_first_post_id = a.post_id), ' . NEWS_TABLE . ' AS n WHERE n.news_id = t.news_id AND t.news_id > 0 AND a.post_id is NULL AND t.topic_time > ' . $interval_begin . ' AND t.topic_time <interval_end>db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum news information', '', __LINE__, __FILE__, $sql); } for ( $i = 1; $i <12>db->sql_fetchrow($result) ) { $months[ intval( create_date('n', $row['topic_time'], 0)) ]++; } $this->db->sql_freeresult( $result ); return $months; } // }}} // {{{ fetchYears( ) /** * Returns the range of years for which there are posts. * * @access public * * @return array A multi element array containing the requested information. **/ function fetchYears( ) { $sql = 'SELECT MAX( t.topic_time ) AS max_time, MIN( t.topic_time ) AS min_time FROM ' . TOPICS_TABLE . ' AS t LEFT OUTER JOIN ' . APPROVE_POSTS_TABLE . ' AS a ON (t.topic_first_post_id = a.post_id), ' . NEWS_TABLE . ' AS n WHERE n.news_id = t.news_id AND a.post_id is NULL AND t.news_id > 0'; if ( !($result = $this->db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum news information', '', __LINE__, __FILE__, $sql); } $years = array( ); if( $row = $this->db->sql_fetchrow($result) ) { $years['min'] = intval( create_date('Y', $row['min_time'], 0)); $years['max'] = intval( create_date('Y', $row['max_time'], 0)); } $this->db->sql_freeresult( $result ); return $years; } // }}} // {{{ fetchArticles( ) /** * Fetches news articles from the phpBB database. * * @access public * * @param integer $sort (Optional) The sort order of the items. * @param integer $cat_id (Optional) A specific category of news to display. * @param integer $start (Optional) The first news title to display. * * @return array A multi element array containing the requested information. **/ function fetchArticles( $sort = 0, $cat_id = 0, $start = 0 ) { // Validate parameters. $sort = intval( $sort ); $cat_id = intval( $cat_id ); $start = intval( $start ); $num_items = $this->num_items; if( $sort < 0 ) { $sort = 0; } if( $cat_id < 0 ) { $cat_id = 0; } if( $start <0> 0 ) { $sql .= 'AND t.news_id = ' . $cat_id . ' '; } $current_time = time(); $sql .= ' AND t.topic_time <current_time>db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $articles = array(); while( $row = $this->db->sql_fetchrow($result) ) { $articles[] = $row; } $this->db->sql_freeresult( $result ); return $articles; } // }}} // {{{ fetchArticlesCount( ) /** * Fetches news articles from the phpBB database. * * @access public * * @param integer $sort (Optional) The sort order of the items. * @param integer $cat_id (Optional) A specific category of news to display. * @param integer $start (Optional) The first news title to display. * * @return array A multi element array containing the requested information. **/ function fetchArticlesCount( $cat_id = 0 ) { // Validate parameters. $cat_id = intval( $cat_id ); if( $cat_id <0> 0 ) { $sql .= 'AND t.news_id = ' . $cat_id . ' '; } // End SQL Construction. if( !($result = $this->db->sql_query($sql)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } if( $row = $this->db->sql_fetchrow($result) ) { $this->db->sql_freeresult( $result ); return $row['a_count']; } $this->db->sql_freeresult( $result ); return 0; } // }}} // {{{ fetchTitles( ) /** * Fetches news titles from the phpBB database. * * @access public * * @param integer $sort (Optional) The sort order of the items. * @param integer $cat_id (Optional) A specific category of news to display. * @param integer $start (Optional) The first news title to display. * * @return array A multi element array containing the requested information. **/ function fetchTitles( $sort = 0, $cat_id = 0, $start = 0 ) { // Validate parameters. $sort = intval( $sort ); $cat_id = intval( $cat_id ); $start = intval( $start ); $num_items = $this->num_items; if( $sort < 0 ) { $sort = 0; } if( $cat_id < 0 ) { $cat_id = 0; } if( $start <0> 0 ) { $sql .= 'AND t.news_id = ' . $cat_id . ' '; } $current_time = time(); $sql .= ' AND t.topic_time <current_time>db->sql_fetchrow($result)) ) { echo 'Error ' . __LINE__ . ' ' . __FILE__; return array( ); } $titles = array(); while( $row = $result->fetchRow( DB_FETCHMODE_ASSOC ) ) { $titles[] = $row; } $this->db->sql_freeresult( $result ); return $titles; } // }}} }

"tekguru";p="21934" wrote:Weird, unless it is me it has speeded up loading of the portal too!