/**
* Function used to move pic up
*/
function move_pick_down($id)
{
global $db;
$result = $db->select(tbl("editors_picks"), "*", " pick_id='{$id}'");
if ($db->num_rows > 0) {
$result = $result[0];
$sort = $result['sort'];
if ($sort < get_highest_sort_number()) {
$less_result = $db->select(tbl("editors_picks"), "*", " sort>{$sort}", 1);
if ($db->num_rows > 0) {
$less_result = $less_result[0];
$new_sort = $less_result['sort'];
$db->update(tbl('editors_picks'), array('sort'), $new_sort, " pick_id='{$id}'");
$db->update(tbl('editors_picks'), array('sort'), $sort, " pick_id='" . $less_result['pick_id'] . "'");
}
}
}
}
if (!defined('SUB_PAGE')) {
define('SUB_PAGE', "Editor's Pick");
}
//Removing
if (isset($_GET['remove'])) {
$id = mysql_clean($_GET['remove']);
remove_vid_editors_pick($id);
}
if (isset($_POST['delete_selected'])) {
for ($id = 0; $id <= count($_POST['check_video']); $id++) {
remove_vid_editors_pick($_POST['check_video'][$id]);
}
$eh->flush();
e("Selected videos have been removed from editors pick", "m");
}
$ep_videos = get_ep_videos();
if (isset($_POST['update_order'])) {
if (is_array($ep_videos)) {
foreach ($ep_videos as $epvid) {
$order = $_POST['ep_order_' . $epvid['pick_id']];
move_epick($epvid['videoid'], $order);
}
}
$ep_videos = get_ep_videos();
}
assign('videos', $ep_videos);
assign('max', get_highest_sort_number());
assign('min', get_lowest_sort_number());
subtitle("Editor's Pick");
template_files('editor_pick.html');
display_it();
