level_info[level_album_allow] == 0) { header("Location: home.php"); exit(); }
// BE SURE ALBUM BELONGS TO THIS USER
$album = $database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_id)."' AND album_user_id='".$user->user_info[user_id]."'");
if($database->database_num_rows($album) != 1) { header("Location: user_album.php"); exit(); }
$album_info = $database->database_fetch_assoc($album);
// 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 "
";
exit();
// UPDATE FILES IN THIS ALBUM
}
elseif($task == "revokerights") {
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_info["album_id"])."' AND album_user_id='".$user->user_info["user_id"]."'");
while($row=$database->database_fetch_array($query))
{
$database->database_query("UPDATE se_media SET rights=0, consenttaken='".time()."' WHERE media_album_id=".$database->database_real_escape_string($album_info["album_id"])." AND media_id=".$database->database_real_escape_string($media_id));
}
}
elseif($task == "giverights") {
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_info["album_id"])."' AND album_user_id='".$user->user_info["user_id"]."'");
while($row=$database->database_fetch_array($query))
{
$database->database_query("UPDATE se_media SET rights=1, consentgiven='".time()."' WHERE media_album_id=".$database->database_real_escape_string($album_info["album_id"])." AND media_id=".$database->database_real_escape_string($media_id)." AND consenttaken=0");
}
}
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;
}
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", "
", $_POST[$var2]));
$media_album_id = $_POST[$var3];
$database->database_query("UPDATE se_media SET media_title='$media_title', media_desc='$media_desc', media_album_id='$media_album_id' WHERE media_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 mediatag_id FROM se_mediatags WHERE mediatag_media_id='".$database->database_real_escape_string($_POST["media_id"])."' AND mediatag_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_mediatags SET mediatag_media_id='".$database->database_real_escape_string($_POST["media_id"])."', mediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."', mediatag_date='".time()."'");
$notify->notify_add($to_user->user_info["user_id"], 'phototag', $_POST["media_id"], Array($user->user_info["user_username"], $_POST["media_id"]), Array($user->user_info["user_username"], $_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 "";
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 "";
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";
?>