Files
Testing/batemin/group_files1.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

119 lines
6.0 KiB
PHP

<?php
/* $Id: user_group_edit.php 42 2009-01-29 04:55:14Z john $ */
$page = "admin_general1";
include "../admin/admin_header.php";
ini_set('display_errors', TRUE);
function general()
{
global $database;
if(isset($_POST['group_id'])) { $group_id = $_POST['group_id']; } elseif(isset($_GET['group_id'])) { $group_id = $_GET['group_id']; } else { $group_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("..");
$group = new se_group($user->user_info[user_id], $group_id);
//var_dump($group);
if($task=="delete")
{
$query=mysql_query("SELECT * FROM se_groupmedia WHERE groupmedia_id='".mysql_real_escape_string($_GET["media_id"])."'");
$media_info=mysql_fetch_array($query);
$media_path = $group->group_dir($group_id).$media_info['groupmedia_id'].".".$media_info['groupmedia_ext'];
// echo $media_path;
if(file_exists("../".$media_path)) { unlink("../".$media_path); }
$thumb_path = $group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id']."_thumb.jpg";
if(file_exists("../".$thumb_path)) { unlink("../".$thumb_path); }
$action_thumb_path = $url->url_base.substr($group->group_dir($group->group_info['group_id']), 2).$media_info['groupmedia_id']."_thumb.jpg";
// DELETE ACTION MEDIA IF NECESSARY
$database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'") or die(mysql_error());
// DELETE MEDIA FROM DATABASE
$database->database_query("DELETE FROM se_groupmedia, se_groupmediacomments, se_groupmediatags USING se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmedia.groupmedia_id=se_groupmediacomments.groupmediacomment_groupmedia_id LEFT JOIN se_groupmediatags ON se_groupmedia.groupmedia_id=se_groupmediatags.groupmediatag_groupmedia_id WHERE se_groupmedia.groupmedia_id='{$media_info['groupmedia_id']}'") or die(mysql_error());
// UPDATE CACHED TOTALS
$database->database_query("UPDATE se_groupalbums SET groupalbum_totalfiles=groupalbum_totalfiles-1, groupalbum_totalspace=groupalbum_totalspace-'{$media_info['groupmedia_filesize']}' WHERE groupalbum_id='{$media_info['groupmedia_groupalbum_id']}' LIMIT 1") or die(mysql_error());
// SEND USER TO NEXT PHOTO
//$media_keys = array_keys($media_array);
//$current_index = array_search($media_info[groupmedia_id], $media_keys);
//if($current_index+1 == count($media_array)) { $next_index = 0; } else { $next_index = $current_index+1; }
//header("Location: ".$url->url_create('group_media', NULL, $group->group_info['group_id'], $media_keys[$next_index]));
//exit();
}
if($task=="deletemultiple")
{
foreach($_POST["delete"] as $pic){
$query=mysql_query("SELECT * FROM se_groupmedia WHERE groupmedia_id='".mysql_real_escape_string($pic)."'");
$media_info=mysql_fetch_array($query);
$media_path = $group->group_dir($group_id).$pic.".".$media_info['groupmedia_ext'];
// echo $media_path;
if(file_exists("../".$media_path)) { unlink("../".$media_path); }
$thumb_path = $group->group_dir($group->group_info['group_id']).$pic."_thumb.jpg";
if(file_exists("../".$thumb_path)) { unlink("../".$thumb_path); }
$action_thumb_path = $url->url_base.substr($group->group_dir($group->group_info['group_id']), 2).$pic."_thumb.jpg";
echo "DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'";
// DELETE ACTION MEDIA IF NECESSARY
$database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'") or die(mysql_error());
// DELETE MEDIA FROM DATABASE
$database->database_query("DELETE FROM se_groupmedia, se_groupmediacomments, se_groupmediatags USING se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmedia.groupmedia_id=se_groupmediacomments.groupmediacomment_groupmedia_id LEFT JOIN se_groupmediatags ON se_groupmedia.groupmedia_id=se_groupmediatags.groupmediatag_groupmedia_id WHERE se_groupmedia.groupmedia_id='{$pic}'") or die(mysql_error());
// UPDATE CACHED TOTALS
$database->database_query("UPDATE se_groupalbums SET groupalbum_totalfiles=groupalbum_totalfiles-1, groupalbum_totalspace=groupalbum_totalspace-'{$media_info['groupmedia_filesize']}' WHERE groupalbum_id='{$media_info['groupmedia_groupalbum_id']}' LIMIT 1") or die(mysql_error());
}
}
$groupalbum_info = $database->database_fetch_assoc($database->database_query("SELECT groupalbum_id FROM se_groupalbums WHERE groupalbum_group_id='{$group->group_info['group_id']}' LIMIT 1"));
$total_files = $group->group_media_total($group_id);
?><a href="../admin/admin_viewgroups.php">Back to Groups</a><br />
<br /><form method="post">
<?
// MAKE FILE PAGES AND GET FILE ARRAY
$page_vars = make_page($total_files, $cpp, $p);
$group_files = $group->group_media_list($page_vars[0], $cpp, $sort_by = "groupmedia_date DESC", $where = "");
$query=mysql_query("SELECT * FROM se_groupalbums, se_groupmedia WHERE groupmedia_groupalbum_id=groupalbum_id AND groupalbum_group_id='{$group_id}'");
while($row=mysql_fetch_array($query))
{
?>
<img class='photo' src='../<?=$group->group_dir($group_id)?><?=$row["groupmedia_id"]?>.<?=$row["groupmedia_ext"]?>' border='0' />
<br />
<input type="checkbox" name="delete[]" value="<?=$row["groupmedia_id"]?>" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="../admin/group_files.php?media_id=<?=$row["groupmedia_id"]?>&task=delete&group_id=<?=$group_id?>" onclick="return confirm('Are you sure?');">Delete</a><br /><br />
<?
}?>
<input type="hidden" name="task" value="deletemultiple" />
<input type="submit" value="Delete" /></form><?php
}
include "../admin/admin_footer.php";
?>