Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-11-15 16:11
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
cgi-bin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
qr_codes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
samecar	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
uploads	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
2V3RLatL.php	445 B	-rw-r--r--	2026-02-23 13:08
INSTALLATION.txt	1.59 KB	-rw-r--r--	2025-11-15 19:41
README.md	4.67 KB	-rw-r--r--	2025-11-15 19:41
change_language.php	413 B	-rw-r--r--	2025-11-15 19:33
check_gd.php	1.71 KB	-rw-r--r--	2025-11-15 20:15
check_user.php	1.17 KB	-rw-r--r--	2025-11-15 20:04
completed_applications.php	5.79 KB	-rw-r--r--	2025-11-15 20:31
config.php	10.52 KB	-rw-r--r--	2025-11-15 15:47
dashboard.php	4.61 KB	-rw-r--r--	2025-11-15 20:31
database.sql	4.76 KB	-rw-r--r--	2025-11-15 15:46
error_log	2.12 KB	-rw-r--r--	2025-12-06 06:58
fix_qr_codes.php	2.21 KB	-rw-r--r--	2025-11-15 19:55
footer.php	2.68 KB	-rw-r--r--	2025-11-15 20:31
generate_qr.php	1.2 KB	-rw-r--r--	2025-11-15 19:37
header.php	16.38 KB	-rw-r--r--	2025-11-15 20:31
index.php	3.01 KB	-rw-r--r--	2025-11-15 20:31
login.php	4.61 KB	-rw-r--r--	2025-11-15 20:31
logout.php	85 B	-rw-r--r--	2025-11-15 19:33
new_application.php	26.13 KB	-rw-r--r--	2025-11-15 20:31
payment.php	6.09 KB	-rw-r--r--	2025-11-15 20:31
payment_history.php	4.1 KB	-rw-r--r--	2025-11-15 20:31
pending_applications.php	5.21 KB	-rw-r--r--	2025-11-15 20:31
profile.php	17.09 KB	-rw-r--r--	2025-11-15 20:31
register.php	5.87 KB	-rw-r--r--	2025-11-15 20:31
samecar.zip	71.94 MB	-rw-r--r--	2025-11-15 15:45
setup_admin.php	5.25 KB	-rw-r--r--	2025-11-15 19:48
submit_payment.php	2.36 KB	-rw-r--r--	2025-11-15 19:36
test_admin.php	1.99 KB	-rw-r--r--	2025-11-15 19:48
txets.php	4.37 KB	-rw-r--r--	2026-02-24 02:50
update_existing_applications.php	1.89 KB	-rw-r--r--	2025-11-15 20:01
view_qr.php	7.8 KB	-rw-r--r--	2025-11-15 20:31
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
yKytReRg.php	445 B	-rw-r--r--	2026-02-22 23:14

Rename

<?php
/**
 * Fix QR Codes Script
 * This script updates QR code paths in database to use full URLs
 * Run once: http://localhost/samecar/fix_qr_codes.php
 */

require_once 'config.php';

if (!isAdminLoggedIn() && !isUserLoggedIn()) {
    die('Access denied. Please login first.');
}

$conn = getDBConnection();
$updated = 0;
$errors = [];

// Get all QR codes
$qr_codes = $conn->query("SELECT id, application_id, qr_code_path FROM qr_codes");

echo "<h2>Fixing QR Code Paths</h2>";
echo "<pre>";

while ($qr = $qr_codes->fetch_assoc()) {
    $old_path = $qr['qr_code_path'];
    $new_path = '';
    
    // Check if path is already a full URL
    if (strpos($old_path, 'http') === 0) {
        echo "QR Code #{$qr['id']}: Already has full URL\n";
        continue;
    }
    
    // Check if file exists locally
    if (file_exists($old_path)) {
        // Convert to full URL
        $new_path = SITE_URL . $old_path;
    } elseif (file_exists(QR_CODE_DIR . basename($old_path))) {
        // Try with QR_CODE_DIR
        $new_path = SITE_URL . QR_CODE_DIR . basename($old_path);
    } else {
        // Generate new QR code using API
        $app_id = $qr['application_id'];
        $qr_data = SITE_URL . "view_qr.php?qr_id=" . $app_id;
        $qr_api_url = "https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=" . urlencode($qr_data);
        $new_path = $qr_api_url;
        echo "QR Code #{$qr['id']}: File not found, using API URL\n";
    }
    
    // Update in database
    if ($new_path) {
        $new_path_safe = sanitizeSQL($conn, $new_path);
        if ($conn->query("UPDATE qr_codes SET qr_code_path = '$new_path_safe' WHERE id = {$qr['id']}")) {
            $updated++;
            echo "QR Code #{$qr['id']}: Updated successfully\n";
            echo "  Old: $old_path\n";
            echo "  New: $new_path\n\n";
        } else {
            $errors[] = "Failed to update QR Code #{$qr['id']}";
        }
    }
}

echo "\n\n";
echo "Total Updated: $updated\n";
if (count($errors) > 0) {
    echo "Errors:\n";
    foreach ($errors as $error) {
        echo "  - $error\n";
    }
}

echo "</pre>";
echo "<p><a href='dashboard.php'>Go to Dashboard</a></p>";
?>