0 AND gu.Login > (UNIX_TIMESTAMP() - 300) -- Online in den letzten 5 Minuten ORDER BY gu.Login DESC"; return mysqli_query($con, $sql); } function searchUsers($con, $search) { $search = mysqli_real_escape_string($con, $search); $sql = "SELECT ua.PrincipalID, ua.FirstName, ua.LastName, gu.Login, gu.Online, up.profileImage, up.profileAboutText FROM UserAccounts ua LEFT JOIN GridUser gu ON ua.PrincipalID = gu.UserID LEFT JOIN userprofile up ON ua.PrincipalID = up.useruuid WHERE (ua.FirstName LIKE '%$search%' OR ua.LastName LIKE '%$search%') ORDER BY gu.Login DESC, ua.FirstName ASC LIMIT 20"; return mysqli_query($con, $sql); } function areFriends($con, $userId1, $userId2) { $sql = "SELECT COUNT(*) FROM Friends WHERE ((PrincipalID = '" . mysqli_real_escape_string($con, $userId1) . "' AND Friend = '" . mysqli_real_escape_string($con, $userId2) . "') OR (PrincipalID = '" . mysqli_real_escape_string($con, $userId2) . "' AND Friend = '" . mysqli_real_escape_string($con, $userId1) . "')) AND Flags > 0"; $result = mysqli_query($con, $sql); return $result ? mysqli_fetch_row($result)[0] > 0 : false; } function getFriendshipStats($con, $userId) { $totalFriends = mysqli_fetch_row(mysqli_query($con, " SELECT COUNT(*) FROM Friends WHERE (PrincipalID = '" . mysqli_real_escape_string($con, $userId) . "' OR Friend = '" . mysqli_real_escape_string($con, $userId) . "') AND Flags > 0 "))[0]; $pendingRequests = mysqli_fetch_row(mysqli_query($con, " SELECT COUNT(*) FROM Friends WHERE Friend = '" . mysqli_real_escape_string($con, $userId) . "' AND Flags = 0 "))[0]; $sentRequests = mysqli_fetch_row(mysqli_query($con, " SELECT COUNT(*) FROM Friends WHERE PrincipalID = '" . mysqli_real_escape_string($con, $userId) . "' AND Flags = 0 "))[0]; $onlineFriends = mysqli_fetch_row(mysqli_query($con, " SELECT COUNT(*) FROM Friends f LEFT JOIN GridUser gu ON ( CASE WHEN f.PrincipalID = '" . mysqli_real_escape_string($con, $userId) . "' THEN f.Friend = gu.UserID ELSE f.PrincipalID = gu.UserID END ) WHERE (f.PrincipalID = '" . mysqli_real_escape_string($con, $userId) . "' OR f.Friend = '" . mysqli_real_escape_string($con, $userId) . "') AND f.Flags > 0 AND gu.Login > (UNIX_TIMESTAMP() - 300) "))[0]; return [ 'total' => $totalFriends, 'pending' => $pendingRequests, 'sent' => $sentRequests, 'online' => $onlineFriends ]; } // Parameter verarbeiten $action = isset($_GET['action']) ? $_GET['action'] : 'list'; $search = isset($_GET['search']) ? trim($_GET['search']) : ''; $userId = isset($_GET['user']) ? $_GET['user'] : ''; // Dummy-Benutzer-ID für Demo (normalerweise aus Session) $currentUserId = '00000000-0000-0000-0000-000000000001'; // Beispiel-User-ID ?>
80 ? '...' : '')); ?>
Versuchen Sie es mit anderen Suchbegriffen.
Sie haben derzeit keine Freundschaftsanfragen.
Derzeit sind keine Ihrer Freunde online.