query($auth_sql);
return $result;
}
function findUser($user,$loggedinuser,$connection){
$sql = "select username, firstname, lastname, imagethumburl from PERSON where username like '$user%'";
$result = $connection->query($sql);
$rowsFound = false;
$count = 0;
ob_start();
while($row = $result->getArray()) {
$rowsFound = true;
if($count%2 == 0){
$class = "even";
}else{
$class = "odd";
}
$username = $row['username'];
$userInFriendsList = $this->userInFriendsList($loggedinuser,$username,$connection);
$invited = $this->ifInvited($loggedinuser,$username,$connection);
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$image = $row['imagethumburl'];
require("../views/findUsersList.php");
$count++;
}
unset($result);
$users=ob_get_contents();
ob_end_clean();
if ($rowsFound == true) {
return $users;
}else{
return 'No users match your query.';
}
}
/*****
function getFriendCloud($username,$connection){
$sql = "select firstname, lastname, friends_username from PERSON as p, PERSON_PERSON as pp where pp.person_username='$username' and p.username=pp.friends_username and pp.is_accepted=1";
$result = $connection->query($sql);
$rowsFound = false;
while($row = $result->getArray()) {
$rowsFound = true;
$friend = $row['friends_username'];
$fn = $row['firstname'];
$ln = $row['lastname'];
$friendCloud = $friendCloud." ".''.$fn.' '.$ln.'';
}
unset($result);
if ($rowsFound == true) {
return $friendCloud;
}else{
return 'This person has no friends.';
}
}
****/
function getFriendCloud($username,$connection){
$sql = "select firstname, lastname, friends_username, imagethumburl from PERSON as p, PERSON_PERSON as pp where pp.person_username='$username' and p.username=pp.friends_username and pp.is_accepted=1";
$result = $connection->query($sql);
$rowsFound = false;
$count = 0;
$space = " ";
while($row = $result->getArray()) {
$count = $count + 1;
$rowsFound = true;
$friend = $row['friends_username'];
$fn = $row['firstname'];
$ln = $row['lastname'];
$image = $row['imagethumburl'];
$friendCloud = $friendCloud." ".'
';
if($count >= 6){
break;
}
}
unset($result);
if ($rowsFound == true) {
if ($count >= 6){
return $friendCloud."
more...';
}else{
return $friendCloud;
}
}else{
return 'This person has no friends.';
}
}
function getFriendsList($usernm,$loggedinuser,$connection,$offset){
$sql = "select firstname, lastname, friends_username as username, imagethumburl from PERSON as p, PERSON_PERSON as pp where pp.person_username='$usernm' and p.username=pp.friends_username and pp.is_accepted=1 limit $offset,10";
$result = $connection->query($sql);
$rowsFound = false;
ob_start();
while($row = $result->getArray()) {
$rowsFound = true;
$username = $row['username'];
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$image = $row['imagethumburl'];
require("../views/friendsList.php");
}
unset($result);
$friends = ob_get_contents();
ob_end_clean();
if ($rowsFound == true) {
return $friends;
}else{
return 'This person has no friends.';
}
}
function numFriendshipRequests($un,$connection) {
$sql = "select count(friends_username) from PERSON_PERSON where person_username='$un' and is_accepted=0";
$result = $connection->query($sql);
$row = $result->getArray();
$numRequests = $row['count(friends_username)'];
unset($result);
return $numRequests;
}
function userInFriendsList($user,$friend,$connection){
$sql = "select friends_username from PERSON_PERSON where person_username='$friend' and friends_username='$user' and is_accepted=1";
$result = $connection->query($sql);
$found = 0;
while ($row = $result->getArray()) {
$found = 1;
}
unset($result);
return $found;
}
function ifInvited($user,$friend,$connection) {
$sql = "select friends_username from PERSON_PERSON where person_username='$friend' and friends_username='$user' and is_accepted=0";
$result = $connection->query($sql);
$invited = 0;
while ($row = $result->getArray()) {
$invited = 1;
}
unset($result);
return $invited;
}
function incomingRequests($username,$connection) {
$isql = "select firstname, lastname,person_username, friends_username from PERSON as p, PERSON_PERSON as pp where pp.person_username='$username' and p.username=pp.friends_username and pp.is_accepted=0";
$result1 = $connection->query($isql);
ob_start();
while($row1 = $result1->getArray()) {
$personun1 = $row1['person_username'];
$friendun1 = $row1['friends_username'];
$fn1 = $row1['firstname'];
$ln1 = $row1['lastname'];
require("../views/incomingRequests.php");
}
unset($result1);
$incomingRequests = ob_get_contents();
ob_end_clean();
return $incomingRequests;
}
function outgoingRequests($username,$connection) {
$osql = "select firstname, lastname, person_username, friends_username from PERSON as p, PERSON_PERSON as pp where pp.friends_username='$username' and p.username=pp.person_username and pp.is_accepted=0";
$result1 = $connection->query($osql);
ob_start();
while($row1 = $result1->getArray()) {
$personun = $row1['person_username'];
$friendun = $row1['friends_username'];
$fn = $row1['firstname'];
$ln = $row1['lastname'];
require("../views/outgoingRequests.php");
}
unset($result1);
$outgoingRequests = ob_get_contents();
ob_end_clean();
return $outgoingRequests;
}
static function getInstance() {
$instance = new Users_Controller();
return $instance;
}
}
?>