">Back to Albums

user_info[user_id]}' "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $media_query .= " AND $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $media_query .= " GROUP BY media_id "; // RUN QUERY $media = $database->database_query($media_query); // LOOP OVER MEDIA $thumbs = Array(); 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.jpg"; if(file_exists($thumb_path)) { unlink($thumb_path); } $thumbs[] = $url->url_base.substr($url->url_userdir($user->user_info["user_id"]), 2).$media_info[media_id]."_thumb.jpg"; // DECREMENT ALBUM FILES AND SPACE COUNT if( !is_numeric($media_info['media_filesize']) ) $media_info['media_filesize'] = 0; $database->database_query("UPDATE se_albums SET album_totalfiles=album_totalfiles-1, album_totalspace=album_totalspace-'{$media_info['media_filesize']}' WHERE album_id='{$media_info['media_album_id']}' LIMIT 1"); } // DELETE ACTION MEDIA IF NECESSARY $database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path IN ('".implode("', '", $thumbs)."')"); // DELETE MEDIA FROM DATABASE $database->database_query("DELETE FROM se_media, se_mediacomments, se_mediatags USING se_media 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_media.media_id ='{$delete}'"); } elseif($task=="deletemultiple"){ foreach($_POST["imagedelete"] as $del) { $delete = $del; //if(count($delete) == 0) { return; } // BEGIN QUERY $media_query = " SELECT se_media.media_id, se_media.media_ext, se_media.media_album_id, se_media.media_filesize FROM se_media LEFT JOIN se_mediacomments ON se_mediacomments.mediacomment_media_id=se_media.media_id LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // ADD WHERE IF NECESSARY $media_query .= " WHERE se_media.media_id ='{$delete}' && se_albums.album_user_id='{$user->user_info[user_id]}' "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $media_query .= " AND $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $media_query .= " GROUP BY media_id "; // RUN QUERY $media = $database->database_query($media_query); // LOOP OVER MEDIA $thumbs = Array(); 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.jpg"; if(file_exists($thumb_path)) { unlink($thumb_path); } $thumbs[] = $url->url_base.substr($url->url_userdir($user->user_info["user_id"]), 2).$media_info[media_id]."_thumb.jpg"; // DECREMENT ALBUM FILES AND SPACE COUNT if( !is_numeric($media_info['media_filesize']) ) $media_info['media_filesize'] = 0; $database->database_query("UPDATE se_albums SET album_totalfiles=album_totalfiles-1, album_totalspace=album_totalspace-'{$media_info['media_filesize']}' WHERE album_id='{$media_info['media_album_id']}' LIMIT 1"); } // DELETE ACTION MEDIA IF NECESSARY $database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path IN ('".implode("', '", $thumbs)."')"); // DELETE MEDIA FROM DATABASE $database->database_query("DELETE FROM se_media, se_mediacomments, se_mediatags USING se_media 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_media.media_id ='{$delete}'"); } } 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(); } } } ?>
database_query("SELECT * FROM se_media WHERE media_album_id='".$database->database_real_escape_string($album_id)."'"); while($row=$database->database_fetch_array($query)) { ?>
" />" />

&task=delete&album_id=&user_id=" onclick="return confirm('Are you sure you want to delete this picture?');">Delete