public function find_connection($uid)
{
$db = new Database();
$db->connect();
$userid = Relationship::session_id();
$viewable = FALSE;
$id = $userid;
$relationshipquery = "\n\t\t\t\t\tselect rt.name as relationship\n\t\t\t\t\tfrom relationship r\n\t\t\t\t\tleft join relationshiptype rt on r.realtionshiptypeid=rt.id\n\t\t\t\t\tjoin user s on s.id=r.senderid \n\t\t\t\t\tjoin user rc on rc.id=r.receiverid\n\t\t\t\t\twhere ((r.senderid ='" . $id . "' and r.receiverid='" . $uid . "')\n\t\t\t\t\tor (r.senderid ='" . $uid . "' and r.receiverid='" . $id . "'))\n\t\t\t\t\tand r.confirmed=1\n\t\t\t\t\tand r.realtionshiptypeid>0\n\t\t\t\t\tand s.accountstatusid>0\n\t\t\t\t\tand rc.accountstatusid>0\n\t\t\t\t\torder by r.realtionshiptypeid DESC\n\t\t\t\t\t";
$db->query($relationshipquery);
$tmp = $db->getresult();
if (strlen($tmp['relationship']) > 2) {
$viewable = "You are " . strtolower($tmp['relationship']) . ".";
} else {
$viewable = FALSE;
}
return $viewable;
}
