path: root/app/class/setting.class.php

<?php

require_once "class/framework.class.php";

/*
 * Scrott administrative settings
 */
class Setting extends Framework
{
    /*
     * Helper function for getting setting values from the database
     */
    static function getValue($key)
    {
        $db = parent::getDbConnection();
        $escdKey = $db->esc($key);

        $query = "SELECT `value` FROM `setting` WHERE `key` = '" . $escdKey . "'";
        $res = $db->query($query);

        if (count($res) == 0)
            return false;

        return $res[0]['value'];
    }

    /*
     * Helper function for setting setting values on the database
     */
    static function setValue($key, $value)
    {
        $db = parent::getDbConnection();
        $escdKey = $db->esc($key);
        $escdValue = $db->esc($value);

        if (self::getValue($key) === false)
            $query = "INSERT INTO setting (`key`, value) VALUES('" . $escdKey . "', '" . $escdValue . "')";
        else
            $query = "UPDATE setting SET value = '" . $escdValue . "' WHERE `key` = '" . $escdKey . "'";

        $db->query($query);
    }
}

?>