$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'])) { if ('manual' == $_POST['order_type']) { asort($_POST['catOrd'], SORT_NUMERIC); save_categories_order(array_keys($_POST['catOrd'])); array_push( $page['infos'], l10n('Categories manual order was saved') ); } else { $query = ' SELECT id FROM '.CATEGORIES_TABLE.' WHERE id_uppercat '. (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).' ;'; $category_ids = array_from_query($query, 'id'); if (isset($_POST['recursive'])) { $category_ids = get_subcat_ids($category_ids); } $categories = array(); $names = array(); $id_uppercats = array(); $query = ' SELECT id, name, id_uppercat FROM '.CATEGORIES_TABLE.' WHERE id IN ('.implode(',', $category_ids).') ;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { array_push( $categories, array( 'id' => $row['id'], 'id_uppercat' => $row['id_uppercat'], ) ); array_push( $names, $row['name'] ); } array_multisort( $names, SORT_REGULAR, 'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC, $categories ); save_categories_order($categories); array_push( $page['infos'], l10n('Categories automatically sorted') ); } } // +-----------------------------------------------------------------------+ // | 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); } trigger_action('loc_end_cat_list'); // +-----------------------------------------------------------------------+ // | sending html code | // +-----------------------------------------------------------------------+ $template->assign_var_from_handle('ADMIN_CONTENT', 'categories'); ?>