private function onFriendInboxCommand(Session $session)
{
$uid = $session->getUID();
$fromSmall = self::TYPE_FROM_SMALL;
$fromLarge = self::TYPE_FROM_LARGE;
$friend = self::TYPE_FRIEND;
$result = $this->main->getMySQLi()->query("SELECT(SELECT primaryname FROM players WHERE uid=sel.uid)AS name,theirFriends AS theirFriendsCnt,(SELECT rank FROM players WHERE uid=sel.uid)AS rank FROM(SELECT uid,(SELECT COUNT(*) FROM kitpvp_friends WHERE type={$friend} AND(smalluid=uid OR largeuid=uid))AS theirFriends FROM(SELECT IF(smalluid={$uid},largeuid,smalluid)AS uid FROM kitpvp_friends WHERE(smalluid={$uid} AND type={$fromLarge})OR(largeuid={$uid} AND type={$fromSmall}))AS friends)AS sel", MysqlConnection::ALL);
$names = [];
foreach ($result as &$row) {
$row["theirFriendsCnt"] = (int) $row["theirFriendsCnt"];
$name = $row["name"];
if ($row["theirFriendsCnt"] >= Settings::kitpvp_maxFriends((int) $row["rank"])) {
$name = TextFormat::RED . "{$name} (full)" . TextFormat::WHITE;
}
$names[] = $name;
}
return sprintf("You have %d received friend request(s) from:\n%s.", count($names), count($names) > 0 ? implode(", ", $names) : "---");
}
