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