File size: 3,899 Bytes
0dff816 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 |
<?php
// classes/User.php
class User {
private $conn;
private $table_name = "users";
public $id;
public $username;
public $email;
public $password_hash;
public $tier;
public $package;
public $balance;
public $total_deposits;
public $total_withdrawals;
public $rewards;
public function __construct($db) {
$this->conn = $db;
}
// Get user by ID
public function getUserById($id) {
$query = "SELECT * FROM " . $this->table_name . " WHERE id = ? LIMIT 0,1";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $id);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if($row) {
$this->id = $row['id'];
$this->username = $row['username'];
$this->email = $row['email'];
$this->tier = $row['tier'];
$this->package = $row['package'];
$this->balance = $row['balance'];
$this->total_deposits = $row['total_deposits'];
$this->total_withdrawals = $row['total_withdrawals'];
$this->rewards = $row['rewards'];
return true;
}
return false;
}
// Get user by username
public function getUserByUsername($username) {
$query = "SELECT * FROM " . $this->table_name . " WHERE username = ? LIMIT 0,1";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $username);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if($row) {
$this->id = $row['id'];
$this->username = $row['username'];
$this->email = $row['email'];
$this->tier = $row['tier'];
$this->package = $row['package'];
$this->balance = $row['balance'];
$this->total_deposits = $row['total_deposits'];
$this->total_withdrawals = $row['total_withdrawals'];
$this->rewards = $row['rewards'];
return true;
}
return false;
}
// Update user balance
public function updateBalance($amount) {
$query = "UPDATE " . $this->table_name . " SET balance = balance + ? WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $amount);
$stmt->bindParam(2, $this->id);
if($stmt->execute()) {
$this->balance += $amount;
return true;
}
return false;
}
// Update user deposits
public function updateDeposits($amount) {
$query = "UPDATE " . $this->table_name . " SET total_deposits = total_deposits + ? WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $amount);
$stmt->bindParam(2, $this->id);
if($stmt->execute()) {
$this->total_deposits += $amount;
return true;
}
return false;
}
// Update user withdrawals
public function updateWithdrawals($amount) {
$query = "UPDATE " . $this->table_name . " SET total_withdrawals = total_withdrawals + ? WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $amount);
$stmt->bindParam(2, $this->id);
if($stmt->execute()) {
$this->total_withdrawals += $amount;
return true;
}
return false;
}
// Update user rewards
public function updateRewards($amount) {
$query = "UPDATE " . $this->table_name . " SET rewards = rewards + ? WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $amount);
$stmt->bindParam(2, $this->id);
if($stmt->execute()) {
$this->rewards += $amount;
return true;
}
return false;
}
}
?> |