221 lines
10 KiB
PHP
221 lines
10 KiB
PHP
<?php
|
|
|
|
/* $Id: user_group_edit.php 42 2009-01-29 04:55:14Z john $ */
|
|
|
|
$page = "editgroupvideos";
|
|
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($_POST["delete"]=="Delete Selected")
|
|
{
|
|
foreach($_POST["deleteid"] as $id)
|
|
{
|
|
|
|
// MAKE SURE MEDIA EXISTS
|
|
$media_query = $database->database_query("SELECT * FROM se_group_videos WHERE se_group_videos.video_id='{$id}' AND se_group_videos.video_group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|
|
|
$media_info = $database->database_fetch_assoc($media_query);
|
|
|
|
$media_path = $group->group_dir($group->group_info['group_id'])."video_".$media_info['video_id'].".mp4";
|
|
if(file_exists($media_path)) { @unlink($media_path); }
|
|
$thumb_path = $group->group_dir($group->group_info['group_id'])."video_".$media_info['video_id']."_thumb.jpg";
|
|
if(file_exists($thumb_path)) { @unlink($thumb_path); }
|
|
|
|
|
|
//echo "DELETE FROM se_actionmedia WHERE actionmedia_path = '{$action_thumb_path}'";
|
|
// DELETE MEDIA FROM DATABASE
|
|
|
|
$database->database_query("DELETE FROM se_group_videos, groupvideocomments USING se_group_videos LEFT JOIN groupvideocomments ON se_group_videos.video_id=groupvideocomments.object_id WHERE se_group_videos.video_id='{$media_info['video_id']}'");
|
|
|
|
|
|
}
|
|
}
|
|
|
|
if( $task == "resize" )
|
|
{
|
|
|
|
if(isset($_POST['video_id'])) { $video_id = $_POST['video_id']; } elseif(isset($_GET['video_id'])) { $video_id = $_GET['video_id']; } else { $video_id = "1"; }
|
|
if(isset($_POST['resize'])) { $resize = $_POST['resize']; } elseif(isset($_GET['resize'])) { $resize = $_GET['resize']; } else { $resize = "1"; }
|
|
if($resize!=1||$resize!=2){$resize=1;}
|
|
|
|
// MAKE SURE SUBMITTED PRIVACY OPTIONS ARE ALLOWED, IF NOT, SET TO EVERYONE
|
|
if(!in_array($video_privacy, $level_video_privacy)) { $video_privacy = $level_video_privacy[0]; }
|
|
if(!in_array($video_comments, $level_video_comments)) { $video_comments = $level_video_comments[0]; }
|
|
|
|
$database->database_query("UPDATE se_group_videos SET resize='{$resize}' WHERE video_id='$video_id' AND video_group_id='{$group->group_info['group_id']}'");
|
|
$smarty->assign('task1', "resize");
|
|
|
|
}
|
|
|
|
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++;
|
|
}
|
|
|
|
$query=$database->database_query("SELECT se_group_videos.group_video_id FROM se_group_videos WHERE se_group_videos.video_group_id='{$group_id}' AND video_admin_approved=1");
|
|
$total_files=$database->database_num_rows($query);
|
|
|
|
|
|
$groupmedia_query = "SELECT se_group_videos.*, count(groupvideocomments.id) AS total_comments";
|
|
|
|
// CONTINUE QUERY
|
|
$groupmedia_query .= " FROM se_group_videos LEFT JOIN groupvideocomments ON groupvideocomments.object_id=se_group_videos.video_id WHERE ";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
$groupmedia_query .= " se_group_videos.video_group_id='{$group_id}' AND video_admin_approved=1 ";
|
|
// IF GROUP EXISTS, SPECIFY GROUP ID
|
|
|
|
// ADD AND IF NECESSARY
|
|
|
|
// ADD ADDITIONAL WHERE CLAUSE
|
|
|
|
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
|
|
$groupmedia_query .= " GROUP BY video_id ORDER BY video_id DESC LIMIT ".$page_vars[0].", ".$cpp;
|
|
//if(SE_DEBUG){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="editgroupvideos.php?group_id=<?=$group_id?>&p=1"><span class="white arrow">«</span></a> <a href="editgroupvideos.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="editgroupvideos.php?group_id=<?=$group_id?>&p=<?=$foo?>"><?=$foo?></a>
|
|
<? }?> |
|
|
<? if($page_vars[1]!= $page_vars[2]){?><a href="editgroupvideos.php?group_id=<?=$group_id?>&p=<?=$p+1?>"><span class="white arrow">›</span></a> <a href="editgroupvideos.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/video_group.php?group_id=<?=$group_id?>&video_id=<?=$row["video_id"]?>"><img src="<?=$group->group_dir()."/video_".$row["video_id"]."_thumb.jpg"?>" class="photo" border="0" width="90" height="90" style="float: left; margin: 3px;" alt="" title=""></a><br />
|
|
|
|
<a href='editgroupvideos.php?task=resize&resize=1&video_id=<?=$row["video_id"]?>&group_id=<?=$group_id?>' onClick="return confirm('Are you sure you want to resize this video horizontally?');"><!--<img src='./images/icons/video_delete16.gif' border='0' class='button' />-->Resize Video Horizontally</a>
|
|
|
|
<br><br>
|
|
|
|
|
|
<a href='editgroupvideos.php?task=resize&resize=2&video_id=<?=$row["video_id"]?>&group_id=<?=$group_id?>' onClick="return confirm('Are you sure you want to resize this video vertically?');"><!--<img src='./images/icons/video_delete16.gif' border='0' class='button' />-->Resize Video Vertically</a>
|
|
<br>
|
|
<br>
|
|
|
|
<input type="checkbox" name="deleteid[]" value="<?=$row["video_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="editgroupvideos.php?group_id=<?=$group_id?>&p=1"><span class="white arrow">«</span></a> <a href="editgroupvideos.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="editgroupvideos.php?group_id=<?=$group_id?>&p=<?=$foo?>"><?=$foo?></a>
|
|
<? }?> |
|
|
<? if($page_vars[1]!= $page_vars[2]){?><a href="editgroupvideos.php?group_id=<?=$group_id?>&p=<?=$p+1?>"><span class="white arrow">›</span></a> <a href="editgroupvideos.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";
|
|
?>
|