<?php
/*
Plugin Name: Personal Plugin
Version: 1.0
Description: Personal Plugin
Plugin URI: http://piwigo.org
Author:
Author URI:
*/

add_event_handler('loc_begin_admin', 'sort_all_categories');
function sort_all_categories()
{
  if (!isset($_GET['page']) or 'maintenance' != $_GET['page'])
  {
    return null;
  }

  if (!isset($_GET['action']) or 'categories' != $_GET['action'])
  {
    return null;
  }

  $categories = array();
  $names = array();

  $query = '
SELECT id, name, id_uppercat
  FROM '.CATEGORIES_TABLE.'
;';
  $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,
    SORT_DESC,
    $categories
  );

  $current_rank_for_id_uppercat = array();
  $current_rank = 0;
  
  $datas = array();
  foreach ($categories as $category)
  {
    if (is_array($category))
    {
      $id = $category['id'];
      $id_uppercat = $category['id_uppercat'];

      if (!isset($current_rank_for_id_uppercat[$id_uppercat]))
      {
        $current_rank_for_id_uppercat[$id_uppercat] = 0;
      }
      $current_rank = ++$current_rank_for_id_uppercat[$id_uppercat];
    }
    else
    {
      $id = $category;
      $current_rank++;
    }
    
    array_push($datas, array('id' => $id, 'rank' => $current_rank));
  }
  $fields = array('primary' => array('id'), 'update' => array('rank'));
  mass_updates(CATEGORIES_TABLE, $fields, $datas);
}

?>