Back to users

database_query("SELECT media_id, media_ext FROM se_media WHERE media_album_id='$album_id'"); // LOOP OVER MEDIA while($media_info = $database->database_fetch_assoc($media)) { $media_path = $url->url_userdir($user->user_info["user_id"]).$media_info[media_id].".".$media_info[media_ext]; if(file_exists($media_path)) { unlink($media_path); } $thumb_path = $url->url_userdir($user->user_info["user_id"]).$media_info[media_id]."_thumb.".$media_info[media_ext]; if(file_exists($thumb_path)) { unlink($thumb_path); } } $database->database_query("DELETE FROM se_albums, se_media, se_mediacomments, se_mediatags USING se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id LEFT JOIN se_mediacomments ON se_media.media_id=se_mediacomments.mediacomment_media_id LEFT JOIN se_mediatags ON se_media.media_id=se_mediatags.mediatag_media_id WHERE se_albums.album_id='$album_id'"); // CALL ALBUM CREATION HOOK ($hook = SE_Hook::exists('se_album_delete')) ? SE_Hook::call($hook, array()) : NULL; } // MOVE ALBUM UP elseif($task == "moveup") { $album_id = $_GET['album_id']; $album_query = $database->database_query("SELECT album_id, album_order FROM se_albums WHERE album_id='$album_id' AND album_user_id='".$user->user_info[user_id]."'"); if($database->database_num_rows($album_query) == 1) { $album_info = $database->database_fetch_assoc($album_query); $prev_query = $database->database_query("SELECT album_id, album_order FROM se_albums WHERE album_user_id='".$user->user_info[user_id]."' AND album_order<'".$album_info[album_order]."' ORDER BY album_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_albums SET album_order='" . $prev_info[album_order] . "' WHERE album_id='" . $album_info[album_id] . "'" ); $database->database_query("UPDATE se_albums SET album_order='" . $album_info[album_order] . "' WHERE album_id='" . $prev_info[album_id]. "'"); // SEND AJAX CONFIRMATION echo ""; exit(); } } } $query=mysql_query("SELECT * FROM se_albums WHERE album_user_id='".$user->user_info["user_id"]."'"); while($row=mysql_fetch_array($query)) { ?>&user_id=user_info["user_id"]?>">" />
&user_id=user_info["user_id"]?>">Edit Album | &user_id=user_info["user_id"]?>&task=delete" onclick="return confirm('Are you sure you want to delete this album?');">Delete Album