Files
Testing/home.php

531 lines
20 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 $ */
$page = 'home';
include "header.php";
//if(SE_DEBUG1){$page = 'home2';}
$task = ( !empty($_POST['task']) ? $_POST['task'] : ( !empty($_GET['task']) ? $_GET['task'] : NULL ) );
$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');}
{
$sql = "
SELECT
COUNT(*) as cnt
FROM
se_albums
";
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
// ADD WHERE IF NECESSARY
$sql .= "
WHERE 1=1
";
// ENSURE USER ID IS NOT EMPTY
// INSERT AND IF NECESSARY
if( !empty($where) ) $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if( !empty($where) ) $sql .= "
{$where}
";
$res2=$database->database_query($sql);
// GET AND RETURN TOTAL PHOTO ALBUMS
$row= $database->database_fetch_assoc($res2);
$album_total=$row['cnt'];
$num=$album_total-56;
$rand=rand(1, $num);
//$rand=rand(1, 1000-56);
if($rand<1){$rand=1;}
$top=$rand+55;
// ADD ORDER, AND LIMIT CLAUSE
// BEGIN QUERY
$sql = "
SELECT
se_albums.*,
se_albums.album_totalfiles AS total_files,
se_albums.album_totalspace AS total_space, se_users.*
";
// IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION
// CONTINUE QUERY
$sql .= "
FROM
se_albums, se_users
";
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
// ADD WHERE IF NECESSARY
$sql .= "
WHERE se_albums.album_user_id=se_users.user_id
";
$rand=rand(1, $num);
if($rand<1){$rand=1;}
$top=$rand+55;
// ADD ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
album_id
LIMIT
$rand, 130
";
// RUN QUERY
$resource = $database->database_query($sql);
// GET ALBUMS INTO AN ARRAY
$album_array = Array();
while( $album_info = $database->database_fetch_assoc($resource) )
{
if($album_info['user_enabled']==1){
// IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR
// GET PATH OF ALBUM COVER
$album_cover_id = 0;
$album_cover_ext = "";
if( $album_info['album_cover'] )
{
$album_cover_query = $database->database_query("SELECT media_id, media_ext FROM se_media WHERE media_id='{$album_info['album_cover']}' AND media_album_id='{$album_info['album_id']}' LIMIT 1");
if( $database->database_num_rows($album_cover_query) )
{
$album_cover_array = $database->database_fetch_assoc($album_cover_query);
$album_cover_id = $album_cover_array['media_id'];
$album_cover_ext = $album_cover_array['media_ext'];
}
}
// CREATE ARRAY OF ALBUM DATA
SE_Language::_preload(user_privacy_levels($album_info['album_privacy']));
// SET OTHER INFO
$album_info['album_author'] =& $author;
$album_info['album_space'] = $album_space_mb;
$album_info['album_privacy'] = user_privacy_levels($album_info['album_privacy']);
$album_info['album_cover_id'] = $album_cover_id;
$album_info['album_cover_ext'] = $album_cover_ext;
$album_info['album_files'] = $album_info['total_files'];
$signup_user = new se_user(Array($album_info['user_id']));
// $signup_user->user_displayname();
//echo var_dump($album_info['album_author']->user_displayname());
//$signup_user->user_info['display_name']=$signup_user->user_displayname();
//echo $signup_user->user_info['user_username'];
// exit;
$album_array[] = $album_info;
//$album_array[] =& $signup_user;
unset($author, $album_info, $signup_user);
}
}
// RETURN ARRAY
$smarty->assign('album_array', $album_array);
}
$smarty->assign('profile_views', $profile_views);
$smarty->assign('profile_viewers', $profile_viewers);
include "footer.php";
?>