byp4a55 professor6T9

Linux server313.web-hosting.com 4.18.0-553.54.1.lve.el8.x86_64 #1 SMP Wed Jun 4 13:01:13 UTC 2025 x86_64
LiteSpeed
66.29.141.225

File Name : fetch_dashboard.php

<?php
require_once '../config/config.php';

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

// Validate session
$user_id = $_SESSION['user_id'] ?? null;
if (!$user_id) {
    echo json_encode(['error' => 'Unauthorized']);
    exit;
}

try {
    // Query promotions where the user is the listing owner
    $query = "
        SELECT 
            ap.id,
            l.title,
            ap.referral_link,
            ap.reward_amount,
            ap.status,
            COUNT(DISTINCT pc.id) AS clicks,
            COUNT(DISTINCT pl.id) AS leads,
            COUNT(DISTINCT CASE WHEN pe.status = 'released' THEN pe.id ELSE NULL END) AS deals
        FROM ad_promotions ap
        INNER JOIN listings l ON ap.listing_id = l.id
        LEFT JOIN promotion_clicks pc ON pc.promotion_id = ap.id
        LEFT JOIN promotion_leads pl ON pl.promotion_id = ap.id
        LEFT JOIN promotion_escrow pe ON pe.promotion_id = ap.id
        WHERE ap.owner_id = ?
        GROUP BY ap.id
        ORDER BY ap.created_at DESC
    ";

$stmt = $conn->prepare($query);
    $stmt->execute([$user_id]);
    $promotions = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo json_encode(['promotions' => $promotions]);

} catch (PDOException $e) {
    echo json_encode(['error' => 'Database error', 'details' => $e->getMessage()]);
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	livisdkr/livisdkr	0755	2025-12-13 08:26:09
..	dir	-	livisdkr/nobody	0750	2026-03-01 02:48:46
promote_ads	dir	-	livisdkr/livisdkr	0755	2026-02-27 06:45:55
.htaccess	text/plain	127 B	livisdkr/livisdkr	0444	2025-12-13 08:25:55
apply-promotion.php	text/x-php	1.05 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:32
confirm-deal.php	text/x-php	2.24 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:31
create_promotion.php	text/x-php	1.24 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:33
error_log	text/plain	6.23 KB	livisdkr/livisdkr	0644	2025-12-13 07:45:47
fetch_dashboard.php	text/x-php	1.27 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:33
fetch_promoter_dashboard.php	text/x-php	1.02 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:34
my_promotions.php	text/x-php	1.84 KB	livisdkr/livisdkr	0644	2025-05-31 02:18:57
referral.php	text/x-php	972 B	livisdkr/livisdkr	0644	2025-05-31 02:18:57
request_promotion.php	text/x-php	2.12 KB	livisdkr/livisdkr	0644	2025-05-31 02:18:58
submit-lead.php	text/x-php	2.06 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:35
track-click.php	text/x-php	1.34 KB	livisdkr/livisdkr	0644	2025-08-15 12:47:36

Team Anon Force

https://t.me/Professor6T9x