browse.php

<?php
/***************************************************************************
 *   copyright				: (C) 2008 - 2014 WeBid
 *   site					: http://www.webidsupport.com/
 ***************************************************************************/

/***************************************************************************
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version. Although none of the code may be
 *   sold. If you have been sold this script, get a refund.
 ***************************************************************************/

include 'common.php';
include $include_path . 'dates.inc.php';
include $main_path . 'language/' . $language . '/categories.inc.php';
$catscontrol = new MPTTcategories();

// Get parameters from the URL
$id = (isset($_GET['id'])) ? intval($_GET['id']) : 0;
$_SESSION['browse_id'] = $id;
$all_items = true;

$params = array();
if ($id != 0)
{
	$query = "SELECT right_id, left_id FROM " . $DBPrefix . "categories WHERE cat_id = :cat_id";
	$params[] = array(':cat_id', $id, 'int');
}
else
{
	$query = "SELECT right_id, left_id, cat_id FROM " . $DBPrefix . "categories WHERE left_id = 1";
}

$db->query($query, $params);
$parent_node = $db->result();
$id = (isset($parent_node['cat_id'])) ? $parent_node['cat_id'] : $id;
$catalist = '';
if ($parent_node['left_id'] != 1)
{
	$children = $catscontrol->get_children_list($parent_node['left_id'], $parent_node['right_id']);
	$childarray = array($id);
	foreach ($children as $k => $v)
	{
		$childarray[] = $v['cat_id'];
	}
	$catalist = '(';
	$catalist .= implode(',', $childarray);
	$catalist .= ')';
	$all_items = false;
}

$NOW = time();

/*
specified category number
look into table - and if we don't have such category - redirect to full list
*/
$query = "SELECT * FROM " . $DBPrefix . "categories WHERE cat_id = :cat_id";
$params = array();
$params[] = array(':cat_id', $id, 'int');
$db->query($query, $params);
$category = $db->result();

if ($db->numrows() == 0)
{
	// redirect to global categories list
	header ('location: browse.php?id=0');
	exit;
}
else
{
	// Retrieve the translated category name
	$par_id = $category['parent_id'];
	$TPL_categories_string = '';
	$crumbs = $catscontrol->get_bread_crumbs($category['left_id'], $category['right_id']);
	for ($i = 0; $i < count($crumbs); $i++)
	{
		if ($crumbs[$i]['cat_id'] > 0)
		{
			if ($i > 0)
			{
				$TPL_categories_string .= ' &gt; ';
			}
			$TPL_categories_string .= '<a href="' . $system->SETTINGS['siteurl'] . 'browse.php?id=' . $crumbs[$i]['cat_id'] . '">' . $category_names[$crumbs[$i]['cat_id']] . '</a>';
		}
	}

	// get list of subcategories of this category
	$subcat_count = 0;
	$query = "SELECT * FROM " . $DBPrefix . "categories WHERE parent_id = :parent_id ORDER BY cat_name";
	$params = array();
	$params[] = array(':parent_id', $id, 'int');
	$db->query($query, $params);
	$need_to_continue = 1;
	$cycle = 1;

	$TPL_main_value = '';
	while ($row = $db->fetch())
	{
		++$subcat_count;
		if ($cycle == 1)
		{
			$TPL_main_value .= '<tr align="left">' . "\n";
		}
		$sub_counter = $row['sub_counter'];
		$cat_counter = $row['counter'];
		if ($sub_counter != 0)
		{
			$count_string = ' (' . $sub_counter . ')';
		}
		else
		{
			if ($cat_counter != 0)
			{
				$count_string = ' (' . $cat_counter . ')';
			}
			else
			{
				$count_string = '';
			}
		}
		if ($row['cat_colour'] != '')
		{
			$BG = 'bgcolor=' . $row['cat_colour'];
		}
		else
		{
			$BG = '';
		}
		// Retrieve the translated category name
		$row['cat_name'] = $category_names[$row['cat_id']];
		$catimage = (!empty($row['cat_image'])) ? '<img src="' . $row['cat_image'] . '" border=0>' : '';
		$TPL_main_value .= "\t" . '<td ' . $BG . ' WIDTH="33%">' . $catimage . '<a href="' . $system->SETTINGS['siteurl'] . 'browse.php?id=' . $row['cat_id'] . '">' . $row['cat_name'] . $count_string . '</a></td>' . "\n";

		++$cycle;
		if ($cycle == 4)
		{
			$cycle = 1;
			$TPL_main_value .= '</tr>' . "\n";
		}
	}

	if ($cycle >= 2 && $cycle <= 3)
	{
		while ($cycle < 4)
		{
			$TPL_main_value .= '	<td width="33%">&nbsp;</td>' . "\n";
			++$cycle;
		}
		$TPL_main_value .= '</tr>' . "\n";
	}

	$insql = "(category IN " . $catalist;
	if ($system->SETTINGS['extra_cat'] == 'y')
	{
		$insql .= " OR secondcat IN " . $catalist;
	}
	$insql = (!$all_items) ? $insql . ") AND" : '';

	// get total number of records
	$query = "SELECT count(*) as COUNT FROM " . $DBPrefix . "auctions
			WHERE " . $insql . " starts <= :time
			AND closed = 0
			AND suspended = 0";
	$params = array();
	$params[] = array(':time', $NOW, 'int');
	if (!empty($_POST['catkeyword']))
	{
		$query .= " AND title LIKE :title";
		$params[] = array(':title', '%' . $system->cleanvars($_POST['catkeyword']) . '%', 'str');
	}
	$db->query($query, $params);
	$TOTALAUCTIONS = $db->result('COUNT');

	// Handle pagination
	if (!isset($_GET['PAGE']) || $_GET['PAGE'] == 1)
	{
		$OFFSET = 0;
		$PAGE = 1;
	}
	else
	{
		$PAGE = $_REQUEST['PAGE'];
		$OFFSET = ($PAGE - 1) * $system->SETTINGS['perpage'];
	}
	$PAGES = ceil($TOTALAUCTIONS / $system->SETTINGS['perpage']);

	$query = "SELECT * FROM " . $DBPrefix . "auctions
			WHERE " . $insql . " starts <= :time
			AND closed = 0
			AND suspended = 0";
	$params = array();
	$params[] = array(':time', $NOW, 'int');
	if (!empty($_POST['catkeyword']))
	{
		$query .= " AND title LIKE :title";
		$params[] = array(':title', '%' . $system->cleanvars($_POST['catkeyword']) . '%', 'str');
	}
	$query .= " ORDER BY ends ASC LIMIT :offset, :perpage";
	$params[] = array(':offset', $OFFSET, 'int');
	$params[] = array(':perpage', $system->SETTINGS['perpage'], 'int');

	// get featured items
	$query_feat = "SELECT * FROM " . $DBPrefix . "auctions
			WHERE " . $insql . " starts <= :time
			AND closed = 0
			AND suspended = 0
			AND featured = 'y'";
	$params_feat = array();
	$params_feat[] = array(':time', $NOW, 'int');
	if (!empty($_POST['catkeyword']))
	{
		$query_feat .= " AND title LIKE :title";
		$params_feat[] = array(':title', '%' . $system->cleanvars($_POST['catkeyword']) . '%', 'str');
	}
	$query_feat .= " ORDER BY ends ASC LIMIT :offset, 5";
	$params_feat[] = array(':offset', (($PAGE - 1) * 5), 'int');

	include $include_path . 'browseitems.inc.php';
	browseItems($query, $params, $query_feat, $params_feat, $TOTALAUCTIONS, 'browse.php', 'id=' . $id);

	$template->assign_vars(array(
			'ID' => $id,
			'TOP_HTML' => $TPL_main_value,
			'CAT_STRING' => $TPL_categories_string,
			'NUM_AUCTIONS' => $TOTALAUCTIONS
			));
}

include 'header.php';
$template->set_filenames(array(
		'body' => 'browsecats.tpl'
		));
$template->display('body');
include 'footer.php';
?>