<?php

/***************************************************************************

* copyright : (C) 2008 - 2013 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;

if ($id != 0)

{

$query = "SELECT right_id, left_id FROM " . $DBPrefix . "categories WHERE cat_id = " . $id;

}

else

{

$query = "SELECT right_id, left_id, cat_id FROM " . $DBPrefix . "categories WHERE left_id = 1";

}

$res = mysql_query($query);

$system->check_mysql($res, $query, __LINE__, __FILE__);

$parent_node = mysql_fetch_assoc($res);

$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 = " . $id;

$result = mysql_query($query);

$system->check_mysql($result, $query, __LINE__, __FILE__);

$category = mysql_fetch_assoc($result);

if (mysql_num_rows($result) == 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 = " . $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 .= '<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 <= " . $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__);

$TOTALAUCTIONS = mysql_result($res, 0);

// 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 <= " . $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) . "," . $system->SETTINGS['perpage'];

$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, $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';

?>