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

-- Car & Vehicle Owner Verification System Database
-- Created for XAMPP/MySQL

CREATE DATABASE IF NOT EXISTS fastear1_carowner;
USE fastear1_carowner;

-- Users Table
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    full_name VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_email (email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Applications Table
CREATE TABLE IF NOT EXISTS applications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    application_code VARCHAR(7) UNIQUE NOT NULL,
    user_id INT NOT NULL,
    step1_full_name VARCHAR(255) NOT NULL,
    step1_father_name VARCHAR(255) NOT NULL,
    step1_age INT NOT NULL,
    step1_education VARCHAR(255) NOT NULL,
    step1_address TEXT NOT NULL,
    step1_phone VARCHAR(20) NOT NULL,
    step2_email VARCHAR(255) NOT NULL,
    step2_confirm_phone VARCHAR(20) NOT NULL,
    step2_vehicle_type VARCHAR(50) NOT NULL,
    step2_vehicle_name VARCHAR(255) NOT NULL,
    step2_vehicle_number VARCHAR(100) NOT NULL,
    step2_vehicle_confirm_number VARCHAR(100) NOT NULL,
    step3_confirm_name VARCHAR(255) NOT NULL,
    step3_vehicle_picture1 VARCHAR(255),
    step3_vehicle_picture2 VARCHAR(255),
    step3_vehicle_picture3 VARCHAR(255),
    step3_vehicle_color VARCHAR(50) NOT NULL,
    step3_license_id VARCHAR(100) NOT NULL,
    step3_driving_experience VARCHAR(50) NOT NULL,
    step3_owner_picture VARCHAR(255),
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    INDEX idx_user_id (user_id),
    INDEX idx_status (status),
    INDEX idx_application_code (application_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Payments Table
CREATE TABLE IF NOT EXISTS payments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    application_id INT NOT NULL,
    vehicle_type VARCHAR(50) NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    status ENUM('pending', 'paid', 'rejected') DEFAULT 'pending',
    payment_method VARCHAR(50),
    transaction_id VARCHAR(100),
    payment_proof VARCHAR(255),
    payment_date TIMESTAMP NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (application_id) REFERENCES applications(id) ON DELETE CASCADE,
    INDEX idx_user_id (user_id),
    INDEX idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- QR Codes Table
CREATE TABLE IF NOT EXISTS qr_codes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    application_id INT NOT NULL,
    qr_code_path VARCHAR(255) NOT NULL,
    qr_code_data TEXT NOT NULL,
    is_active TINYINT(1) DEFAULT 0,
    activated_at TIMESTAMP NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (application_id) REFERENCES applications(id) ON DELETE CASCADE,
    INDEX idx_user_id (user_id),
    INDEX idx_is_active (is_active)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Admin Table
CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Vehicle Types Pricing Table
CREATE TABLE IF NOT EXISTS vehicle_pricing (
    id INT AUTO_INCREMENT PRIMARY KEY,
    vehicle_type VARCHAR(50) UNIQUE NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert Default Admin (username: admin, password: admin123)
-- Note: If login fails, run setup_admin.php or test_admin.php to fix password hash
INSERT INTO admins (username, password) VALUES 
('admin', '$2y$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LJZdL17lhWy') 
ON DUPLICATE KEY UPDATE username=username;
-- Default password: admin123 (hashed with bcrypt)
-- If this hash doesn't work, use setup_admin.php to create/update admin

-- Insert Default Vehicle Types and Pricing
INSERT INTO vehicle_pricing (vehicle_type, price) VALUES
('Motorcycle', 500.00),
('Car', 1000.00),
('SUV', 1500.00),
('Truck', 2000.00),
('Van', 1200.00),
('Bus', 2500.00),
('Rickshaw', 600.00),
('Auto Rickshaw', 600.00)
ON DUPLICATE KEY UPDATE vehicle_type=vehicle_type;