function MG_staticSortMediaSave()
{
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 ($sortfield) {
case '0':
// media_time
$sql_sort_by = " ORDER BY m.media_time ";
break;
case '1':
// media_upload_time
$sql_sort_by = " ORDER BY m.media_upload_time ";
break;
case '2':
// media title
$sql_sort_by = " ORDER BY m.media_title ";
break;
case '3':
// media original filename
$sql_sort_by = " ORDER BY m.media_original_filename ";
break;
default:
$sql_sort_by = " ORDER BY m.media_time ";
break;
}
switch ($sortorder) {
case '0':
// ascending
$sql_order = " DESC";
break;
case '1':
// descending
$sql_order = " ASC";
break;
}
if ($process_subs == 0) {
$sql = "SELECT *\n FROM " . $_TABLES['mg_media_albums'] . " as ma LEFT JOIN " . $_TABLES['mg_media'] . " as m ON m.media_id = ma.media_id\n WHERE ma.album_id=" . $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);
$media_id[$x] = $row['media_id'];
$media_order[$x] = $order;
$order += 10;
}
$media_count = $numRows;
$i = 0;
for ($x = 0; $x < $media_count; $x++) {
$sql = "UPDATE " . $_TABLES['mg_media_albums'] . " SET media_order=" . $media_order[$x] . " WHERE media_id='" . $media_id[$x] . "' AND album_id=" . $startaid;
$res = DB_query($sql);
}
} else {
MG_staticSortMediaChildren($startaid, $sql_order, $sql_sort_by);
}
header("Location: " . $_MG_CONF['admin_url'] . 'index.php?msg=1');
}
function MG_staticSortMediaSave()
{
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':
// media_time
$sql_sort_by = " ORDER BY m.media_time ";
break;
case '1':
// media_upload_time
$sql_sort_by = " ORDER BY m.media_upload_time ";
break;
case '2':
// media title
$sql_sort_by = " ORDER BY m.media_title ";
break;
case '3':
// media original filename
$sql_sort_by = " ORDER BY m.media_original_filename ";
break;
default:
$sql_sort_by = " ORDER BY m.media_time ";
break;
}
switch ($sortorder) {
case '0':
// ascending
$sql_order = " DESC";
break;
case '1':
// descending
$sql_order = " ASC";
break;
}
if ($process_subs == 0) {
$sql = "SELECT m.media_id FROM {$_TABLES['mg_media_albums']} AS ma " . "LEFT JOIN {$_TABLES['mg_media']} AS m ON m.media_id = ma.media_id " . "WHERE ma.album_id=" . $startaid . $sql_sort_by . $sql_order;
$result = DB_query($sql);
$order = 10;
while ($row = DB_fetchArray($result)) {
DB_change($_TABLES['mg_media_albums'], 'media_order', $order, array('media_id', 'album_id'), array($row['media_id'], $startaid));
$order += 10;
}
} else {
MG_staticSortMediaChildren($startaid, $sql_order, $sql_sort_by);
}
header("Location: " . $_MG_CONF['admin_url'] . 'index.php?msg=1');
}
