require('scripts/config.php') ?>
$search = $_REQUEST['search'];
$section_type = $_REQUEST['section_type'];
$section_name = ucwords($_REQUEST['section_name']);
$category_id = $_REQUEST['category_id'];
$pageno = $_REQUEST['pageno'];
$q = $_REQUEST['q'];
if(isset($category_id) && $category_id != '')
{
$category_sql = "AND items.category_id = $category_id";
$category_name_sql = mysql_query("SELECT category_name FROM categories WHERE active = 1 AND category_id = $category_id");
$category_name_result = mysql_fetch_assoc($category_name_sql);
$category_link = "/$category_id/".strtolower(str_ireplace($replace_chars, "-", $category_name_result['category_name']));
}
if($search == 1) {
if(isset($_REQUEST['search_type'])) {
$search_type_sql = ' AND (';
for($i = 0; $i < count($_REQUEST['search_type']); $i++) {
$search_type_sql .= ($i != 0 ? ' OR ' : '').'items.type = '.$_REQUEST['search_type'][$i];
}
$search_type_sql .= ')';
}
if(isset($_REQUEST['search_categories'])) {
$search_categories_sql = ' AND (';
for($i = 0; $i < count($_REQUEST['search_categories']); $i++) {
$search_categories_sql .= ($i != 0 ? ' OR ' : '').'items.category_id = '.$_REQUEST['search_categories'][$i];
}
$search_categories_sql .= ')';
}
$item_sql_count = "SELECT COUNT(*) FROM items, items_tags, tags WHERE items.active = 1 AND items_tags.item_id = items.item_id AND tags.tag_id = items_tags.tag_id AND tags.tag LIKE '%$q%' $search_type_sql $search_categories_sql";
$item_sql = "SELECT * FROM items INNER JOIN categories ON categories.category_id = items.category_id INNER JOIN images ON items.ref_image2 = images.image_id INNER JOIN items_tags ON items_tags.item_id = items.item_id INNER JOIN tags ON tags.tag_id = items_tags.tag_id WHERE items.active =1 AND tags.tag LIKE '%$q%' GROUP BY items.item_id $search_type_sql $search_categories_sql";
} else {
$item_sql_count = "SELECT COUNT(*) FROM items WHERE items.active = 1 AND items.type = $section_type $category_sql";
$item_sql = "SELECT * FROM items INNER JOIN categories ON categories.category_id = items.category_id INNER JOIN images ON items.ref_image2 = images.image_id WHERE items.active = 1 AND items.type = $section_type $category_sql";
$section_categories = mysql_query("SELECT categories.* FROM categories, items WHERE categories.category_id = items.category_id AND categories.active = 1 AND items.type = $section_type GROUP BY categories.category_id ORDER BY categories.category_name ASC");
}
if (!isset($pageno) || $pageno == '') {
$pageno = 1;
}
$item_count_sql = mysql_query($item_sql_count);
$item_count_result = mysql_fetch_row($item_count_sql);
$item_count = $item_count_result[0];
$items_per_page = 4;
$last_page = ceil($item_count/$items_per_page);
$pageno = (int)$pageno;
if ($pageno > $last_page) {
$pageno = $last_page;
}
if ($pageno < 1) {
$pageno = 1;
}
$limit = 'LIMIT ' .($pageno - 1) * $items_per_page .',' .$items_per_page;
$section_items = mysql_query($item_sql." ".$limit);
?>
require('sections/header.html') ?>
if ($search != 1) { ?>
if($item_count > 0) {?>
while ($result = mysql_fetch_assoc($section_items)) {
$section_name = $result['type'] == 1 ? 'backgrounds' : 'layouts';
?>
}
?>
} else {?>
Search returned 0 results, please try again or broaden your search:
include('sections/advanced-search.html')?>
}?>
if ($search == 1) {
$page_link = "search";
$search_query = "/?q=$q";
} else {
$page_link = strtolower($section_name);
}
if ($pageno == 1) {
echo " First Prev ";
} else {
echo "
First ";
$prev_page = $pageno-1;
echo "
Prev ";
}
echo " ( Page $pageno of $last_page ) ";
if ($pageno == $last_page) {
echo " Next Last ";
} else {
$next_page = $pageno+1;
echo "
Next ";
echo "
Last ";
}
?>