Random Child Forum Display Order ?

[Sidewindr]

I modified the code in vb2 to display child forums in a particular forum in a random order.

How can I do this in vb3 ??

[Sidewindr]

I did this previously by hacking the forumdisplay.php where the SQL query was done to retrieve the child forums. I cannot really find where in the vB3 code this is.. Can someone PLEASE help me?? *beg*

// display sub forums
$permissions = $getperms;
//Forum info
//// BEGIN MODIFICATION Random Forum display for Sponsor Forum
if ($forumid == "40") {
  $forums=$DB_site->query('SELECT * FROM forum WHERE active=1 ORDER BY RAND()');
} else {
  $forums=$DB_site->query('SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder,forumid');
}
//// END MODIFICATION Random Forum display for Sponsor Forum

[Sidewindr]

I managed to get it working .. with a minor hitch however.

I modified "includes/functions_forumlist.php" as below.
The problem I now have is for all of the childeren of forumid #40 I have to assign them display orders in order for them to become random. If they all have a display order of "1" then they list in order of the DB tables. Is it possible to get this to work without having to put incrementing display orders in for each of the childeren forums??

ORIGINAL CODE

        // do some sorting (instead of sorting with MySQL and causing a filesort)
        foreach($iforumcache AS $parentid => $devnull)
        {
                ksort($iforumcache["$parentid"]); // sort by display order
        }
        ksort($iforumcache); // sort by parentid (not actually sure if this is necessary)

NEW CODE

        // do some sorting (instead of sorting with MySQL and causing a filesort)
        foreach($iforumcache AS $parentid => $devnull)
        {
                if ($parentid == 40) {
                        srand ((float)microtime()*1000000);
                        shuffle($iforumcache["$parentid"]);
                } else {
                        ksort($iforumcache["$parentid"]); // sort by display order
                }
        }
        ksort($iforumcache); // sort by parentid (not actually sure if this is necessary)