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
require_once 'config.php';

$qr_id = isset($_GET['qr_id']) ? sanitizeInput($_GET['qr_id']) : '';

if (empty($qr_id)) {
    die('Invalid QR Code ID');
}

$conn = getDBConnection();

// Check if it's a 7-digit code or old numeric ID
if (strlen($qr_id) == 7 && is_numeric($qr_id)) {
    // New 7-digit code
    $qr_id_safe = sanitizeSQL($conn, $qr_id);
    $where_clause = "a.application_code = '$qr_id_safe'";
} else {
    // Old numeric ID (for backward compatibility)
    $qr_id_num = intval($qr_id);
    if ($qr_id_num > 0) {
        $where_clause = "a.id = $qr_id_num";
    } else {
        die('Invalid QR Code ID');
    }
}

// Get application details (public view - limited information)
$app = $conn->query("SELECT a.*, u.email 
                     FROM applications a 
                     JOIN users u ON a.user_id = u.id
                     WHERE $where_clause AND a.status = 'approved'")->fetch_assoc();

if (!$app) {
    die('Application not found or not approved.');
}

// Check if QR code is active (use application id for qr_codes table)
$app_id_for_qr = $app['id'];
$qr = $conn->query("SELECT is_active FROM qr_codes WHERE application_id = $app_id_for_qr")->fetch_assoc();
if (!$qr || !$qr['is_active']) {
    die('QR Code is not active.');
}

include 'header.php';
?>
<div class="main-content">
<div class="container my-5">
    <div class="row justify-content-center">
        <div class="col-md-10 col-lg-8">
            <div class="gov-card">
                <div class="gov-card-header text-center">
                    <i class="bi bi-shield-check-fill"></i>
                    <span>Owner Verification</span>
                </div>
                <div class="gov-card-body p-4">
                    <div class="alert alert-gov-success mb-4 text-center">
                        <i class="bi bi-check-circle-fill fs-4"></i>
                        <strong class="d-block mt-2">This information has been verified and approved by the official system.</strong>
                    </div>
                    
                    <?php if ($app['step3_owner_picture']): ?>
                        <div class="text-center mb-4 pb-4 border-bottom">
                            <img src="<?php echo UPLOAD_DIR . 'owners/' . $app['step3_owner_picture']; ?>" 
                                 class="img-thumbnail" style="width: 200px; height: 200px; object-fit: cover; border-radius: 50%; border: 4px solid var(--gov-green); box-shadow: var(--gov-shadow-sm);">
                            <h5 class="mt-3 fw-bold text-gov-green"><?php echo htmlspecialchars($app['step1_full_name']); ?></h5>
                        </div>
                    <?php endif; ?>
                    
                    <div class="row g-3 mb-4">
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Owner Name</small>
                                <strong><?php echo htmlspecialchars($app['step1_full_name']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Father Name</small>
                                <strong><?php echo htmlspecialchars($app['step1_father_name']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Vehicle Type</small>
                                <strong><?php echo htmlspecialchars($app['step2_vehicle_type']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Vehicle Name</small>
                                <strong><?php echo htmlspecialchars($app['step2_vehicle_name']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Vehicle Number</small>
                                <strong class="text-gov-green fs-5"><?php echo htmlspecialchars($app['step2_vehicle_number']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Vehicle Color</small>
                                <strong><?php echo htmlspecialchars($app['step3_vehicle_color']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">License ID</small>
                                <strong><?php echo htmlspecialchars($app['step3_license_id']); ?></strong>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="border rounded p-3 bg-light">
                                <small class="text-muted fw-bold d-block mb-1">Driving Experience</small>
                                <strong><?php echo htmlspecialchars($app['step3_driving_experience']); ?></strong>
                            </div>
                        </div>
                    </div>
                    
                    <?php if ($app['step3_vehicle_picture1']): ?>
                        <div class="mt-4 pt-4 border-top">
                            <h6 class="fw-bold mb-3"><i class="bi bi-images"></i> Vehicle Pictures</h6>
                            <div class="row g-3">
                                <div class="col-md-4">
                                    <img src="<?php echo UPLOAD_DIR . 'vehicles/' . $app['step3_vehicle_picture1']; ?>" 
                                         class="img-thumbnail w-100" style="height: 200px; object-fit: cover; border: 2px solid var(--gov-border);">
                                </div>
                                <?php if ($app['step3_vehicle_picture2']): ?>
                                    <div class="col-md-4">
                                        <img src="<?php echo UPLOAD_DIR . 'vehicles/' . $app['step3_vehicle_picture2']; ?>" 
                                             class="img-thumbnail w-100" style="height: 200px; object-fit: cover; border: 2px solid var(--gov-border);">
                                    </div>
                                <?php endif; ?>
                                <?php if ($app['step3_vehicle_picture3']): ?>
                                    <div class="col-md-4">
                                        <img src="<?php echo UPLOAD_DIR . 'vehicles/' . $app['step3_vehicle_picture3']; ?>" 
                                             class="img-thumbnail w-100" style="height: 200px; object-fit: cover; border: 2px solid var(--gov-border);">
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
</div>
</div>
<?php include 'footer.php'; ?>