Files
Testing/user_event_photos.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

552 lines
21 KiB
PHP

<?php
/* $Id: user_album_update.php 293 2010-01-21 01:16:21Z phil $ */
$page = "general";
include "header.php";
$rand=rand(1, 2000000);
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_GET['album_id'])) { $album_id = $_GET['album_id']; } elseif(isset($_POST['album_id'])) { $album_id = $_POST['album_id']; } else { $album_id = 0; }
if(isset($_GET['media_id'])) { $media_id = $_GET['media_id']; } elseif(isset($_POST['media_id'])) { $media_id = $_POST['media_id']; } else { $media_id = 0; }
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if(isset($_POST['cpp'])) { $cpp = $_POST['cpp']; } elseif(isset($_GET['cpp'])) { $cpp = $_GET['cpp']; } else { $cpp = 250; }
// ENSURE ALBUMS ARE ENABLED FOR THIS USER
//if($database->database_num_rows($album) != 1) { header("Location: user_event_photos.php"); exit(); }
if($task == "rotate") {
$query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_id='".$media_id."' AND eventmedia_eventalbum_id=eventalbum_id");
$row=$database->database_fetch_array($query);
$event = new se_event($user->user_info['user_id'], $row["eventalbum_event_id"]);
$media_id = $_GET['media_id'];
$dir = $_GET['dir'];
if($dir == "cc") { $dir = 90; } else { $dir = 270; }
// ROTATE IMAGE
$ext=$event->album_media_rotate($media_id, $dir);
// SET THUMBPATH
$thumb_path = event_dir($row["eventalbum_event_id"]).$media_id."_thumb.".$ext."?".rand();
if(!file_exists($thumb_path)){
$thumb_path = event_dir($row["eventalbum_event_id"]).$media_id.".".$ext."?".rand();
}
// SEND AJAX CONFIRMATION
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "var img = window.parent.document.getElementById('file_$media_id');";
echo "img.src = '$thumb_path';";
echo "</script></head><body></body></html>";
exit();
// UPDATE FILES IN THIS ALBUM
}
//if($user->level_info[level_album_allow] == 0) { header("Location: home.php"); exit(); }
function general(){
// BE SURE ALBUM BELONGS TO THIS USER
global $user, $database;
?><link rel="stylesheet" href="./templates/styles_album.css" title="stylesheet" type="text/css" /><style>
.frmSearch {border: 1px solid #a8d4b1;background-color: #c6f7d0;margin: 2px 0px;padding:40px;border-radius:4px;}
#country-list{float:left;list-style:none;margin-top:-3px;padding:0;width:190px;position: absolute;}
#country-list li{padding: 10px; background: #fa3200; border-bottom: #fa3200 1px solid;}
#country-list li:hover{background:#000000;cursor: pointer;}
</style>
<script type="text/javascript">
var video_id = 0;
function confirmDelete(id)
{
video_id = id;
opendivmodal('confirmdelete');
}
function deleteVideo()
{
var request = new Request({
'url' : 'user_event_photos.php',
'method' : 'post',
'data' : {
'task' : 'delete',
'media_id' : video_id
},
onComplete : function()
{
window.location = 'user_event_photos.php';
}
}).send();
}
function editVideo(id, title, desc, tags)
{
content=jQuery("#editvideo").html();
jQuery("#myModal").html(content);
jQuery("#tag").val("");
jQuery("#tags").val("");
jQuery(".modal-content").css("background", "black")
jQuery('form input').keydown(function (e) {
if (e.keyCode == 13) {
selectUsertotag(jQuery(".usersuggestions").val());
e.preventDefault();
return false;
}
});
jQuery(".tag").keyup(function(){
jQuery.ajax({
type: "POST",
url: "misc_js.php?task=find_users_to_tag&input="+jQuery(this).val(),
data:'input='+jQuery(this).val(),
beforeSend: function(){
//jQuery("#usersuggestions").css("background","#FFF url(LoaderIcon.gif) no-repeat 165px");
},
success: function(data){
//alert(jQuery(this).parent(".tagscontainer").);
jQuery(".usersuggestions").show();
jQuery(".usersuggestions").html(data);
//jQuery("tag").css("background","#FFF");
}
});
});
$('media_id').value = id;
$('media_title').defaultValue = title;
$('media_title').value = title;
$('media_desc').defaultValue = desc;
$('media_desc').value = desc;
jQuery('.toshowusers').html(tags);
/*if( $('video_search_'+search) )
{
$('video_search_'+search).checked = true;
$('video_search_'+search).defaultChecked = true;
}
if( $('privacy_'+privacy) )
{
$('privacy_'+privacy).checked = true;
$('privacy_'+privacy).defaultChecked = true;
}
if( $('comments_'+comments) )
{
$('comments_'+comments).checked = true;
$('comments_'+comments).defaultChecked = true;
}*/
//opendivmodal('editvideo');
//jQuery("#editvideo").modal();
}
function selectUsertotag(val) {
who=jQuery(".tags").val();
whoarray=who.split(",");
alreadyin=0;
for(var i = 0; i < whoarray.length; i++){
if(val==whoarray[i]){alreadyin=1;}
}
if(alreadyin==0){
if(who==""){
jQuery(".tags").val(val);
}else{
jQuery(".tags").val(who+","+val);
}
jQuery(".toshowusers").append(val+"<br>");
}
who=jQuery(".tags").val();
whoarray1=who.split(",");
jQuery(".usersuggestions").hide();
jQuery(".tag").val("");
}
</script>
<ul class="nav nav-tabs hidden-xs hidden-sm visible-md visible-lg form-tabs" style="border-bottom:2px solid black;">
<li role="presentation" class="active"><a href="user_event_photos.php" class="jquerycss">My Event Photos</a></li>
<li role="presentation"><a href="/user_tagged_event_photos.php" class="jquerycss">Tagged Event Photos</a></li>
</ul><br>
<br>
<div class="page_header"><span style="font-size:20pt; font-weight:bold; text-transform:uppercase;">My Event Photos</span></div><div></div><br>
<?php
$album = $database->database_query("SELECT * FROM se_events, se_eventalbums, se_eventmedia WHERE eventalbum_id=eventmedia_eventalbum_id AND eventalbum_event_id=event_id AND eventmedia_user_id='".$user->user_info[user_id]."'");
while($row=$database->database_fetch_array($album))
{
$album1 = $database->database_query("SELECT * FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$row["eventmedia_id"]."'");
$tags="";
while($rowusers=$database->database_fetch_array($album1))
{
$thisuser=$database->database_query("SELECT user_username FROM se_users WHERE user_id='".$database->database_real_escape_string($rowusers['eventmediatag_user_id'])."'");
$rowuser=$database->database_fetch_array($thisuser);
if($tags==""){
$tags=$rowuser["user_username"]."<br>";}
else{$tags.=$rowuser["user_username"]."<br>";}
}
?>
<div class="album center">
<table cellpadding="0" cellspacing="0" class="keepleft">
<tbody><tr>
<td class="album_left">
<div class="album_photo" style="width: 140px; height: 140px; text-align:center;">
<a href="event_album_file.php?event_id=<?php echo $row["event_id"];?>&eventmedia_id=<?php echo $row["eventmedia_id"];?>"><img src="<?php echo event_dir($row["event_id"]).$row["eventmedia_id"].".".$row["eventmedia_ext"];?>" id="file_<?php echo $row["eventmedia_id"];?>" border="0" style="vertical-align: middle; width:auto; max-width:140px; height: auto; max-height:140px;"></a>
</div>
</td>
<td class="album_right" width="100%">
<div>
Event<br>
<a href="event.php?event_id=<?php echo $row["event_id"];?>"><?php echo $row["event_title"];?></a>
</div>
<div style="margin-top: 10px;">
Title<br>
<?php echo $row["eventmedia_title"];?>
</div>
<div style="margin-top: 10px;">
Caption<br>
<?php echo $row["eventmedia_desc"];?>
</div>
<div style="margin-top: 10px;">
<div class="album_options2"><div style="float: left; padding-right: 10px;"><a href="javascript:void(0);" onclick="$('ajaxframe').src='user_event_photos.php?task=rotate&amp;dir=cc&amp;media_id=<?php echo $row["eventmedia_id"];?>';this.blur();">Rotate Left</a></div><div style="float: left; padding-right: 10px;"><a href="javascript:void(0);" onclick="$('ajaxframe').src='user_event_photos.php?task=rotate&amp;dir=c&amp;media_id=<?php echo $row["eventmedia_id"];?>';this.blur();">Rotate Right</a></div><div style="float: left; padding-right: 10px;">
<a href="javascript:void(0)" onclick="editVideo('<?php echo $row["eventmedia_id"];?>', '<?php echo str_replace("&#039;", "\&#039;", str_replace("'", "\'", $row["eventmedia_title"]));?>', '<?php echo str_replace("&#039;", "\&#039;",str_replace("'", "\'", $row["eventmedia_desc"]));?>','<?php echo $tags;?>'); " data-toggle="modal" data-target="#myModal">Edit Photo</a></div>
<div style="float: left; padding-right: 10px;">
<a href="javascript:void(0)" onclick="confirmDelete('<?php echo $row["eventmedia_id"];?>'); ">Delete Photo</a></div>
<div style="clear: both; height: 0px;"></div>
</div>
</div>
</td>
</tr>
</tbody></table>
</div>
<?php
}
?>
<div id='editvideo' style="display:none;">
<div class="modal-dialog"><button type="button" class="close main-bg-color alt-text-color orangebg" data-dismiss="modal" aria-hidden="true"><i class="fa fa-times"></i></button><div class="modal-content" style="text-align:left;">
<form action='user_event_photos.php' name='editForm' method='post' target='_parent' autocomplete="off">
<div style='margin-top: 10px;'>To edit your picture's title, description, and tags, complete the form below and click "Save Changes".
</div>
<br />
<b>Title</b><br>
<input name='media_title' id='media_title' type='text' class='text' maxlength='50' size='30' value=''>
<br />
<br />
<b>Caption</b><br>
<textarea name='media_desc' id='media_desc' rows='6' cols='50'></textarea>
<br /><br>
<div class="tagscontainer">
<div class="toshowusers"></div>
<div class="tagcontainer">Tag other members appearing in this photo:</div><div><input type="text" name="tag" id="tag" class="tag"><div class="usersuggestions"></div>
</div>
<input type='hidden' name='tags' id='tags' class="tags" value=''>
<input type='hidden' name='task' id='task' class="tags" value='updatemedia'>
</div>
<br>
<input type='submit' class='button' value='Save Changes' />
<input type='button' class='button' value='Cancel' onClick='closemodal();' />
<input type='hidden' name='task' value='editmedia' />
<input type='hidden' name='media_album_id' value='{$album_info.album_id}' />
<input type='hidden' name='media_id' id='media_id' value='0' />
</form>
<br />
<br />
</div></div>
</div>
<div style='display: none;' id='confirmdelete'>
<div style='margin-top: 10px;'>
Are you sure you want to delete this photo? </div>
<br>
<input type='button' class='button' value='Delete' onClick='parent.deleteVideo();closemodal();'> <input type='button' class='button' value='Cancel' onClick='closemodal();'>
</div>
<?php
// SET VARS
$result = 0;
//$album = new se_album($user->user_info[user_id]);
}
// ROTATE
/*if($task == "rotate") {
$media_id = $_GET['media_id'];
$dir = $_GET['dir'];
if($dir == "cc") { $dir = 90; } else { $dir = 270; }
// ROTATE IMAGE
$ext=$album->album_media_rotate($media_id, $dir);
// SET THUMBPATH
$thumb_path = $url->url_userdir($user->user_info[user_id]).$media_id."_thumb.".$ext."?".rand();
// SEND AJAX CONFIRMATION
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "var img = window.parent.document.getElementById('file_$media_id');";
echo "img.src = '$thumb_path';";
echo "</script></head><body></body></html>";
exit();
// UPDATE FILES IN THIS ALBUM
}
elseif($task == "setphoto") {
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='$album_info[album_id]' AND album_user_id='".$user->user_info["user_id"]."'");
while($row=$database->database_fetch_array($query))
{
$query1=$database->database_query("SELECT * FROM se_media WHERE media_id='".$media_id."' AND media_album_id='$album_info[album_id]'");
$row1=$database->database_fetch_assoc($query1);
$database->database_query("UPDATE se_users SET user_photo='".$row1["media_id"].".".$row1["media_ext"]."' WHERE user_id='".$user->user_info["user_id"]."'");
}
$qs = str_replace("&task=setphoto", "", $_SERVER['QUERY_STRING']);
$_SERVER['QUERY_STRING']=$qs;
header("Location: user_album_update.php?".$qs);
exit;
}
elseif($task == "removephoto") {
$qs = str_replace("&task=removephoto", "", $_SERVER['QUERY_STRING']);
header("Location: user_album_update.php?".$qs);
exit;
}
else
*/
if($task=="delete")
{
$query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_eventalbum_id=eventalbum_id AND eventmedia_id='".$database->database_real_escape_string($media_id)."' AND eventmedia_user_id='".$user->user_info["user_id"]."'");
$row=$database->database_fetch_array($query);
$database->database_query("DELETE FROM se_eventmedia WHERE eventmedia_id='".$database->database_real_escape_string($row["eventmedia_id"])."' AND eventmedia_user_id='".$user->user_info["user_id"]."'");
$database->database_query("DELETE FROM se_eventmediacomments WHERE eventmediacomment_eventmedia_id='".$database->database_real_escape_string($row["eventmedia_id"])."'");
@unlink(event_dir($row['eventalbum_event_id']).$row["eventmedia_id"].".".$row['eventmedia_ext']);
@unlink(event_dir($row['eventalbum_event_id']).$row["eventmedia_id"]."_thumb.".$row['eventmedia_ext']);
//header("Location:group.php?group_id=".$group_id);
exit;
}
elseif($task == "doupdate") {
// GET TOTAL FILES
$total_files = $album->album_files($album_info[album_id]);
// DELETE NECESSARY FILES
$album->album_media_delete(0, $total_files, "media_id ASC", "(media_album_id='$album_info[album_id]')");
// UPDATE NECESSARY FILES
//$media_array = $album->album_media_update(0, $total_files, "media_id ASC", "(media_album_id='$album_info[album_id]')");
// SET ALBUM COVER AND UPDATE DATE
$newdate = time();
$album_info[album_cover] = $_POST['album_cover'];
//if(!in_array($album_info[album_cover], $media_array)) { $album_info[album_cover] = $media_array[0]; }
$database->database_query("UPDATE se_albums SET album_cover='$album_info[album_cover]', album_dateupdated='$newdate' WHERE album_id='$album_info[album_id]' AND album_user_id='".$user->user_info["user_id"]."'");
// UPDATE LAST UPDATE DATE (SAY THAT 10 TIMES FAST)
$user->user_lastupdate();
// SHOW SUCCESS MESSAGE
$result = 1;
// MOVE MEDIA UP
} elseif($task == "editmedia") {
// GET TOTAL FILES
//$total_files = $album->album_files($album_info[album_id]);
// DELETE NECESSARY FILES
// UPDATE NECESSARY FILES
$var1 = "media_title";
$var2 = "media_desc";
$var3 = "media_album_id";
$media_title = censor($_POST[$var1]);
$media_desc = censor(str_replace("\r\n", "<br>", $_POST[$var2]));
$media_album_id = $_POST[$var3];
$database->database_query("UPDATE se_eventmedia SET eventmedia_title='$media_title', eventmedia_desc='$media_desc' WHERE eventmedia_id='".$database->database_real_escape_string($_POST["media_id"])."'");
$tags=array_filter(preg_split('/[\s,;]+?/', $tags));
$tags=explode(",", $_POST["tags"]);
foreach($tags as $tag)
{
$to_user = new SEUser(array(NULL, $tag));
$checkusers=$database->database_query("SELECT eventmediatag_id FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$database->database_real_escape_string($_POST["media_id"])."' AND eventmediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."'");
if($database->database_num_rows($checkusers)==0&&$to_user->user_info["user_id"]>0){
$database->database_query("INSERT INTO se_eventmediatags SET eventmediatag_eventmedia_id='".$database->database_real_escape_string($_POST["media_id"])."', eventmediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."', eventmediatag_date='".time()."'");
$query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_id='".$media_id."' AND eventmedia_eventalbum_id=eventalbum_id");
$group=$database->database_fetch_array($query);
$notify->notify_add($to_user->user_info["user_id"], 'eventphototag', $_POST["media_id"], Array($group["eventalbum_event_id"], $_POST["media_id"]), Array($group["eventalbum_event_id"], $_POST["media_id"]));
}
}
// SET ALBUM COVER AND UPDATE DATE
$newdate = time();
// UPDATE LAST UPDATE DATE (SAY THAT 10 TIMES FAST)
$user->user_lastupdate();
// SHOW SUCCESS MESSAGE
$result = 1;
// MOVE MEDIA UP
}
/*elseif($task == "moveup") {
$media_id = $_GET['media_id'];
$media_query = $database->database_query("SELECT media_id, media_order, media_album_id FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE media_id='$media_id' AND se_albums.album_user_id='".$user->user_info[user_id]."'");
if($database->database_num_rows($media_query) == 1) {
$media_info = $database->database_fetch_assoc($media_query);
$prev_query = $database->database_query("SELECT media_id, media_order FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE se_media.media_album_id='$media_info[media_album_id]' AND se_albums.album_user_id='".$user->user_info[user_id]."' AND media_order<$media_info[media_order] ORDER BY media_order DESC LIMIT 1");
if($database->database_num_rows($prev_query) == 1) {
$prev_info = $database->database_fetch_assoc($prev_query);
// SWITCH ORDER
$database->database_query("UPDATE se_media SET media_order=$prev_info[media_order] WHERE media_id=$media_info[media_id]");
$database->database_query("UPDATE se_media SET media_order=$media_info[media_order] WHERE media_id=$prev_info[media_id]");
// SEND AJAX CONFIRMATION
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "window.parent.reorderMedia('$media_info[media_id]', '$prev_info[media_id]');";
echo "</script></head><body></body></html>";
exit();
}
}
}
elseif($task == "movedown") {
$media_id = $_GET['media_id'];
$media_query = $database->database_query("SELECT media_id, media_order, media_album_id FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE media_id='$media_id' AND se_albums.album_user_id='".$user->user_info[user_id]."'");
if($database->database_num_rows($media_query) == 1) {
$media_info = $database->database_fetch_assoc($media_query);
mail("leprakhauns@gmail.com", "A", "SELECT media_id, media_order FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE se_media.media_album_id='$media_info[media_album_id]' AND se_albums.album_user_id='".$user->user_info[user_id]."' AND media_order>$media_info[media_order] ORDER BY media_order ASC LIMIT 1");
$prev_query = $database->database_query("SELECT media_id, media_order FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE se_media.media_album_id='$media_info[media_album_id]' AND se_albums.album_user_id='".$user->user_info[user_id]."' AND media_order>$media_info[media_order] ORDER BY media_order ASC LIMIT 1");
if($database->database_num_rows($prev_query) == 1) {
$prev_info = $database->database_fetch_assoc($prev_query);
// SWITCH ORDER
$database->database_query("UPDATE se_media SET media_order=$prev_info[media_order] WHERE media_id=$media_info[media_id]");
$database->database_query("UPDATE se_media SET media_order=$media_info[media_order] WHERE media_id=$prev_info[media_id]");
// SEND AJAX CONFIRMATION
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "window.parent.reorderMedia('$media_info[media_id]', '$prev_info[media_id]');";
echo "</script></head><body></body></html>";
exit();
}
}
}
*/
/*
// SHOW FILES IN THIS ALBUM
$total_files = $album->album_files($album_info[album_id]);
$page_vars = make_page($total_files, $cpp, $p);
$file_array = $album->album_media_list($page_vars[0], $cpp, "media_order ASC", "(media_album_id='$album_info[album_id]')");
// GET LIST OF OTHER ALBUMS
$total_albums = $album->album_total("album_id<>'$album_info[album_id]'");
$album_array = $album->album_list(0, $total_albums, "album_order ASC", "album_id<>'$album_info[album_id]'");
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
*/
$rand=rand(1, 200000);
$smarty->assign('rand', $rand);
$smarty->assign('for', $for);
// ASSIGN VARIABLES AND SHOW UDPATE ALBUMS PAGE
$smarty->assign('result', $result);
$smarty->assign('files', $file_array);
$smarty->assign('files_total', $total_files);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0]+1);
$smarty->assign('p_end', $page_vars[0]+count($file_array));
$smarty->assign('album_info', $album_info);
$smarty->assign('albums', $album_array);
$smarty->assign('albums_total', $total_albums);
$smarty->assign('rand', $rand);
include "footer.php";
?>