From 1ab32cccb7eaf8f5707c06895179e31743dceae9 Mon Sep 17 00:00:00 2001 From: plegall Date: Sun, 5 Dec 2004 22:47:46 +0000 Subject: - ordering function moved from admin/update to admin/include/function - remote_site uses ordering and update_global_rank git-svn-id: http://piwigo.org/svn/trunk@638 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/update.php | 37 ------------------------------------- 1 file changed, 37 deletions(-) (limited to 'admin/update.php') diff --git a/admin/update.php b/admin/update.php index aca5307ea..e540065e2 100644 --- a/admin/update.php +++ b/admin/update.php @@ -36,43 +36,6 @@ define('CURRENT_DATE', date('Y-m-d')); // | functions | // +-----------------------------------------------------------------------+ -/** - * order categories (update categories.rank and global_rank database fields) - * - * the purpose of this function is to give a rank for all categories - * (insides its sub-category), even the newer that have none at te - * beginning. For this, ordering function selects all categories ordered by - * rank ASC then name ASC for each uppercat. - * - * @returns void - */ -function ordering() -{ - $current_rank = 0; - $current_uppercat = ''; - - $query = ' -SELECT id, if(id_uppercat is null,\'\',id_uppercat) AS id_uppercat - FROM '.CATEGORIES_TABLE.' - ORDER BY id_uppercat,rank,name -;'; - $result = pwg_query($query); - $datas = array(); - while ($row = mysql_fetch_array($result)) - { - if ($row['id_uppercat'] != $current_uppercat) - { - $current_rank = 0; - $current_uppercat = $row['id_uppercat']; - } - $data = array('id' => $row['id'], 'rank' => ++$current_rank); - array_push($datas, $data); - } - - $fields = array('primary' => array('id'), 'update' => array('rank')); - mass_updates(CATEGORIES_TABLE, $fields, $datas); -} - function insert_local_category($id_uppercat) { global $conf, $page, $user, $lang, $counts; -- cgit v1.2.3