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(['success' => false, 'error' => 'Unauthorized']);
    exit;
}

$user_id = $_SESSION['user_id'];

// Get stories from friends (created in last 24 hours)
$stmt = $pdo->prepare("
    SELECT s.id, s.user_id, s.media_url, s.type, s.content, s.bg_color, s.created_at, u.username, u.profile_pic_url,
    (SELECT COUNT(*) FROM story_views sv WHERE sv.story_id = s.id AND sv.user_id = ?) as is_seen
    FROM stories s
    JOIN users u ON s.user_id = u.id
    WHERE (s.user_id IN (SELECT user_id_1 FROM friends WHERE user_id_2 = ?) 
       OR s.user_id IN (SELECT user_id_2 FROM friends WHERE user_id_1 = ?)
       OR s.user_id = ?)
    AND s.created_at > DATE_SUB(NOW(), INTERVAL 24 HOUR)
    ORDER BY s.created_at DESC
");
$stmt->execute([$user_id, $user_id, $user_id, $user_id]);
$stories = $stmt->fetchAll();

// Group stories by user
$grouped = [];
foreach ($stories as $s) {
    if (!isset($grouped[$s['user_id']])) {
        $grouped[$s['user_id']] = [
            'user_id' => $s['user_id'],
            'username' => $s['username'],
            'profile_pic_url' => $s['profile_pic_url'],
            'all_seen' => true, // default true, will change to false if any unseen story found
            'stories' => []
        ];
    }

$is_seen = $s['is_seen'] > 0;
    if (!$is_seen) {
        $grouped[$s['user_id']]['all_seen'] = false;
    }

$grouped[$s['user_id']]['stories'][] = [
        'id' => $s['id'],
        'media_url' => $s['media_url'],
        'content' => $s['content'],
        'bg_color' => $s['bg_color'],
        'type' => $s['type'],
        'is_seen' => $is_seen,
        'created_at' => $s['created_at']
    ];
}

// Convert back to sequential array
echo json_encode(array_values($grouped));