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"; ?>