Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/soundstudiopro.com/private_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * IMMEDIATE FIX: Restore Stéphane to Essential Plan
 */

require_once __DIR__ . '/config/database.php';

$pdo = getDBConnection();

// Get Stéphane's info
$stmt = $pdo->prepare("SELECT id, name, email, plan, credits FROM users WHERE email = ? OR id = 5");
$stmt->execute(['stevenberg450@gmail.com']);
$user = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$user) {
    die("User not found\n");
}

echo "BEFORE FIX:\n";
echo "User ID: {$user['id']}\n";
echo "Name: {$user['name']}\n";
echo "Email: {$user['email']}\n";
echo "Current Plan: {$user['plan']}\n";
echo "Credits: {$user['credits']}\n\n";

// Get his subscription
$sub_stmt = $pdo->prepare("SELECT plan_name, status FROM user_subscriptions WHERE user_id = ? ORDER BY created_at DESC LIMIT 1");
$sub_stmt->execute([$user['id']]);
$subscription = $sub_stmt->fetch(PDO::FETCH_ASSOC);

if ($subscription) {
    echo "Subscription Plan: {$subscription['plan_name']}\n";
    echo "Status: {$subscription['status']}\n\n";
}

// FIX IT NOW - Set to essential
try {
    $pdo->beginTransaction();
    
    // Update plan to essential
    $update = $pdo->prepare("UPDATE users SET plan = 'essential' WHERE id = ?");
    $update->execute([$user['id']]);
    
    // Update monthly_track_usage if exists
    $usage_stmt = $pdo->prepare("SELECT id, track_limit FROM monthly_track_usage WHERE user_id = ? ORDER BY created_at DESC LIMIT 1");
    $usage_stmt->execute([$user['id']]);
    $usage = $usage_stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($usage && $usage['track_limit'] != 5) {
        $fix_usage = $pdo->prepare("UPDATE monthly_track_usage SET track_limit = 5 WHERE id = ?");
        $fix_usage->execute([$usage['id']]);
        echo "Updated track_limit to 5\n";
    }
    
    $pdo->commit();
    
    // Verify
    $verify = $pdo->prepare("SELECT plan FROM users WHERE id = ?");
    $verify->execute([$user['id']]);
    $fixed = $verify->fetch(PDO::FETCH_ASSOC);
    
    echo "\n✅ FIXED!\n";
    echo "Plan is now: {$fixed['plan']}\n";
    echo "Track limit: 5 (Essential plan)\n";
    
} catch (Exception $e) {
    if ($pdo->inTransaction()) {
        $pdo->rollBack();
    }
    die("ERROR: " . $e->getMessage() . "\n");
}