setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $user_id = $_SESSION['user_id']; // --- অটোমেটিক ডাটাবেস কলাম চেক (Auto Migration) --- $withdrawCols = $db->query("PRAGMA table_info(withdrawals)")->fetchAll(PDO::FETCH_ASSOC); $existingCols = array_column($withdrawCols, 'name'); if (!in_array('method', $existingCols)) { $db->exec("ALTER TABLE withdrawals ADD COLUMN method TEXT"); } if (!in_array('address', $existingCols)) { $db->exec("ALTER TABLE withdrawals ADD COLUMN address TEXT"); } // ১. একটিভ পেমেন্ট মেথড আনা $active_methods = $db->query("SELECT * FROM payment_methods WHERE status = 1")->fetchAll(PDO::FETCH_ASSOC); // ২. ইউজারের বর্তমান ব্যালেন্স চেক $stmt = $db->prepare("SELECT main_balance FROM users WHERE id = ?"); $stmt->execute([$user_id]); $user_balance = $stmt->fetchColumn(); $msg = ""; $error = ""; // ৩. ডিপোজিট প্রসেস (পেন্ডিং থাকবে) if (isset($_POST['submit_deposit'])) { $amount = (float)$_POST['amount']; $method = htmlspecialchars($_POST['method']); $tid = htmlspecialchars($_POST['transaction_id']); if($amount >= 0.5) { $ins = $db->prepare("INSERT INTO deposits (user_id, amount, method, status, created_at) VALUES (?, ?, ?, 'Pending', datetime('now'))"); $ins->execute([$user_id, $amount, "$method (TID: $tid)"]); $msg = "Deposit request submitted! Assets will be added after review."; } else { $error = "Minimum deposit is $0.5"; } } // ৪. উইথড্র প্রসেস (সাথে সাথে ব্যালেন্স কাটা হবে) if (isset($_POST['submit_withdraw'])) { $amount = (float)$_POST['amount']; $method = htmlspecialchars($_POST['method']); $address = htmlspecialchars($_POST['address']); if ($amount < 1) { $error = "Minimum withdrawal is $1"; } elseif ($user_balance >= $amount) { // ১. ডাটাবেস থেকে টাকা কেটে নেওয়া $deduct = $db->prepare("UPDATE users SET main_balance = main_balance - ? WHERE id = ?"); $deduct->execute([$amount, $user_id]); // ২. রিকোয়েস্ট সেভ করা $ins = $db->prepare("INSERT INTO withdrawals (user_id, amount, method, address, status, created_at) VALUES (?, ?, ?, ?, 'Pending', datetime('now'))"); $ins->execute([$user_id, $amount, $method, $address]); // ৩. বর্তমান পেজের ভেরিয়েবল আপডেট করা $user_balance -= $amount; $msg = "Withdrawal request sent! $".$amount." deducted from assets."; } else { $error = "Insufficient balance!"; } } } catch (PDOException $e) { die("System Error: " . $e->getMessage()); } ?> Ziber Wallet - Assets

Total Assets

$

Secured Wallet
$msg
"; ?> $error"; ?>

Target Address

---