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';

// Test fetching commission levels from database
try {
 $stmt = $pdo->prepare("SELECT * FROM referral_commissions ORDER BY level ASC");
 $stmt->execute();
 $commission_levels = $stmt->fetchAll();
 
 echo "<h2>Referral Commission Levels</h2>";
 
 if (count($commission_levels) > 0) {
 echo "<table border='1' cellpadding='10'>";
 echo "<tr><th>ID</th><th>Level</th><th>Commission %</th><th>Created</th><th>Updated</th></tr>";
 
 foreach ($commission_levels as $level) {
 echo "<tr>";
 echo "<td>" . $level['id'] . "</td>";
 echo "<td>" . $level['level'] . "</td>";
 echo "<td>" . number_format($level['commission_percentage'], 2) . "%</td>";
 echo "<td>" . $level['created_at'] . "</td>";
 echo "<td>" . $level['updated_at'] . "</td>";
 echo "</tr>";
 }
 
 echo "</table>";
 echo "Total levels: " . count($commission_levels) . "";
 } else {
 echo "No commission levels found in database.";
 echo "This might be because:";
 echo "<ul>";
 echo "<li>The referral_commissions table doesn't exist yet</li>";
 echo "<li>The table exists but is empty</li>";
 echo "</ul>";
 
 // Try to create the table
 try {
 $createTable = "CREATE TABLE IF NOT EXISTS referral_commissions (
 id INT AUTO_INCREMENT PRIMARY KEY,
 level INT NOT NULL UNIQUE,
 commission_percentage DECIMAL(5, 2) NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 )";
 
 $pdo->exec($createTable);
 echo "✓ Table created successfully!";
 
 // Insert default levels
 $insertStmt = $pdo->prepare("INSERT IGNORE INTO referral_commissions (level, commission_percentage) VALUES (?, ?)");
 $insertStmt->execute([1, 10.00]);
 $insertStmt->execute([2, 5.00]);
 $insertStmt->execute([3, 2.00]);
 
 echo "✓ Default commission levels inserted!";
 echo "Please refresh this page to see the commission levels.";
 } catch (PDOException $e) {
 echo "Error creating table: " . $e->getMessage() . "";
 }
 }
} catch (PDOException $e) {
 echo "Database error: " . $e->getMessage() . "";
 
 if (strpos($e->getMessage(), 'Base table or view not found') !== false) {
 echo "The referral_commissions table doesn't exist. The admin panel should automatically create it when accessed.";
 echo "Please visit the <a href='admin/referral_commissions.php'>Referral Commissions page</a> in the admin panel first.";
 }
}

echo "<hr>";
echo "<a href='admin/referral_commissions.php'>Go to Admin Referral Commissions</a> | ";
echo "<a href='user/invite.php'>Go to User Invite Page</a> | ";
echo "<a href='test_commission_display.php'>Go to Commission Display Test</a>";
?>