Files
Testing/home3.php

731 lines
17 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 $ */
include "header.php";
$page = 'home3';
$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
$testers=array("joeblow2@aol.com", "bbird20@msn.com", "hookup43@yahoo.com", "benrd295@aol.com", "ali.bushell@gmail.com", "macgreg500@hotmail.com", "rodney2518@yahoo.com", "ctteddy2000@yahoo.com", "jackrabbit2c@yahoo.com", "jockbro22@yahoo.com", "midtownnycm4m@gmail.com", "undiesboy24uk@yahoo.com", "aztop4u@gmail.com", "randyirishboi@yahoo.co.uk", "simon44@gmail.com", "poptartxxx@gmail.com", "workinitm2m@yahoo.com", "moz815_99@yahoo.com", "massguy1977@yahoo.com", "sdtrvlr@att.net", "hookup43@yahoo.com", "leanhots@gmail.com", "bater.jeff@yahoo.com", "edwindavis1@gmail.com", "grflood@msn.com", "mnkaig@gmail.com", "pigletsatx@yahoo.com", "Ezduzit234@aol.com", "iagy7@aol.com", "jtpayne22@gmail.com", "jockedgedc@gmail.com", "dschwake@yahoo.com", "musclejock12@yahoo.com", "thosetwoguys_wa@yahoo.com", "michaeloz1@hotmail.com", "seattleplaytime@gmail.com", "jim-star@live.co.uk", "csangster@live.com", "sfmac1013@yahoo.com", "bearis40@yahoo.ca", "cumragbator@comcast.net", "risskov24@yahoo.it", "italjhnsn@yahoo.com", "haidjay@gmail.com", "philtomx@hotmail.com", "cjackbate@gmail.com", "leprakhauns@gmail.com", "maximail78@yahoo.com", "bateworld@gmail.com", "peterr2468@gmail.com");
//if(in_array(strtolower($user->user_info["user_email"]), $testers)){
if( !$user->user_exists && !$setting['setting_permission_portal'] )
{
if (rc_imobile::is_mobile_display()) {
//$page = "home_login_required";
$page = "error-home";
$home="true";
}
else {
$page = "error-home";
$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 "WHAT'S HOT" CONTENT
$whats_hot = new rc_page();
$page_info = $whats_hot->get_record(3);
$smarty->assign('whats_hot', $page_info['page_content']);
*/
// GET RECENT LOGINS
$login_array = recent_logins();
$smarty->assign_by_ref('logins', $login_array);
// GET NEWS ITEMS
$news_array = site_news();
$smarty->assign_by_ref('news', $news_array);
// 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("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('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);
//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
$whats_hot = new rc_page();
$wh_info = $whats_hot->get_record(115);
$smarty->assign('whats_hot', $wh_info['page_content']);
// Added 4/16/2014 Phil: For the What's Hot ad above content - corresponding code not added to home.tpl
//$smarty->assign('showadabove', 'no');
//$adabove = new rc_page();
//$adabove_info = $adabove->get_record(118);
//$smarty->assign('adabove', $adabove_info['page_content']);
//if (strpos($adabove_info['page_content'],'<!-- show me //-->') !== false) {
// $smarty->assign('showadabove', 'yes');
//}
$adbelow = new rc_page();
$adbelow_info = $adbelow->get_record(116);
$smarty->assign('adbelow', $adbelow_info['page_content']);
$smarty->assign('addcolumnc', 'no');
$ccolumn = new rc_page();
$ccolumn_info = $ccolumn->get_record(117);
if (strpos($ccolumn_info['page_content'],'<!--add column c//-->') !== false) {
$smarty->assign('addcolumnc', 'yes');
}
$smarty->assign('ccolumn', $ccolumn_info['page_content']);
include "footer.php";
?>