203 lines
11 KiB
PHP
203 lines
11 KiB
PHP
<?php
|
|
if (!defined('IN_INDEX')) {
|
|
header('Location: ../index.php');
|
|
exit;
|
|
}
|
|
|
|
if (isset($_SESSION[$settings['session_prefix'].'user_id'])) {
|
|
$tmp_user_id = $_SESSION[$settings['session_prefix'].'user_id'];
|
|
} else {
|
|
$tmp_user_id = 0;
|
|
}
|
|
|
|
if (isset($_GET['list_spam']) && isset($_SESSION[$settings['session_prefix'].'user_type']) && $_SESSION[$settings['session_prefix'].'user_type'] > 0) {
|
|
// list spam postings:
|
|
$count_result = mysqli_query($connid, "SELECT COUNT(*) FROM ".$db_settings['forum_table']." WHERE spam = 1");
|
|
list($search_results_count) = mysqli_fetch_row($count_result);
|
|
$total_pages = ceil($search_results_count / $settings['search_results_per_page']);
|
|
if (isset($_GET['page'])) $page = intval($_GET['page']); else $page = 1;
|
|
if ($page < 1) $page = 1;
|
|
if ($page > $total_pages) $page = $total_pages;
|
|
$ul = ($page - 1) * $settings['search_results_per_page'];
|
|
// data for browse navigation:
|
|
$page_browse['page'] = $page;
|
|
$page_browse['total_items'] = $search_results_count;
|
|
$page_browse['items_per_page'] = $settings['search_results_per_page'];
|
|
$page_browse['browse_array'][] = 1;
|
|
if ($page > 5) $page_browse['browse_array'][] = 0;
|
|
for ($browse = $page - 3; $browse < $page + 4; $browse++) {
|
|
if ($browse > 1 && $browse < $total_pages) $page_browse['browse_array'][] = $browse;
|
|
}
|
|
if ($page < $total_pages - 4) $page_browse['browse_array'][] = 0;
|
|
if($total_pages > 1) $page_browse['browse_array'][] = $total_pages;
|
|
if($page < $total_pages) $page_browse['next_page'] = $page + 1; else $page_browse['next_page'] = 0;
|
|
if($page > 1) $page_browse['previous_page'] = $page - 1; else $page_browse['previous_page'] = 0;
|
|
$smarty->assign('page_browse', $page_browse);
|
|
if ($search_results_count > 0) {
|
|
$result = @mysqli_query($connid, "SELECT id, pid, tid, ".$db_settings['forum_table'].".user_id, UNIX_TIMESTAMP(time) AS time, UNIX_TIMESTAMP(time + INTERVAL ".$time_difference." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, name, user_name, subject, IF(text='',true,false) AS no_text, category, marked, sticky
|
|
FROM ".$db_settings['forum_table']."
|
|
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id = ".$db_settings['forum_table'].".user_id
|
|
WHERE spam = 1
|
|
ORDER BY tid DESC, time ASC LIMIT ".$ul.", ".$settings['search_results_per_page']) or die(mysqli_error($connid));
|
|
$i = 0;
|
|
while ($row = mysqli_fetch_array($result)) {
|
|
$search_results[$i]['id'] = intval($row['id']);
|
|
$search_results[$i]['pid'] = intval($row['pid']);
|
|
|
|
if ($row['user_id'] > 0) {
|
|
if (!$row['user_name']) $search_results[$i]['name'] = $lang['unknown_user'];
|
|
else $search_results[$i]['name'] = htmlspecialchars($row['user_name']);
|
|
}
|
|
else $search_results[$i]['name'] = htmlspecialchars($row['name']);
|
|
$search_results[$i]['subject'] = htmlspecialchars($row['subject']);
|
|
$search_results[$i]['timestamp'] = $row['timestamp'];
|
|
$search_results[$i]['no_text'] = $row['no_text'];
|
|
$search_results[$i]['formated_time'] = format_time($lang['time_format'], $row['timestamp']);
|
|
if (isset($categories[$row["category"]]) && $categories[$row['category']] != '') {
|
|
$search_results[$i]['category'] = $row["category"];
|
|
$search_results[$i]['category_name'] = $categories[$row["category"]];
|
|
}
|
|
$i++;
|
|
}
|
|
mysqli_free_result($result);
|
|
}
|
|
$smarty->assign('search_results_count', $search_results_count);
|
|
if (isset($search_results)) $smarty->assign('search_results', $search_results);
|
|
$smarty->assign('list_spam', true);
|
|
$smarty->assign('subnav_location', 'subnav_list_spam');
|
|
} elseif (isset($_GET['search'])) {
|
|
// regular serach:
|
|
$search = urldecode($_GET['search']);
|
|
if (isset($_GET['p_category'])) $p_category = intval($_GET['p_category']);
|
|
else $p_category = 0;
|
|
if (isset($_GET['method']) && $_GET['method'] == 'tags') $method = 'tags';
|
|
elseif (isset($_GET['method']) && $_GET['method'] == 'fulltext_or') $method = 'fulltext_or';
|
|
else $method = 'fulltext';
|
|
$search = trim($search);
|
|
|
|
// split search query at spaces, but not between double quotes:
|
|
$help_pattern = '[!/*/~/?]'; // pattern to hide spaces between quotes
|
|
$x_search = preg_replace_callback("#\"(.+?)\"#is", create_function('$string', 'global $help_pattern; return str_replace(" ",$help_pattern,$string[1]);'), $search);
|
|
|
|
$x_search_array = explode(' ', my_strtolower($x_search, $lang['charset']));
|
|
foreach($x_search_array as $item) {
|
|
$search_array[] = mysqli_real_escape_string($connid, str_replace($help_pattern, ' ', $item));
|
|
}
|
|
|
|
// limit to 3 words:
|
|
if (count($search_array) > 3) {
|
|
for ($i = 0; $i < 3; ++$i) {
|
|
$stripped_search_array[] = $search_array[$i];
|
|
}
|
|
$search_array = $stripped_search_array;
|
|
}
|
|
foreach ($search_array as $item) {
|
|
if (my_strpos($item, ' ', 0, CHARSET)) {
|
|
$item = '"'.$item.'"';
|
|
}
|
|
$serch_string_array[] = $item;
|
|
}
|
|
$search = implode(' ', $serch_string_array);
|
|
|
|
// search...
|
|
if ($method == 'fulltext_or') {
|
|
if (isset($p_category) && $p_category != 0) $search_string = "category = ".$p_category." AND spam = 0 AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%". implode("%' OR category = ".$p_category." AND spam = 0 AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%",$search_array)."%'";
|
|
else $search_string = "spam = 0 AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%".implode("%' OR spam = 0 AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%",$search_array)."%'";
|
|
} elseif ($method == 'tags') {
|
|
if (isset($p_category) && $p_category != 0) $search_string = "lower(tags) LIKE '%;".implode(";%' AND lower(tags) LIKE '%",$search_array)."%' AND category = ".$p_category." AND spam = 0";
|
|
else $search_string = "lower(tags) LIKE '%;".implode(";%' AND lower(tags) LIKE '%;",$search_array).";%' AND spam= 0 ";
|
|
} else {
|
|
// fulltext
|
|
if (isset($p_category) && $p_category != 0) $search_string = "concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%".implode("%' AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%",$search_array)."%' AND category = ".$p_category." AND spam = 0";
|
|
else $search_string = "concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%".implode("%' AND concat(lower(subject), lower(name), lower(text), lower(tags)) LIKE '%",$search_array)."%' AND spam = 0";
|
|
}
|
|
|
|
// count results:
|
|
if ($search != '') {
|
|
if ($categories != false) $count_result = mysqli_query($connid, "SELECT COUNT(*) FROM ".$db_settings['forum_table']." WHERE ".$search_string." AND category IN (".$category_ids_query.")");
|
|
else $count_result = mysqli_query($connid, "SELECT COUNT(*) FROM ".$db_settings['forum_table']." WHERE ".$search_string);
|
|
list($search_results_count) = mysqli_fetch_row($count_result);
|
|
}
|
|
else $search_results_count = 0;
|
|
|
|
$total_pages = ceil($search_results_count / $settings['search_results_per_page']);
|
|
if (isset($_GET['page'])) $page = intval($_GET['page']); else $page = 1;
|
|
if ($page < 1) $page = 1;
|
|
if ($page > $total_pages) $page = $total_pages;
|
|
$ul = ($page - 1) * $settings['search_results_per_page'];
|
|
// data for browse navigation:
|
|
$page_browse['page'] = $page;
|
|
$page_browse['total_items'] = $search_results_count;
|
|
$page_browse['items_per_page'] = $settings['search_results_per_page'];
|
|
$page_browse['browse_array'][] = 1;
|
|
if ($page > 5) $page_browse['browse_array'][] = 0;
|
|
for ($browse = $page - 3; $browse < $page + 4; $browse++) {
|
|
if ($browse > 1 && $browse < $total_pages) $page_browse['browse_array'][] = $browse;
|
|
}
|
|
if ($page < $total_pages - 4) $page_browse['browse_array'][] = 0;
|
|
if ($total_pages > 1) $page_browse['browse_array'][] = $total_pages;
|
|
if ($page < $total_pages) $page_browse['next_page'] = $page + 1; else $page_browse['next_page'] = 0;
|
|
if ($page > 1) $page_browse['previous_page'] = $page - 1; else $page_browse['previous_page'] = 0;
|
|
$smarty->assign('page_browse', $page_browse);
|
|
|
|
if ($search_results_count > 0) {
|
|
if ($categories != false) {
|
|
$result = @mysqli_query($connid, "SELECT id, pid, tid, ft.user_id, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".$time_difference." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, name, user_name, subject, IF(text='',true,false) AS no_text, category, marked, sticky, rst.user_id AS req_user
|
|
FROM ".$db_settings['forum_table']." AS ft
|
|
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id = ft.user_id
|
|
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
|
|
WHERE ".$search_string." AND category IN (".$category_ids_query.")
|
|
ORDER BY tid DESC, ft.time ASC LIMIT ".$ul.", ".$settings['search_results_per_page']) or die(mysqli_error($connid));
|
|
} else {
|
|
$result = @mysqli_query($connid, "SELECT id, pid, tid, ft.user_id, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(ft.time + INTERVAL ".$time_difference." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, name, user_name, subject, IF(text='',true,false) AS no_text, category, marked, sticky, rst.user_id AS req_user
|
|
FROM ".$db_settings['forum_table']." AS ft
|
|
LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id = ft.user_id
|
|
LEFT JOIN ".$db_settings['read_status_table']." AS rst ON rst.posting_id = ft.id AND rst.user_id = ". intval($tmp_user_id) ."
|
|
WHERE ".$search_string."
|
|
ORDER BY tid DESC, ft.time ASC LIMIT ".$ul.", ".$settings['search_results_per_page']) or die(mysqli_error($connid));
|
|
}
|
|
$i = 0;
|
|
while ($row = mysqli_fetch_array($result)) {
|
|
$search_results[$i]['id'] = intval($row['id']);
|
|
$search_results[$i]['pid'] = intval($row['pid']);
|
|
|
|
if ($row['user_id'] > 0) {
|
|
if (!$row['user_name']) $search_results[$i]['name'] = $lang['unknown_user'];
|
|
else $search_results[$i]['name'] = htmlspecialchars($row['user_name']);
|
|
}
|
|
else $search_results[$i]['name'] = htmlspecialchars($row['name']);
|
|
|
|
$search_results[$i]['subject'] = htmlspecialchars($row['subject']);
|
|
$search_results[$i]['timestamp'] = $row['timestamp'];
|
|
$search_results[$i]['no_text'] = $row['no_text'];
|
|
$search_results[$i]['formated_time'] = format_time($lang['time_format'],$row['timestamp']);
|
|
if (isset($categories[$row["category"]]) && $categories[$row['category']] != '') {
|
|
$search_results[$i]['category'] = $row["category"];
|
|
$search_results[$i]['category_name'] = $categories[$row["category"]];
|
|
}
|
|
if ($row['req_user'] !== NULL and is_numeric($row['req_user'])) {
|
|
$search_results[$i]['is_read'] = true;
|
|
} else {
|
|
$search_results[$i]['is_read'] = false;
|
|
}
|
|
$i++;
|
|
}
|
|
mysqli_free_result($result);
|
|
}
|
|
|
|
$smarty->assign('search_results_count', $search_results_count);
|
|
if (isset($search_results)) $smarty->assign('search_results', $search_results);
|
|
|
|
$smarty->assign('search', htmlspecialchars($_GET['search']));
|
|
$smarty->assign('search_encoded', urlencode($search));
|
|
$smarty->assign('p_category', $p_category);
|
|
$smarty->assign('method', $method);
|
|
$smarty->assign('subnav_location', 'subnav_search');
|
|
} else {
|
|
$smarty->assign('p_category', 0);
|
|
$smarty->assign('method', 'fulltext');
|
|
}
|
|
|
|
$smarty->assign('subtemplate', 'search.inc.tpl');
|
|
$template = 'main.tpl';
|
|
?>
|