/** * Function used to move pic up */ function move_pick_up($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_lowest_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();