Файл: apwa/phpbb_seo/phpbb_seo_related.php
Строк: 224
<?php
/**
*
* @package phpBB SEO Related topics
* @version $Id: phpbb_seo_related.php 314 2011-06-27 08:21:34Z dcz $
* @copyright (c) 2006 - 2011 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 $version = '0.2.4';
var $fulltext = true;
var $limit = 5;
var $allforums = false;
var $check_ignore = false;
var $forum_exclude = array();
/**
* 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;
// Only include those forums the user is having read access to...
$related_forum_ids = $auth->acl_getf('f_read', true);
if (!empty($related_forum_ids)) {
$related_forum_ids = array_keys($related_forum_ids);
if (!empty($this->forum_exclude)) {
$related_forum_ids = array_diff($related_forum_ids, $this->forum_exclude);
}
$forum_sql = !empty($related_forum_ids) ? $db->sql_in_set('t.forum_id', $related_forum_ids, false) . ' AND ' : '';
} else {
$forum_sql = !empty($this->forum_exclude) ? $db->sql_in_set('t.forum_id', $this->forum_exclude, true) . ' AND ' : '';
}
} else {
if (in_array($forum_id, $this->forum_exclude)) {
return false;
}
$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, 't.topic_title');
if (!$sql_like) {
return false;
}
$sql_array['WHERE'] .= " AND $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 string $text the table field we are matching against
* @param int $limit maxximum number of words to use in the query
*/
function buil_sql_like($text, $field, $limit = 3) {
global $db;
$sql_like = array();
$i = 0;
$text = explode(' ', trim(preg_replace('`[s]+`', ' ', $text)));
if ( !empty($text) ) {
foreach ($text as $word) {
$sql_like[] = "'%" . $db->sql_escape(trim($word)) . "%'";
$i++;
if ($i >= $limit) {
break;
}
}
}
$result = false;
$escape = '';
$operator = 'LIKE';
if (!empty($sql_like)) {
switch ($db->sql_layer) {
case 'mysql':
case 'mysql4':
case 'mysqli':
$result = '(t.topic_title LIKE ' . implode(' OR ', $sql_like) . ')';
break;
case 'oracle': // untested
case 'mssql': // untested
case 'mssql_odbc': // untested
case 'mssqlnative': // untested
case 'firebird': // untested
$escape = " ESCAPE '\'";
// no break;
case 'postgres':
if ($db->sql_layer === 'postgres') {
$operator = 'ILIKE';
}
// no break;
case 'sqlite': // untested
$result = '(' . implode(' OR ', $this->sql_like_field($sql_like, $field, $operator, $escape)) . ')';
break;
}
}
return $result;
}
/**
* sql_like_field
* @param array $sql_like the escaped words to match
* @param string $field the field to match against
* @param string $operator the operator to use
* @param string $escape the optional escape string
*/
function sql_like_field($sql_like, $field, $operator = 'LIKE', $escape = '') {
$result = array();
foreach ($sql_like as $word) {
$result[] = "($field $operator $word $escape)";
}
return $result;
}
}
?>