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"; ?>