AppId.php

Go to the documentation of this file.

<?php

namespace Combu;

class AppId extends DataClass {

    const TABLE_NAME = "AppId";

    public $Id = 0;
    public $AppId = "";
    public $Secret = "";
    public $DateCreated = "";
    public $Name = "";
    public $Description = "";
    public $Active = 0;

    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        if (empty($src)) {
            return;
        }
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        } else if (is_numeric($src)) {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), sprintf("Id = %d", $src));
        } else {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), sprintf("AppId = '%s'", $Database->Escape($src)));
        }
    }

    public function Exists() {
        global $Database;
        $sql = "SELECT Id FROM " . self::GetTableName(__CLASS__) . " WHERE Name = '" . $Database->Escape($this->Name) . "'";
        if ($this->Id > 0) {
            $sql .= " AND Id <> " . $this->Id . "'";
        }
        $res = $Database->Query($sql);
        if ($res) {
            $row = $Database->FetchAssoc($res);
            if ($row) {
                return TRUE;
            }
        }
        return FALSE;
    }
    
    public function IsActive() {
        return ($this->Active == 1);
    }
    
    public function IsValid() {
        return ($this->Id > 0 && strlen($this->AppId) > 0 && strcasecmp($this->AppId, "new") != 0);
    }
    
    public static function GetApp($appId, $appSecret) {
        global $Database;
        if (!empty($appId) && !empty($appSecret)) {
            $apps = DataClass::LoadRecords(sprintf("SELECT * FROM %s WHERE AppId = '%s'", self::GetTableName(__CLASS__), $Database->Escape($appId)), __CLASS__);
            if (count($apps) > 0) {
                $app = $apps[0];
                if ($app->IsActive() && \strcmp($app->AppId, $appId) === 0 && \strcmp($app->Secret, $appSecret) === 0) {
                    return $app;
                }
            }
        }
        return NULL;
    }

    public static function Load ($limit = null, $offset = null, &$count = null, $returnArray = false) {
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), NULL, "DateCreated DESC", $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Active = %d, Name = '%s', Description = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $this->Active,
                    $Database->Escape($this->Name),
                    $Database->Escape($this->Description),
                    $this->Id);
        } else {
            $this->Active = 1;
            $this->AppId = Utils::NewGUID();
            $this->Secret = Utils::NewGUID();
            $this->DateCreated = Utils::GetCurrentDateTimeFormat();
            $query = sprintf("INSERT INTO %s (Active, DateCreated, AppId, Secret, Name, Description) VALUES (%d, %s, '%s', '%s', '%s', '%s')",
                    self::GetTableName(__CLASS__),
                    $this->Active,
                    $Database->EscapeDate($this->DateCreated),
                    $Database->Escape($this->AppId),
                    $Database->Escape($this->Secret),
                    $Database->Escape($this->Name),
                    $Database->Escape($this->Description));
        }
        if ($Database->Query($query)) {
            if ($this->Id <= 0) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0 && $this->_Delete(self::GetTableName(__CLASS__), sprintf("Id = %d", $this->Id))) {
            
            $this->_Delete(self::GetTableName(Account_App::class), sprintf("IdApp = %d", $this->Id));
            $this->_Delete(self::GetTableName(News::class), sprintf("IdApp = %d", $this->Id));
            $this->_Delete(self::GetTableName(AppCustomData::class), sprintf("IdApp = %d", $this->Id));
            $this->_Delete(self::GetTableName(Inventory::class), sprintf("IdApp = %d", $this->Id));
            $this->_Delete(self::GetTableName(SessionToken::class), sprintf("IdApp = %d", $this->Id));
            $this->_Delete(self::GetTableName(IpBan::class), sprintf("IdApp = %d", $this->Id));
            
            $achievements = Achievement::Load($this->Id);
            foreach ($achievements as $achievement) {
                if ($achievement->IdApp == $this->Id) {
                    $achievement->Delete();
                }
            }
            
            $leaderboards = LeaderBoard::Load($this->Id);
            foreach ($leaderboards as $leaderboard) {
                if ($leaderboard->IdApp == $this->Id) {
                    $leaderboard->Delete();
                }
            }
            
            $newsletters = Newsletter::Load($this->Id);
            foreach ($newsletters as $newsletter) {
                if ($newsletter->IdApp == $this->Id) {
                    $newsletter->Delete();
                }
            }
            
            return TRUE;
        }
        return FALSE;
    }
}