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'); }