Viewing file:  User.php (8.47 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
class User {
public $id = null;
public $username = null;
public $password = null;
public $email = null;
public $birth_date = null;
public $join_date = null;
public $gender = null;
public $role = null;
public $data = null;
public $avatar = 0;
public $bio = '';
public $xp = 0;
public $rank = '-';
public $level = 1;
public function __construct($data = array())
{
if (isset($data['id'])) $this->id = (int)$data['id'];
if (isset($data['username'])) $this->username = $data['username'];
if (isset($data['password'])) $this->password = $data['password'];
if (isset($data['email'])) $this->email = $data['email'];
if (isset($data['birth_date'])) $this->birth_date = $data['birth_date'];
if (isset($data['join_date'])) $this->join_date = $data['join_date'];
if (isset($data['gender'])) $this->gender = $data['gender'];
if (isset($data['data'])) $this->data = json_decode($data['data'], true);
if (isset($data['avatar'])) $this->avatar = $data['avatar'];
if (isset($data['role'])) $this->role = $data['role'];
if (isset($data['bio'])) $this->bio = $data['bio'];
if (isset($data['xp'])) $this->xp = $data['xp'];
if(is_null($this->xp)){
$this->xp = 0;
}
if(is_null($this->birth_date)){
$this->birth_date = date('Y-m-d');
}
if(!$this->data){
$this->data = array();
$this->data['likes'] = [];
}
if(file_exists(ABSPATH.'includes/rank.json')){
$rank = json_decode(file_get_contents(ABSPATH.'includes/rank.json'), true);
if($rank){
$index = 0;
foreach ($rank as $name => $value) {
if($this->xp >= $value){
$index++;
$this->level = $index;
$this->rank = $name;
}
}
}
}
}
public function storeFormValues($params)
{
$this->__construct($params);
if(is_null($this->join_date)){
$this->join_date = date('Y-m-d');
}
}
public static function getById($id)
{
$conn = open_connection();
$sql = "SELECT * FROM users WHERE id = :id";
$st = $conn->prepare($sql);
$st->bindValue(":id", $id, PDO::PARAM_INT);
$st->execute();
$row = $st->fetch();
if ($row) return new User($row); //$row
}
public static function getByUsername($username)
{
$conn = open_connection();
$sql = "SELECT * FROM users WHERE username = :username";
$st = $conn->prepare($sql);
$st->bindValue(":username", $username, PDO::PARAM_STR);
$st->execute();
$row = $st->fetch();
if ($row) return new User($row); //$row
}
public static function getList($amount = 30, $sort = 'desc', $page = 0)
{
$conn = open_connection();
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM users
ORDER BY id $sort LIMIT :amount OFFSET :page";
$st = $conn->prepare($sql);
$st->bindValue(":amount", $amount, PDO::PARAM_INT);
$st->bindValue(":page", $page, PDO::PARAM_INT);
$st->execute();
$list = array();
while ($row = $st->fetch())
{
$user = new User($row);
$list[] = $user;
}
$sql = "SELECT FOUND_ROWS() AS totalRows";
$totalRows = $conn->query($sql)->fetch()[0];
$totalPages = 0;
if (count($list))
{
$totalPages = ceil($totalRows / $amount);
}
return (array(
"results" => $list,
"totalRows" => $totalRows,
"totalPages" => $totalPages
));
}
public static function getByEmail($email)
{
$conn = open_connection();
$sql = "SELECT * FROM users WHERE email = :email";
$st = $conn->prepare($sql);
$st->bindValue(":email", $email, PDO::PARAM_STR);
$st->execute();
$row = $st->fetch();
if ($row) return new User($row); //$row
}
public function array_id_exist($id)
{
if(!is_null($this->id)){
if(!is_null($this->data) || isset($this->data['likes'])){
$index = 1;
foreach ($this->data['likes'] as $val) {
if($val == $id){
return $index;
}
$index++;
}
return false;
}
}
}
public function like($id)
{
if(!is_null($this->id)){
if(is_null($this->data) || $this->data == ''){
$this->data = array();
$this->data['likes'] = array();
}
if(!$this->array_id_exist($id)){
array_push($this->data['likes'], $id);
}
$this->xp += 10;
$this->update_data();
$this->update_xp();
} else {
echo "User is null";
}
}
public function dislike($id)
{
if(!is_null($this->id)){
if(is_null($this->data) || $this->data == ''){
$this->data = array();
$this->data['likes'] = array();
}
$arr = $this->array_id_exist($id);
if($arr){
array_splice($this->data['likes'], $arr-1, 1);
$this->update_data();
}
} else {
echo "User is null";
}
}
public function insert()
{
if (!is_null($this->id)) trigger_error("User::insert(): Attempt to insert an User object that already has its ID property set (to $this->id).", E_USER_ERROR);
if(!$this->avatar){
$this->avatar = rand(1,20);
}
$conn = open_connection();
$sql = 'INSERT INTO users ( username, password, email, birth_date, join_date, gender, data, role, avatar )
VALUES ( :username, :password, :email, :birth_date, :join_date, :gender, :data, :role, :avatar )';
$st = $conn->prepare($sql);
$st->bindValue(":username", $this->username, PDO::PARAM_STR);
$st->bindValue(":password", $this->password, PDO::PARAM_STR);
$st->bindValue(":email", $this->email, PDO::PARAM_STR);
$st->bindValue(":birth_date", $this->birth_date, PDO::PARAM_STR);
$st->bindValue(":join_date", $this->join_date, PDO::PARAM_STR);
$st->bindValue(":gender", $this->gender, PDO::PARAM_STR);
$st->bindValue(":data", json_encode($this->data), PDO::PARAM_STR);
$st->bindValue(":role", 'user', PDO::PARAM_STR);
$st->bindValue(":avatar", $this->avatar, PDO::PARAM_INT);
$st->execute();
$this->id = $conn->lastInsertId();
}
public function update_data()
{
if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
//
$conn = open_connection();
$sql = "UPDATE users SET data=:data WHERE id = :id";
$st = $conn->prepare($sql);
$st->bindValue(":id", $this->id, PDO::PARAM_INT);
$st->bindValue(":data", json_encode($this->data), PDO::PARAM_STR);
$st->execute();
}
public function update_xp()
{
if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
//
$conn = open_connection();
$sql = "UPDATE users SET xp=:xp WHERE id = :id";
$st = $conn->prepare($sql);
$st->bindValue(":id", $this->id, PDO::PARAM_INT);
$st->bindValue(":xp", $this->xp, PDO::PARAM_INT);
$st->execute();
}
public function add_xp($val)
{
if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
//
$this->xp += (int)$val;
$conn = open_connection();
$sql = "UPDATE users SET xp=:xp WHERE id = :id";
$st = $conn->prepare($sql);
$st->bindValue(":id", $this->id, PDO::PARAM_INT);
$st->bindValue(":xp", $this->xp, PDO::PARAM_INT);
$st->execute();
}
public function update()
{
if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
//
$conn = open_connection();
$sql = "UPDATE users SET username=:username, password=:password, email=:email, birth_date=:birth_date, gender=:gender, bio=:bio, avatar=:avatar WHERE id = :id";
$st = $conn->prepare($sql);
$st->bindValue(":id", $this->id, PDO::PARAM_INT);
$st->bindValue(":username", $this->username, PDO::PARAM_STR);
$st->bindValue(":password", $this->password, PDO::PARAM_STR);
$st->bindValue(":email", $this->email, PDO::PARAM_STR);
$st->bindValue(":birth_date", $this->birth_date, PDO::PARAM_STR);
$st->bindValue(":gender", $this->gender, PDO::PARAM_STR);
$st->bindValue(":bio", $this->bio, PDO::PARAM_STR);
$st->bindValue(":avatar", $this->avatar, PDO::PARAM_INT);
$st->execute();
}
public function delete()
{
if (is_null($this->id)) trigger_error("User::delete(): Attempt to delete an User object that does not have its ID property set.", E_USER_ERROR);
$conn = open_connection();
$st = $conn->prepare("DELETE FROM users WHERE id = :id LIMIT 1");
$st->bindValue(":id", $this->id, PDO::PARAM_INT);
$st->execute();
//Delete its avatar if exist
if(file_exists( ABSPATH.'images/avatar/'.$this->username.'.png' )){
unlink( ABSPATH.'images/avatar/'.$this->username.'.png' );
}
}
}
?>
|