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." ".'

'.$fn.' '.$ln.' '.$space.'
'; 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; } } ?>