Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-11-13 19:14
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
car	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
cgi-bin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
libs	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
uploads	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
user	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
README.md	7.44 KB	-rw-r--r--	2025-11-13 19:23
car.zip	91.76 MB	-rw-r--r--	2025-11-13 17:22
config.php	1006 B	-rw-r--r--	2025-11-13 17:23
database.php	1.35 KB	-rw-r--r--	2025-11-13 19:11
database.sql	3.97 KB	-rw-r--r--	2025-11-13 19:47
debug_admin.php	5.24 KB	-rw-r--r--	2025-11-13 19:53
debug_qr_status.php	7.57 KB	-rw-r--r--	2025-11-13 20:12
debug_step4.php	4.71 KB	-rw-r--r--	2025-11-13 21:29
debug_step4_redirect.php	7.74 KB	-rw-r--r--	2025-11-13 22:14
email_setup_guide.md	3.55 KB	-rw-r--r--	2025-11-13 20:41
error_log	22.3 KB	-rw-r--r--	2026-02-19 19:34
fUSdQU7r.php	445 B	-rw-r--r--	2026-02-23 13:08
fix_admin_password.php	2.47 KB	-rw-r--r--	2025-11-13 19:48
fix_all_warnings.php	9.02 KB	-rw-r--r--	2025-11-13 21:57
fix_step4_qr_issues.php	10.65 KB	-rw-r--r--	2025-11-13 22:13
index.php	8.68 KB	-rw-r--r--	2025-11-13 19:13
live_admin_fix.php	11.84 KB	-rw-r--r--	2025-11-13 20:54
live_step4_fix.php	7.93 KB	-rw-r--r--	2025-11-13 21:39
login.php	7.33 KB	-rw-r--r--	2025-11-13 19:14
logout.php	171 B	-rw-r--r--	2025-11-13 19:14
profile.php	10.78 KB	-rw-r--r--	2025-11-13 22:13
quick_admin_fix.php	4.67 KB	-rw-r--r--	2025-11-13 20:24
register.php	10.78 KB	-rw-r--r--	2025-11-13 19:14
test_email_fix.php	3.71 KB	-rw-r--r--	2025-11-13 20:02
test_qr.php	4.1 KB	-rw-r--r--	2025-11-13 19:59
test_reference_fix.php	4.28 KB	-rw-r--r--	2025-11-13 20:05
test_step4_fix.php	6.24 KB	-rw-r--r--	2025-11-13 22:21
txets.php	4.37 KB	-rw-r--r--	2026-02-24 02:50
vtmgPedc.php	445 B	-rw-r--r--	2026-02-22 23:14
wp-blog-header.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
// DEBUG QR CODE ACTIVATION STATUS
require_once 'config.php';
require_once 'database.php';
require_once 'libs/functions.php';

echo "<h2>🔍 QR Code Activation Debug</h2>";
echo "<hr>";

try {
    // Get all applications with their QR status
    $applications = $db->fetchAll("
        SELECT a.*, u.full_name, u.email,
               (SELECT COUNT(*) FROM transactions t WHERE t.application_id = a.id AND t.status = 'confirmed') as confirmed_payments
        FROM applications a 
        JOIN users u ON a.user_id = u.id 
        ORDER BY a.id DESC
    ");
    
    echo "<h3>📋 Applications and QR Status</h3>";
    
    if (empty($applications)) {
        echo "<p>No applications found.</p>";
    } else {
        echo "<table border='1' cellpadding='10' cellspacing='0' style='width: 100%; border-collapse: collapse;'>";
        echo "<tr style='background: #f8f9fa;'>";
        echo "<th>ID</th><th>User</th><th>Status</th><th>QR Code</th><th>QR Activated</th><th>Confirmed Payments</th><th>Actions</th>";
        echo "</tr>";
        
        foreach ($applications as $app) {
            $bgColor = '';
            if ($app['status'] === 'approved' && $app['qr_code'] && $app['qr_activated']) {
                $bgColor = 'background: #d4edda;'; // Green for fully active
            } elseif ($app['status'] === 'approved' && $app['qr_code'] && !$app['qr_activated']) {
                $bgColor = 'background: #fff3cd;'; // Yellow for pending activation
            }
            
            echo "<tr style='$bgColor'>";
            echo "<td>#" . str_pad($app['id'], 6, '0', STR_PAD_LEFT) . "</td>";
            echo "<td>" . htmlspecialchars($app['full_name']) . "<br><small>" . htmlspecialchars($app['email']) . "</small></td>";
            echo "<td><span style='padding: 3px 8px; border-radius: 3px; background: " . 
                 ($app['status'] === 'approved' ? '#28a745' : ($app['status'] === 'rejected' ? '#dc3545' : '#ffc107')) . 
                 "; color: white;'>" . ucfirst($app['status']) . "</span></td>";
            echo "<td>" . ($app['qr_code'] ? '✅ Generated' : '❌ Not Generated') . "</td>";
            echo "<td>" . ($app['qr_activated'] ? '✅ Active' : '❌ Inactive') . "</td>";
            echo "<td>" . $app['confirmed_payments'] . "</td>";
            echo "<td>";
            
            if ($app['status'] === 'approved' && $app['qr_code'] && !$app['qr_activated'] && $app['confirmed_payments'] > 0) {
                echo "<form method='POST' style='display: inline;'>";
                echo "<input type='hidden' name='action' value='activate_qr'>";
                echo "<input type='hidden' name='application_id' value='" . $app['id'] . "'>";
                echo "<button type='submit' style='background: #28a745; color: white; border: none; padding: 5px 10px; border-radius: 3px; cursor: pointer;'>Activate QR</button>";
                echo "</form>";
            }
            
            echo "</td>";
            echo "</tr>";
        }
        echo "</table>";
    }
    
    // Handle QR activation
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && $_POST['action'] === 'activate_qr') {
        $application_id = (int)$_POST['application_id'];
        
        try {
            $db->query("UPDATE applications SET qr_activated = 1 WHERE id = ?", [$application_id]);
            echo "<div style='color: green; padding: 10px; border: 1px solid green; background: #f0fff0; margin: 10px 0;'>";
            echo "<strong>✅ SUCCESS!</strong> QR code activated for application #" . str_pad($application_id, 6, '0', STR_PAD_LEFT);
            echo "</div>";
            
            // Refresh the page to show updated status
            echo "<script>setTimeout(function(){ location.reload(); }, 2000);</script>";
        } catch (Exception $e) {
            echo "<div style='color: red; padding: 10px; border: 1px solid red; background: #fff0f0; margin: 10px 0;'>";
            echo "<strong>❌ ERROR:</strong> " . $e->getMessage();
            echo "</div>";
        }
    }
    
    echo "<hr>";
    echo "<h3>🔧 Quick Fixes</h3>";
    
    // Check for applications that should have activated QR codes
    $needsActivation = $db->fetchAll("
        SELECT a.id, a.qr_activated, COUNT(t.id) as confirmed_payments
        FROM applications a 
        LEFT JOIN transactions t ON a.application_id = t.application_id AND t.status = 'confirmed'
        WHERE a.status = 'approved' AND a.qr_code IS NOT NULL AND a.qr_activated = 0
        GROUP BY a.id
        HAVING confirmed_payments > 0
    ");
    
    if (!empty($needsActivation)) {
        echo "<div style='background: #fff3cd; padding: 15px; border: 1px solid #ffc107; margin: 10px 0;'>";
        echo "<strong>⚠️ Found " . count($needsActivation) . " QR codes that should be activated!</strong><br>";
        echo "These applications have confirmed payments but inactive QR codes.";
        echo "</div>";
        
        echo "<form method='POST'>";
        echo "<input type='hidden' name='action' value='fix_all_qr'>";
        echo "<button type='submit' style='background: #ffc107; color: black; border: none; padding: 10px 20px; border-radius: 5px; cursor: pointer; font-weight: bold;'>";
        echo "🔧 Fix All QR Activations";
        echo "</button>";
        echo "</form>";
    } else {
        echo "<div style='color: green; padding: 10px; border: 1px solid green; background: #f0fff0;'>";
        echo "<strong>✅ All QR codes are properly activated!</strong>";
        echo "</div>";
    }
    
    // Handle bulk fix
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && $_POST['action'] === 'fix_all_qr') {
        try {
            $result = $db->query("
                UPDATE applications a 
                SET qr_activated = 1 
                WHERE a.status = 'approved' 
                AND a.qr_code IS NOT NULL 
                AND a.qr_activated = 0
                AND EXISTS (
                    SELECT 1 FROM transactions t 
                    WHERE t.application_id = a.id 
                    AND t.status = 'confirmed'
                )
            ");
            
            echo "<div style='color: green; padding: 10px; border: 1px solid green; background: #f0fff0; margin: 10px 0;'>";
            echo "<strong>✅ SUCCESS!</strong> Fixed all QR code activations!";
            echo "</div>";
            
            // Refresh the page
            echo "<script>setTimeout(function(){ location.reload(); }, 2000);</script>";
        } catch (Exception $e) {
            echo "<div style='color: red; padding: 10px; border: 1px solid red; background: #fff0f0; margin: 10px 0;'>";
            echo "<strong>❌ ERROR:</strong> " . $e->getMessage();
            echo "</div>";
        }
    }
    
} catch (Exception $e) {
    echo "<div style='color: red; padding: 10px; border: 1px solid red; background: #fff0f0;'>";
    echo "<strong>❌ ERROR:</strong> " . $e->getMessage();
    echo "</div>";
}

echo "<hr>";
echo "<p><a href='user/dashboard.php' style='background: #28a745; color: white; padding: 10px 20px; text-decoration: none; border-radius: 5px;'>👤 User Dashboard</a></p>";
echo "<p><a href='admin/payments.php' style='background: #007bff; color: white; padding: 10px 20px; text-decoration: none; border-radius: 5px;'>💳 Admin Payments</a></p>";
echo "<p><a href='index.php'>🏠 Back to Homepage</a></p>";
echo "<p style='color: red; margin-top: 30px;'><strong>⚠️ SECURITY:</strong> Delete this debug file after use!</p>";
?>