Files
Testing/bwadmin/viewalbum.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

225 lines
8.4 KiB
PHP

<?php
/* $Id: user_group_edit.php 42 2009-01-29 04:55:14Z john $ */
$page = "admin_general1";
include "admin_header.php";
ini_set('display_errors', TRUE);
function general()
{
global $ads, $database;
?><a href="user_files.php?user_id=<?=$_GET["user_id"]?>">Back to Albums</a><br />
<br />
<?
global $database, $url;
if(isset($_POST['album_id'])) { $album_id = $_POST['album_id']; } elseif(isset($_GET['album_id'])) { $album_id = $_GET['album_id']; } else { $album_id = 0; }
if(isset($_POST['user_id'])) { $user_id = $_POST['user_id']; } elseif(isset($_GET['user_id'])) { $user_id = $_GET['user_id']; } else { $user_id = 0; }
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_POST['justadded'])) { $justadded = $_POST['justadded']; } elseif(isset($_GET['justadded'])) { $justadded = $_GET['justadded']; } else { $justadded = ""; }
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 = 1; }
chdir("..");
$user = new SEUser(Array($user_id));
//var_dump($user);
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
$album=new se_album($user_id);
// CREATE ALBUM OBJECT
// BE SURE ALBUM BELONGS TO THIS USER, DELETE ALBUM
if($task == "delete") {
$delete = $_GET["media_id"];
//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=="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 "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "window.parent.reorderAlbum('$album_info[album_id]', '$prev_info[album_id]');";
echo "</script></head><body></body></html>";
exit();
}
}
}
?><form method="post"><table><?
$query=$database->database_query("SELECT * FROM se_media WHERE media_album_id='".$database->database_real_escape_string($album_id)."'");
while($row=$database->database_fetch_array($query))
{
?><tr><td valign="top"><input type="checkbox" name="imagedelete[]" value="<?=$row["media_id"]?>" /></td><td><img src="../<?=$url->url_userdir($user->user_info['user_id'])?><?=$row["media_id"].".".$row["media_ext"]?>" /><br />
<br />
</td><td valign="top">
<a href="viewalbum.php?media_id=<?=$row["media_id"]?>&task=delete&album_id=<?=$album_id?>&user_id=<?=$user_id?>" onclick="return confirm('Are you sure you want to delete this picture?');">Delete</a></td></td></tr>
<?
}?>
<tr><td>
<input type="hidden" name="task" value="deletemultiple" />
<input type="submit" value="Delete" name="delete" />
</td></tr></table>
</form>
<?
}
include "admin_footer.php";
?>