fileSystemRoot/phplib/db_mysql.inc"); require_once("$default->fileSystemRoot/lib/database/db.inc"); /** * $Id$ * * Stores system settings * * Licensed under the GNU GPL. For full terms see the file COPYING. * * @version $Revision$ * @author Michael Joseph , Jam Warehouse (Pty) Ltd, South Africa * @package lib */ class System { var $db; function System() { global $default; $this->db = new Database(); } /** * Returns true if there are entries in the system_settings table */ function initialised() { global $default; if ($this->db->query("SELECT count(*) AS count FROM system_settings")) { $this->db->next_record(); return ($this->db->f("count") > 0) ? true : false; } } /** * Retrieves a system setting * * @param string setting name * @return string the setting */ function get($sSettingName) { global $default; // select the value from the db return lookupField($default->owl_system_settings_table, "value", "name", $sSettingName); } /** * Sets a setting, if $sSettingName exists then the value is overwritten * else a new setting is inserted. * * @param string the name of the system setting * @param string the value of the system setting */ function set($sSettingName, $sSettingValue) { global $default, $lang_err_database; if (lookupField($default->owl_system_settings_table, "name", "name", $sSettingName)) { // the setting exists, so overwrite it if ($default->db->query("UPDATE $default->owl_system_settings_table SET value='$sSettingValue' where name='$sSettingName'")) { return true; } else { $_SESSION["errorMessage"] = $lang_err_database; return false; } } else { // the setting doesn't exist, lets insert it if ($default->db->query("INSERT INTO $default->owl_system_settings_table (name, value) VALUES ('$sSettingName', '$sSettingValue')")) { return true; } else { $_SESSION["errorMessage"] = $lang_err_database; return false; } } } function generateRequiredFieldValidation($aValidationColumnNames,$aValidationDisplayColumnNames) { $sToRender .= "\n\n\n\n"; //return $sToRender; } } ?>