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($task == "remove" && $group->groupowner_level_info['level_group_photo'] != 0) { $group->group_photo_delete(); $group->group_lastupdate(); } if($_POST["delete"]=="Delete Selected") { foreach($_POST["deleteid"] as $id) { // MAKE SURE MEDIA EXISTS $media_query = $database->database_query("SELECT se_groupmedia.*, se_groupalbums.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_groupmedia LEFT JOIN se_groupalbums ON se_groupmedia.groupmedia_groupalbum_id=se_groupalbums.groupalbum_id LEFT JOIN se_users ON se_groupmedia.groupmedia_user_id WHERE se_groupmedia.groupmedia_id='{$id}' AND se_groupalbums.groupalbum_group_id='{$group->group_info['group_id']}' LIMIT 1"); $media_info = $database->database_fetch_assoc($media_query); $media_array = Array(); $media_query = $database->database_query("SELECT groupmedia_id, groupmedia_ext, '{$group->group_info['group_id']}' AS groupalbum_group_id FROM se_groupmedia WHERE groupmedia_groupalbum_id='{$media_info['groupalbum_id']}' ORDER BY groupmedia_date DESC"); while($thismedia = $database->database_fetch_assoc($media_query)) { $media_array[$thismedia['groupmedia_id']] = $thismedia; } $media_path = $group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id'].".".$media_info['groupmedia_ext']; if(file_exists($media_path)) { @unlink($media_path); } $thumb_path = $group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id']."_thumb.".$media_info['groupmedia_ext']; if(file_exists($thumb_path)) { @unlink($thumb_path); } $action_thumb_path = $url->url_base.substr($group->group_dir($group->group_info['group_id']), 2).$media_info['groupmedia_id']."_thumb.".$media_info['groupmedia_ext']; // DELETE ACTION MEDIA IF NECESSARY $database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'"); //echo "DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'"; // DELETE MEDIA FROM DATABASE $database->database_query("DELETE FROM se_groupmedia, se_groupmediacomments, se_groupmediatags USING se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmedia.groupmedia_id=se_groupmediacomments.groupmediacomment_groupmedia_id LEFT JOIN se_groupmediatags ON se_groupmedia.groupmedia_id=se_groupmediatags.groupmediatag_groupmedia_id WHERE se_groupmedia.groupmedia_id='{$media_info['groupmedia_id']}'"); // UPDATE CACHED TOTALS $database->database_query("UPDATE se_groupalbums SET groupalbum_totalfiles=groupalbum_totalfiles-1, groupalbum_totalspace=groupalbum_totalspace-'{$media_info['groupmedia_filesize']}' WHERE groupalbum_id='{$media_info['groupmedia_groupalbum_id']}' LIMIT 1"); } } 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++; } $groupmedia_query = "SELECT se_groupmedia.*, se_groupalbums.groupalbum_id, se_groupalbums.groupalbum_group_id, se_groupalbums.groupalbum_title, count(se_groupmediacomments.groupmediacomment_id) AS total_comments"; // CONTINUE QUERY $groupmedia_query .= " FROM se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmediacomments.groupmediacomment_groupmedia_id=se_groupmedia.groupmedia_id LEFT JOIN se_groupalbums ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id WHERE "; // ADD WHERE IF NECESSARY $groupmedia_query .= " se_groupalbums.groupalbum_group_id='{$group_id}' AND "; // IF GROUP EXISTS, SPECIFY GROUP ID $groupmedia_query .= " se_groupalbums.groupalbum_group_id='{$group_id}'"; // ADD AND IF NECESSARY // ADD ADDITIONAL WHERE CLAUSE // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $groupmedia_query .= " GROUP BY groupmedia_id ORDER BY groupmedia_id DESC LIMIT ".$page_vars[0].", ".$cpp; //echo $groupmedia_query; $query=$database->database_query($groupmedia_query); $total_friends1=$database->database_num_rows($query); ?>
1){?>
« ‹« ‹ | | › »› »
viewing results - of viewing results - of
Go to Page:
database_fetch_array($query)) { ?>
1){?>
« ‹« ‹ | | › »› »
viewing results - of viewing results - of
Go to Page:
groupvalue_info); $field->cat_list(0, 0, 0, "", "", ""); $cat_array = $field->cats; if($is_error != 0) { $selected_cat_array = array_filter($cat_array, create_function('$a', 'if($a[cat_id] == "'.$group->group_info['group_groupcat_id'].'") { return $a; }')); while(list($key, $val) = each($selected_cat_array)) { $cat_array[$key][fields] = $selected_fields; } } // GET SUBCAT IF NECESSARY $thiscat = $database->database_fetch_assoc($database->database_query("SELECT groupcat_id, groupcat_dependency FROM se_groupcats WHERE groupcat_id='{$group->group_info['group_groupcat_id']}' LIMIT 1")); if($thiscat['groupcat_dependency'] == 0) { $group->group_info['group_groupsubcat_id'] = 0; } else { $group->group_info['group_groupsubcat_id'] = $group->group_info['group_groupcat_id']; $group->group_info['group_groupcat_id'] = $thiscat['groupcat_dependency']; } // REMOVE BREAKS $group->group_info['group_desc'] = str_replace("
", "\r\n", $group->group_info['group_desc']); // ASSIGN VARIABLES AND SHOW USER EDIT GROUP PAGE $smarty->assign('result', $result); $smarty->assign('is_error', $is_error); $smarty->assign('justadded', $justadded); $smarty->assign('group', $group); $smarty->assign('cats', $cat_array); include "footer.php"; ?>