Gecko [ fastearnlimited.com ]

Linux spg1.cloudpowerdns.com 5.14.0-611.34.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Feb 18 05:51:10 EST 2026 x86_64
LiteSpeed
Server IP : 176.9.63.151 & Your IP : 216.73.217.60
Domains : Cant Read [ /etc/named.conf ]
User : fastear1

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 V6 - Random Referral Codes
 */
require_once 'includes/config.php';

echo "<h2>⚙️ Setting up Random Referral Codes...</h2>";

try {
    // 1. Add referral_code column to users table
    $pdo->exec("ALTER TABLE users ADD COLUMN referral_code VARCHAR(20) UNIQUE AFTER id");
    echo "<p style='color:green'>✓ Added 'referral_code' column to users table</p>";

// 2. Generate random 7-character codes for existing users
    function generateReferralCode()
    {
        $chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
        $code = "";
        for ($i = 0; $i < 7; $i++) {
            $code .= $chars[rand(0, strlen($chars) - 1)];
        }
        return $code;
    }

$stmt = $pdo->query("SELECT id FROM users");
    $users = $stmt->fetchAll();

foreach ($users as $u) {
        $code = generateReferralCode();
        // Ensure uniqueness (simple check)
        $exists = true;
        while ($exists) {
            $check = $pdo->prepare("SELECT id FROM users WHERE referral_code = ?");
            $check->execute([$code]);
            if ($check->rowCount() == 0) {
                $exists = false;
            } else {
                $code = generateReferralCode();
            }
        }

$update = $pdo->prepare("UPDATE users SET referral_code = ? WHERE id = ?");
        $update->execute([$code, $u['id']]);
    }

echo "<p style='color:green'>✓ Generated unique 7-character referral codes for " . count($users) . " users</p>";
    echo "<h3>✅ Update Complete!</h3>";
    echo "<a href='user/referral.php'>Check Referral Link</a>";

} catch (PDOException $e) {
    if (strpos($e->getMessage(), 'Duplicate column name') !== false) {
        echo "<p style='color:orange'>⚠️ Column 'referral_code' already exists.</p>";
    } else {
        echo "<h3 style='color:red'>❌ Error: " . $e->getMessage() . "</h3>";
    }
}