[Andreas]

!!! Warning !!!

This code is UNTESTED. Use it at your own risk.
I strongly recommend NOT to use it in a production environment.

PHP Code:

<?php
    require_once('./global.php');
    require_once('./includes/adminfunctions.php');
    $displayorder=1;
    $forums = $DB_site->query("SELECT forumid FROM " . TABLE_PREFIX . "forum WHERE displayorder!=0 ORDER by title ASC");
    while ($forum = $DB_site->fetch_array($forums))
    {
        $DB_site->query("UPDATE " . TABLE_PREFIX . "forum SET displayorder = $displayorder WHERE forumid=$forum[forumid]");
        $displayorder++;
    }
    unset($forumarraycache, $forumcache);
    build_forum_permissions();
        echo('Forums reordered');
?>