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
/**
 * Update Existing Applications Script
 * This script adds application_code to existing applications
 * Run once: http://localhost/samecar/update_existing_applications.php
 * DELETE THIS FILE AFTER RUNNING FOR SECURITY
 */

require_once 'config.php';

if (!isAdminLoggedIn()) {
    die('Access denied. Admin login required.');
}

$conn = getDBConnection();

// Check if application_code column exists
$columns = $conn->query("SHOW COLUMNS FROM applications LIKE 'application_code'");
if ($columns->num_rows == 0) {
    // Add column
    $conn->query("ALTER TABLE applications ADD COLUMN application_code VARCHAR(7) UNIQUE NULL AFTER id");
    $conn->query("ALTER TABLE applications ADD INDEX idx_application_code (application_code)");
    echo "<h2>Added application_code column</h2>";
}

// Get all applications without code
$apps = $conn->query("SELECT id FROM applications WHERE application_code IS NULL OR application_code = ''");

$updated = 0;
$errors = [];

echo "<h2>Updating Existing Applications</h2>";
echo "<pre>";

while ($app = $apps->fetch_assoc()) {
    $app_id = $app['id'];
    $new_code = generateApplicationCode($conn);
    $new_code_safe = sanitizeSQL($conn, $new_code);
    
    if ($conn->query("UPDATE applications SET application_code = '$new_code_safe' WHERE id = $app_id")) {
        $updated++;
        echo "Application #$app_id: Updated with code $new_code\n";
    } else {
        $errors[] = "Failed to update Application #$app_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='admin/dashboard.php'>Go to Admin Dashboard</a></p>";
echo "<p style='color:red;'><strong>IMPORTANT: Delete this file (update_existing_applications.php) after running!</strong></p>";
?>