$id, 'rank' => ++$current_rank)); } $fields = array('primary' => array('id'), 'update' => array('rank')); mass_updates(CATEGORIES_TABLE, $fields, $datas); update_global_rank(@$_GET['parent_id']); } // +-----------------------------------------------------------------------+ // | initialization | // +-----------------------------------------------------------------------+ $categories = array(); $base_url = PHPWG_ROOT_PATH.'admin.php?page=cat_list'; $navigation = ''; $navigation.= $lang['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'], $lang['cat_virtual_deleted']); ordering(); update_global_rank(); } // 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 = mysql_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') ); } // +-----------------------------------------------------------------------+ // | 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_filenames(array('categories'=>'admin/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_vars(array( 'CATEGORIES_NAV'=>$navigation, 'F_ACTION'=>$form_action, 'L_ADD_VIRTUAL'=>$lang['cat_add'], 'L_SUBMIT'=>$lang['submit'], 'L_STORAGE'=>$lang['storage'], 'L_NB_IMG'=>$lang['pictures'], 'L_MOVE_UP'=>$lang['up'], 'L_EDIT'=>$lang['edit'], 'L_DELETE'=>$lang['delete'], )); $tpl = array('cat_first','cat_last'); // +-----------------------------------------------------------------------+ // | Categories display | // +-----------------------------------------------------------------------+ $categories = array(); $query = ' SELECT id, name, permalink, dir, rank, nb_images, 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 ;'; $result = pwg_query($query); while ($row = mysql_fetch_array($result)) { $categories[$row['id']] = $row; // by default, let's consider there is no sub-categories. This will be // calculated after. $categories[$row['id']]['nb_subcats'] = 0; } if (count($categories) > 0) { $query = ' SELECT id_uppercat, COUNT(*) AS nb_subcats FROM '. CATEGORIES_TABLE.' WHERE id_uppercat IN ('.implode(',', array_keys($categories)).') GROUP BY id_uppercat ;'; $result = pwg_query($query); while ($row = mysql_fetch_array($result)) { $categories[$row['id_uppercat']]['nb_subcats'] = $row['nb_subcats']; } $template->assign_block_vars('categories', array()); } foreach ($categories as $category) { // TODO : not used anymore ? //$images_folder = PHPWG_ROOT_PATH.'template/'; //$images_folder.= $user['template'].'/admin/images'; $base_url = PHPWG_ROOT_PATH.'admin.php?page='; $cat_list_url = $base_url.'cat_list'; $self_url = $cat_list_url; if (isset($_GET['parent_id'])) { $self_url.= '&parent_id='.$_GET['parent_id']; } $template->assign_block_vars( 'categories.category', array( 'NAME' => $category['name'], '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'], ) ); if (empty($category['dir'])) { $template->assign_block_vars( 'categories.category.delete', array( 'URL'=>$self_url.'&delete='.$category['id'] ) ); $template->assign_block_vars( 'categories.category.virtual', array( 'CLASS' => 'virtual_cat', ) ); } if ($category['nb_images'] > 0) { $template->assign_block_vars( 'categories.category.elements', array( 'URL'=>$base_url.'element_set&cat='.$category['id'] ) ); } if ('private' == $category['status']) { $template->assign_block_vars( 'categories.category.permissions', array( 'URL'=>$base_url.'cat_perm&cat='.$category['id'] ) ); } } // Add a link to Page bottom only if needed (10 or more categories) if ( isset($category['rank']) and $category['rank'] > 9 ) { $template->assign_block_vars('eop_link', array('ICON'=>'Displayed')); } // +-----------------------------------------------------------------------+ // | sending html code | // +-----------------------------------------------------------------------+ $template->assign_var_from_handle('ADMIN_CONTENT', 'categories'); ?>