Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	13.96 KB	-rw-r--r--	2025-10-17 23:08
auth.php	343 B	-rw-r--r--	2025-10-17 23:20
dashboard.php	8.71 KB	-rw-r--r--	2025-10-18 00:40
deposit_methods.php	12.36 KB	-rw-r--r--	2025-10-17 23:06
deposits.php	13.24 KB	-rw-r--r--	2025-10-18 00:56
dpin.php	6.16 KB	-rw-r--r--	2025-10-17 23:06
footer.php	565 B	-rw-r--r--	2025-10-17 23:05
header.php	13.06 KB	-rw-r--r--	2025-10-18 02:06
login.php	3.37 KB	-rw-r--r--	2025-10-17 23:09
login_as_user.php	1020 B	-rw-r--r--	2025-10-17 23:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:08
plans.php	13.65 KB	-rw-r--r--	2025-10-17 23:06
referral_commissions.php	11.93 KB	-rw-r--r--	2025-10-18 00:13
team_commissions.php	6.66 KB	-rw-r--r--	2025-10-17 23:45
test_modals.php	4.44 KB	-rw-r--r--	2025-10-18 00:49
test_referral_commissions.php	2.87 KB	-rw-r--r--	2025-10-18 00:13
test_user_edit.php	4.96 KB	-rw-r--r--	2025-10-18 00:44
transactions.php	6.36 KB	-rw-r--r--	2025-10-17 23:08
users.php	13.55 KB	-rw-r--r--	2025-10-18 00:49
withdraw_methods.php	12.49 KB	-rw-r--r--	2025-10-17 23:08
withdraws.php	9.16 KB	-rw-r--r--	2025-10-17 23:39

Rename

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

// Check if admin is logged in
requireAdminLogin();

echo "<h2>Test User Edit and Balance Update</h2>";

// Test user data
$test_user_id = 1; // Assuming user ID 1 exists

try {
 // Get current user data
 $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
 $stmt->execute([$test_user_id]);
 $user = $stmt->fetch();
 
 if ($user) {
 echo "<h3>Current User Data:</h3>";
 echo "ID: " . $user['id'] . "";
 echo "Name: " . htmlspecialchars($user['fullname']) . "";
 echo "Email: " . htmlspecialchars($user['email']) . "";
 echo "Phone: " . htmlspecialchars($user['phone']) . "";
 echo "Balance: ₨" . number_format($user['balance'], 2) . "";
 
 // Test updating user data
 echo "<h3>Testing User Update:</h3>";
 
 $new_name = $user['fullname'] . " (Updated)";
 $new_email = "updated_" . $user['email'];
 $new_phone = "03001234567";
 
 $stmt = $pdo->prepare("UPDATE users SET fullname = ?, email = ?, phone = ? WHERE id = ?");
 $result = $stmt->execute([$new_name, $new_email, $new_phone, $test_user_id]);
 
 if ($result) {
 echo "✓ User data updated successfully";
 
 // Revert changes
 $stmt = $pdo->prepare("UPDATE users SET fullname = ?, email = ?, phone = ? WHERE id = ?");
 $stmt->execute([$user['fullname'], $user['email'], $user['phone'], $test_user_id]);
 echo "✓ User data reverted successfully";
 } else {
 echo "✗ Failed to update user data";
 }
 
 // Test balance update
 echo "<h3>Testing Balance Update:</h3>";
 
 $original_balance = $user['balance'];
 $test_amount = 100.00;
 
 // Test adding balance
 $stmt = $pdo->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
 $result = $stmt->execute([$test_amount, $test_user_id]);
 
 if ($result) {
 echo "✓ Balance added successfully";
 
 // Check new balance
 $stmt = $pdo->prepare("SELECT balance FROM users WHERE id = ?");
 $stmt->execute([$test_user_id]);
 $updated_user = $stmt->fetch();
 
 if ($updated_user['balance'] == ($original_balance + $test_amount)) {
 echo "✓ Balance verification successful";
 
 // Revert balance
 $stmt = $pdo->prepare("UPDATE users SET balance = ? WHERE id = ?");
 $stmt->execute([$original_balance, $test_user_id]);
 echo "✓ Balance reverted successfully";
 } else {
 echo "✗ Balance verification failed";
 }
 } else {
 echo "✗ Failed to add balance";
 }
 
 // Test deducting balance
 if ($original_balance >= $test_amount) {
 $stmt = $pdo->prepare("UPDATE users SET balance = balance - ? WHERE id = ?");
 $result = $stmt->execute([$test_amount, $test_user_id]);
 
 if ($result) {
 echo "✓ Balance deducted successfully";
 
 // Check new balance
 $stmt = $pdo->prepare("SELECT balance FROM users WHERE id = ?");
 $stmt->execute([$test_user_id]);
 $updated_user = $stmt->fetch();
 
 if ($updated_user['balance'] == ($original_balance - $test_amount)) {
 echo "✓ Deduction verification successful";
 } else {
 echo "✗ Deduction verification failed";
 }
 
 // Revert balance
 $stmt = $pdo->prepare("UPDATE users SET balance = ? WHERE id = ?");
 $stmt->execute([$original_balance, $test_user_id]);
 echo "✓ Balance reverted successfully";
 } else {
 echo "✗ Failed to deduct balance";
 }
 } else {
 echo "⚠ Insufficient balance for deduction test";
 }
 } else {
 echo "✗ User not found";
 }
} catch (PDOException $e) {
 echo "Database error: " . $e->getMessage() . "";
}

echo "<hr>";
echo "<a href='users.php'>Go to Users Management</a> | <a href='dashboard.php'>Go to Admin Dashboard</a>";
?>