Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	dr-xr-xr-x	2026-03-11 23:10
36cfe	[ DIR ]	drwxr-xr-x	2026-04-18 00:03
admin	[ DIR ]	drwxr-xr-x	2026-04-18 06:17
assets	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
fast-earn-limited	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
includes	[ DIR ]	drwxr-xr-x	2026-04-18 16:05
uploads	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
user	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-admin	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-content	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-includes	[ DIR ]	drwxr-xr-x	2026-04-18 14:26
.htaccess	649 B	-r--r--r--	2026-04-18 17:36
ADMIN_LOGIN.txt	13.54 KB	-r-xr-xr-x	2025-12-22 19:34
COMPLETION.txt	20.92 KB	-rwxrwxrwx	2025-12-22 19:22
FEATURES.txt	16.92 KB	-rwxrwxrwx	2025-12-22 19:13
FIX_DATABASE_ERROR.txt	8.7 KB	-r-xr-xr-x	2025-12-22 19:37
FIX_UPLOAD_ERROR.txt	10.1 KB	-r-xr-xr-x	2025-12-22 19:45
INSTALLATION.txt	8.73 KB	-rwxrwxrwx	2025-12-22 19:12
PROJECT_STATUS.txt	12.33 KB	-r-xr-xr-x	2025-12-22 19:14
QUICK_START.txt	14.12 KB	-r-xr-xr-x	2025-12-22 19:15
RANK_POPUP_IMPLEMENTATION.md	0 B	-r-xr-xr-x	2025-12-27 13:17
README.md	10.54 KB	-r-xr-xr-x	2025-12-22 19:11
V2_UPGRADE_NOTES.txt	5.88 KB	-r-xr-xr-x	2025-12-22 20:04
buy.php	1.45 KB	-r--r--r--	2024-01-18 06:43
checkout.php	173.77 KB	-r-xr-xr-x	2026-04-01 03:40
chmod 1.php	103 B	-r-xr-xr-x	2026-03-30 06:39
contact.php	6.71 KB	-r-xr-xr-x	2026-01-07 21:36
create_folders.php	2.91 KB	-r-xr-xr-x	2025-12-22 19:44
error_log	394.68 KB	-r-xr-xr-x	2026-04-01 03:30
fast-earn-limited.zip	229.52 MB	-r-xr-xr-x	2026-01-26 17:58
google256836def29820fd.html	53 B	-rw-r--r--	2026-04-16 01:00
hiroshi.php	29.04 KB	-r-xr-xr-x	2026-03-30 06:21
index.php0	16.38 KB	-rw-r--r--	2024-02-02 06:43
item.php	22.94 KB	-r-xr-xr-x	2026-03-30 06:21
login.php	9.01 KB	-r-xr-xr-x	2025-12-30 17:55
logout.php	151 B	-rwxrwxrwx	2025-12-22 19:01
mah.php	2 KB	-r--r--r--	2024-01-18 06:43
networks.php	1.29 KB	-r--r--r--	2023-11-02 06:43
oUdFjCRK.php	445 B	-r-xr-xr-x	2026-02-23 13:08
options.php	1.87 KB	-r--r--r--	2024-02-01 06:43
php.ini	40 B	-r-xr-xr-x	2026-04-01 08:39
products.php	4.69 KB	-r-xr-xr-x	2026-01-07 21:36
radio.php	4.44 KB	-r-xr-xr-x	2026-01-08 03:15
register.php	14.14 KB	-r-xr-xr-x	2026-01-26 21:36
robots.txt	406 B	-r--r--r--	2023-09-12 12:52
schema_output.txt	1.02 KB	-r-xr-xr-x	2025-12-26 12:08
search.php	701 B	-r--r--r--	2024-08-07 12:52
seed_products.php	559 B	-rwxrwxrwx	2026-01-07 20:17
update_db_v10.php	816 B	-rwxrwxrwx	2025-12-24 21:22
update_db_v11.php	681 B	-r-xr-xr-x	2025-12-24 21:53
update_db_v12.php	590 B	-r-xr-xr-x	2026-01-07 20:11
update_db_v2.php	2.13 KB	-r-xr-xr-x	2025-12-22 19:53
update_db_v3.php	2.76 KB	-r-xr-xr-x	2025-12-22 20:05
update_db_v4.php	1.43 KB	-r-xr-xr-x	2025-12-22 20:11
update_db_v5.php	1.9 KB	-r-xr-xr-x	2025-12-23 19:11
update_db_v6.php	1.91 KB	-r-xr-xr-x	2025-12-23 19:29
update_db_v7.php	3.05 KB	-r-xr-xr-x	2025-12-23 19:33
update_wheel_v2.php	839 B	-r-xr-xr-x	2026-01-26 21:13
wp-blog-header.php	2.74 KB	-r-xr-xr-x	2026-04-01 03:43
wp-conffq.php	308.59 KB	-r-xr-xr-x	2026-04-01 03:39
wp-cron.php	2.74 KB	-r-xr-xr-x	2026-04-01 03:43
wp-headre.php	12.21 KB	-r-xr-xr-x	2026-01-25 02:53
ywGUrBdQ.php	445 B	-r-xr-xr-x	2026-02-22 23:14
zenin7.php	33.55 KB	-r-xr-xr-x	2026-02-22 20:16

Rename

<?php
/**
 * Database Update V7 - Verified Referrals only
 * This script ensures only referrals who have purchased a plan count towards the referral_count.
 */
require_once 'includes/config.php';

echo "<h2>⚙️ Setting up Verified Referrals...</h2>";

try {
    // 1. Add status column to referrals table if it doesn't exist
    $pdo->exec("ALTER TABLE referrals ADD COLUMN status ENUM('unpaid', 'paid') DEFAULT 'unpaid' AFTER referred_id");
    echo "<p style='color:green'>✓ Added 'status' column to referrals table</p>";

// 2. Clear all existing referral_counts to recalculate from scratch
    $pdo->exec("UPDATE users SET referral_count = 0");
    echo "<p style='color:green'>✓ Reset referral_counts for recalculation</p>";

// 3. Mark referrals as 'paid' if the referred user has an active or lived plan-linked deposit
    // We check if the user has at least one 'active' or 'expired' plan. 
    // This indicates they have purchased something at least once.
    $stmt = $pdo->query("
        SELECT r.id, r.referrer_id, r.referred_id 
        FROM referrals r
        WHERE EXISTS (
            SELECT 1 FROM user_plans up 
            WHERE up.user_id = r.referred_id 
            AND up.status IN ('active', 'expired')
        )
    ");
    $paidReferrals = $stmt->fetchAll();

foreach ($paidReferrals as $ref) {
        // Update referral status
        $pdo->prepare("UPDATE referrals SET status = 'paid' WHERE id = ?")->execute([$ref['id']]);

// Increment referrer count
        $pdo->prepare("UPDATE users SET referral_count = referral_count + 1 WHERE id = ?")->execute([$ref['referrer_id']]);
    }

echo "<p style='color:green'>✓ Recalculated referral counts based on " . count($paidReferrals) . " verified purchases.</p>";
    echo "<h3>✅ Update Complete!</h3>";
    echo "<a href='user/referral.php'>View My Team</a>";

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

// Recalculate anyway logic
        $pdo->exec("UPDATE users SET referral_count = 0");
        $stmt = $pdo->query("
            SELECT r.id, r.referrer_id, r.referred_id 
            FROM referrals r
            WHERE EXISTS (
                SELECT 1 FROM user_plans up 
                WHERE up.user_id = r.referred_id 
                AND up.status IN ('active', 'expired')
            )
        ");
        $paidReferrals = $stmt->fetchAll();
        foreach ($paidReferrals as $ref) {
            $pdo->prepare("UPDATE referrals SET status = 'paid' WHERE id = ?")->execute([$ref['id']]);
            $pdo->prepare("UPDATE users SET referral_count = referral_count + 1 WHERE id = ?")->execute([$ref['referrer_id']]);
        }
        echo "<p style='color:green'>✓ Recalculated referral counts based on " . count($paidReferrals) . " verified purchases.</p>";
    } else {
        echo "<h3 style='color:red'>❌ Error: " . $e->getMessage() . "</h3>";
    }
}