Files
Testing/group_album_file1.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

307 lines
12 KiB
PHP

<?php
/* $Id: group_album_file.php 161 2009-04-28 21:14:59Z john $ */
$page = "group_album_file1";
include "header.php";
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = ""; }
if(isset($_POST['group_id'])) { $group_id = $_POST['group_id']; } elseif(isset($_GET['group_id'])) { $group_id = $_GET['group_id']; } else { $group_id = 0; }
if(isset($_POST['groupmedia_id'])) { $groupmedia_id = $_POST['groupmedia_id']; } elseif(isset($_GET['groupmedia_id'])) { $groupmedia_id = $_GET['groupmedia_id']; } else { $groupmedia_id = 0; }
$group = new se_group($user->user_info['user_id'], $group_id);
if($group->group_info["group_user_id"]!=$user->user_info["user_id"]){
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
if( (!$user->user_exists && !$setting['setting_permission_group']) || ($user->user_exists && (~(int)$user->level_info['level_group_allow'] & 1)) )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 656);
$smarty->assign('error_submit', 641);
include "footer.php";
}}
// DISPLAY ERROR PAGE IF NO OWNER
if( !$group->group_exists )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 2000219);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// 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='{$groupmedia_id}' AND se_groupalbums.groupalbum_group_id='{$group->group_info['group_id']}' LIMIT 1");
if( !$database->database_num_rows($media_query) )
{
header("Location: ".$url->url_create('group', NULL, $group->group_info['group_id']));
exit();
}
$media_info = $database->database_fetch_assoc($media_query);
$uploader = new se_user();
if( $media_info['groupmedia_user_id'] != $media_info['user_id'] )
{
$uploader->user_exists = FALSE;
}
else
{
$uploader->user_exists = TRUE;
$uploader->user_info['user_id'] = $media_info['user_id'];
$uploader->user_info['user_username'] = $media_info['user_username'];
$uploader->user_info['user_fname'] = $media_info['user_fname'];
$uploader->user_info['user_lname'] = $media_info['user_lname'];
$uploader->user_displayname();
}
$media_info['uploader'] = $uploader;
// GET PRIVACY LEVEL
$privacy_max = $group->group_privacy_max($user);
if( !($privacy_max & $group->group_info['group_privacy']) )
{
header("Location: ".$url->url_create("group", NULL, $group->group_info['group_id']));
exit();
}
// GET MEDIA IN ALBUM FOR CAROUSEL
$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_array($media_query)) {
$media_array1[] = $thismedia;
$thisid[]=$thismedia['groupmedia_id'];
if($groupmedia_id==$thismedia['groupmedia_id']){
$start1=$thisid[$x-3];
$startid=$x-3;
if(($startid)<0){
$start1=$thisid[$x-2];
$startid=$x-2;
if(($startid)<0){
$start1=$thisid[$x-1];
$startid=$x-1;
}
}
if(($startid)<0){
$start1=$thisid[$x]; $startid=0;
}
$endid=$x+4;
//$end=$thisid[$x+5];
$u=1;
}
if($x==$endid&&$endid!=""){$end=$thisid[$x]; }
$media_array[$thismedia['groupmedia_id']] = $thismedia;
$x++;
}
$totalnum=count($media_array);
//if($end>count($media_array1)){$end=count($media_array1);}
$countitems=count($media_array1);
$start=$start1*1;
$y=$startid;
$media_array=array();
while($end!=$thisid[$y]) {
$t=$thisid[$y-1]*1;
$r=$thisid[$y+1]*1;
if($groupmedia_id==$thisid[$y]){
$thismediaid=$y;
$previd=$r;
$nextid=$t*1;
}
//$media_array[] = $media_array1[$y];
if( $media_array1[$y]==""){break;}
$media_array[$thisid[$y]] = $media_array1[$y];
$y++;
}
//$nextid=$media_array[$nextid]["media_id"];
//$nextid=$t;
//$previd=$p;
//$previd=$media_array[$previousid]["media_id"];
if($previd<0){$previd=0;}
// IF USER IS ALLOWED, CHECK TASK
if( $group->user_rank == 2 || $group->user_rank == 1 || ($media_info['uploader']->user_exists && $user->user_info['user_id'] == $media_info['uploader']->user_info['user_id']) )
{
// DELETE PHOTO
if($task == "media_delete")
{
$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}'");
// 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");
// SEND USER TO NEXT PHOTO
$media_keys = array_keys($media_array);
$current_index = array_search($media_info[groupmedia_id], $media_keys);
if($current_index+1 == count($media_array)) { $next_index = 0; } else { $next_index = $current_index+1; }
header("Location: ".$url->url_create('group_media', NULL, $group->group_info['group_id'], $media_keys[$next_index]));
exit();
}
// EDIT PHOTO
elseif($task == "media_edit")
{
$media_info['groupmedia_title'] = $_POST['groupmedia_title'];
$media_info['groupmedia_desc'] = $_POST['groupmedia_desc'];
$database->database_query("UPDATE se_groupmedia SET groupmedia_title='{$media_info['groupmedia_title']}', groupmedia_desc='{$media_info['groupmedia_desc']}' WHERE groupmedia_id='{$media_info['groupmedia_id']}' LIMIT 1");
}
}
// GET CUSTOM GROUP STYLE IF ALLOWED
if( $group->groupowner_level_info['level_group_style'] )
{
$groupstyle_info = $database->database_fetch_assoc($database->database_query("SELECT groupstyle_css FROM se_groupstyles WHERE groupstyle_group_id='{$group->group_info['group_id']}' LIMIT 1"));
$global_css = $groupstyle_info['groupstyle_css'];
}
// GET MEDIA WIDTH/HEIGHT
$mediasize = @getimagesize($group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id'].'.'.$media_info['groupmedia_ext']);
$media_info['groupmedia_width'] = $mediasize[0];
$media_info['groupmedia_height'] = $mediasize[1];
// CHECK IF USER IS ALLOWED TO TAG PHOTOS
$allowed_to_tag = ($privacy_max & $media_info['groupalbum_tag']);
// CHECK IF USER IS ALLOWED TO COMMENT
$allowed_to_comment = ($privacy_max & $group->group_info['group_comments']);
// GET MEDIA COMMENTS
$comment = new se_comment('groupmedia', 'groupmedia_id', $media_info['groupmedia_id']);
$total_comments = $comment->comment_total();
// UPDATE ALBUM VIEWS
$album_views_new = ++$media_info['groupalbum_views'];
$database->database_query("UPDATE se_groupalbums SET groupalbum_views=groupalbum_views+1 WHERE groupalbum_id='{$media_info['groupalbum_id']}' LIMIT 1");
// UPDATE NOTIFICATIONS
if( $user->user_info['user_id'] == $group->group_info['group_user_id'] )
{
$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$user->user_info['user_id']}' AND (se_notifytypes.notifytype_name='groupmediacomment' OR se_notifytypes.notifytype_name='groupmediatag' OR se_notifytypes.notifytype_name='newgrouptag') AND notify_object_id='{$media_info['groupmedia_id']}'");
}
/*
// RETRIEVE TAGS FOR THIS PHOTO
$tag_array = Array();
$tags = $database->database_query("SELECT se_groupmediatags.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_groupmediatags LEFT JOIN se_users ON se_groupmediatags.groupmediatag_user_id=se_users.user_id WHERE groupmediatag_groupmedia_id='{$media_info['groupmedia_id']}' ORDER BY groupmediatag_id ASC");
while($tag = $database->database_fetch_assoc($tags))
{
$taggeduser = new se_user();
if( $tag['user_id'] )
{
$taggeduser->user_exists = TRUE;
$taggeduser->user_info['user_id'] = $tag['user_id'];
$taggeduser->user_info['user_username'] = $tag['user_username'];
$taggeduser->user_info['user_fname'] = $tag['user_fname'];
$taggeduser->user_info['user_lname'] = $tag['user_lname'];
$taggeduser->user_displayname();
}
else
{
$taggeduser->user_exists = FALSE;
}
$tag['tagged_user'] = $taggeduser;
$tag_array[] = $tag;
}
*/
// SET GROUP OWNER (OR EDITOR)
if($group->user_rank == 2 || $group->user_rank == 1) {
$groupowner = $user;
} else {
$groupowner = new se_user(Array($group->group_info['group_user_id']));
}
// SET GLOBAL PAGE TITLE
$global_page_title[0] = 2000326;
$global_page_title[1] = $group->group_info['group_title'];
$global_page_description[0] = 2000327;
$global_page_description[1] = $group->group_info['group_title'];
if(isset($_POST['favorites'])) { $fave = $_POST['favorites']; } elseif(isset($_GET['favorites'])) { $fave = $_GET['favorites']; } else { $fave = 0; }
if($fave==="delete"){
$database->database_query("DELETE FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='groupphoto' AND owner='".$group_id."' AND objectid='".$groupmedia_id."'");
}
if($fave==="addto"){
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='groupphoto' AND owner='".$group_id."' AND objectid='".$groupmedia_id."'");
if($database->database_num_rows($query)==0){
$database->database_query("INSERT INTO favorites SET user='".$user->user_info["user_id"]."', type='groupphoto', owner='".$group_id."', objectid='".$groupmedia_id."'");
}
}
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='groupphoto' AND owner='".$group_id."' AND objectid='".$groupmedia_id."'");
if($database->database_num_rows($query)>0){$smarty->assign('favorites1', 1);}
$owner = new SEUser(Array($media_info["groupmedia_user_id"]));
$smarty->assign('owner', $owner);
// ASSIGN VARIABLES AND DISPLAY ALBUM FILE PAGE
$smarty->assign('favorites', 1);
$smarty->assign('totalnum', $totalnum);
$smarty->assign('thismediaid', $thismediaid+1);
$smarty->assign('group', $group);
$smarty->assign('groupowner', $groupowner);
$smarty->assign('media_info', $media_info);
$smarty->assign('nextid', $nextid);
$smarty->assign('previd', $previd);
$smarty->assign('total_comments', $total_comments);
$smarty->assign('allowed_to_comment', $allowed_to_comment);
$smarty->assign('allowed_to_tag', $allowed_to_tag);
$smarty->assign('media', $media_array);
$smarty->assign('media_keys', array_keys($media_array));
$smarty->assign('tags', $tag_array);
include "footer.php";
?>