check_mysql($res, $query, __LINE__, __FILE__);
$parent_node = mysql_fetch_assoc($res);
$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 .= ')';
}
$NOW = time();
/*
specified category number
look into table - and if we don't have such category - redirect to full list
*/
$bool = false;
if ($id != 0)
{
$query = "SELECT * FROM " . $DBPrefix . "categories WHERE cat_id = " . $id;
$result = mysql_query($query);
$system->check_mysql($result, $query, __LINE__, __FILE__);
$category = mysql_fetch_array($result);
$bool = (mysql_num_rows($result) == 0);
}
if ($bool)
{
// redirect to global categories list
header ('location: browse.php?id=0');
exit;
}
else
{
// Retrieve the translated category name
if ($id == 0)
{
$TPL_categories_string = $MSG['2__0027'];
$par_id = 0;
}
else
{
$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 .= ' > ';
}
$TPL_categories_string .= '' . $category_names[$crumbs[$i]['cat_id']] . '';
}
}
# This is to fix the breadcrumbs where subcategories are not being shown.
$i = $i-1;
if ($category['cat_id'] != 1 && $category['cat_name'] != $category_names[$crumbs[$i]['cat_id']])
$TPL_categories_string .= '' . $category['cat_name'] . '';
}
// get list of subcategories of this category
$subcat_count = 0;
$query = "SELECT * FROM " . $DBPrefix . "categories WHERE parent_id = " . $id . " ORDER BY cat_name";
$result = mysql_query($query);
$system->check_mysql($result, $query, __LINE__, __FILE__);
$need_to_continue = 1;
$cycle = 1;
$TPL_main_value = '';
while ($row = mysql_fetch_array($result))
{
++$subcat_count;
if ($cycle == 1)
{
$TPL_main_value .= '' . "\n";
}
$sub_counter = (int)$row['sub_counter'];
$cat_counter = (int)$row['counter'];
/* // Disabled because not working properly. - SC
if ($sub_counter != 0)
{
$count_string = ' (' . $sub_counter . ')';
}
else
{
if ($cat_counter != 0)
{
$count_string = ' (' . $cat_counter . ')';
}
else
{
$count_string = '';
}
}*/
// For determining the actual number of open and available auctioned items per category. - SC
$queryCatCount = 'SELECT COUNT(*) AS catcount FROM auctions WHERE category = ' . $row['cat_id'] . ' AND closed = 0 AND starts < ' . time();
$resultCatCount = mysql_query($queryCatCount);
$catCount = mysql_result($resultCatCount, 0);
$count_string = ($catCount > 0) ? '(' . $catCount . ')' : '';
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'])) ? '
' : '';
$TPL_main_value .= "\t" . '' . $catimage . '' . $row['cat_name'] . $count_string . ' | ' . "\n";
++$cycle;
if ($cycle == 4)
{
$cycle = 1;
$TPL_main_value .= '
' . "\n";
}
}
if ($cycle >= 2 && $cycle <= 3)
{
while ($cycle < 4)
{
$TPL_main_value .= ' | ' . "\n";
++$cycle;
}
$TPL_main_value .= '' . "\n";
}
// determine limits for SQL query
$lines = 30;
$page = (isset($_GET['page'])) ? $_GET['page'] : 1;
$left_limit = ($page - 1) * $lines;
// retrieve records corresponding to passed page number
$page = (int)$page;
if ($page == 0) $page = 1;
$lines = (int)$lines;
if ($lines == 0) $lines = 50;
$insql = ($id != 0) ? "category IN " . $catalist . " AND" : '';
// get total number of records
$query = "SELECT count(*) as count FROM " . $DBPrefix . "auctions
WHERE " . $insql . " starts <= " . $NOW . "
AND closed = 0
AND suspended = 0";
if (!empty($_POST['catkeyword']))
{
$query .= " AND title like '%" . $system->cleanvars($_POST['catkeyword']) . "%'";
}
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
$hash = mysql_fetch_assoc($res);
$TOTALAUCTIONS = $hash['count'];
// Handle pagination
if (!isset($_GET['PAGE']) || $_GET['PAGE'] == 1)
{
$OFFSET = 0;
$PAGE = 1;
}
else
{
$PAGE = $_REQUEST['PAGE'];
$OFFSET = ($PAGE - 1) * $LIMIT;
}
$PAGES = ceil($TOTALAUCTIONS / $LIMIT);
$query = "SELECT * FROM " . $DBPrefix . "auctions
WHERE " . $insql . " starts <= " . $NOW . "
AND closed = 0
AND suspended = 0";
if (!empty($_POST['catkeyword']))
{
$query .= " AND title LIKE '%" . $system->cleanvars($_POST['catkeyword']) . "%'";
}
$query .= " ORDER BY ends ASC LIMIT " . intval($OFFSET) . "," . intval($LIMIT);
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
// get featured items
$query = "SELECT * FROM " . $DBPrefix . "auctions
WHERE " . $insql . " starts <= " . $NOW . "
AND closed = 0
AND suspended = 0
AND featured = 'y'";
if (!empty($_POST['catkeyword']))
{
$query .= " AND title LIKE '%" . $system->cleanvars($_POST['catkeyword']) . "%'";
}
$query .= " ORDER BY ends ASC LIMIT " . intval(($PAGE - 1) * 5) . ", 5";
$feat_res = mysql_query($query);
$system->check_mysql($feat_res, $query, __LINE__, __FILE__);
include $include_path . 'browseitems.inc.php';
browseItems($res, $feat_res, 'browse.php');
$template->assign_vars(array(
'TOP_HTML' => $TPL_main_value,
'CAT_STRING' => $TPL_categories_string
));
}
include 'header.php';
$template->set_filenames(array(
'body' => 'browsecats.tpl'
));
$template->display('body');
include 'footer.php';
?>