$parent = isset($POST['cat' . ($i - 1)]) ? $POST['cat' . ($i - 1)] : 0;
$safe_box = true;
if ($parent == 0) {
$query = "SELECT left_id, right_id, level FROM " . $DBPrefix . "categories WHERE parent_id = -1";
if ($pc != 0) {
$safe_box = false;
}
$pc++;
} else {
$query = "SELECT left_id, right_id, level FROM " . $DBPrefix . "categories WHERE cat_id = " . intval($parent);
}
if ($safe_box) {
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
$cat = mysql_fetch_assoc($res);
$temparray = $catscontrol->get_children($cat['left_id'], $cat['right_id'], $cat['level']);
if (count($temparray) > 0) {
for ($j = 0; $j < count($temparray); $j++) {
$boxarray[$i][$temparray[$j]['cat_id']] = $temparray[$j]['cat_name'];
$boxarray[$i][$temparray[$j]['cat_id']] .= $temparray[$j]['left_id'] + 1 != $temparray[$j]['right_id'] ? ' ->' : '';
}
} else {
$SHOWBUTTON = true;
}
}
}
$boxes = count($boxarray);
for ($i = 0; $i < $boxes; $i++) {
$template->assign_block_vars('boxes', array('B_NOWLINE' => $i % 2 == 0 && $i > 0, 'I' => $i, 'PERCENT' => $boxes == 1 ? 100 : $boxes == 2 ? 50 : 33));
foreach ($boxarray[$i] as $k => $v) {
$template->assign_block_vars('boxes.cats', array('K' => $k, 'CATNAME' => $category_names[$k], 'SELECTED' => isset($POST['cat' . $i]) && $POST['cat' . $i] == $k ? ' selected' : ''));
$query = "SELECT left_id, right_id, level, cat_id FROM " . $DBPrefix . "categories WHERE parent_id = -1";
$params = array();
} else {
$parent = intval($_GET['parent']);
$query = "SELECT left_id, right_id, level FROM " . $DBPrefix . "categories WHERE cat_id = :parent_id";
$params = array();
$params[] = array(':parent_id', $parent, 'int');
}
$db->query($query, $params);
$parent_node = $db->result();
if (!isset($_GET['parent'])) {
$parent = $parent_node['cat_id'];
}
$crumb_string = '';
if ($parent != 0) {
$crumbs = $catscontrol->get_bread_crumbs($parent_node['left_id'], $parent_node['right_id']);
for ($i = 0; $i < count($crumbs); $i++) {
if ($i > 0) {
$crumb_string .= ' > ';
}
$crumb_string .= '<a href="categories.php?parent=' . $crumbs[$i]['cat_id'] . '">' . $crumbs[$i]['cat_name'] . '</a>';
}
}
$children = $catscontrol->get_children($parent_node['left_id'], $parent_node['right_id'], $parent_node['level']);
for ($i = 0; $i < count($children); $i++) {
$child = $children[$i];
$template->assign_block_vars('cats', array('CAT_ID' => $child['cat_id'], 'CAT_NAME' => $system->uncleanvars($child['cat_name']), 'CAT_COLOUR' => $child['cat_colour'], 'CAT_IMAGE' => $child['cat_image'], 'B_SUBCATS' => $child['left_id'] != $child['right_id'] - 1, 'B_AUCTIONS' => $child['counter'] > 0));
}
$template->assign_vars(array('ERROR' => isset($ERR) ? $ERR : '', 'SITEURL' => $system->SETTINGS['siteurl'], 'CRUMBS' => $crumb_string, 'PARENT' => $parent));
$template->set_filenames(array('body' => 'categories.tpl'));
$template->display('body');
