function MG_staticSortAlbumsSave()
{
global $_TABLES, $_MG_CONF;
$startaid = !empty($_POST['startaid']) ? COM_applyFilter($_POST['startaid'], true) : 0;
$sortfield = !empty($_POST['sortfield']) ? COM_applyFilter($_POST['sortfield'], true) : 0;
$sortorder = !empty($_POST['sortorder']) ? COM_applyFilter($_POST['sortorder'], true) : 0;
$process_subs = !empty($_POST['processsub']) ? COM_applyFilter($_POST['processsub'], true) : 0;
switch ($sortfield) {
case '0':
// album title
$sql_sort_by = " ORDER BY album_title ";
break;
case '1':
// media_count
$sql_sort_by = " ORDER BY media_count ";
break;
case '2':
// last_update
$sql_sort_by = " ORDER BY last_update ";
break;
default:
$sql_sort_by = " ORDER BY album_title ";
break;
}
switch ($sortorder) {
case '0':
// ascending
$sql_order = " DESC";
break;
case '1':
// descending
$sql_order = " ASC";
break;
}
if ($process_subs == 0) {
$sql = "SELECT album_id FROM {$_TABLES['mg_albums']} " . "WHERE album_parent=" . $startaid . " " . $sql_sort_by . $sql_order;
$result = DB_query($sql);
$order = 10;
while ($row = DB_fetchArray($result)) {
DB_change($_TABLES['mg_albums'], 'album_order', $order, 'album_id', $row['album_id']);
$order += 10;
}
} else {
MG_staticSortAlbumChildren($startaid, $sql_order, $sql_sort_by);
}
header("Location: " . $_MG_CONF['admin_url'] . 'index.php?msg=1');
}
function MG_staticSortAlbumsSave()
{
global $_USER, $_CONF, $_TABLES, $_MG_CONF, $LANG_MG00, $LANG_MG01, $LANG_MG03, $_POST;
$startaid = COM_applyFilter($_POST['startaid'], true);
$sortfield = COM_applyFilter($_POST['sortfield'], true);
$sortorder = COM_applyFilter($_POST['sortorder'], true);
$process_subs = COM_applyFilter($_POST['processsub'], true);
switch ($sortby) {
case '0':
// album title
$sql_sort_by = " ORDER BY album_title ";
break;
case '1':
// media_count
$sql_sort_by = " ORDER BY media_count ";
break;
case '2':
// last_update
$sql_sort_by = " ORDER BY last_update ";
break;
default:
$sql_sort_by = " ORDER BY album_title ";
break;
}
switch ($sortorder) {
case '0':
// ascending
$sql_order = " DESC";
break;
case '1':
// descending
$sql_order = " ASC";
break;
}
if ($process_subs == 0) {
$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;
$i = 0;
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);
}
} else {
MG_staticSortAlbumChildren($startaid, $sql_order, $sql_sort_by);
}
header("Location: " . $_MG_CONF['admin_url'] . 'index.php?msg=1');
}
