Changeset 394 for trunk/admin/update.php

Timestamp:

Mar 26, 2004, 6:08:09 PM (20 years ago)

Author:

gweltas

Message:

• Template migration
• Admin Control Panel migration
• Category management

File:

• trunk/admin/update.php (modified) (3 diffs)

trunk/admin/update.php

@@ -28 +28 @@
 include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php' );
 //------------------------------------------------------------------- functions
+function ordering( $id_uppercat )
+{
+  $rank = 1;
+                
+  $query = 'SELECT id';
+  $query.= ' FROM '.CATEGORIES_TABLE;
+  if ( !is_numeric( $id_uppercat ) )
+  {
+    $query.= ' WHERE id_uppercat IS NULL';
+  }
+  else
+  {
+    $query.= ' WHERE id_uppercat = '.$id_uppercat;
+  }
+  $query.= ' ORDER BY rank ASC, dir ASC';
+  $query.= ';';
+  $result = mysql_query( $query );
+  while ( $row = mysql_fetch_array( $result ) )
+  {
+    $query = 'UPDATE '.CATEGORIES_TABLE;
+    $query.= ' SET rank = '.$rank;
+    $query.= ' WHERE id = '.$row['id'];
+    $query.= ';';
+    mysql_query( $query );
+    $rank++;
+    ordering( $row['id'] );
+  }
+}
+
 function insert_local_category( $id_uppercat )
 {
@@ -678 +707 @@
   ));
   
-$tpl = array('remote_site');
 //-------------------------------------------- introduction : choices of update
 // Display choice if "update" var is not specified
@@ -733 +761 @@
   $start = get_moment();
   update_category( 'all' );
+  ordering('NULL');
   $end = get_moment();
   echo get_elapsed_time( $start, $end ).' for update_category( all )<br />';