200 lines
10 KiB
PHP
200 lines
10 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: user_group_edit.php 42 2009-01-29 04:55:14Z john $ */
|
||
|
|
|
||
|
|
$page = "editgroupphotos";
|
||
|
|
include "header.php";
|
||
|
|
|
||
|
|
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 = 27; }
|
||
|
|
|
||
|
|
// ENSURE GROUPS ARE ENABLED FOR THIS USER
|
||
|
|
if( ~(int)$user->level_info['level_group_allow'] & 2 )
|
||
|
|
{
|
||
|
|
/* header("Location: user_home.php");
|
||
|
|
exit();*/
|
||
|
|
}
|
||
|
|
|
||
|
|
// INITIALIZE GROUP OBJECT
|
||
|
|
$group = new se_group($user->user_info[user_id], $group_id);
|
||
|
|
|
||
|
|
if( !$group->group_exists || $group->user_rank<=0 )
|
||
|
|
{
|
||
|
|
header("Location: user_group.php");
|
||
|
|
exit();
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// INITIALIZE VARIABLES
|
||
|
|
$is_error = 0;
|
||
|
|
$result = 0;
|
||
|
|
|
||
|
|
|
||
|
|
// DELETE PHOTO
|
||
|
|
if($task == "remove" && $group->groupowner_level_info['level_group_photo'] != 0) {
|
||
|
|
$group->group_photo_delete();
|
||
|
|
$group->group_lastupdate();
|
||
|
|
}
|
||
|
|
|
||
|
|
if($_POST["delete"]=="Delete Selected")
|
||
|
|
{
|
||
|
|
foreach($_POST["deleteid"] as $id)
|
||
|
|
{
|
||
|
|
|
||
|
|
// MAKE SURE MEDIA EXISTS
|
||
|
|
$media_query = $database->database_query("SELECT se_groupmedia.*, se_groupalbums.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_groupmedia LEFT JOIN se_groupalbums ON se_groupmedia.groupmedia_groupalbum_id=se_groupalbums.groupalbum_id LEFT JOIN se_users ON se_groupmedia.groupmedia_user_id WHERE se_groupmedia.groupmedia_id='{$id}' AND se_groupalbums.groupalbum_group_id='{$group->group_info['group_id']}' LIMIT 1");
|
||
|
|
|
||
|
|
$media_info = $database->database_fetch_assoc($media_query);
|
||
|
|
$media_array = Array();
|
||
|
|
$media_query = $database->database_query("SELECT groupmedia_id, groupmedia_ext, '{$group->group_info['group_id']}' AS groupalbum_group_id FROM se_groupmedia WHERE groupmedia_groupalbum_id='{$media_info['groupalbum_id']}' ORDER BY groupmedia_date DESC");
|
||
|
|
while($thismedia = $database->database_fetch_assoc($media_query)) { $media_array[$thismedia['groupmedia_id']] = $thismedia; }
|
||
|
|
|
||
|
|
$media_path = $group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id'].".".$media_info['groupmedia_ext'];
|
||
|
|
if(file_exists($media_path)) { @unlink($media_path); }
|
||
|
|
$thumb_path = $group->group_dir($group->group_info['group_id']).$media_info['groupmedia_id']."_thumb.".$media_info['groupmedia_ext'];
|
||
|
|
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.".$media_info['groupmedia_ext'];
|
||
|
|
|
||
|
|
// DELETE ACTION MEDIA IF NECESSARY
|
||
|
|
$database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'");
|
||
|
|
//echo "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");
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|
||
|
|
function editphotos()
|
||
|
|
{
|
||
|
|
global $group_id, $cpp, $p, $group, $database;
|
||
|
|
if($p==""){$p=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($groupalbum_info['groupalbum_id']);
|
||
|
|
|
||
|
|
$page_vars = make_page($total_files, $cpp, $p);
|
||
|
|
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
|
||
|
|
{
|
||
|
|
|
||
|
|
if(($page_vars[1]+10)==$x)
|
||
|
|
{break;}
|
||
|
|
$for[$y]=$x;
|
||
|
|
$y++;
|
||
|
|
}
|
||
|
|
$groupmedia_query = "SELECT se_groupmedia.*, se_groupalbums.groupalbum_id, se_groupalbums.groupalbum_group_id, se_groupalbums.groupalbum_title, count(se_groupmediacomments.groupmediacomment_id) AS total_comments";
|
||
|
|
|
||
|
|
// CONTINUE QUERY
|
||
|
|
$groupmedia_query .= " FROM se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmediacomments.groupmediacomment_groupmedia_id=se_groupmedia.groupmedia_id LEFT JOIN se_groupalbums ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id WHERE ";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
$groupmedia_query .= " se_groupalbums.groupalbum_group_id='{$group_id}' AND ";
|
||
|
|
// IF GROUP EXISTS, SPECIFY GROUP ID
|
||
|
|
$groupmedia_query .= " se_groupalbums.groupalbum_group_id='{$group_id}'";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
|
||
|
|
// ADD ADDITIONAL WHERE CLAUSE
|
||
|
|
|
||
|
|
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
|
||
|
|
$groupmedia_query .= " GROUP BY groupmedia_id ORDER BY groupmedia_id DESC LIMIT ".$page_vars[0].", ".$cpp;
|
||
|
|
//echo $groupmedia_query;
|
||
|
|
$query=$database->database_query($groupmedia_query);
|
||
|
|
$total_friends1=$database->database_num_rows($query);
|
||
|
|
?><div style="margin-left: auto; margin-right: auto;"><div style="text-align: center; margin-bottom: 10px;">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<? if($page_vars[2]> 1){?>
|
||
|
|
<div class='browse_pages'>
|
||
|
|
<? if($page_vars[1]!= 1){?><a href="editgroupphotos.php?group_id=<?=$group_id?>&p=1"><span class="white arrow">«</span></a> <a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
||
|
|
| <?
|
||
|
|
foreach($for as $foo){?>
|
||
|
|
<a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$foo?>"><?=$foo?></a>
|
||
|
|
<? }?> |
|
||
|
|
<? if($page_vars[1]!= $page_vars[2]){?><a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$p+1?>"><span class="white arrow">›</span></a> <a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$page_vars[2]?>"><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
||
|
|
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
|
||
|
|
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
|
||
|
|
<? }else{?>
|
||
|
|
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
|
||
|
|
|
||
|
|
<? }?></span><br />
|
||
|
|
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" /><input type="hidden" name="group_id" value="<?=$group_id?>" /><input type="submit" value="Go" /></form>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<? }?>
|
||
|
|
|
||
|
|
|
||
|
|
</div><div class="groupphotodeletecontainer"><?
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
?>
|
||
|
|
<div class="groupdelete"><a href="http://bateworld.com/group_album_file.php?group_id=<?=$group_id?>&groupmedia_id=<?=$row["groupmedia_id"]?>"><img src="<?=$group->group_dir().$row["groupmedia_id"].".".$row["groupmedia_ext"]?>" class="photo" border="0" width="90" height="90" style="float: left; margin: 3px;" alt="" title=""></a><br />
|
||
|
|
<input type="checkbox" name="deleteid[]" value="<?=$row["groupmedia_id"]?>" class="deletethis" /></div>
|
||
|
|
<?
|
||
|
|
}?></div><div style="clear: both;"></div>
|
||
|
|
<div style="text-align: center; margin-bottom: 10px;">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<? if($page_vars[2]> 1){?>
|
||
|
|
<div class='browse_pages'>
|
||
|
|
<? if($page_vars[1]!= 1){?><a href="editgroupphotos.php?group_id=<?=$group_id?>&p=1"><span class="white arrow">«</span></a> <a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$p-1?>" onclick="loadXMLDoc(<?=$p-1?>);"><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
||
|
|
| <?
|
||
|
|
foreach($for as $foo){?>
|
||
|
|
<a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$foo?>"><?=$foo?></a>
|
||
|
|
<? }?> |
|
||
|
|
<? if($page_vars[1]!= $page_vars[2]){?><a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$p+1?>"><span class="white arrow">›</span></a> <a href="editgroupphotos.php?group_id=<?=$group_id?>&p=<?=$page_vars[2]?>"><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
||
|
|
<br /><span style="font-weight:normal;"><? if(($page_vars[0]+1)==($page_vars[0]+$total_friends1)){?>
|
||
|
|
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
|
||
|
|
<? }else{?>
|
||
|
|
viewing results <?=$page_vars[0]+1?>-<?=$page_vars[0]+$total_friends1?> of <?=$total_files?>
|
||
|
|
|
||
|
|
<? }?></span><br />
|
||
|
|
<form method="get">Go to Page: <input type="text" name="p" id="p1" class="gotext" /><input type="hidden" name="group_id" value="<?=$group_id?>" /><input type="submit" value="Go" /></form>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<? }?>
|
||
|
|
|
||
|
|
|
||
|
|
</div><?
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// GET FIELDS
|
||
|
|
$field = new se_field("group", $group->groupvalue_info);
|
||
|
|
$field->cat_list(0, 0, 0, "", "", "");
|
||
|
|
$cat_array = $field->cats;
|
||
|
|
if($is_error != 0) {
|
||
|
|
$selected_cat_array = array_filter($cat_array, create_function('$a', 'if($a[cat_id] == "'.$group->group_info['group_groupcat_id'].'") { return $a; }'));
|
||
|
|
while(list($key, $val) = each($selected_cat_array)) {
|
||
|
|
$cat_array[$key][fields] = $selected_fields;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// GET SUBCAT IF NECESSARY
|
||
|
|
$thiscat = $database->database_fetch_assoc($database->database_query("SELECT groupcat_id, groupcat_dependency FROM se_groupcats WHERE groupcat_id='{$group->group_info['group_groupcat_id']}' LIMIT 1"));
|
||
|
|
if($thiscat['groupcat_dependency'] == 0) {
|
||
|
|
$group->group_info['group_groupsubcat_id'] = 0;
|
||
|
|
} else {
|
||
|
|
$group->group_info['group_groupsubcat_id'] = $group->group_info['group_groupcat_id'];
|
||
|
|
$group->group_info['group_groupcat_id'] = $thiscat['groupcat_dependency'];
|
||
|
|
}
|
||
|
|
|
||
|
|
// REMOVE BREAKS
|
||
|
|
$group->group_info['group_desc'] = str_replace("<br>", "\r\n", $group->group_info['group_desc']);
|
||
|
|
|
||
|
|
|
||
|
|
// ASSIGN VARIABLES AND SHOW USER EDIT GROUP PAGE
|
||
|
|
$smarty->assign('result', $result);
|
||
|
|
$smarty->assign('is_error', $is_error);
|
||
|
|
$smarty->assign('justadded', $justadded);
|
||
|
|
$smarty->assign('group', $group);
|
||
|
|
$smarty->assign('cats', $cat_array);
|
||
|
|
include "footer.php";
|
||
|
|
?>
|