diff options
Diffstat (limited to 'phpBB/phpbb_seo/phpbb_seo_related.php')
| -rw-r--r-- | phpBB/phpbb_seo/phpbb_seo_related.php | 243 |
1 files changed, 243 insertions, 0 deletions
diff --git a/phpBB/phpbb_seo/phpbb_seo_related.php b/phpBB/phpbb_seo/phpbb_seo_related.php new file mode 100644 index 0000000000..d8e1802f1c --- /dev/null +++ b/phpBB/phpbb_seo/phpbb_seo_related.php @@ -0,0 +1,243 @@ +<?php +/** +* +* @package phpBB SEO Related topics +* @version $Id: phpbb_seo_related.php 222 2010-02-27 13:08:48Z dcz $ +* @copyright (c) 2006 - 2010 www.phpbb-seo.com +* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2 +* +*/ + +/** +* @ignore +*/ +if (!defined('IN_PHPBB')) { + exit; +} +/** +* seo_related Class +* www.phpBB-SEO.com +* @package phpBB SEO Related topics +*/ +class seo_related { + var $fulltext = true; + var $limit = 5; + var $allforums = false; + var $check_ignore = false; + /** + * constructor + */ + function seo_related() { + global $db, $config; + if (empty($config['seo_related'])) { + return; + } + // override the above defaults when the acp is in use + $this->limit = !empty($config['seo_related_limit']) ? max(1, (int) $config['seo_related_limit']) : $this->limit; + $this->allforums = isset($config['seo_related_allforums']) ? max(0, (int) $config['seo_related_allforums']) : $this->allforums; + $this->check_ignore = isset($config['seo_related_check_ignore']) ? max(0, (int) $config['seo_related_check_ignore']) : $this->check_ignore; + // better to always check, since it's fast + if ($db->sql_layer != 'mysql4' && $db->sql_layer != 'mysqli') { + $this->fulltext = false; + } else { + $this->fulltext = isset($config['seo_related_fulltext']) ? max(0, (int) $config['seo_related_fulltext']) : $this->fulltext; + } + } + /** + * get related topic list + * @param array $topic_data shuld at least provide with topic_id and topic_title + * @param mixed $forum_id The forum id to search in (false / 0 / null to search into all forums) + * */ + function get($topic_data, $forum_id = false) { + global $db, $auth, $cache, $template, $user, $phpEx, $phpbb_root_path, $topic_tracking_info, $config, $phpbb_seo; + if (empty($config['seo_related'])) { + return; + } + $related_result = false; + $enable_icons = 0; + $this->allforums = !$forum_id ? true : $this->allforums; + $sql = $this->build_query($topic_data, $forum_id); + if ($sql && ($result = $db->sql_query_limit($sql, $this->limit))) { + // Grab icons + $icons = $cache->obtain_icons(); + $attachement_icon = $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']); + $s_attachement = $auth->acl_get('u_download'); + while($row = $db->sql_fetchrow($result)) { + $related_forum_id = (int) $row['forum_id']; + $related_topic_id = (int) $row['topic_id']; + $enable_icons = max($enable_icons, $row['enable_icons']); + if ($auth->acl_get('f_list', $related_forum_id)) { + $row['topic_title'] = censor_text($row['topic_title']); + // www.phpBB-SEO.com SEO TOOLKIT BEGIN + if (!empty($phpbb_seo->seo_opt['url_rewrite'])) { + $phpbb_seo->set_url($row['forum_name'], $related_forum_id, $phpbb_seo->seo_static['forum']); + $phpbb_seo->prepare_iurl($row, 'topic', $row['topic_type'] == POST_GLOBAL ? $phpbb_seo->seo_static['global_announce'] : $phpbb_seo->seo_url['forum'][$related_forum_id]); + } + // www.phpBB-SEO.com SEO TOOLKIT END + // Replies + $replies = ($auth->acl_get('m_approve', $related_forum_id)) ? $row['topic_replies_real'] : $row['topic_replies']; + $unread_topic = (isset($topic_tracking_info[$related_topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$related_topic_id]) ? true : false; + $view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$related_forum_id&t=$related_topic_id"); + $topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $related_forum_id)) ? true : false; + $u_mcp_queue = ($topic_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&mode=approve_details&t=$related_topic_id", true, $user->session_id) : ''; + // Get folder img, topic status/type related information + $folder_img = $folder_alt = $topic_type = ''; + topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type); + // www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe + if (!empty($phpbb_seo->seo_opt['no_dupe']['on'])) { + if (($replies + 1) > $phpbb_seo->seo_opt['topic_per_page']) { + $phpbb_seo->seo_opt['topic_last_page'][$related_topic_id] = floor($replies / $phpbb_seo->seo_opt['topic_per_page']) * $phpbb_seo->seo_opt['topic_per_page']; + } + } + // www.phpBB-SEO.com SEO TOOLKIT END -> no dupe + $template->assign_block_vars('related', array( + 'TOPIC_TITLE' => $row['topic_title'], + 'U_TOPIC' => $view_topic_url, + 'U_FORUM' => $this->allforums ? append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$related_forum_id") : '', + 'FORUM' => $row['forum_name'], + 'PAGINATION' => topic_generate_pagination($replies, $view_topic_url), + 'REPLIES' => $replies, + 'VIEWS' => $row['topic_views'], + 'FIRST_POST_TIME' => $user->format_date($row['topic_time']), + 'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']), + 'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']), + 'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']), + // www.phpBB-SEO.com SEO TOOLKIT BEGIN -> no dupe + 'U_LAST_POST' => !empty($phpbb_seo->seo_opt['no_dupe']['on']) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$related_forum_id&t=$related_topic_id&start=" . @intval($phpbb_seo->seo_opt['topic_last_page'][$related_topic_id])) . '#p' . $row['topic_last_post_id'] : append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$related_forum_id&t=$related_topic_id&p=" . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'], + // www.phpBB-SEO.com SEO TOOLKIT END -> no dupe + 'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'), + 'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt, false), + 'TOPIC_ICON_IMG' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '', + 'ATTACH_ICON_IMG' => ($row['topic_attachment'] && $s_attachement) ? $attachement_icon : '', + 'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && $auth->acl_get('m_report', $related_forum_id)) ? true : false, + 'S_UNREAD_TOPIC' => $unread_topic, + 'S_POST_ANNOUNCE' => ($row['topic_type'] == POST_ANNOUNCE) ? true : false, + 'S_POST_GLOBAL' => ($row['topic_type'] == POST_GLOBAL) ? true : false, + 'S_POST_STICKY' => ($row['topic_type'] == POST_STICKY) ? true : false, + 'S_TOPIC_LOCKED' => ($row['topic_status'] == ITEM_LOCKED) ? true : false, + 'S_TOPIC_UNAPPROVED' => $topic_unapproved, + 'U_MCP_REPORT' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=reports&f=' . $related_forum_id . '&t=' . $related_topic_id, true, $user->session_id), + 'U_MCP_QUEUE' => $u_mcp_queue, + )); + $related_result = true; + } + } + $db->sql_freeresult($result); + } + if ($related_result) { + $template->assign_vars(array( + 'S_RELATED_RESULTS' => $related_result, + 'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'), + 'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'), + 'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', 'TOPIC_UNAPPROVED'), + 'REPORTED_IMG' => $user->img('icon_topic_reported', 'TOPIC_REPORTED'), + 'GOTO_PAGE_IMG' => $user->img('icon_post_target', 'GOTO_PAGE'), + 'S_TOPIC_ICONS' => $enable_icons, + )); + } + } + /** + * build_query + * @param array $topic_data shuld at least provide with topic_id and topic_title + * @param mixed $forum_id The forum id to search in (false / 0 / null to search into all forums) + */ + function build_query($topic_data, $forum_id = false) { + global $db; + if (!($match = $this->prepare_match($topic_data['topic_title']))) { + return false; + } + if (!$forum_id || $this->allforums) { + global $auth; + // Do not include those forums the user is not having read access to... + $related_read_ary = $auth->acl_getf('f_read', true); + $related_forum_ids = array(); + foreach ($related_read_ary as $_forum_id => $null) { + $related_forum_ids[$_forum_id] = (int) $_forum_id; + } + $forum_sql = sizeof($related_forum_ids) ? $db->sql_in_set('t.forum_id', $related_forum_ids, false, true) . ' AND ' : ''; + } else { + $forum_sql = ' t.forum_id = ' . (int) $forum_id . ' AND '; + } + $sql_array = array( + 'SELECT' => 't.*, f.forum_name, f.enable_icons', + 'FROM' => array( + TOPICS_TABLE => 't', + FORUMS_TABLE => 'f' + ), + 'WHERE' => "$forum_sql f.forum_id = t.forum_id", + ); + if ($this->fulltext) { + $sql_array['SELECT'] .= ", MATCH (t.topic_title) AGAINST ('" . $db->sql_escape($match) . "') relevancy"; + $sql_array['WHERE'] .= " AND MATCH (t.topic_title) AGAINST ('" . $db->sql_escape($match) . "')"; + $sql_array['ORDER_BY'] = 'relevancy DESC'; + } else { + $sql_like = $this->buil_sql_like($match); + if (!$sql_like) { + return false; + } + $sql_array['WHERE'] .= " AND t.topic_title $sql_like"; + $sql_array['ORDER_BY'] = 't.topic_id DESC'; + } + $sql_array['WHERE'] .= " AND t.topic_status <> " . ITEM_MOVED . " + AND t.topic_id <> " . (int) $topic_data['topic_id']; + return $db->sql_build_query('SELECT', $sql_array); + } + /** + * prepare_match : Prepares the word list to search for + * @param string $text the string of all words to search for, eg topic_title + * @param int $min_lenght word with less than $min_lenght letters will be dropped + * @param int $max_lenght word with more than $max_lenght letters will be dropped + */ + function prepare_match($text, $min_lenght = 3, $max_lenght = 14) { + $word_list = array(); + $text = trim(preg_replace('`[\s]+`', ' ', $text)); + if (!empty($text)) { + $word_list = array_unique(explode(' ', utf8_strtolower($text))); + foreach ($word_list as $k => $word) { + $len = utf8_strlen(trim($word)); + if ( ($len < $min_lenght) || ($len > $max_lenght) ) { + unset($word_list[$k]); + } + } + } + if (!empty($word_list) && $this->check_ignore) { + global $phpbb_root_path, $user, $phpEx; + // add stop words to $user to allow reuse + if (empty($user->stop_words)) { + $words = array(); + if (file_exists("{$user->lang_path}{$user->lang_name}/search_ignore_words.$phpEx")){ + // include the file containing ignore words + include("{$user->lang_path}{$user->lang_name}/search_ignore_words.$phpEx"); + } + $user->stop_words = & $words; + } + $word_list = array_diff($word_list, $user->stop_words); + } + return !empty($word_list) ? implode(' ', $word_list) : ''; + } + /** + * buil_sql_like + * @param string $text the string of all words to search for,prepared with prepare_match + * @param int $limit maxximum number of words to use in the query + */ + function buil_sql_like($text, $limit = 3) { + global $db; + $sql_like = ''; + $i = 0; + $text = str_replace(array('_', '%'), array("\_", "\%"), $text); + $text = str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $text); + $text = explode(' ', trim(preg_replace('`[\s]+`', ' ', $text))); + if ( !empty($text) ) { + foreach ($text as $word) { + $word = $db->sql_escape(trim($word)); + $sql_like .= empty($sql_like) ? " LIKE '%$word%'" : " OR '%$word%'"; + $i++; + if ($i >= $limit) { + return $sql_like; + } + } + } + return $sql_like; + } +} +?>
\ No newline at end of file |