Files
Testing/latestgroups.php

77 lines
3.9 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: home.php 8 2009-01-11 06:02:53Z john $ */
$includegroups=true;
include "header-ajax.php";
$page = 'latestgroups';
//GROUPS
$s = "group_datecreated DESC";
$v = 0;
$groupcat_id = 0;
// SET WHERE CLAUSE
$where = "CASE
WHEN se_groups.group_user_id='{$user->user_info['user_id']}'
THEN TRUE
WHEN ((se_groups.group_privacy & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_groups.group_privacy & 64) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_groups.group_privacy & 2) AND (SELECT TRUE FROM se_groupmembers WHERE groupmember_user_id='{$user->user_info['user_id']}' AND groupmember_group_id=se_groups.group_id AND groupmember_status=1 LIMIT 1))
THEN TRUE
WHEN ((se_groups.group_privacy & 4) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_groups.group_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status=1 LIMIT 1))
THEN TRUE
WHEN ((se_groups.group_privacy & 8) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_groupmembers LEFT JOIN se_friends ON se_groupmembers.groupmember_user_id=se_friends.friend_user_id1 WHERE se_groupmembers.groupmember_group_id=se_groups.group_id AND se_friends.friend_user_id2='{$user->user_info['user_id']}' AND se_groupmembers.groupmember_status=1 AND se_friends.friend_status=1 LIMIT 1))
THEN TRUE
WHEN ((se_groups.group_privacy & 16) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_groupmembers LEFT JOIN se_friends AS friends_primary ON se_groupmembers.groupmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE se_groupmembers.groupmember_group_id=se_groups.group_id AND se_groupmembers.groupmember_status=1 AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND friends_primary.friend_status=1 AND friends_secondary.friend_status=1 LIMIT 1))
THEN TRUE
ELSE FALSE
END";
// SPECIFIC GROUP CATEGORY
if( is_numeric($groupcat_id) )
{
$groupcat_query = $database->database_query("SELECT groupcat_id, groupcat_title, groupcat_dependency FROM se_groupcats WHERE groupcat_id='{$groupcat_id}' LIMIT 1");
if( $database->database_num_rows($groupcat_query) )
{
$groupcat = $database->database_fetch_assoc($groupcat_query);
if( !$groupcat['groupcat_dependency'] )
{
$cat_ids[] = $groupcat['groupcat_id'];
$depcats = $database->database_query("SELECT groupcat_id FROM se_groupcats WHERE groupcat_id='{$groupcat['groupcat_id']}' OR groupcat_dependency='{$groupcat['groupcat_id']}'");
while($depcat_info = $database->database_fetch_assoc($depcats)) { $cat_ids[] = $depcat_info['groupcat_id']; }
$where .= " AND se_groups.group_groupcat_id IN('".implode("', '", $cat_ids)."')";
}
else
{
$where .= " AND se_groups.group_groupcat_id='{$groupcat['groupcat_id']}'";
$groupsubcat = $groupcat;
$groupcat = $database->database_fetch_assoc($database->database_query("SELECT groupcat_id, groupcat_title FROM se_groupcats WHERE groupcat_id='{$groupcat['groupcat_dependency']}' LIMIT 1"));
}
}
}
// CREATE GROUP OBJECT
$group = new se_group();
// GET TOTAL GROUPS
$total_groups = $group->group_total($where);
// MAKE ENTRY PAGES
$groups_per_page = 24;
$page_vars = make_page($total_groups, $groups_per_page, $p);
// GET GROUP ARRAY
$group_array = $group->group_list($page_vars[0], $groups_per_page, $s, $where, TRUE);
// GET CATS
$field = new se_field("group");
$field->cat_list(0, 0, 0, "", "", "groupfield_id=0");
$cat_array = $field->cats;
// ASSIGN SMARTY VARIABLES AND DISPLAY GROUPS PAGE
$smarty->assign('groupcat_id', $groupcat_id);
$smarty->assign('groupcat', $groupcat);
$smarty->assign('groupsubcat', $groupsubcat);
$smarty->assign('cats', $cat_array);
$smarty->assign('groups', $group_array);
$smarty->assign('total_groups', $total_groups);
include "footer-ajax.php";
?>