Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
admin	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
assets	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
db	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
includes	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
uploads	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
user	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_USER_EDIT_ISSUE.md	6.15 KB	-rw-r--r--	2025-10-18 00:44
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README_DEPLOYMENT.txt	1.74 KB	-rw-r--r--	2025-10-18 01:49
README_REFERRAL_COMMISSIONS.md	4.02 KB	-rw-r--r--	2025-10-18 00:22
SQL_CHANGES_SUMMARY.md	2.02 KB	-rw-r--r--	2025-10-18 00:25
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_database_structure.php	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_duplicate_commissions.php	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_referrals_table.php	2.28 KB	-rw-r--r--	2025-10-18 00:39
complete_setup.sql	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup_for_import.sql	5.36 KB	-rw-r--r--	2025-10-18 01:59
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_referral_commissions.sql	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions_for_import.sql	705 B	-rw-r--r--	2025-10-18 01:59
index.php	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.15 KB	-rw-r--r--	2025-10-18 02:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
register.php	6.58 KB	-rw-r--r--	2025-10-18 02:05
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test_commission_application.php	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_display.php	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_fix.php	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_mobile_menu.php	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_referral.php	2.07 KB	-rw-r--r--	2025-10-17 23:55
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions_for_import.sql	710 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table.sql	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table_for_import.sql	426 B	-rw-r--r--	2025-10-18 01:59
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions_working.php	8.2 KB	-rw-r--r--	2025-10-18 00:56

Rename

<?php
require_once 'includes/db.php';

echo "<h2>Checking for Duplicate Commissions</h2>";

try {
    // Check for duplicate transactions
    $stmt = $pdo->prepare("SELECT user_id, type, amount, note, COUNT(*) as count FROM transactions WHERE type = 'commission' GROUP BY user_id, type, amount, note HAVING COUNT(*) > 1 ORDER BY count DESC");
    $stmt->execute();
    $duplicates = $stmt->fetchAll();
    
    if (count($duplicates) > 0) {
        echo "<h3>Duplicate Commission Transactions Found:</h3>";
        echo "<table border='1' cellpadding='5' cellspacing='0'>";
        echo "<tr><th>User ID</th><th>Amount</th><th>Note</th><th>Count</th></tr>";
        
        foreach ($duplicates as $dup) {
            echo "<tr>";
            echo "<td>" . $dup['user_id'] . "</td>";
            echo "<td>" . $dup['amount'] . "</td>";
            echo "<td>" . htmlspecialchars($dup['note']) . "</td>";
            echo "<td>" . $dup['count'] . "</td>";
            echo "</tr>";
        }
        
        echo "</table>";
        
        echo "<p><a href='fix_duplicate_commissions.php' style='color: red; font-weight: bold;'>Click here to fix duplicates</a></p>";
    } else {
        echo "<p style='color: green;'>No duplicate commission transactions found.</p>";
    }
    
    // Check for duplicate referral records
    $stmt = $pdo->prepare("SELECT user_id, referred_user_id, level, commission_amount, COUNT(*) as count FROM referrals GROUP BY user_id, referred_user_id, level, commission_amount HAVING COUNT(*) > 1 ORDER BY count DESC");
    $stmt->execute();
    $referral_duplicates = $stmt->fetchAll();
    
    if (count($referral_duplicates) > 0) {
        echo "<h3>Duplicate Referral Records Found:</h3>";
        echo "<table border='1' cellpadding='5' cellspacing='0'>";
        echo "<tr><th>User ID</th><th>Referred User ID</th><th>Level</th><th>Amount</th><th>Count</th></tr>";
        
        foreach ($referral_duplicates as $dup) {
            echo "<tr>";
            echo "<td>" . $dup['user_id'] . "</td>";
            echo "<td>" . $dup['referred_user_id'] . "</td>";
            echo "<td>" . $dup['level'] . "</td>";
            echo "<td>" . $dup['commission_amount'] . "</td>";
            echo "<td>" . $dup['count'] . "</td>";
            echo "</tr>";
        }
        
        echo "</table>";
    } else {
        echo "<p style='color: green;'>No duplicate referral records found.</p>";
    }
    
    // Check the last 10 commission transactions
    echo "<h3>Last 10 Commission Transactions:</h3>";
    $stmt = $pdo->prepare("SELECT t.*, u.fullname FROM transactions t JOIN users u ON t.user_id = u.id WHERE t.type = 'commission' ORDER BY t.created_at DESC LIMIT 10");
    $stmt->execute();
    $recent_commissions = $stmt->fetchAll();
    
    if (count($recent_commissions) > 0) {
        echo "<table border='1' cellpadding='5' cellspacing='0'>";
        echo "<tr><th>ID</th><th>User</th><th>Amount</th><th>Note</th><th>Date</th></tr>";
        
        foreach ($recent_commissions as $commission) {
            echo "<tr>";
            echo "<td>" . $commission['id'] . "</td>";
            echo "<td>" . htmlspecialchars($commission['fullname']) . "</td>";
            echo "<td>" . $commission['amount'] . "</td>";
            echo "<td>" . htmlspecialchars($commission['note']) . "</td>";
            echo "<td>" . $commission['created_at'] . "</td>";
            echo "</tr>";
        }
        
        echo "</table>";
    } else {
        echo "<p>No recent commission transactions found.</p>";
    }
    
    // Check if the new columns exist in referrals table
    echo "<h3>Referrals Table Structure Check:</h3>";
    try {
        $stmt = $pdo->prepare("SELECT transaction_id, source_transaction_id FROM referrals LIMIT 1");
        $stmt->execute();
        echo "<p style='color: green;'>✓ New columns (transaction_id, source_transaction_id) exist in referrals table</p>";
    } catch (PDOException $e) {
        echo "<p style='color: orange;'>⚠ New columns may not exist in referrals table yet. Run update_referrals_table.sql</p>";
    }
    
} catch (PDOException $e) {
    echo "<p style='color: red;'>Error: " . $e->getMessage() . "</p>";
}

echo "<hr>";
echo "<p><a href='admin/referral_commissions.php'>Go to Admin Referral Commissions</a> | ";
echo "<a href='user/dashboard.php'>Go to User Dashboard</a></p>";
?>