GameMatch_Account.php

Go to the documentation of this file.

<?php

namespace Combu;

class GameMatch_Account extends DataClass {
    
    const TABLE_NAME = "Match_Account";
    
    public $Id = 0;
    public $IdMatch = 0;
    public $IdAccount = 0;
    public $CustomData = "";
    
    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        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 Load($idMatch = 0, $idAccount = 0, $returnArray = FALSE) {
        $where = "";
        if ($idMatch > 0)
            $where .= ($where ? " AND " : "") . sprintf("(IdMatch = %d)", $idMatch);
        if ($idAccount > 0)
            $where .= ($where ? " AND " : "") . sprintf("(IdAccount = %d)", $idAccount);
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, "Id");
    }
    
   public function Save() {
        global $Database;
        if ($this->IdMatch < 1 || $this->IdAccount < 1) {
            return FALSE;
        }
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET CustomData = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->CustomData),
                    $this->Id);
        } else {
            $this->DateCreation = date("Y-m-d H:i:s");
            $query = sprintf("INSERT INTO %s (IdMatch, IdAccount, CustomData) VALUES (%d, %d, '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdMatch,
                    $this->IdAccount,
                    $Database->Escape($this->CustomData));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0) {
            if ($this->_Delete(self::GetTableName(__CLASS__), sprintf("Id = %d", $this->Id))) {
                $this->_Delete(self::GetTableName(GameMatch_Round::class), sprintf("IdMatchAccount = %d", $this->Id));
                return TRUE;
            }
        }
        return FALSE;
    }
    
    public function ToArray() {
        $user = new Account($this->IdAccount);
        $array = Utils::ObjectToArray($this);
        $array["User"] = $user->ToArray();
        $array["Rounds"] = array();
        $rounds = GameMatch_Round::Load($this->Id);
        foreach ($rounds as $r) {
            $array["Rounds"][] = $r->ToArray();
        }
        return $array;
    }
    
    public function ToJson() {
        $array = $this->ToArray();
        return json_encode($array);
    }
}