class.ilExternalFeedBlock.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once("./Services/Block/classes/class.ilCustomBlock.php");

class ilExternalFeedBlock extends ilCustomBlock
{
    protected $db;

    protected $log;


    protected $feed_url;

    public function __construct($a_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();
        $this->log = $DIC["ilLog"];
        if ($a_id > 0) {
            $this->setId($a_id);
            $this->read();
        }
    }

    public function setFeedUrl($a_feed_url)
    {
        $this->feed_url = $a_feed_url;
    }

    public function isFeedUrlLocal($url)
    {
        $host = strtolower(parse_url($url, PHP_URL_HOST));
        if (is_int(strpos($url, ".localhost")) || trim($host) == "localhost") {
            return true;
        }
        $ip = gethostbyname($host);

        $res = filter_var(
            $ip,
            FILTER_VALIDATE_IP,
            FILTER_FLAG_IPV4 | FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE
        );
        if (in_array($res, [false, ""])) {
            return true;
        }
        return false;
    }

    public function getFeedUrl()
    {
        return $this->feed_url;
    }

    public function create()
    {
        $ilDB = $this->db;
        $ilLog = $this->log;
        
        parent::create();
        
        $query = "INSERT INTO il_external_feed_block (" .
            " id" .
            ", feed_url" .
            " ) VALUES (" .
            $ilDB->quote($this->getId(), "integer")
            . "," . $ilDB->quote($this->getFeedUrl(), "text") . ")";
        $ilDB->manipulate($query);
    }

    public function read()
    {
        $ilDB = $this->db;
        
        parent::read();
        
        $query = "SELECT * FROM il_external_feed_block WHERE id = " .
            $ilDB->quote($this->getId(), "integer");
        $set = $ilDB->query($query);
        $rec = $ilDB->fetchAssoc($set);

        $this->setFeedUrl($rec["feed_url"]);
    }

    public function update()
    {
        $ilDB = $this->db;
        
        parent::update();
        
        $query = "UPDATE il_external_feed_block SET " .
            " feed_url = " . $ilDB->quote($this->getFeedUrl(), "text") .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer");
        
        $ilDB->manipulate($query);
    }

    public function delete()
    {
        $ilDB = $this->db;
        
        parent::delete();
        
        $query = "DELETE FROM il_external_feed_block" .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer");
        
        $ilDB->manipulate($query);
    }
}