getConnection(); // Get top users by followers $query = "SELECT u.id, u.name, u.phone, u.profile_picture, (SELECT COUNT(*) FROM user_followers WHERE following_id = u.id) as total_followers, (SELECT COUNT(*) FROM user_followers WHERE follower_id = u.id) as total_following, (SELECT COUNT(*) FROM post_likes pl JOIN posts p ON pl.post_id = p.id WHERE p.user_id = u.id) as total_likes, (SELECT COUNT(*) FROM posts WHERE user_id = u.id) as posts_count FROM users u WHERE u.role = 'user' ORDER BY total_followers DESC LIMIT 50"; $stmt = $db->prepare($query); $stmt->execute(); $top_users = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get recent followers activity $query = "SELECT uf.*, u1.name as follower_name, u1.profile_picture as follower_pic, u2.name as following_name, u2.profile_picture as following_pic FROM user_followers uf JOIN users u1 ON uf.follower_id = u1.id JOIN users u2 ON uf.following_id = u2.id ORDER BY uf.created_at DESC LIMIT 20"; $stmt = $db->prepare($query); $stmt->execute(); $recent_follows = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $error = "خطأ: " . $e->getMessage(); $top_users = []; $recent_follows = []; } ?> المتابعين - Roz Skin

إحصائيات المتابعين

إجمالي المستخدمين

إجمالي المتابعات

إجمالي المنشورات

إجمالي الإعجابات

المستخدمون الأكثر متابعة

$user): ?>
#
<?php echo htmlspecialchars($user['name']); ?>

منشور

إعجاب

لا توجد بيانات متابعين

آخر المتابعات

<?php echo htmlspecialchars($follow['follower_name']); ?>

يتابع

<?php echo htmlspecialchars($follow['following_name']); ?>

لا توجد متابعات حديثة