119 lines
6.0 KiB
PHP
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_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=$database->database_query("SELECT * FROM se_groupmedia WHERE groupmedia_id='".$database->database_real_escape_string($_GET["media_id"])."'");
|
||
|
|
$media_info=$database->database_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}'");
|
||
|
|
|
||
|
|
// 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']}'");
|
||
|
|
|
||
|
|
// 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");
|
||
|
|
|
||
|
|
// 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=$database->database_query("SELECT * FROM se_groupmedia WHERE groupmedia_id='".$database->database_real_escape_string($pic)."'");
|
||
|
|
$media_info=$database->database_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}'");
|
||
|
|
|
||
|
|
// 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}'");
|
||
|
|
|
||
|
|
// 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");
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$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_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=$database->database_query("SELECT * FROM se_groupalbums, se_groupmedia WHERE groupmedia_groupalbum_id=groupalbum_id AND groupalbum_group_id='{$group_id}'");
|
||
|
|
while($row=$database->database_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"]?>" /> <a href="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_footer.php";
|
||
|
|
?>
|