Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2026-01-09 22:13
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
fast-earn-limited	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
includes	[ 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
ADMIN_LOGIN.txt	13.54 KB	-rw-r--r--	2025-12-22 19:34
COMPLETION.txt	20.92 KB	-rw-r--r--	2025-12-22 19:22
FEATURES.txt	16.92 KB	-rw-r--r--	2025-12-22 19:13
FIX_DATABASE_ERROR.txt	8.7 KB	-rw-r--r--	2025-12-22 19:37
FIX_UPLOAD_ERROR.txt	10.1 KB	-rw-r--r--	2025-12-22 19:45
INSTALLATION.txt	8.73 KB	-rw-r--r--	2025-12-22 19:12
PROJECT_STATUS.txt	12.33 KB	-rw-r--r--	2025-12-22 19:14
QUICK_START.txt	14.12 KB	-rw-r--r--	2025-12-22 19:15
README.md	10.54 KB	-rw-r--r--	2025-12-22 19:11
V2_UPGRADE_NOTES.txt	5.88 KB	-rw-r--r--	2025-12-22 20:04
checkout.php	16.2 KB	-rw-r--r--	2026-01-07 16:26
contact.php	6.71 KB	-rw-r--r--	2026-01-07 16:36
create_folders.php	2.91 KB	-rw-r--r--	2025-12-22 19:44
database.sql	9.14 KB	-rw-r--r--	2025-12-22 19:52
full_setup.php	29.74 KB	-rw-r--r--	2026-01-26 16:55
index.php	30.43 KB	-rw-r--r--	2026-01-07 16:56
login.php	8.83 KB	-rw-r--r--	2025-12-30 13:45
logout.php	151 B	-rw-r--r--	2025-12-22 19:01
products.php	4.69 KB	-rw-r--r--	2026-01-07 16:39
register.php	14.14 KB	-rw-r--r--	2025-12-30 13:25
seed_products.php	559 B	-rw-r--r--	2026-01-07 16:15
update_database.sql	781 B	-rw-r--r--	2025-12-22 19:36
update_db.php	4.07 KB	-rw-r--r--	2025-12-22 19:36
update_db_v10.php	816 B	-rw-r--r--	2025-12-24 21:22
update_db_v11.php	681 B	-rw-r--r--	2025-12-24 21:53
update_db_v12.php	590 B	-rw-r--r--	2026-01-07 16:12
update_db_v2.php	2.13 KB	-rw-r--r--	2025-12-22 19:53
update_db_v3.php	2.76 KB	-rw-r--r--	2025-12-22 20:05
update_db_v4.php	1.43 KB	-rw-r--r--	2025-12-22 20:11
update_db_v5.php	1.9 KB	-rw-r--r--	2025-12-23 19:11
update_db_v6.php	1.91 KB	-rw-r--r--	2025-12-23 19:29
update_db_v7.php	3.05 KB	-rw-r--r--	2025-12-23 19:33
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

<?php
/**
 * Database Update Script
 * Run this file ONCE to add missing columns to existing database
 * Access: http://localhost/222/fast-earn-limited/update_db.php
 */

require_once 'includes/config.php';

echo "<!DOCTYPE html>
<html>
<head>
    <title>Database Update</title>
    <style>
        body { font-family: Arial, sans-serif; max-width: 800px; margin: 50px auto; padding: 20px; background: #f5f5f5; }
        .success { background: #d4edda; color: #155724; padding: 15px; border-radius: 5px; margin: 10px 0; }
        .error { background: #f8d7da; color: #721c24; padding: 15px; border-radius: 5px; margin: 10px 0; }
        .info { background: #d1ecf1; color: #0c5460; padding: 15px; border-radius: 5px; margin: 10px 0; }
        h1 { color: #333; }
        pre { background: #fff; padding: 10px; border-radius: 5px; overflow-x: auto; }
    </style>
</head>
<body>
    <h1>🔧 Database Update Script</h1>
";

try {
    echo "<div class='info'>Starting database update...</div>";

// Check if columns already exist
    $stmt = $pdo->query("SHOW COLUMNS FROM users LIKE 'username'");
    $usernameExists = $stmt->rowCount() > 0;

$stmt = $pdo->query("SHOW COLUMNS FROM users LIKE 'role'");
    $roleExists = $stmt->rowCount() > 0;

// Add username column if it doesn't exist
    if (!$usernameExists) {
        echo "<div class='info'>Adding 'username' column...</div>";
        $pdo->exec("ALTER TABLE users ADD COLUMN username VARCHAR(50) UNIQUE DEFAULT NULL COMMENT 'Username for admin login' AFTER id");
        echo "<div class='success'>✓ Added 'username' column</div>";
    } else {
        echo "<div class='info'>✓ 'username' column already exists</div>";
    }

// Add role column if it doesn't exist
    if (!$roleExists) {
        echo "<div class='info'>Adding 'role' column...</div>";
        $pdo->exec("ALTER TABLE users ADD COLUMN role ENUM('user', 'admin') DEFAULT 'user' COMMENT 'User role' AFTER password");
        echo "<div class='success'>✓ Added 'role' column</div>";
    } else {
        echo "<div class='info'>✓ 'role' column already exists</div>";
    }

// Update admin user (ID = 1)
    echo "<div class='info'>Updating admin user...</div>";
    $stmt = $pdo->prepare("UPDATE users SET username = ?, role = ?, full_name = ? WHERE id = 1");
    $stmt->execute(['admin', 'admin', 'Administrator']);
    echo "<div class='success'>✓ Admin user updated (username: admin, role: admin)</div>";

// Set all other users to role 'user'
    echo "<div class='info'>Setting role for existing users...</div>";
    $pdo->exec("UPDATE users SET role = 'user' WHERE id != 1 AND (role IS NULL OR role = '')");
    echo "<div class='success'>✓ All users updated with role='user'</div>";

// Show admin credentials
    echo "<div class='success'>
        <h2>✅ Database Update Complete!</h2>
        <p><strong>Admin Login Credentials:</strong></p>
        <pre>
URL:      http://localhost/222/fast-earn-limited/admin/login.php
Username: admin
Email:    admin@fastearn.com
Phone:    03000000000
Password: admin123
        </pre>
        <p><strong>User Login:</strong></p>
        <pre>
URL: http://localhost/222/fast-earn-limited/login.php
        </pre>
    </div>";

echo "<div class='info'>
        <strong>⚠️ IMPORTANT:</strong> For security, please delete this file (update_db.php) after running it.
    </div>";

echo "<div style='margin-top: 20px;'>
        <a href='admin/login.php' style='display: inline-block; background: #007bff; color: white; padding: 10px 20px; text-decoration: none; border-radius: 5px; margin-right: 10px;'>
            Go to Admin Login
        </a>
        <a href='login.php' style='display: inline-block; background: #28a745; color: white; padding: 10px 20px; text-decoration: none; border-radius: 5px;'>
            Go to User Login
        </a>
    </div>";

} catch (PDOException $e) {
    echo "<div class='error'>
        <h3>❌ Error:</h3>
        <pre>" . htmlspecialchars($e->getMessage()) . "</pre>
    </div>";
}

echo "</body></html>";
?>