function MG_staticSortChildAlbum($startaid, $sql_order, $sql_sort_by)
{
global $MG_albums, $_TABLES;
$sql = "SELECT album_id,album_order FROM {$_TABLES['mg_albums']} WHERE album_parent=" . $startaid . " " . $sql_sort_by . $sql_order;
$order = 10;
$result = DB_query($sql);
$numRows = DB_numRows($result);
for ($x = 0; $x < $numRows; $x++) {
$row = DB_fetchArray($result);
$album_id[$x] = $row['album_id'];
$album_order[$x] = $order;
$order += 10;
}
$album_count = $numRows;
for ($x = 0; $x < $album_count; $x++) {
$sql = "UPDATE " . $_TABLES['mg_albums'] . " SET album_order=" . $album_order[$x] . " WHERE album_id=" . $album_id[$x];
$res = DB_query($sql);
}
if (!empty($MG_albums[$startaid]->children)) {
$children = $MG_albums[$startaid]->getChildren();
foreach ($children as $child) {
MG_staticSortChildAlbum($MG_albums[$child]->id, $sql_order, $sql_sort_by);
}
}
}
function MG_staticSortChildAlbum($startaid, $sql_order, $sql_sort_by)
{
global $_TABLES;
$sql = "SELECT album_id,album_order FROM {$_TABLES['mg_albums']} " . "WHERE album_parent=" . intval($startaid) . $sql_sort_by . $sql_order;
$order = 10;
$result = DB_query($sql);
$numRows = DB_numRows($result);
$album_id = array();
$album_order = array();
for ($x = 0; $x < $numRows; $x++) {
$row = DB_fetchArray($result);
$album_id[$x] = $row['album_id'];
$album_order[$x] = $order;
$order += 10;
}
$album_count = $numRows;
for ($x = 0; $x < $album_count; $x++) {
DB_change($_TABLES['mg_albums'], 'album_order', $album_order[$x], 'album_id', $album_id[$x]);
}
$album = new mgAlbum($startaid);
$children = $album->getChildren();
foreach ($children as $child) {
MG_staticSortChildAlbum($child, $sql_order, $sql_sort_by);
}
}