387 lines
17 KiB
PHP
387 lines
17 KiB
PHP
<?php
|
|
/* $Id: home.php 8 2009-01-11 06:02:53Z john $ */
|
|
$page = 'home1';
|
|
include "header.php";
|
|
|
|
|
|
$smarty->assign('homepage', 'homepage');
|
|
//if($user->user_info["user_email"]!=""){header("Location: /user_home.php");exit;}
|
|
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
|
|
//if(in_array(strtolower($user->user_info["user_email"]), $testers)){
|
|
if( !$user->user_exists && !$setting['setting_permission_portal'] )
|
|
{
|
|
$home="true";
|
|
$page = "error-home";
|
|
|
|
$smarty->assign('home', $home);
|
|
$smarty->assign('error_header', 9000005);
|
|
$smarty->assign('error_message', 9000006);
|
|
$smarty->assign('error_submit', 641);
|
|
include "footer.php";
|
|
exit;
|
|
}
|
|
|
|
if($user->user_info["iperror"]==1){$database->database_query("UPDATE se_users SET iperror=0 WHERE user_id='".$user->user_info["user_id"]."'");}
|
|
|
|
//}else{
|
|
if( !$user->user_exists && !$setting['setting_permission_portal'] )
|
|
{
|
|
|
|
$page = "error-home";
|
|
|
|
// $smarty->assign('error_header', 9000005);
|
|
$smarty->assign('error_message', 9000006);
|
|
//$smarty->assign('error_submit', 641);
|
|
include "footer.php";
|
|
exit;
|
|
}
|
|
//}
|
|
|
|
|
|
|
|
|
|
// IF PREVIOUSLY LOGGED IN EMAIL COOKIE AVAILABLE, SET IT
|
|
$prev_email = ( isset($_COOKIE['prev_email']) ? $_COOKIE['prev_email'] : "" );
|
|
|
|
// UPDATE REFERRING URLS TABLE
|
|
update_refurls();
|
|
|
|
// NOTE: THESE FUNCTIONS ARE MOSTLY IN include/functions_general.php
|
|
// Moved for simplicity in caching the results
|
|
|
|
// POPULATE USER SETTINGS ARRAY
|
|
$user->user_settings();
|
|
|
|
// GET RECENT POPULAR USERS (MOST FRIENDS)
|
|
//$friend_array = popular_users();
|
|
|
|
$smarty->assign_by_ref('friends', $friend_array);
|
|
|
|
// GET RECENT LOGINS
|
|
$login_array = recent_logins();
|
|
$smarty->assign_by_ref('logins', $login_array);
|
|
$video_array = recent_videos();
|
|
$smarty->assign_by_ref('video', $video_array);
|
|
|
|
|
|
// GET NEWS ITEMS
|
|
$news_array = site_news();
|
|
$smarty->assign_by_ref('news', $news_array);
|
|
$checkitout_news = checkitout_news();
|
|
$smarty->assign_by_ref('checkitout', $checkitout_news);
|
|
|
|
// GET UPCOMING BIRTHDAYS, START BY CHECKING FOR BIRTHDAY PROFILE FIELDS
|
|
$birthday_array = friends_birthdays();
|
|
$smarty->assign_by_ref('birthdays', $birthday_array);
|
|
|
|
// Backwards compatibility with old home.tpl template
|
|
$total_members = ( isset($stats_array['members']['stat']) ? $stats_array['members']['stat'] : 0 );
|
|
$total_friends = ( isset($stats_array['friends']['stat']) ? $stats_array['friends']['stat'] : 0 );
|
|
$total_comments = ( isset($stats_array['comments']['stat']) ? $stats_array['comments']['stat'] : 0 );
|
|
$smarty->assign('total_members', $total_members);
|
|
$smarty->assign('total_friends', $total_friends);
|
|
$smarty->assign('total_comments', $total_comments);
|
|
|
|
|
|
// Get online users
|
|
$online_array = online_users_count("1");
|
|
$smarty->assign_by_ref('online_users', $online_array);
|
|
|
|
|
|
// Get actions feed - Has code in it that is preventing direct caching
|
|
/*
|
|
if($_GET["show"]=="")
|
|
{
|
|
|
|
$actions_array = $actions->actions_display(5, $setting['setting_actions_actionsperuser']);
|
|
|
|
$smarty->assign_by_ref('show', $_GET["show"]);
|
|
}
|
|
else
|
|
{
|
|
if($_GET["show"]==1){$_GET["show"]=0;}
|
|
|
|
$actions_array = $actions->actions_display($_GET["show"], $setting['setting_actions_actionsperuser']);
|
|
|
|
$smarty->assign_by_ref('show', $_GET["show"]);
|
|
}
|
|
|
|
$smarty->assign_by_ref('actions', $actions_array);*/
|
|
|
|
// CREATE ARRAY OF ACTION TYPES
|
|
$actiontypes_array = $actions->actions_allowed();
|
|
$smarty->assign_by_ref('show', $_GET["show"]);
|
|
|
|
$smarty->assign_by_ref('membersonline', $_GET["membersonline"]);
|
|
|
|
$smarty->assign_by_ref('actiontypes', $actiontypes_array);
|
|
|
|
// ASSIGN SMARTY VARIABLES
|
|
$smarty->assign('prev_email', $prev_email);
|
|
$smarty->assign('ip', $_SERVER['REMOTE_ADDR']);
|
|
|
|
// GET RECENT SIGNUPS
|
|
$signup_array = recent_signups();
|
|
$smarty->assign_by_ref('signups', $signup_array);
|
|
|
|
$verified_array = recent_verified();
|
|
$smarty->assign_by_ref('verifieds', $verified_array);
|
|
|
|
//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);
|
|
|
|
//EVENTS
|
|
$s_events="event_totalmembers DESC";
|
|
$v_events=3;
|
|
$p_events=1;
|
|
// SET WHERE CLAUSE
|
|
$where_events = "CASE
|
|
WHEN se_events.event_user_id='{$user->user_info['user_id']}'
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 32) AND '{$user->user_exists}'<>0)
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 64) AND '{$user->user_exists}'=0)
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_event_id=se_events.event_id AND eventmember_status=1 LIMIT 1))
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 4) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_events.event_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status=1 LIMIT 1))
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 8) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends ON se_eventmembers.eventmember_user_id=se_friends.friend_user_id1 WHERE se_eventmembers.eventmember_event_id=se_events.event_id AND se_friends.friend_user_id2='{$user->user_info['user_id']}' AND se_eventmembers.eventmember_status=1 AND se_friends.friend_status=1 LIMIT 1))
|
|
THEN TRUE
|
|
WHEN ((se_events.event_privacy & 16) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_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_eventmembers.eventmember_event_id=se_events.event_id AND se_eventmembers.eventmember_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";
|
|
|
|
// SET WHERE CLAUSE
|
|
$where_events .= " && se_events.event_date_start>'".time()."' ";
|
|
// Force sort?
|
|
$s_events = "event_date_start ASC";
|
|
// CREATE EVENT OBJECT
|
|
$event = new se_event();
|
|
// GET TOTAL EVENTS
|
|
$total_events = $event->event_total($where_events);
|
|
// MAKE ENTRY PAGES
|
|
$events_per_page = 24;
|
|
$events_page_vars = make_page($total_events, $events_per_page, $p_events);
|
|
// GET EVENT ARRAY
|
|
$event_array = $event->event_list($events_page_vars[0], $events_per_page, $s_events, $where_events, TRUE);
|
|
|
|
// ASSIGN SMARTY VARIABLES AND DISPLAY EVENTS PAGE
|
|
$smarty->assign('events', $event_array);
|
|
$smarty->assign('total_events', $total_events);
|
|
|
|
// SET FORUMCAT ARRAY
|
|
//$forumcat_array = $forum->forum_list_home();
|
|
// ASSIGN SMARTY VARS AND INCLUDE FOOTER
|
|
//$smarty->assign('forumcats', $forumcat_array);
|
|
|
|
// Blog - Recent Blogs Everyone
|
|
$s_blog = "blogentry_date DESC";
|
|
$v_blog = 0;
|
|
$p_blog = 1;
|
|
// SET WHERE CLAUSE
|
|
$where_blog = "CASE
|
|
WHEN se_blogentries.blogentry_user_id='{$user->user_info['user_id']}'
|
|
THEN TRUE
|
|
WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
|
|
THEN TRUE
|
|
WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
|
|
THEN TRUE
|
|
WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_blogentries.blogentry_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
|
|
"/* THEN TRUE
|
|
WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_SUBNET) AND'{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_blogentries.blogentry_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))
|
|
*/."THEN TRUE
|
|
WHEN ((se_blogentries.blogentry_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_blogentries.blogentry_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";
|
|
if($where_blog == "")
|
|
{
|
|
$where_blog .= "WHERE se_blogentries.blogentry_user_id <> '70695'";
|
|
}
|
|
else
|
|
{
|
|
$where_blog .= " AND se_blogentries.blogentry_user_id <> '70695'";
|
|
}
|
|
// CREATE blog OBJECT
|
|
/*$blog = new se_blog();
|
|
// GET TOTAL blogs
|
|
$total_blogentries = $blog->blog_entries_total($where_blog);
|
|
// MAKE ENTRY PAGES
|
|
$blogentries_per_page = 24;
|
|
|
|
$page_vars = make_page($total_blogentries, $blogentries_per_page, $p_blog);
|
|
|
|
// GET blog ARRAY
|
|
$blogentry_array = $blog->blog_entries_list($page_vars[0], $blogentries_per_page, $s_blog, $where_blog);
|
|
|
|
// GET BLOG ENTRY CATEGORIES
|
|
$blogentrycats_query = $database->database_query("SELECT * FROM se_blogentrycats WHERE blogentrycat_user_id=0 ORDER BY blogentrycat_id ASC");
|
|
$blogentrycats_array = array();
|
|
while( $blogentrycat=$database->database_fetch_assoc($blogentrycats_query) )
|
|
{
|
|
$blogentrycats_array[] = array(
|
|
'blogentrycat_id' => $blogentrycat['blogentrycat_id'],
|
|
'blogentrycat_title' => $blogentrycat['blogentrycat_title']
|
|
);
|
|
}
|
|
// ASSIGN SMARTY VARIABLES AND DISPLAY blogs PAGE
|
|
$smarty->assign('total_blogentries', $total_blogentries);
|
|
$smarty->assign_by_ref('blogentries', $blogentry_array);
|
|
$smarty->assign_by_ref('blogentrycats', $blogentrycats_array);
|
|
*/
|
|
// Polls
|
|
$p=1;
|
|
$s = "poll_datecreated DESC";
|
|
$v = 0;
|
|
$where = "CASE
|
|
WHEN se_polls.poll_user_id='{$user->user_info['user_id']}'
|
|
THEN TRUE
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
|
|
THEN TRUE
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
|
|
THEN TRUE
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_polls.poll_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
|
|
"/*THEN TRUE
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_polls.poll_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))*/."
|
|
THEN TRUE
|
|
WHEN ((se_polls.poll_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_polls.poll_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";
|
|
/*
|
|
$poll = new se_poll();
|
|
// GET TOTAL pollS
|
|
//$total_polls = $poll->poll_total($where);
|
|
|
|
// MAKE ENTRY PAGES
|
|
$polls_per_page = 4;
|
|
$page_vars = make_page($total_polls, $polls_per_page, $p);
|
|
// GET poll ARRAY
|
|
$poll_array = $poll->poll_list($page_vars[0], $polls_per_page, $s, $where, TRUE);
|
|
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
|
|
{
|
|
if(($page_vars[1]+10)==$x)
|
|
{break;}
|
|
$for[$y]=$x;
|
|
$y++;
|
|
}*/
|
|
$smarty->assign('for', $for);
|
|
// ASSIGN SMARTY VARIABLES AND DISPLAY pollS PAGE
|
|
$smarty->assign('polls', $poll_array);
|
|
$smarty->assign('total_polls', $total_polls);
|
|
|
|
$_SESSION["pdp_nickname"]=$user->user_info['user_username'];
|
|
$_SESSION["pdp_blocklist"]=$user->user_info['user_blocklist'];
|
|
$_SESSION["cp_userlevel"]=$user->user_info['user_level_id'];
|
|
// GET "WHAT'S HOT" CONTENT
|
|
|
|
// RESET PROFILE VIEWS
|
|
if($task == "resetviews")
|
|
{
|
|
|
|
$database->database_query("UPDATE se_profileviews SET profileview_views=0, profileview_viewers='' WHERE profileview_user_id='{$user->user_info['user_id']}' LIMIT 1");
|
|
|
|
}
|
|
// RETRIEVE VIEWS AND VIEWERS IF NECESSARY
|
|
$profile_views = 0;
|
|
$profile_viewers = Array();
|
|
$view_query = $database->database_query("SELECT profileview_views, profileview_viewers FROM se_profileviews WHERE profileview_user_id='{$user->user_info['user_id']}'");
|
|
|
|
if($database->database_num_rows($view_query) == 1)
|
|
{
|
|
$views = $database->database_fetch_assoc($view_query);
|
|
$profile_views = $views['profileview_views'];
|
|
if($views['profileview_viewers'] == "") { $views['profileview_viewers'] = "''"; }
|
|
|
|
$viewer_query = $database->database_query("SELECT user_id, user_username, user_fname, user_lname FROM se_users WHERE user_id IN ({$views['profileview_viewers']})");
|
|
|
|
while($viewer_info = $database->database_fetch_assoc($viewer_query))
|
|
{
|
|
$viewer = new se_user();
|
|
$viewer->user_info['user_id'] = $viewer_info['user_id'];
|
|
$viewer->user_info['user_username'] = $viewer_info['user_username'];
|
|
$viewer->user_info['user_fname'] = $viewer_info['user_fname'];
|
|
$viewer->user_info['user_lname'] = $viewer_info['user_lname'];
|
|
$viewer->user_displayname();
|
|
|
|
// SET PROFILE VIEWERS
|
|
$profile_viewers[] = $viewer;
|
|
}
|
|
|
|
$profile_viewers_array = explode(",", $views['profileview_viewers']);
|
|
// usort($profile_viewers, create_function('$a,$b', 'global $profile_viewers_array; if(array_search($a->user_info["user_id"], $profile_viewers_array) == array_search($b->user_info["user_id"], $profile_viewers_array)) { return 0; } else { return (array_search($a->user_info["user_id"], $profile_viewers_array) < array_search($b->user_info["user_id"], $profile_viewers_array)) ? -1 : 1; }'));
|
|
}
|
|
|
|
if($user->user_info["user_signupdate"]>=(time()-60*15)){$smarty->assign('nostatus', '1');}
|
|
|
|
$smarty->assign('profile_views', $profile_views);
|
|
$smarty->assign('profile_viewers', $profile_viewers);
|
|
include "footer.php";
|
|
?>
|