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

-- Car Owner Management System Database
-- Create database and tables

CREATE DATABASE IF NOT EXISTS car_management;
USE car_management;

-- Users table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    full_name VARCHAR(255) NOT NULL,
    phone VARCHAR(20),
    profile_picture VARCHAR(255),
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Applications table
CREATE TABLE applications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    
    -- Personal Information
    full_name VARCHAR(255) NOT NULL,
    father_name VARCHAR(255) NOT NULL,
    age INT NOT NULL,
    education VARCHAR(255) NOT NULL,
    address TEXT NOT NULL,
    phone VARCHAR(20) NOT NULL,
    
    -- Vehicle Information
    email VARCHAR(255) NOT NULL,
    confirm_phone VARCHAR(20) NOT NULL,
    vehicle_type ENUM('Bike', 'Car', 'Truck') NOT NULL,
    vehicle_name VARCHAR(255) NOT NULL,
    vehicle_number VARCHAR(50) NOT NULL,
    
    -- Upload Information
    vehicle_picture1 VARCHAR(255),
    vehicle_picture2 VARCHAR(255),
    vehicle_picture3 VARCHAR(255),
    vehicle_color VARCHAR(50) NOT NULL,
    license_id VARCHAR(100) NOT NULL,
    driving_experience VARCHAR(50) NOT NULL,
    user_picture VARCHAR(255),
    
    -- Application Status
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    qr_code VARCHAR(255),
    qr_activated TINYINT(1) DEFAULT 0,
    admin_notes TEXT,
    
    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
);

-- Transactions table
CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    application_id INT NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    payment_method ENUM('Easypaisa', 'JazzCash') NOT NULL,
    transaction_id VARCHAR(255),
    status ENUM('pending', 'confirmed', 'rejected') DEFAULT 'pending',
    payment_proof VARCHAR(255),
    admin_notes TEXT,
    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
);

-- Settings table
CREATE TABLE settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    setting_key VARCHAR(100) UNIQUE NOT NULL,
    setting_value TEXT NOT NULL,
    description TEXT,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Admin users table
CREATE TABLE admin_users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    full_name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert default settings
INSERT INTO settings (setting_key, setting_value, description) VALUES
('qr_price_bike', '500', 'QR Code price for Bike in PKR'),
('qr_price_car', '800', 'QR Code price for Car in PKR'),
('qr_price_truck', '1200', 'QR Code price for Truck in PKR');

-- Insert default admin user (username: admin, password: admin123)
INSERT INTO admin_users (username, password, full_name, email) VALUES
('admin', '$2y$10$8K1p/mQIapnqcUaygGOeKOG4ZqA5Tc4Q5qoKbeXRBGzpHpAKfLfHy', 'System Administrator', 'admin@carmanagement.com');

-- Create indexes for better performance
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_applications_user_id ON applications(user_id);
CREATE INDEX idx_applications_status ON applications(status);
CREATE INDEX idx_transactions_user_id ON transactions(user_id);
CREATE INDEX idx_transactions_application_id ON transactions(application_id);
CREATE INDEX idx_transactions_status ON transactions(status);