LeaderBoard_User.php

Go to the documentation of this file.

<?php

namespace Combu;

class LeaderBoard_User extends DataClass {

    const TABLE_NAME = "LeaderBoard_User";

    public $Id = 0;
    public $IdLeaderboard = 0;
    public $IdAccount = 0;
    public $Username = "";
    public $ValueInt = 0;
    public $ValueFloat = 0;
    public $ValueString = "";
    public $LastUpdated = "";

    public function __construct($src = null, $stripSlashes = false) {
        if ($src == null)
            return;
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        } else if (is_numeric($src) && intval($src) > 0) {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), "Id = " . intval($src));
        }
    }

    public static function LoadAccount ($idAccount, $idLeaderboard = 0, $returnArray = false) {
        $where = sprintf("IdAccount = %d", $idAccount);
        if ($idLeaderboard > 0)
            $where .= sprintf(" AND IdLeaderboard = %d", $idLeaderboard);
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where);
    }

    public static function Load ($idLeaderboard, $order, $limit = null, $offset = null, &$count = null, $returnArray = false) {
        $where = sprintf("al.IdLeaderboard = %d", $idLeaderboard);
        return self::_loadEx("al.*", self::GetTableName(__CLASS__) . " al INNER JOIN " . self::GetTableName(Account::class) . " u ON u.Id = al.IdAccount", ($returnArray ? "" : __CLASS__), $where, $order, $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        if ($this->Id < 1) {
            $query = sprintf("INSERT INTO %s (IdLeaderboard, IdAccount, Username, ValueInt, ValueFloat, LastUpdated) VALUES (%d, %d, '%s', %d, %f, '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdLeaderboard,
                    $this->IdAccount,
                    $Database->Escape($this->Username),
                    $this->ValueInt,
                    $this->ValueFloat,
                    date("Y-m-d H:i:s"));
        } else {
            $query = sprintf("UPDATE %s SET Username = '%s', ValueInt = %d, ValueFloat = %f, LastUpdated = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Username),
                    $this->ValueInt,
                    $this->ValueFloat,
                    date("Y-m-d H:i:s"),
                    $this->Id);
        }
        $saved = $Database->Query($query);
        if ($saved) {
            if ($this->Id <= 0)
                $this->Id = $Database->InsertedId();
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id < 1)
            return FALSE;
        return $this->_Delete(self::GetTableName(__CLASS__), "Id = " . $this->Id);
    }
    
    public static function Prune() {
        self::TruncateClass(__CLASS__);
    }
}