555 lines
21 KiB
PHP
555 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 = 40; }
|
|
// ENSURE ALBUMS ARE ENABLED FOR THIS USER
|
|
|
|
//if($database->database_num_rows($album) != 1) { header("Location: user_group_photos.php"); exit(); }
|
|
|
|
|
|
if($task == "rotate") {
|
|
|
|
$query=$database->database_query("SELECT * FROM se_groupmedia, se_groupalbums WHERE groupmedia_id='".$media_id."' AND groupmedia_groupalbum_id=groupalbum_id");
|
|
$row=$database->database_fetch_array($query);
|
|
$group = new se_group($user->user_info['user_id'], $row["groupalbum_group_id"]);
|
|
$media_id = $_GET['media_id'];
|
|
$dir = $_GET['dir'];
|
|
|
|
if($dir == "cc") { $dir = 90; } else { $dir = 270; }
|
|
|
|
// ROTATE IMAGE
|
|
$ext=$group->album_media_rotate($media_id, $dir);
|
|
|
|
// SET THUMBPATH
|
|
$thumb_path = group_dir($row["groupalbum_group_id"]).$media_id."_thumb.".$ext."?".rand();
|
|
if(!file_exists($thumb_path)){
|
|
$thumb_path = group_dir($row["groupalbum_group_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_group_photos.php',
|
|
'method' : 'post',
|
|
'data' : {
|
|
'task' : 'delete',
|
|
'media_id' : video_id
|
|
},
|
|
onComplete : function()
|
|
{
|
|
window.location = 'user_group_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_group_photos.php" class="jquerycss">My Group Photos</a></li>
|
|
<li role="presentation" ><a href="/user_tagged_group_photos.php" class="jquerycss">Tagged Group Photos</a></li>
|
|
</ul><br>
|
|
<br>
|
|
<div class="page_header"><span style="font-size:20pt; font-weight:bold; text-transform:uppercase;">My Group Photos</span></div>
|
|
<div></div><br>
|
|
|
|
<?php
|
|
|
|
$album = $database->database_query("SELECT * FROM se_groups, se_groupalbums, se_groupmedia WHERE groupalbum_id=groupmedia_groupalbum_id AND groupalbum_group_id=group_id AND groupmedia_user_id='".$user->user_info[user_id]."'");
|
|
|
|
|
|
|
|
while($row=$database->database_fetch_array($album))
|
|
{
|
|
$album1 = $database->database_query("SELECT * FROM se_groupmediatags WHERE groupmediatag_groupmedia_id='".$row["groupmedia_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['groupmediatag_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="group_album_file.php?group_id=<?php echo $row["group_id"];?>&groupmedia_id=<?php echo $row["groupmedia_id"];?>"><img src="<?php echo group_dir($row["group_id"]).$row["groupmedia_id"].".".$row["groupmedia_ext"];?>" id="file_<?php echo $row["groupmedia_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>
|
|
Group<br>
|
|
<a href="group.php?group_id=<?php echo $row["group_id"];?>"><?php echo $row["group_title"];?></a>
|
|
</div>
|
|
<div style="margin-top: 10px;">
|
|
Title<br>
|
|
<?php echo $row["groupmedia_title"];?>
|
|
</div>
|
|
<div style="margin-top: 10px;">
|
|
Caption<br>
|
|
<?php echo $row["groupmedia_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_group_photos.php?task=rotate&dir=cc&media_id=<?php echo $row["groupmedia_id"];?>';this.blur();">Rotate Left</a></div><div style="float: left; padding-right: 10px;"><a href="javascript:void(0);" onclick="$('ajaxframe').src='user_group_photos.php?task=rotate&dir=c&media_id=<?php echo $row["groupmedia_id"];?>';this.blur();">Rotate Right</a></div><div style="float: left; padding-right: 10px;">
|
|
<a href="javascript:void(0)" onclick="editVideo('<?php echo $row["groupmedia_id"];?>', '<?php echo str_replace("'", "\'",str_replace("'", "\'", $row["groupmedia_title"]));?>', '<?php echo str_replace("'", "\'",str_replace("'", "\'", $row["groupmedia_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["groupmedia_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_group_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 == "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_groupmedia SET groupmedia_title='$media_title', groupmedia_desc='$media_desc' WHERE groupmedia_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 groupmediatag_id FROM se_groupmediatags WHERE groupmediatag_groupmedia_id='".$database->database_real_escape_string($_POST["media_id"])."' AND groupmediatag_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_groupmediatags SET groupmediatag_groupmedia_id='".$database->database_real_escape_string($_POST["media_id"])."', groupmediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."', groupmediatag_date='".time()."'");
|
|
|
|
|
|
$query=$database->database_query("SELECT * FROM se_groupmedia, se_groupalbums WHERE groupmedia_id='".$media_id."' AND groupmedia_groupalbum_id=groupalbum_id");
|
|
$group=$database->database_fetch_array($query);
|
|
$notify->notify_add($to_user->user_info["user_id"], 'groupphototag', $_POST["media_id"], Array($group["groupalbum_group_id"], $_POST["media_id"]), Array($group["groupalbum_group_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=="delete")
|
|
{
|
|
|
|
|
|
|
|
$query=$database->database_query("SELECT * FROM se_groupmedia, se_groupalbums WHERE groupmedia_groupalbum_id=groupalbum_id AND groupmedia_id='".$database->database_real_escape_string($media_id)."' AND groupmedia_user_id='".$user->user_info["user_id"]."'");
|
|
$row=$database->database_fetch_array($query);
|
|
$database->database_query("DELETE FROM se_groupmedia WHERE groupmedia_id='".$database->database_real_escape_string($row["groupmedia_id"])."' AND groupmedia_user_id='".$user->user_info["user_id"]."'");
|
|
|
|
|
|
$database->database_query("DELETE FROM se_groupmediacomments WHERE groupmediacomment_groupmedia_id='".$database->database_real_escape_string($row["groupmedia_id"])."'");
|
|
@unlink(group_dir($row['groupalbum_group_id']).$row["groupmedia_id"].".".$row['groupmedia_ext']);
|
|
@unlink(group_dir($row['groupalbum_group_id']).$row["groupmedia_id"]."_thumb.".$row['groupmedia_ext']);
|
|
//header("Location:group.php?group_id=".$group_id);
|
|
exit;
|
|
}
|
|
|
|
/*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";
|
|
?>
|