108 lines
3.8 KiB
PHP
108 lines
3.8 KiB
PHP
<?php
|
|
|
|
/* $Id: user_friends.php 42 2009-01-29 04:55:14Z john $ */
|
|
|
|
$page = "user_friends";
|
|
include "header.php";
|
|
|
|
|
|
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
|
|
if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "zz"; }
|
|
if(isset($_POST['search'])) { $search = $_POST['search']; } elseif(isset($_GET['search'])) { $search = $_GET['search']; } else { $search = ""; }
|
|
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = ""; }
|
|
if(isset($_POST['friendtype'])) { $friendtype = $_POST['friendtype']; } elseif(isset($_GET['friendtype'])) { $friendtype = $_GET['friendtype']; } else { $friendtype = ""; }
|
|
// ENSURE CONECTIONS ARE ALLOWED FOR THIS USER
|
|
if( !$setting['setting_connection_allow'] )
|
|
{
|
|
header("Location: home.php");
|
|
exit();
|
|
}
|
|
|
|
|
|
// SET FRIEND SORT-BY VARIABLES FOR HEADING LINKS
|
|
$u = "ud"; // LAST UPDATE DATE
|
|
$l = "ld"; // LAST LOGIN DATE
|
|
$t = "t"; // FRIEND TYPE
|
|
$n="n";
|
|
$a="a";
|
|
$z="zz";
|
|
|
|
// SET SORT VARIABLE FOR DATABASE QUERY
|
|
switch($s)
|
|
{
|
|
case "ud": $sort = "se_users.user_dateupdated DESC"; $u = "ud"; break;
|
|
case "ld": $sort = "se_users.user_lastlogindate DESC"; $l = "ld"; break;
|
|
case "t": $sort = "se_friends.friend_type"; $t = "td"; break;
|
|
case "n": $sort = "se_friends.friend_id DESC"; $n = "n"; break;
|
|
case "a": $sort = "se_users.user_username"; $a = "a"; break;
|
|
default: $sort = "se_users.user_username ASC"; $z = "zz";
|
|
}
|
|
//echo $sort;
|
|
// SET WHERE CLAUSE
|
|
$is_where = 0;
|
|
$where = "1=1 ";
|
|
if($search != "")
|
|
{
|
|
$is_where = 1;
|
|
$where .= " AND (se_users.user_username LIKE '%$search%')";// OR se_users.user_fname LIKE '%$search%' OR se_users.user_lname LIKE '%$search%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%$search%' OR se_users.user_email LIKE '%$search%')";
|
|
}
|
|
if($friendtype != "")
|
|
{
|
|
$is_where = 1;
|
|
$where .= " AND (se_friends.friend_type='".$friendtype."')";// OR se_users.user_fname LIKE '%$search%' OR se_users.user_lname LIKE '%$search%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%$search%' OR se_users.user_email LIKE '%$search%')";
|
|
}
|
|
|
|
|
|
// DECIDE WHETHER TO SHOW DETAILS
|
|
$connection_types = explode("<!>", trim($setting['setting_connection_types']));
|
|
$show_details = ( !empty($connection_types) || $setting['setting_connection_other'] || $setting['setting_connection_explain'] );
|
|
|
|
// GET TOTAL FRIENDS
|
|
$total_friends = $user->user_friend_total(0, 1, $is_where, $where);
|
|
|
|
// MAKE FRIEND PAGES
|
|
$friends_per_page = 24;
|
|
$page_vars = make_page($total_friends, $friends_per_page, $p);
|
|
|
|
// GET FRIEND ARRAY
|
|
$friends = $user->user_friend_list($page_vars[0], $friends_per_page, 0, 1, $sort, $where, $show_details);
|
|
|
|
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);
|
|
|
|
|
|
$query=$database->database_query("SELECT DISTINCT(BINARY friend_type) as friend_type FROM se_friends WHERE friend_user_id1='".$user->user_info["user_id"]."'");
|
|
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
|
|
$friendtypes[]=array("friendtype"=>$row["friend_type"]);
|
|
}
|
|
|
|
// ASSIGN VARIABLES AND INCLUDE FOOTER
|
|
$smarty->assign('s', $s);
|
|
$smarty->assign('u', $u);
|
|
$smarty->assign('l', $l);
|
|
$smarty->assign('t', $t);
|
|
$smarty->assign('n', $n);
|
|
$smarty->assign('a', $a);
|
|
$smarty->assign('z', $z);
|
|
$smarty->assign('search', $search);
|
|
$smarty->assign('friends', $friends);
|
|
$smarty->assign('friendtypes', $friendtypes);
|
|
$smarty->assign('friendtype', $friendtype);
|
|
$smarty->assign('total_friends', $total_friends);
|
|
$smarty->assign('maxpage', $page_vars[2]);
|
|
$smarty->assign('p', $page_vars[1]);
|
|
$smarty->assign('p_start', $page_vars[0]+1);
|
|
$smarty->assign('p_end', $page_vars[0]+count($friends));
|
|
$smarty->assign('show_details', $show_details);
|
|
include "footer.php";
|
|
?>
|