IpBan.php

Go to the documentation of this file.

<?php

namespace Combu;

class IpBan extends DataClass {

    const TABLE_NAME = "IpBan";

    public $Id = 0;
    public $DateCreated = NULL;
    public $DateUpdated = NULL;
    public $IdApp = 0;
    public $IdAdminAccount = 0;
    public $FromIp = "";
    public $ToIp = "";
    public $FromIpInt = 0;
    public $ToIpInt = 0;
    public $Reason = "";

    public function __construct($src = null, $stripSlashes = false) {
        if (!empty($src)) {
            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));
            }
        }
    }

    public static function Load ($idApp = 0, $idAdminAccount = 0, $ip = NULL, $limit = null, $offset = null, &$count = null) {
        global $Database;
        $where = "";
        if ($idApp > 0) {
            $where .= ($where ? " AND " : "") . sprintf("(IdApp = 0 OR IdApp = %d)", $idApp);
        }
        if ($idAdminAccount > 0) {
            $where .= ($where ? " AND " : "") . sprintf("(IdAdminAccount = %d)", $idAdminAccount);
        }
        if (!empty($ip)) {
            $where .= ($where ? " AND " : "") . sprintf("(INET6_ATON('%s') BETWEEN FromIpInt AND ToIpInt)", $Database->Escape($ip));
        }
        return self::_load(self::GetTableName(__CLASS__), __CLASS__, $where, NULL, $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        $this->DateUpdated = Utils::GetCurrentDateTimeFormat();
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET IdApp = %d, FromIp = '%s', ToIp = '%s', FromIpInt = INET6_ATON('%s'), ToIpInt = INET6_ATON('%s'), Reason = '%s', DateUpdated = %s, IdAdminAccount = %d WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $this->IdApp,
                    $Database->Escape($this->FromIp),
                    $Database->Escape($this->ToIp),
                    $Database->Escape($this->FromIp),
                    $Database->Escape($this->ToIp),
                    $Database->Escape($this->Reason),
                    $Database->EscapeDate($this->DateUpdated),
                    $this->IdAdminAccount,
                    $this->Id);
        } else {
            $this->DateCreated = $this->DateUpdated;
            $query = sprintf("INSERT INTO %s (IdApp, IdAdminAccount, DateCreated, DateUpdated, FromIp, ToIp, FromIpInt, ToIpInt, Reason) VALUES (%d, %d, %s, %s, '%s', '%s', INET6_ATON('%s'), INET6_ATON('%s'), '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdApp,
                    $this->IdAdminAccount,
                    $Database->EscapeDate($this->DateCreated),
                    $Database->EscapeDate($this->DateUpdated),
                    $Database->Escape($this->FromIp),
                    $Database->Escape($this->ToIp),
                    $Database->Escape($this->FromIp),
                    $Database->Escape($this->ToIp),
                    $Database->Escape($this->Reason));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0) {
            return $this->_Delete(self::GetTableName(__CLASS__), sprintf("Id = %d", $this->Id));
        }
        return FALSE;
    }
}