Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
call_actions.php	3.5 KB	-rw-r--r--	2026-02-22 20:21
chat_actions.php	4.36 KB	-rw-r--r--	2026-02-22 19:13
delete_story.php	1.79 KB	-rw-r--r--	2026-02-21 23:17
error_log	14.72 KB	-rw-r--r--	2026-03-05 18:14
get_friends.php	1.83 KB	-rw-r--r--	2026-02-22 18:39
get_messages.php	1.17 KB	-rw-r--r--	2026-02-22 17:43
get_my_stories.php	1.02 KB	-rw-r--r--	2026-02-21 23:06
get_stories.php	1.92 KB	-rw-r--r--	2026-02-21 23:03
handle_request.php	2.05 KB	-rw-r--r--	2026-02-21 21:55
mark_story_seen.php	853 B	-rw-r--r--	2026-02-21 23:03
message_action.php	1.8 KB	-rw-r--r--	2026-02-21 23:19
search_users.php	1.07 KB	-rw-r--r--	2026-02-21 21:55
send_message.php	1.68 KB	-rw-r--r--	2026-02-21 23:17
send_request.php	1.65 KB	-rw-r--r--	2026-02-21 22:18
update_profile.php	4.85 KB	-rw-r--r--	2026-02-21 22:49
upload_chat_media.php	1.86 KB	-rw-r--r--	2026-02-22 18:37
upload_story.php	2.6 KB	-rw-r--r--	2026-02-21 22:59
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
session_start();
require_once '../includes/db.php';
require_once '../includes/functions.php';

header('Content-Type: application/json');

if (!isLoggedIn()) {
    echo json_encode(['error' => 'Not authenticated']);
    exit;
}

$user_id = $_SESSION['user_id'];

// Update current user's last_seen only (this is the heartbeat)
try {
    $pdo->prepare("UPDATE users SET last_seen = NOW() WHERE id = ?")->execute([$user_id]);
}
catch (PDOException $e) {
}

// Get friends with their unread message count.
// We calculate is_online on the fly: if last_seen is within last 15 seconds, they are online.
$friendsQuery = $pdo->prepare("
    SELECT u.id, u.username, u.profile_pic_url, u.last_seen,
           (u.last_seen >= DATE_SUB(NOW(), INTERVAL 15 SECOND)) as is_online,
           (SELECT COUNT(*) FROM messages m WHERE m.sender_id = u.id AND m.receiver_id = ? AND m.status != 'read') as unread_count
    FROM friends f
    JOIN users u ON (f.user_id_1 = u.id OR f.user_id_2 = u.id)
    WHERE (f.user_id_1 = ? OR f.user_id_2 = ?) AND u.id != ?
");
$friendsQuery->execute([$user_id, $user_id, $user_id, $user_id]);
$friends = $friendsQuery->fetchAll();

// Mark delivered for received messages if user is fetching friends online
try {
    $pdo->prepare("UPDATE messages SET status = 'delivered' WHERE receiver_id = ? AND status = 'sent'")->execute([$user_id]);
}
catch (PDOException $e) {
// Log but continue
}

// Get incoming requests
$reqQuery = $pdo->prepare("
    SELECT fr.id as request_id, u.id as sender_id, u.username, u.profile_pic_url 
    FROM friend_requests fr
    JOIN users u ON fr.sender_id = u.id
    WHERE fr.receiver_id = ? AND fr.status = 'pending'
");
$reqQuery->execute([$user_id]);
$requests = $reqQuery->fetchAll();

echo json_encode([
    'friends' => $friends,
    'requests' => $requests
]);