Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-09-15 16:52
DB	[ DIR ]	drwxr-xr-x	2024-01-26 18:47
Documentation	[ DIR ]	drwxr-xr-x	2025-08-31 15:59
Documentation.1	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
FASTEARNADS	[ DIR ]	drwxr-xr-x	2025-09-15 19:14
Files	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
admin	[ DIR ]	drwxr-xr-x	2025-10-18 00:49
admin.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
admin.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:54
app	[ DIR ]	drwxr-xr-x	2025-09-15 01:54
asset	[ DIR ]	drwxr-xr-x	2024-01-15 11:35
assets	[ DIR ]	drwxr--r--	2025-10-18 01:49
assets.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
assets.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:09
assets.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
assets.4	[ DIR ]	drwxr-xr-x	2025-10-18 21:42
bootstrap	[ DIR ]	drwxr-xr-x	2025-09-15 21:09
cgi-bin	[ DIR ]	drwxr-xr-x	2025-08-31 15:33
cgi-bin.1	[ DIR ]	drwxr-xr-x	2025-11-14 14:25
cgi-bin.2	[ DIR ]	drwxr-xr-x	2026-03-06 11:21
core	[ DIR ]	drwxr-xr-x	2025-11-21 11:34
core.1	[ DIR ]	drwxr-xr-x	2025-11-21 15:51
data sycho	[ DIR ]	drwxr-xr-x	2026-03-18 10:25
database	[ DIR ]	drwxr-xr-x	2025-09-15 01:47
db	[ DIR ]	drwxr-xr-x	2025-10-17 23:00
db.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
debug.php	[ DIR ]	drwxr-xr-x	2026-03-13 16:15
deployment_package	[ DIR ]	drwxr-xr-x	2025-10-18 02:05
deployment_package.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
earnonline	[ DIR ]	drwxr-xr-x	2025-10-18 17:55
includes	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
includes.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
includes.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:40
loading	[ DIR ]	drwxr-xr-x	2025-01-23 07:37
public	[ DIR ]	drwxr-xr-x	2025-09-15 19:19
resources	[ DIR ]	drwxr-xr-x	2025-09-15 01:28
routes	[ DIR ]	drwxr-xr-x	2025-09-15 21:08
serive	[ DIR ]	drwxr-xr-x	2024-10-22 19:23
shearearn	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
storage	[ DIR ]	drwxr-xr-x	2025-09-15 01:56
uploads	[ DIR ]	drwxr--r--	2025-10-18 01:49
uploads.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
uploads.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:08
uploads.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
user	[ DIR ]	drwxr-xr-x	2025-10-17 23:42
user.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
user.2	[ DIR ]	drwxr-xr-x	2025-10-18 22:14
vendor	[ DIR ]	drwxr-xr-x	2025-09-15 01:53
.env	1.2 KB	-rw-r--r--	2025-09-15 19:24
.env.example	1.19 KB	-rw-r--r--	2025-09-15 01:27
.htaccess	281 B	-rw-r--r--	2025-09-15 16:51
.htaccess.1	1.08 KB	-rw-r--r--	2025-10-18 21:45
.htaccess.2	913 B	-rw-r--r--	2023-12-27 04:45
.htaccess.3	281 B	-rw-r--r--	2025-12-23 09:40
.htaccess.4	1.38 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.5	812 B	-rw-r--r--	2025-12-23 09:40
.htaccess.6	281 B	-rw-r--r--	2026-02-22 15:25
.htaccess.7	5.15 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.8	1.02 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.9	281 B	-rw-r--r--	2025-12-23 09:40
.trash_restore	11.24 KB	-rw-------	2026-03-30 15:07
.well-known_2.zip	66.1 MB	-rw-r--r--	2025-07-10 15:10
.well-known_3.zip	69.98 MB	-rw-r--r--	2025-07-18 07:02
6clube by Tha_perfect_provider (1).zip	67.84 MB	-rw-r--r--	2025-11-21 12:25
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FASTEARNADS.zip	26.04 MB	-rw-r--r--	2025-09-15 19:10
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_DUPLICATE_COMMISSIONS.md.1	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
FIX_USER_EDIT_ISSUE.md.1	6.15 KB	-rw-r--r--	2025-10-18 00:44
Hyipe rio_2.zip	56.84 MB	-rw-r--r--	2025-08-31 15:56
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
IMPROVEMENTS_SUMMARY.md.1	4.11 KB	-rw-r--r--	2025-10-18 00:40
MRby91club.sql	32.58 MB	-rw-r--r--	2025-11-09 05:09
MRby91club.zip	58.89 MB	-rw-r--r--	2025-11-09 05:09
PropLab v1.0 Nulled.zip	67.55 MB	-rw-r--r--	2025-11-21 11:36
README.md	6.77 KB	-rw-r--r--	2025-09-15 01:24
README.md.1	3.01 KB	-rw-r--r--	2025-10-18 21:46
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README.txt.1	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
README_REFERRAL_COMMISSIONS.md.1	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
SQL_CHANGES_SUMMARY.md.1	2.02 KB	-rw-r--r--	2025-10-18 00:25
Vinance-Digital-Trading-Platform-V2.7[www.shop.softbdteam.com].zip	39.3 MB	-rw-r--r--	2025-11-28 16:01
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
apply_database_fixes.php.1	5.17 KB	-rw-r--r--	2025-10-18 00:39
artisan	1.7 KB	-rw-r--r--	2025-09-15 01:54
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_commission_levels.php.1	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_database_structure.php.1	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_duplicate_commissions.php.1	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
check_referrals_table.php.1	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.sql.1	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
complete_setup_for_import.sql.1	5.36 KB	-rw-r--r--	2025-10-18 01:59
composer.json	1.83 KB	-rw-r--r--	2025-09-15 01:27
composer.lock	294.45 KB	-rw-r--r--	2025-09-15 01:52
config.php	2.63 KB	-rw-r--r--	2025-10-18 17:56
crazydeveloperbd_auto-ptc.sql	320.06 KB	-rw-r--r--	2025-02-03 11:56
crazydeveloperbd_auto-ptc.sql.1	320.06 KB	-rw-r--r--	2025-02-03 11:56
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
create_table_direct.php.1	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
data sycho.1	0 B	-rw-r--r--	2026-03-18 10:25
database.sql	13.77 KB	-rw-r--r--	2025-10-18 22:24
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
debug_referral_chain.php.1	6.88 KB	-rw-r--r--	2025-10-18 00:54
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
earnonline.zip	88.67 KB	-rw-r--r--	2025-10-18 17:55
error.php	3.84 KB	-rw-r--r--	2025-10-18 21:45
error_log	488 B	-rw-r--r--	2025-07-04 21:02
error_log.1	37.29 KB	-rw-r--r--	2025-11-21 16:03
favicon.png	2.71 KB	-rw-r--r--	2025-06-07 20:15
favicon.png.1	6.62 KB	-rw-r--r--	2022-08-31 22:45
favicon.png.2	50.48 KB	-rw-r--r--	2025-07-18 10:14
favicon.png.3	2.21 KB	-rw-r--r--	2025-07-18 10:19
fix_css_paths.bat	1.85 KB	-rw-r--r--	2025-10-18 02:06
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_duplicate_commissions.php.1	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.sql.1	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
fix_referral_commissions_for_import.sql.1	705 B	-rw-r--r--	2025-10-18 01:59
index-8df9a8d8.js	1.09 MB	-rw-r--r--	2026-03-18 15:16
index.php	25.73 KB	-rw-r--r--	2025-10-18 01:40
index.php.1	26.17 KB	-rw-r--r--	2025-10-18 02:11
index.php.2	23.31 KB	-rw-r--r--	2025-10-18 22:32
index.php.3	1.77 KB	-rw-r--r--	2023-12-27 04:45
index.php.backup	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_professional.php	26.17 KB	-rw-r--r--	2025-10-18 02:12
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.14 KB	-rw-r--r--	2025-10-17 23:09
login.php.1	4.15 KB	-rw-r--r--	2025-10-18 02:12
logo.png	18.18 KB	-rw-r--r--	2025-06-07 20:15
logo.png.1	46.68 KB	-rw-r--r--	2025-07-18 10:12
logo.png.2	46.68 KB	-rw-r--r--	2025-07-18 10:11
logo.png.3	920.77 KB	-rw-r--r--	2023-07-01 15:03
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
logout.php.1	88 B	-rw-r--r--	2025-10-17 23:02
mailer.php	10.16 KB	-rw-r--r--	2026-03-30 14:45
mobile-demo.html	23.36 KB	-rw-r--r--	2025-09-15 01:32
register.php	6.57 KB	-rw-r--r--	2025-10-17 23:09
register.php.1	6.58 KB	-rw-r--r--	2025-10-18 02:12
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
run_setup.bat.1	714 B	-rw-r--r--	2025-10-18 00:23
servertime.php	128 B	-rw-r--r--	2024-09-27 12:16
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
setup_referral_commissions.php.1	2.73 KB	-rw-r--r--	2025-10-18 00:21
shearearn.zip	3.2 MB	-rw-r--r--	2025-10-17 21:11
test.html	203 B	-rw-r--r--	2025-10-17 23:16
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test.php.1	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_application.php.1	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_display.php.1	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_commission_fix.php.1	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_mobile_menu.php.1	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
test_referral.php.1	2.07 KB	-rw-r--r--	2025-10-17 23:55
tradex (1).sql	189.14 KB	-rw-r--r--	2025-11-21 15:51
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions.sql.1	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_referral_commissions_for_import.sql.1	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.sql.1	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
update_referrals_table_for_import.sql.1	426 B	-rw-r--r--	2025-10-18 01:59
verify-code.php	8.79 KB	-rw-r--r--	2026-03-30 14:55
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions.php.1	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
verify_commissions_working.php.1	8.2 KB	-rw-r--r--	2025-10-18 00:56
website_deployment_package.zip	648.91 KB	-rw-r--r--	2025-10-18 01:49
website_deployment_package_final.zip	657.48 KB	-rw-r--r--	2025-10-18 02:06
website_deployment_package_professional.zip	667.46 KB	-rw-r--r--	2025-10-17 21:14
website_deployment_package_updated.zip	653.07 KB	-rw-r--r--	2025-10-18 01:59

Rename

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

echo "<h2>Debug Referral Chain</h2>";

// Function to get referrer at a specific level
function getReferrerAtLevel($pdo, $user_id, $level) {
 try {
 $current_user_id = $user_id;
 echo "Starting with user ID: " . $current_user_id . "";
 
 // Traverse up the referral chain
 for ($i = 1; $i <= $level; $i++) {
 echo "Checking level " . $i . "...";
 
 $stmt = $pdo->prepare("SELECT referred_by FROM users WHERE id = ?");
 $stmt->execute([$current_user_id]);
 $user = $stmt->fetch();
 
 echo "Found user data: " . print_r($user, true) . "";
 
 if (!$user || !$user['referred_by']) {
 echo "No referrer found at level " . $i . "";
 return null; // No referrer at this level
 }
 
 $current_user_id = $user['referred_by'];
 echo "Moving to referrer ID: " . $current_user_id . "";
 }
 
 // Get the referrer details
 $stmt = $pdo->prepare("SELECT id FROM users WHERE id = ?");
 $stmt->execute([$current_user_id]);
 $result = $stmt->fetch();
 
 echo "Final referrer result: " . print_r($result, true) . "";
 
 return $result;
 } catch (PDOException $e) {
 echo "Error: " . $e->getMessage() . "";
 return null;
 }
}

// Function to calculate and distribute referral commissions
function calculateReferralCommissions($pdo, $user_id, $amount, $transaction_id = null) {
 try {
 echo "<h3>Calculating commissions for user ID: " . $user_id . ", amount: " . $amount . "</h3>";
 
 // If transaction_id is provided, check if commissions have already been calculated for this transaction
 if ($transaction_id) {
 $stmt = $pdo->prepare("SELECT COUNT(*) as count FROM referrals WHERE source_transaction_id = ?");
 $stmt->execute([$transaction_id]);
 if ($stmt->fetch()['count'] > 0) {
 // Commissions already calculated for this transaction
 echo "Commissions already calculated for this transaction";
 return;
 }
 }
 
 // Get referral commission levels
 $stmt = $pdo->prepare("SELECT * FROM referral_commissions ORDER BY level ASC");
 $stmt->execute();
 $commission_levels = $stmt->fetchAll();
 
 echo "Found " . count($commission_levels) . " commission levels";
 
 // Get user's referrer
 $stmt = $pdo->prepare("SELECT referred_by FROM users WHERE id = ?");
 $stmt->execute([$user_id]);
 $user = $stmt->fetch();
 
 echo "User data: " . print_r($user, true) . "";
 
 if (!$user || !$user['referred_by']) {
 echo "No referrer for this user";
 return; // No referrer
 }
 
 // Calculate commissions for each level
 foreach ($commission_levels as $level_data) {
 $level = $level_data['level'];
 $percentage = $level_data['commission_percentage'];
 
 echo "Processing level " . $level . " with " . $percentage . "% commission";
 
 // Get the referrer at this level
 $referrer = getReferrerAtLevel($pdo, $user_id, $level);
 
 if ($referrer) {
 $commission_amount = ($amount * $percentage) / 100;
 
 echo "Commission amount: " . $commission_amount . " for referrer ID: " . $referrer['id'] . "";
 
 // Add commission to referrer's balance
 $stmt = $pdo->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
 $stmt->execute([$commission_amount, $referrer['id']]);
 
 // Add transaction record
 $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, note) VALUES (?, 'commission', ?, ?)");
 $stmt->execute([$referrer['id'], $commission_amount, 'Referral commission (Level ' . $level . '): ' . $percentage . '% of ₨' . number_format($amount, 2)]);
 
 // Get the transaction ID of the newly inserted commission transaction
 $commission_transaction_id = $pdo->lastInsertId();
 
 // Add referral record
 if ($transaction_id) {
 // If we have a transaction ID, include it in the referral record
 $stmt = $pdo->prepare("INSERT INTO referrals (user_id, referred_user_id, level, commission_amount, transaction_id, source_transaction_id) VALUES (?, ?, ?, ?, ?, ?)");
 $stmt->execute([$referrer['id'], $user_id, $level, $commission_amount, $commission_transaction_id, $transaction_id]);
 } else {
 // If we don't have a transaction ID, insert without it
 $stmt = $pdo->prepare("INSERT INTO referrals (user_id, referred_user_id, level, commission_amount, transaction_id) VALUES (?, ?, ?, ?, ?)");
 $stmt->execute([$referrer['id'], $user_id, $level, $commission_amount, $commission_transaction_id]);
 }
 
 echo "Commission awarded successfully!";
 } else {
 echo "No referrer at level " . $level . "";
 }
 }
 } catch (PDOException $e) {
 // Log error but don't stop the process
 echo "Referral commission calculation failed: " . $e->getMessage() . "";
 error_log('Referral commission calculation failed: ' . $e->getMessage());
 }
}

// Test with a specific user
$test_user_id = 2; // Change this to a user ID that has a referrer
$test_amount = 1000.00;

echo "Testing with user ID: " . $test_user_id . " and amount: " . $test_amount . "";

// Get user details
try {
 $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
 $stmt->execute([$test_user_id]);
 $user = $stmt->fetch();
 
 if ($user) {
 echo "<h3>User Details:</h3>";
 echo "<pre>" . print_r($user, true) . "</pre>";
 
 // Test the commission calculation
 calculateReferralCommissions($pdo, $test_user_id, $test_amount, 12345);
 } else {
 echo "User not found";
 }
} catch (PDOException $e) {
 echo "Error fetching user: " . $e->getMessage() . "";
}

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