julia/core/models/Config.php

<?php

namespace Entity;

class Config extends ModelBase
{
    private static $config = array();

    protected function install()
    {
        $dbPrefix = $this->getDbPrefix();
        $result = self::$dbo->exec("CREATE TABLE IF NOT EXISTS `{$dbPrefix}config` (
            `lang` VARCHAR(8) NULL,
            `key` VARCHAR(64) NOT NULL,
            `value` TEXT NULL,
            UNIQUE(`lang`, `key`)
        )");
        if ($result === false)
            throw new \Exception(get_class().": ".self::$dbo->errorInfo()[2]);
        return true;
    }

    public static function getConfig($lang =null, $key =null, $defaultValue =null)
    {
        $fetcher = new self();
        if (isset(self::$config[$lang]))
            return;
        $values = $fetcher->selects(array("lang" => $lang));
        foreach ($values as $i)
            self::$config[$lang][$i->key] = $i->value;
        if ($key)
            return (isset(self::$config[$lang][$key]) ? self::$config[$lang][$key] : $defaultValue);
        return $defaultValue;
    }
}