level_info['level_group_allow'] & 2 ) { /* header("Location: user_home.php"); exit();*/ } // INITIALIZE GROUP OBJECT $group = new se_group($user->user_info[user_id], $group_id); if( !$group->group_exists || $group->user_rank<=0 ) { header("Location: user_group.php"); exit(); } // INITIALIZE VARIABLES $is_error = 0; $result = 0; // DELETE PHOTO if($_POST["delete"]=="Delete Selected") { foreach($_POST["deleteid"] as $id) { // MAKE SURE MEDIA EXISTS $media_query = $database->database_query("SELECT * FROM se_group_videos WHERE se_group_videos.video_id='{$id}' AND se_group_videos.video_group_id='{$group->group_info['group_id']}' LIMIT 1"); $media_info = $database->database_fetch_assoc($media_query); $media_path = $group->group_dir($group->group_info['group_id'])."video_".$media_info['video_id'].".mp4"; if(file_exists($media_path)) { @unlink($media_path); } $thumb_path = $group->group_dir($group->group_info['group_id'])."video_".$media_info['video_id']."_thumb.jpg"; if(file_exists($thumb_path)) { @unlink($thumb_path); } //echo "DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'"; // DELETE MEDIA FROM DATABASE $database->database_query("DELETE FROM se_group_videos, groupvideocomments USING se_group_videos LEFT JOIN groupvideocomments ON se_group_videos.video_id=groupvideocomments.object_id WHERE se_group_videos.video_id='{$media_info['video_id']}'"); } } if( $task == "resize" ) { if(isset($_POST['video_id'])) { $video_id = $_POST['video_id']; } elseif(isset($_GET['video_id'])) { $video_id = $_GET['video_id']; } else { $video_id = "1"; } if(isset($_POST['resize'])) { $resize = $_POST['resize']; } elseif(isset($_GET['resize'])) { $resize = $_GET['resize']; } else { $resize = "1"; } if($resize!=1||$resize!=2){$resize=1;} // MAKE SURE SUBMITTED PRIVACY OPTIONS ARE ALLOWED, IF NOT, SET TO EVERYONE if(!in_array($video_privacy, $level_video_privacy)) { $video_privacy = $level_video_privacy[0]; } if(!in_array($video_comments, $level_video_comments)) { $video_comments = $level_video_comments[0]; } $database->database_query("UPDATE se_group_videos SET resize='{$resize}' WHERE video_id='$video_id' AND video_group_id='{$group->group_info['group_id']}'"); $smarty->assign('task1', "resize"); } function editphotos() { global $group_id, $cpp, $p, $group, $database; if($p==""){$p=1;} $groupalbum_info = $database->database_fetch_assoc($database->database_query("SELECT groupalbum_id FROM se_groupalbums WHERE groupalbum_group_id='{$group->group_info['group_id']}' LIMIT 1")); //$total_files = $group->group_media_total($groupalbum_info['groupalbum_id']); $page_vars = make_page($total_files, $cpp, $p); for($x=$page_vars[1]; $x<=$page_vars[2]; $x++) { if(($page_vars[1]+10)==$x) {break;} $for[$y]=$x; $y++; } $query=$database->database_query("SELECT se_group_videos.group_video_id FROM se_group_videos WHERE se_group_videos.video_group_id='{$group_id}' AND video_admin_approved=1"); $total_files=$database->database_num_rows($query); $groupmedia_query = "SELECT se_group_videos.*, count(groupvideocomments.id) AS total_comments"; // CONTINUE QUERY $groupmedia_query .= " FROM se_group_videos LEFT JOIN groupvideocomments ON groupvideocomments.object_id=se_group_videos.video_id WHERE "; // ADD WHERE IF NECESSARY $groupmedia_query .= " se_group_videos.video_group_id='{$group_id}' AND video_admin_approved=1 "; // IF GROUP EXISTS, SPECIFY GROUP ID // ADD AND IF NECESSARY // ADD ADDITIONAL WHERE CLAUSE // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $groupmedia_query .= " GROUP BY video_id ORDER BY video_id DESC LIMIT ".$page_vars[0].", ".$cpp; //if(SE_DEBUG){echo $groupmedia_query;} $query=$database->database_query($groupmedia_query); $total_friends1=$database->database_num_rows($query); ?>