469 lines
22 KiB
PHP
469 lines
22 KiB
PHP
|
|
<?php
|
|||
|
|
|
|||
|
|
/* $Id: group.php 69 2009-02-26 01:22:42Z szerrade $ */
|
|||
|
|
|
|||
|
|
|
|||
|
|
$page = "group";
|
|||
|
|
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 = ""; }
|
|||
|
|
if(isset($_POST['media_id'])) { $media_id = $_POST['media_id']; } elseif(isset($_GET['media_id'])) { $media_id = $_GET['media_id']; } else { $media_id = ""; }
|
|||
|
|
|
|||
|
|
if($task=="make_photo")
|
|||
|
|
{
|
|||
|
|
$media_query = $database->database_query("SELECT se_groupmedia.*, se_groupalbums.*, se_groups.group_id FROM se_groupmedia LEFT JOIN se_groupalbums ON se_groupmedia.groupmedia_groupalbum_id=se_groupalbums.groupalbum_id LEFT JOIN se_groups ON se_groupalbums.groupalbum_group_id=se_groups.group_id WHERE se_groupmedia.groupmedia_id='".$database->database_real_escape_string($media_id)."' AND se_groupalbums.groupalbum_group_id='".$database->database_real_escape_string($group_id)."' AND se_groups.group_user_id='".$user->user_info["user_id"]."' LIMIT 1");
|
|||
|
|
if($database->database_num_rows($media_query)>0)
|
|||
|
|
{
|
|||
|
|
$row=$database->database_fetch_array($media_query);
|
|||
|
|
$database->database_query("UPDATE se_groups SET group_photo='".$row["groupmedia_id"].".".$row["groupmedia_ext"]."' WHERE group_id='".$database->database_real_escape_string($group_id)."' AND se_groups.group_user_id='".$user->user_info["user_id"]."' LIMIT 1");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$group = new se_group($user->user_info['user_id'], $group_id);
|
|||
|
|
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
|
|||
|
|
if($group->group_info["group_user_id"]!=$user->user_info["user_id"]){
|
|||
|
|
if( (!$user->user_exists && !$setting['setting_permission_group']) || ($user->user_exists && (~(int)$user->level_info['level_group_allow'] & 1)) )
|
|||
|
|
{
|
|||
|
|
$page = "error";
|
|||
|
|
$smarty->assign('error_header', "");
|
|||
|
|
$smarty->assign('error_message', 656);
|
|||
|
|
$smarty->assign('error_submit', 641);
|
|||
|
|
include "footer.php";
|
|||
|
|
}}
|
|||
|
|
|
|||
|
|
// DISPLAY ERROR PAGE IF NO OWNER
|
|||
|
|
|
|||
|
|
if( !$group->group_exists )
|
|||
|
|
{
|
|||
|
|
$page = "error";
|
|||
|
|
$smarty->assign('error_header', "");
|
|||
|
|
$smarty->assign('error_message', 2000219);
|
|||
|
|
$smarty->assign('error_submit', 641);
|
|||
|
|
include "footer.php";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// GET VIEW AND VARS
|
|||
|
|
if(isset($_POST['v'])) { $v = $_POST['v']; } elseif(isset($_GET['v'])) { $v = $_GET['v']; } else { $v = "group"; }
|
|||
|
|
if(isset($_POST['search'])) { $search = $_POST['search']; } elseif(isset($_GET['search'])) { $search = $_GET['search']; } else { $search = ""; }
|
|||
|
|
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = ""; }
|
|||
|
|
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
|
|||
|
|
|
|||
|
|
|
|||
|
|
if($task=="adopt"&&$group->group_info['adoption']==1)
|
|||
|
|
{
|
|||
|
|
$database->database_query("UPDATE se_groups SET group_user_id='".$user->user_info["user_id"]."', adoption=0 WHERE group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
$database->database_query("UPDATE se_groupmembers SET groupmember_rank='0' WHERE groupmember_rank='2' AND groupmember_group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
$database->database_query("UPDATE se_groupmembers SET groupmember_rank='2' WHERE groupmember_user_id='".$user->user_info["user_id"]."' AND groupmember_group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
$group->group_info['group_user_id']=$user->user_info["user_id"];
|
|||
|
|
|
|||
|
|
$user1=new SEUser(array("390124"));
|
|||
|
|
$to = $user->user_info["user_username"];
|
|||
|
|
$subject = "Congratulations on Adopting a Group";
|
|||
|
|
$message = "Congratulations on becoming the new leader of this group! Please take a look at the <a href=\"https://support.bateworld.com/KnowledgeBase/Folder/3ZEiI9FXCR8saX_XflRwZAN_pQPQA2g0EQxaoZLxqc01?folderId=Yc3OykdFEG_nufs-9bbpKwN_pQPQA2g0EQxaoZLxqc01\" target=\"_blank\">Groups & Group Media FAQ</a> for some helpful information about how groups operate. Remember that BateWorld is a masturbation community, and masturbation should be the focus of your group. As a group leader it’s your responsibility to ensure that all members of your group adhere to <a href=\"https://bateworld.com/community-guidelines/\" target=\"_blank\">BateWorld Community Guidelines</a> and that any uploads comply with the <a href=\"https://bateworld.com/terms-of-service/\" target=\"_blank\">BateWorld Terms of Service</a> and feature only Verified members.
|
|||
|
|
|
|||
|
|
|
|||
|
|
Some tips to get you started with fluffing up your newly adopted group:
|
|||
|
|
|
|||
|
|
- Have a look at older Discussions and delete anything that no longer seems relevant.
|
|||
|
|
|
|||
|
|
- Take a minute to page through your new group Photos and Videos. If you see files that violate the BateWorld TOS, please delete them.
|
|||
|
|
|
|||
|
|
|
|||
|
|
If you have any questions, get in touch with the <a href=\"https://support.bateworld.com/Tickets/Create\" target=\"_blank\">BateWorld Admin Team</a>. We will be happy to help.";
|
|||
|
|
|
|||
|
|
|
|||
|
|
$user1->user_message_send_mail_admin($to, $subject, $message);
|
|||
|
|
|
|||
|
|
header("Location: group.php?group_id=".$group_id);
|
|||
|
|
exit;
|
|||
|
|
}
|
|||
|
|
if($task=="upforadopt"&&$group->group_info['group_user_id']==$user->user_info["user_id"])
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
$database->database_query("UPDATE se_groups SET adoption=1, group_user_id='' WHERE group_id='{$group->group_info['group_id']}' AND group_user_id='".$user->user_info["user_id"]."' LIMIT 1");
|
|||
|
|
$database->database_query("UPDATE se_groupmembers SET groupmember_rank='0' WHERE groupmember_rank='2' AND groupmember_group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
$group->group_info['group_user_id']=$user->user_info["user_id"];
|
|||
|
|
$group->group_info['adoption']=1;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
// VALIDATE VIEW VAR
|
|||
|
|
if($v != "group" && $v != "members" && $v != "comments" && $v != "photos" && $v != "discussions" && $v != "videos") { $v = "group"; }
|
|||
|
|
|
|||
|
|
|
|||
|
|
// DELETE DISCUSSION TOPIC
|
|||
|
|
if( $task == "topic_delete" && ($group->user_rank == 2 || $group->user_rank == 1) )
|
|||
|
|
{
|
|||
|
|
$grouptopic_id = $_GET['grouptopic_id'];
|
|||
|
|
$resource = $database->database_query("SELECT NULL FROM se_grouptopics WHERE se_grouptopics.grouptopic_id='{$grouptopic_id}' LIMIT 1");
|
|||
|
|
|
|||
|
|
if( $database->database_num_rows($resource) )
|
|||
|
|
{
|
|||
|
|
$database->database_query("DELETE FROM se_grouptopics WHERE se_grouptopics.grouptopic_id='{$grouptopic_id}' LIMIT 1");
|
|||
|
|
$database->database_query("DELETE FROM se_groupposts WHERE se_groupposts.grouppost_grouptopic_id='{$grouptopic_id}' LIMIT 1");
|
|||
|
|
$database->database_query("UPDATE se_groups SET group_totaltopics=group_totaltopics-1 WHERE group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
$group->group_info['group_totaltopics']--;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
// RETRIEVE FILES
|
|||
|
|
elseif($task == "files_get")
|
|||
|
|
{
|
|||
|
|
// GET VARS
|
|||
|
|
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; }
|
|||
|
|
|
|||
|
|
// GET GROUP ALBUM INFO
|
|||
|
|
$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"));
|
|||
|
|
|
|||
|
|
// GET TOTAL FILES
|
|||
|
|
$total_files = $group->group_media_total($groupalbum_info['groupalbum_id']);
|
|||
|
|
|
|||
|
|
// 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 = "");
|
|||
|
|
|
|||
|
|
|
|||
|
|
// CONSTRUCT JSON RESPONSE
|
|||
|
|
$file_output = Array('total_files' => (int) $total_files,
|
|||
|
|
'maxpage' => (int) $page_vars[2],
|
|||
|
|
'p_start' => (int) ($page_vars[0]+1),
|
|||
|
|
'p_end' => (int) ($page_vars[0]+count($group_files)),
|
|||
|
|
'p' => (int) $page_vars[1],
|
|||
|
|
'files' => $group_files);
|
|||
|
|
echo json_encode($file_output);
|
|||
|
|
exit();
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// GET PRIVACY LEVEL
|
|||
|
|
$privacy_max = $group->group_privacy_max($user);
|
|||
|
|
$allowed_to_view = (bool) ($privacy_max & $group->group_info['group_privacy']);
|
|||
|
|
$is_group_private = !$allowed_to_view;
|
|||
|
|
|
|||
|
|
// CHECK IF USER IS ALLOWED TO COMMENT
|
|||
|
|
$allowed_to_comment = (bool) ($privacy_max & $group->group_info['group_comments']);
|
|||
|
|
|
|||
|
|
// CHECK IF USER IS ALLOWED TO POST IN DISCUSSION
|
|||
|
|
$allowed_to_discuss = (bool) ($privacy_max & $group->group_info['group_discussion']);
|
|||
|
|
|
|||
|
|
// CHECK IF USER IS ALLOWED TO UPLOAD PHOTOS
|
|||
|
|
$allowed_to_upload = (bool) ($privacy_max & $group->group_info['group_upload']);
|
|||
|
|
|
|||
|
|
// CHECK IF USER IS ALLOWED TO INVITE MEMBERS
|
|||
|
|
$allowed_to_invite = (bool) ( $group->user_rank>=1 || ($group->user_rank>-1 && $group->group_info['group_invite']) );
|
|||
|
|
|
|||
|
|
|
|||
|
|
// UPDATE GROUP VIEWS IF GROUP VISIBLE
|
|||
|
|
if( $allowed_to_view )
|
|||
|
|
{
|
|||
|
|
$group_views = $group->group_info['group_views'] + 1;
|
|||
|
|
$database->database_query("UPDATE se_groups SET group_views=group_views+1 WHERE group_id='{$group->group_info['group_id']}' LIMIT 1");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// DELETE COMMENT NOTIFICATIONS IF VIEWING COMMENT PAGE
|
|||
|
|
if( /* $v == "discussions" && */ $user->user_info['user_id'] == $group->group_info['group_user_id'] )
|
|||
|
|
{
|
|||
|
|
//$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupcomment' AND notify_object_id='{$group->group_info['group_id']}'");
|
|||
|
|
|
|||
|
|
$database->database_query("UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupcomment' AND notify_object_id='{$group->group_info['group_id']}'");
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// DELETE POST NOTIFICATIONS IF VIEWING DISCUSSION PAGE
|
|||
|
|
if( /* $v == "discussions" && */ $user->user_info['user_id'] == $group->group_info['group_user_id'] )
|
|||
|
|
{
|
|||
|
|
//$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='grouppost' AND notify_object_id='{$group->group_info['group_id']}'");
|
|||
|
|
|
|||
|
|
$database->database_query("UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='grouppost' AND notify_object_id='{$group->group_info['group_id']}'");
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// GET GROUP COMMENTS
|
|||
|
|
|
|||
|
|
$comment = new se_comment('group', 'group_id', $group->group_info['group_id']);
|
|||
|
|
$total_comments = $comment->comment_total();
|
|||
|
|
|
|||
|
|
// GET GROUP MEDIA
|
|||
|
|
$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]);
|
|||
|
|
|
|||
|
|
// GET GROUP FIELDS
|
|||
|
|
$groupcat_info = $database->database_fetch_assoc($database->database_query("SELECT t1.groupcat_id AS subcat_id, t1.groupcat_title AS subcat_title, t1.groupcat_dependency AS subcat_dependency, t2.groupcat_id AS cat_id, t2.groupcat_title AS cat_title FROM se_groupcats AS t1 LEFT JOIN se_groupcats AS t2 ON t1.groupcat_dependency=t2.groupcat_id WHERE t1.groupcat_id='{$group->group_info['group_groupcat_id']}'"));
|
|||
|
|
if($groupcat_info['subcat_dependency'] == 0) { $cat_where = "groupcat_id='{$group->group_info['group_groupcat_id']}'"; } else { $cat_where = "groupcat_id='{$groupcat_info['subcat_dependency']}'"; }
|
|||
|
|
$field = new se_field("group", $group->groupvalue_info);
|
|||
|
|
$field->cat_list(0, 1, 0, $cat_where, "groupcat_id='0'", "");
|
|||
|
|
|
|||
|
|
// SET WHERE CLAUSE FOR MEMBER LIST
|
|||
|
|
$where[] = "(se_groupmembers.groupmember_status='1')";
|
|||
|
|
if($search != "") { $where[] = "(se_users.user_username LIKE '{$search}%')";}// OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search}%' OR se_users.user_email LIKE '%{$search}%')"; }
|
|||
|
|
|
|||
|
|
// GET TOTAL MEMBERS
|
|||
|
|
$total_members = $group->group_member_total(implode(" AND ", $where), 1);
|
|||
|
|
|
|||
|
|
// MAKE MEMBER PAGES AND GET MEMBER ARRAY
|
|||
|
|
$members_per_page = 10;
|
|||
|
|
if($v == "members") { $p_members = $p; } else { $p_members = 1; }
|
|||
|
|
$page_vars_members = make_page($total_members, $members_per_page, $p_members);
|
|||
|
|
|
|||
|
|
|
|||
|
|
if($_GET["order"]=="username"){
|
|||
|
|
$members = $group->group_member_list($page_vars_members[0], $members_per_page, "se_users.user_username", implode(" AND ", $where));
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
elseif($_GET["order"]=="recent"){
|
|||
|
|
$members = $group->group_member_list($page_vars_members[0], $members_per_page, "groupmember_id DESC", implode(" AND ", $where));
|
|||
|
|
}
|
|||
|
|
else{
|
|||
|
|
$members = $group->group_member_list($page_vars_members[0], $members_per_page, "se_users.online DESC, se_users.user_username ASC", implode(" AND ", $where));
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
for($x=$page_vars_members[1]; $x<=$page_vars_members[2]; $x++)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if(($page_vars_members[1]+10)==$x)
|
|||
|
|
{break;}
|
|||
|
|
$for[$y]=$x;
|
|||
|
|
$y++;
|
|||
|
|
}
|
|||
|
|
// GET MASTER TOTAL OF MEMBERS
|
|||
|
|
$total_members_all = $group->group_member_total("(se_groupmembers.groupmember_status='1')");
|
|||
|
|
|
|||
|
|
// GET OFFICERS
|
|||
|
|
$where_officers = "se_groupmembers.groupmember_rank<>'0' AND se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'";
|
|||
|
|
$total_officers = $group->group_member_total($where_officers, 0);
|
|||
|
|
$officers = $group->group_member_list(0, $total_officers, "se_groupmembers.groupmember_rank DESC, se_users.user_username", $where_officers);
|
|||
|
|
|
|||
|
|
// CHECK TO SEE IF USER IS SUBSCRIBED TO GROUP AND UPDATE VIEW TIME
|
|||
|
|
if($database->database_num_rows($database->database_query("SELECT NULL FROM se_groupsubscribes WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}' LIMIT 1")) == 1) {
|
|||
|
|
$is_subscribed = 1;
|
|||
|
|
$database->database_query("UPDATE se_groupsubscribes SET groupsubscribe_time='".time()."' WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}'");
|
|||
|
|
} else {
|
|||
|
|
$is_subscribed = 0;
|
|||
|
|
}
|
|||
|
|
// GET TOTAL DISCUSSION TOPICS
|
|||
|
|
$total_topics = $group->group_topic_total();
|
|||
|
|
// MAKE TOPIC PAGES AND GET TOPIC ARRAY
|
|||
|
|
$topics_per_page = 10;
|
|||
|
|
if($v == "discussions") { $p_topics = $p; } else { $p_topics = 1; }
|
|||
|
|
$page_vars_topics = make_page($total_topics, $topics_per_page, $p_topics);
|
|||
|
|
$topics = $group->group_topic_list($page_vars_topics[0], $topics_per_page, "grouptopic_sticky DESC, grouppost_date DESC");
|
|||
|
|
//$topics = $group->group_topic_list($page_vars_topics[0], $topics_per_page, "grouptopic_sticky DESC, grouptopic_date DESC");
|
|||
|
|
for($x1=$page_vars_topics[1]; $x1<=$page_vars_topics[2]; $x1++)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if(($page_vars_topics[1]+10)==$x1)
|
|||
|
|
{break;}
|
|||
|
|
$for1[$y1]=$x1;
|
|||
|
|
$y1++;
|
|||
|
|
}
|
|||
|
|
// GET CUSTOM GROUP STYLE IF ALLOWED
|
|||
|
|
if( $group->groupowner_level_info['level_group_style'] && !$is_group_private )
|
|||
|
|
{
|
|||
|
|
$groupstyle_info = $database->database_fetch_assoc($database->database_query("SELECT groupstyle_css FROM se_groupstyles WHERE groupstyle_group_id='{$group->group_info['group_id']}' LIMIT 1"));
|
|||
|
|
$global_css = $groupstyle_info['groupstyle_css'];
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// SET GLOBAL PAGE TITLE
|
|||
|
|
$global_page_title[0] = 2000312;
|
|||
|
|
$global_page_title[1] = $group->group_info['group_title'];
|
|||
|
|
$global_page_description[0] = 2000313;
|
|||
|
|
$global_page_description[1] = $group->group_info['group_desc'];
|
|||
|
|
|
|||
|
|
|
|||
|
|
// ENSURE SORT/VIEW ARE VALID
|
|||
|
|
if($s != "video_datecreated DESC" && $s != "video_views DESC" && $s != "video_cache_rating_weighted DESC") { $s = "video_dateupdated DESC"; }
|
|||
|
|
//if($v != "0" && $v != "1") { $v = 0; }
|
|||
|
|
|
|||
|
|
|
|||
|
|
// SET WHERE CLAUSE
|
|||
|
|
/*$where = "video_search='1' AND video_is_converted='1' AND
|
|||
|
|
(CASE
|
|||
|
|
WHEN se_group_videos.video_user_id='{$user->user_info['user_id']}'
|
|||
|
|
THEN TRUE
|
|||
|
|
WHEN ((se_group_videos.video_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
|
|||
|
|
THEN TRUE
|
|||
|
|
WHEN ((se_group_videos.video_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
|
|||
|
|
THEN TRUE
|
|||
|
|
WHEN ((se_group_videos.video_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_group_videos.video_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
|
|||
|
|
THEN TRUE
|
|||
|
|
WHEN ((se_group_videos.video_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_group_videos.video_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))
|
|||
|
|
THEN TRUE
|
|||
|
|
WHEN ((se_group_videos.video_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_group_videos.video_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))
|
|||
|
|
THEN TRUE
|
|||
|
|
ELSE FALSE
|
|||
|
|
END)";
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
// ONLY MY FRIENDS' VIDEOS
|
|||
|
|
if($v == "1" && $user->user_exists) {
|
|||
|
|
|
|||
|
|
// SET WHERE CLAUSE
|
|||
|
|
//$where .= " AND (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$user->user_info['user_id']}' AND friend_user_id2=se_group_videos.video_user_id AND friend_status=1)";
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
// CREATE VIDEO OBJECT
|
|||
|
|
$video = new se_video();
|
|||
|
|
|
|||
|
|
// GET TOTAL VIDEOS
|
|||
|
|
$total_videos = $video->group_video_total($group_id);
|
|||
|
|
|
|||
|
|
// MAKE ENTRY PAGES
|
|||
|
|
$videos_per_page =50;
|
|||
|
|
$page_vars = make_page($total_videos, $videos_per_page, $p);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
// GET VIDEO ARRAY
|
|||
|
|
$video_array = $video->group_video_list($page_vars[0], $videos_per_page, $s, $group_id, 1);
|
|||
|
|
|
|||
|
|
|
|||
|
|
for($x3=$page_vars[1]; $x3<=$page_vars[2]; $x3++)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if(($page_vars[1]+10)==$x3)
|
|||
|
|
{break;}
|
|||
|
|
$for3[$y3]=$x3;
|
|||
|
|
$y3++;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
// GET VARS
|
|||
|
|
$cpp=18;
|
|||
|
|
|
|||
|
|
// GET GROUP ALBUM INFO
|
|||
|
|
$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"));
|
|||
|
|
|
|||
|
|
// GET TOTAL FILES
|
|||
|
|
$total_files = $group->group_media_total($groupalbum_info['groupalbum_id']);
|
|||
|
|
|
|||
|
|
// MAKE FILE PAGES AND GET FILE ARRAY
|
|||
|
|
|
|||
|
|
if($v == "photos") { $p_files = $p; } else { $p_files = 1; }
|
|||
|
|
|
|||
|
|
$page_vars_pics = make_page($total_files, $cpp, $p_files);
|
|||
|
|
$group_files = $group->group_media_list($page_vars_pics[0], $cpp, $sort_by = "groupmedia_date DESC", $where = "");
|
|||
|
|
|
|||
|
|
for($x2=$page_vars_pics[1]; $x2<=$page_vars_pics[2]; $x2++)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if(($page_vars_pics[1]+10)==$x2)
|
|||
|
|
{break;}
|
|||
|
|
$for2[$y2]=$x2;
|
|||
|
|
$y2++;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
// CONSTRUCT JSON RESPONSE
|
|||
|
|
$file_output = Array('total_files' => (int) $total_files,
|
|||
|
|
'maxpage' => (int) $page_vars_pics[2],
|
|||
|
|
'p_start' => (int) ($page_vars_pics[0]+1),
|
|||
|
|
'p_end' => (int) ($page_vars_pics[0]+count($group_files)),
|
|||
|
|
'p' => (int) $page_vars_pics[1],
|
|||
|
|
'files' => $group_files);
|
|||
|
|
$smarty->assign('cpp', $cpp);
|
|||
|
|
$smarty->assign('groupalbum_info', $groupalbum_info);
|
|||
|
|
$smarty->assign('total_files', $groupalbum_info);
|
|||
|
|
$smarty->assign('$page_vars_pics', $page_vars_pics);
|
|||
|
|
$smarty->assign('files', $group_files);
|
|||
|
|
|
|||
|
|
$smarty->assign('maxpage_files', $page_vars_pics[2]);
|
|||
|
|
$smarty->assign('p_start_files', $page_vars_pics[0]+1);
|
|||
|
|
$smarty->assign('p_end_files', $page_vars_pics[0]+count($group_files));
|
|||
|
|
$smarty->assign('p_files', $page_vars_pics[1]);
|
|||
|
|
|
|||
|
|
if(SE_DEBUG){echo $page_vars[2];}
|
|||
|
|
$smarty->assign('maxpage_videos', $page_vars[2]);
|
|||
|
|
$smarty->assign('p_start_videos', $page_vars[0]+1);
|
|||
|
|
$smarty->assign('p_end_videos', $page_vars[0]+count($video_array));
|
|||
|
|
$smarty->assign('p_videos', $page_vars[1]);
|
|||
|
|
|
|||
|
|
// GET ACTIONS
|
|||
|
|
$actions_array = $actions->actions_display(0, $setting['setting_actions_actionsonprofile'], "se_actions.action_object_owner='group' AND se_actions.action_object_owner_id='{$group->group_info['group_id']}'");
|
|||
|
|
$smarty->assign_by_ref('actions', $actions_array);
|
|||
|
|
$smarty->assign('videos', $video_array);
|
|||
|
|
$smarty->assign('total_videos', $total_videos);
|
|||
|
|
if(isset($_POST['favorites'])) { $fave = $_POST['favorites']; } elseif(isset($_GET['favorites'])) { $fave = $_GET['favorites']; } else { $fave = 0; }
|
|||
|
|
|
|||
|
|
|
|||
|
|
if($fave==="delete"){
|
|||
|
|
|
|||
|
|
$database->database_query("DELETE FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='group' AND owner='".$group_id."' AND objectid='".$group_id."'");
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
if($fave==="addto"){
|
|||
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='group' AND owner='".$group_id."' AND objectid='".$group_id."'");
|
|||
|
|
|
|||
|
|
if($database->database_num_rows($query)==0){
|
|||
|
|
$database->database_query("INSERT INTO favorites SET user='".$user->user_info["user_id"]."', type='group', owner='".$group_id."', objectid='".$group_id."'");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='group' AND owner='".$group_id."' AND objectid='".$group_id."'");
|
|||
|
|
if($database->database_num_rows($query)>0){$smarty->assign('favorites1', 1);}
|
|||
|
|
|
|||
|
|
|
|||
|
|
$owner=new SEUser(array($group->group_info['group_user_id']));
|
|||
|
|
|
|||
|
|
|
|||
|
|
//var_dump($owner);
|
|||
|
|
|
|||
|
|
$smarty->assign('task', $task);
|
|||
|
|
$smarty->assign('favorites', 1);
|
|||
|
|
//$smarty->assign('favorites', 1);
|
|||
|
|
$smarty->assign('for', $for);
|
|||
|
|
$smarty->assign('for1', $for1);
|
|||
|
|
$smarty->assign('for2', $for2);
|
|||
|
|
$smarty->assign('for3', $for3);
|
|||
|
|
$smarty->assign_by_ref('ipaddress', $_SERVER['REMOTE_ADDR']);
|
|||
|
|
|
|||
|
|
// ASSIGN VARIABLES AND DISPLAY GROUP PAGE
|
|||
|
|
$smarty->assign_by_ref('group', $group);
|
|||
|
|
$smarty->assign_by_ref('cats', $field->cats);
|
|||
|
|
$smarty->assign_by_ref('members', $members);
|
|||
|
|
$smarty->assign_by_ref('officers', $officers);
|
|||
|
|
$smarty->assign_by_ref('topics', $topics);
|
|||
|
|
|
|||
|
|
$smarty->assign('groupcat_info', $groupcat_info);
|
|||
|
|
$smarty->assign('total_comments', $total_comments);
|
|||
|
|
$smarty->assign('total_files', $total_files);
|
|||
|
|
$smarty->assign('is_group_private', $is_group_private);
|
|||
|
|
$smarty->assign('allowed_to_view', $allowed_to_view);
|
|||
|
|
$smarty->assign('allowed_to_comment', $allowed_to_comment);
|
|||
|
|
$smarty->assign('allowed_to_discuss', $allowed_to_discuss);
|
|||
|
|
$smarty->assign('allowed_to_upload', $allowed_to_upload);
|
|||
|
|
$smarty->assign('allowed_to_invite', $allowed_to_invite);
|
|||
|
|
$smarty->assign('is_subscribed', $is_subscribed);
|
|||
|
|
$smarty->assign('v', $v);
|
|||
|
|
$smarty->assign('search', $search);
|
|||
|
|
$smarty->assign('total_members', $total_members);
|
|||
|
|
$smarty->assign('total_members_all', $total_members_all);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
$smarty->assign('maxpage_members', $page_vars_members[2]);
|
|||
|
|
$smarty->assign('p_start_members', $page_vars_members[0]+1);
|
|||
|
|
$smarty->assign('p_end_members', $page_vars_members[0]+count($members));
|
|||
|
|
$smarty->assign('p_members', $page_vars_members[1]);
|
|||
|
|
$smarty->assign('total_topics', $total_topics);
|
|||
|
|
$smarty->assign('maxpage_topics', $page_vars_topics[2]);
|
|||
|
|
$smarty->assign('p_start_topics', $page_vars_topics[0]+1);
|
|||
|
|
$smarty->assign('p_end_topics', $page_vars_topics[0]+count($topics));
|
|||
|
|
$smarty->assign('p_topics', $page_vars_topics[1]);
|
|||
|
|
include "footer.php";
|
|||
|
|
?>
|