prepare("SELECT wallet_balance, available_balance, staking_balance FROM users WHERE id = ?"); $stmt->bind_param("i", $_SESSION['user_id']); $stmt->execute(); $result = $stmt->get_result(); $userData = $result->fetch_assoc(); if ($userData) { $_SESSION['wallet_balance'] = $userData['wallet_balance']; $_SESSION['available_balance'] = $userData['available_balance']; $_SESSION['staking_balance'] = $userData['staking_balance']; } // Get recent transactions $stmt = $conn->prepare("SELECT * FROM transactions WHERE user_id = ? ORDER BY created_at DESC LIMIT 5"); $stmt->bind_param("i", $_SESSION['user_id']); $stmt->execute(); $transactions = $stmt->get_result(); // Handle Send/Receive actions if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['send_amount']) && isset($_POST['send_address'])) { $amount = floatval($_POST['send_amount']); $address = trim($_POST['send_address']); if ($amount > 0 && $amount <= $_SESSION['available_balance']) { $new_balance = $_SESSION['available_balance'] - $amount; $new_total = $_SESSION['wallet_balance'] - $amount; $conn->begin_transaction(); try { $stmt = $conn->prepare("UPDATE users SET available_balance = ?, wallet_balance = ? WHERE id = ?"); $stmt->bind_param("ddi", $new_balance, $new_total, $_SESSION['user_id']); $stmt->execute(); $stmt = $conn->prepare("INSERT INTO transactions (user_id, type, amount, address, status) VALUES (?, 'send', ?, ?, 'completed')"); $stmt->bind_param("ids", $_SESSION['user_id'], $amount, $address); $stmt->execute(); $conn->commit(); $_SESSION['available_balance'] = $new_balance; $_SESSION['wallet_balance'] = $new_total; $success = "Sent $amount USDT successfully!"; } catch (Exception $e) { $conn->rollback(); $error = "Transaction failed. Please try again."; } } else { $error = "Insufficient balance or invalid amount."; } } header('Location: dashboard.php'); exit(); } $mobile_masked = substr($_SESSION['mobile'], 0, 4) . '••••' . substr($_SESSION['mobile'], -2); ?> USDT Vault — Dashboard
● ACTIVE
Total portfolio (USDT)
▲ +3.2% from last month
Available USDT
Staking USDT
Recent activity All
num_rows > 0): ?> fetch_assoc()): ?>
USDT
No transactions yet
Secured by iOS Secure Enclave