Changeset 13282 for trunk/admin/cat_list.php
- Timestamp:
- Feb 20, 2012, 8:28:43 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/cat_list.php
r13025 r13282 101 101 102 102 // +-----------------------------------------------------------------------+ 103 // | tabs | 104 // +-----------------------------------------------------------------------+ 105 106 $page['tab'] = 'list'; 107 include(PHPWG_ROOT_PATH.'admin/include/albums_tab.inc.php'); 108 109 // +-----------------------------------------------------------------------+ 103 110 // | virtual categories management | 104 111 // +-----------------------------------------------------------------------+ … … 135 142 } 136 143 // save manual category ordering 137 else if (isset($_POST['submitOrder'])) 138 { 139 if ('manual' == $_POST['order_type']) 140 { 141 asort($_POST['catOrd'], SORT_NUMERIC); 142 save_categories_order(array_keys($_POST['catOrd'])); 143 144 array_push( 145 $page['infos'], 146 l10n('Album manual order was saved') 147 ); 148 } 149 else 150 { 151 $query = ' 144 else if (isset($_POST['submitManualOrder'])) 145 { 146 asort($_POST['catOrd'], SORT_NUMERIC); 147 save_categories_order(array_keys($_POST['catOrd'])); 148 149 array_push( 150 $page['infos'], 151 l10n('Album manual order was saved') 152 ); 153 } 154 else if (isset($_POST['submitAutoOrder'])) 155 { 156 $query = ' 152 157 SELECT id 153 158 FROM '.CATEGORIES_TABLE.' … … 155 160 (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).' 156 161 ;'; 157 $category_ids = array_from_query($query, 'id'); 158 159 if (isset($_POST['recursive'])) 160 { 161 $category_ids = get_subcat_ids($category_ids); 162 } 163 164 $categories = array(); 165 $names = array(); 166 $id_uppercats = array(); 162 $category_ids = array_from_query($query, 'id'); 163 164 if (isset($_POST['recursive'])) 165 { 166 $category_ids = get_subcat_ids($category_ids); 167 } 167 168 168 $query = ' 169 $categories = array(); 170 $names = array(); 171 $id_uppercats = array(); 172 173 $query = ' 169 174 SELECT id, name, id_uppercat 170 175 FROM '.CATEGORIES_TABLE.' 171 176 WHERE id IN ('.implode(',', $category_ids).') 172 177 ;'; 173 $result = pwg_query($query); 174 while ($row = pwg_db_fetch_assoc($result)) 175 { 176 array_push( 177 $categories, 178 array( 179 'id' => $row['id'], 180 'id_uppercat' => $row['id_uppercat'], 181 ) 182 ); 183 array_push( 184 $names, 185 $row['name'] 186 ); 187 } 188 189 array_multisort( 178 $result = pwg_query($query); 179 while ($row = pwg_db_fetch_assoc($result)) 180 { 181 array_push( 182 $categories, 183 array( 184 'id' => $row['id'], 185 'id_uppercat' => $row['id_uppercat'], 186 ) 187 ); 188 array_push( 190 189 $names, 191 SORT_REGULAR, 192 'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC, 193 $categories 190 $row['name'] 194 191 ); 195 save_categories_order($categories); 196 197 array_push( 198 $page['infos'], 199 l10n('Albums automatically sorted') 200 ); 201 } 192 } 193 194 array_multisort( 195 $names, 196 SORT_REGULAR, 197 'asc' == $_POST['ascdesc'] ? SORT_ASC : SORT_DESC, 198 $categories 199 ); 200 save_categories_order($categories); 201 202 array_push( 203 $page['infos'], 204 l10n('Albums automatically sorted') 205 ); 202 206 } 203 207
Note: See TracChangeset
for help on using the changeset viewer.