run(
"SELECT COUNT(*) FROM friends WHERE :uid1 IN (requesterId, receiverId) AND :uid2 IN (requesterId, receiverId) AND status = 1",
[":uid1" => $userId, ":uid2" => $userId2]
)->rowCount();
if($IsFriends) die('true');
else die('false');
}
else if($method == "IsInGroup")
{
$IsInGroup = Database::singleton()->run(
"SELECT * FROM groups_members WHERE GroupID = :GroupID AND UserID = :UserID",
[":GroupID" => $groupId, ":UserID" => $userId]
)->rowCount();
if($IsInGroup) die('true');
else die('false');
}
else if($method == "GetGroupRank")
{
$GroupRank = Database::singleton()->run(
"SELECT Rank FROM groups_members WHERE GroupID = :GroupID AND UserID = :UserID",
[":GroupID" => $groupId, ":UserID" => $userId]
);
if($GroupRank->rowCount()) die('' . $GroupRank->fetchColumn() . '');
else die('0');
}
else if($method == "GetGroupRole")
{
$GroupRole = Database::singleton()->run(
"SELECT groups_ranks.Name FROM groups_members
INNER JOIN groups_ranks ON groups_ranks.Rank = groups_members.Rank AND groups_ranks.GroupID = groups_members.GroupID
WHERE groups_members.GroupID = :GroupID AND groups_members.UserID = :UserID",
[":GroupID" => $groupId, ":UserID" => $userId]
);
if($GroupRole->rowCount()) die($GroupRole->fetchColumn());
else die('Guest');
}
echo 'false';