$id, 'rank' => ++$current_rank)); } $fields = array('primary' => array('id'), 'update' => array('rank')); mass_updates(CATEGORIES_TABLE, $fields, $datas); update_global_rank(); } // +-----------------------------------------------------------------------+ // | initialization | // +-----------------------------------------------------------------------+ check_input_parameter('parent_id', $_GET, false, PATTERN_ID); $categories = array(); $base_url = get_root_url().'admin.php?page=cat_list'; $navigation = ''; $navigation.= l10n('Home'); $navigation.= ''; // +-----------------------------------------------------------------------+ // | virtual categories management | // +-----------------------------------------------------------------------+ // request to delete a virtual category / not for an adviser if (isset($_GET['delete']) and is_numeric($_GET['delete']) and !is_adviser()) { delete_categories(array($_GET['delete'])); array_push($page['infos'], l10n('Virtual category deleted')); update_global_rank(); redirect(get_root_url().'admin.php?page=cat_list'); } // request to add a virtual category else if (isset($_POST['submitAdd'])) { $output_create = create_virtual_category( $_POST['virtual_name'], @$_GET['parent_id'] ); if (isset($output_create['error'])) { array_push($page['errors'], $output_create['error']); } else { array_push($page['infos'], $output_create['info']); } } // save manual category ordering else if (isset($_POST['submitOrder'])) { asort($_POST['catOrd'], SORT_NUMERIC); save_categories_order(array_keys($_POST['catOrd'])); array_push( $page['infos'], l10n('Categories manual order was saved') ); } // sort categories alpha-numerically else if (isset($_POST['submitOrderAlphaNum'])) { $query = ' SELECT id, name FROM '.CATEGORIES_TABLE.' WHERE id_uppercat '. (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).' ;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { $categories[ $row['id'] ] = strtolower($row['name']); } asort($categories, SORT_REGULAR); save_categories_order(array_keys($categories)); array_push( $page['infos'], l10n('Categories ordered alphanumerically') ); } // sort categories alpha-numerically reverse else if (isset($_POST['submitOrderAlphaNumReverse'])) { $query = ' SELECT id, name FROM '.CATEGORIES_TABLE.' WHERE id_uppercat '. (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).' ;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { $categories[ $row['id'] ] = strtolower($row['name']); } arsort($categories, SORT_REGULAR); save_categories_order(array_keys($categories)); array_push( $page['infos'], l10n('Categories ordered alphanumerically reverse') ); } // +-----------------------------------------------------------------------+ // | Navigation path | // +-----------------------------------------------------------------------+ if (isset($_GET['parent_id'])) { $navigation.= $conf['level_separator']; $navigation.= get_cat_display_name_from_id( $_GET['parent_id'], $base_url.'&parent_id=', false ); } // +-----------------------------------------------------------------------+ // | template initialization | // +-----------------------------------------------------------------------+ $template->set_filename('categories', 'cat_list.tpl'); $form_action = PHPWG_ROOT_PATH.'admin.php?page=cat_list'; if (isset($_GET['parent_id'])) { $form_action.= '&parent_id='.$_GET['parent_id']; } $template->assign(array( 'CATEGORIES_NAV'=>$navigation, 'F_ACTION'=>$form_action, 'PWG_TOKEN' => get_pwg_token(), )); // +-----------------------------------------------------------------------+ // | Categories display | // +-----------------------------------------------------------------------+ $categories = array(); $query = ' SELECT id, name, permalink, dir, rank, status FROM '.CATEGORIES_TABLE; if (!isset($_GET['parent_id'])) { $query.= ' WHERE id_uppercat IS NULL'; } else { $query.= ' WHERE id_uppercat = '.$_GET['parent_id']; } $query.= ' ORDER BY rank ASC ;'; $categories = hash_from_query($query, 'id'); // get the categories containing images directly $categories_with_images = array(); if ( count($categories) ) { $query = ' SELECT DISTINCT category_id FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id IN ('.implode(',', array_keys($categories)).')'; $categories_with_images = array_flip( array_from_query($query, 'category_id') ); } $template->assign('categories', array()); $base_url = get_root_url().'admin.php?page='; foreach ($categories as $category) { $cat_list_url = $base_url.'cat_list'; $self_url = $cat_list_url; if (isset($_GET['parent_id'])) { $self_url.= '&parent_id='.$_GET['parent_id']; } $tpl_cat = array( 'NAME' => trigger_event( 'render_category_name', $category['name'], 'admin_cat_list' ), 'ID' => $category['id'], 'RANK' => $category['rank']*10, 'U_JUMPTO' => make_index_url( array( 'category' => $category ) ), 'U_CHILDREN' => $cat_list_url.'&parent_id='.$category['id'], 'U_EDIT' => $base_url.'cat_modify&cat_id='.$category['id'], 'IS_VIRTUAL' => empty($category['dir']) ); if (empty($category['dir'])) { $tpl_cat['U_DELETE'] = $self_url.'&delete='.$category['id']; $tpl_cat['U_DELETE'].= '&pwg_token='.get_pwg_token(); } if ( array_key_exists($category['id'], $categories_with_images) ) { $tpl_cat['U_MANAGE_ELEMENTS']= $base_url.'element_set&cat='.$category['id']; } if ('private' == $category['status']) { $tpl_cat['U_MANAGE_PERMISSIONS']= $base_url.'cat_perm&cat='.$category['id']; } $template->append('categories', $tpl_cat); } // +-----------------------------------------------------------------------+ // | sending html code | // +-----------------------------------------------------------------------+ $template->assign_var_from_handle('ADMIN_CONTENT', 'categories'); ?>