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>Testing Commission Fix</h2>";

try {
 // Test if we can insert a referral record with the new columns
 $stmt = $pdo->prepare("INSERT INTO referrals (user_id, referred_user_id, level, commission_amount, transaction_id, source_transaction_id) VALUES (?, ?, ?, ?, ?, ?)");
 
 // Use test values (these should be valid user IDs in your database)
 $test_user_id = 1;
 $test_referred_user_id = 2;
 $test_level = 1;
 $test_amount = 10.00;
 $test_transaction_id = 1;
 $test_source_transaction_id = 2;
 
 $result = $stmt->execute([$test_user_id, $test_referred_user_id, $test_level, $test_amount, $test_transaction_id, $test_source_transaction_id]);
 
 if ($result) {
 echo "✓ Successfully inserted test referral record with new columns";
 
 // Get the inserted ID
 $inserted_id = $pdo->lastInsertId();
 
 // Delete the test record
 $stmt = $pdo->prepare("DELETE FROM referrals WHERE id = ?");
 $stmt->execute([$inserted_id]);
 
 echo "✓ Test record cleaned up successfully";
 }
} catch (PDOException $e) {
 echo "✗ Error inserting test referral record: " . $e->getMessage() . "";
 
 if (strpos($e->getMessage(), 'Unknown column') !== false) {
 echo "The new columns (transaction_id, source_transaction_id) don't exist in the referrals table.";
 echo "Please run the update_referrals_table.sql script to add these columns.";
 }
}

// Test the commission calculation function with transaction ID
echo "<h3>Testing Commission Calculation Function</h3>";

// Include the membership file to test the function
include 'user/membership.php';

// Check if the updated function exists
if (function_exists('calculateReferralCommissions')) {
 // Create a reflection to check function parameters
 $reflection = new ReflectionFunction('calculateReferralCommissions');
 $parameters = $reflection->getParameters();
 
 echo "Function calculateReferralCommissions exists with " . count($parameters) . " parameters:";
 echo "<ul>";
 foreach ($parameters as $param) {
 echo "<li>" . $param->getName();
 if ($param->isDefaultValueAvailable()) {
 echo " (default: " . var_export($param->getDefaultValue(), true) . ")";
 }
 echo "</li>";
 }
 echo "</ul>";
 
 if (count($parameters) >= 4) {
 echo "✓ Function has been updated with transaction_id parameter";
 } else {
 echo "✗ Function has not been updated with transaction_id parameter";
 }
} else {
 echo "✗ Function calculateReferralCommissions not found";
}

echo "<hr>";
echo "<a href='check_referrals_table.php'>Check Referrals Table Structure</a> | ";
echo "<a href='check_duplicate_commissions.php'>Check for Duplicates</a> | ";
echo "<a href='admin/referral_commissions.php'>Go to Admin Referral Commissions</a>";
?>