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; }