fileSystemRoot/phplib/db_mysql.inc"); require_once("$default->fileSystemRoot/lib/database/db.inc"); /** * $Id$ * * Stores system settings. * * Copyright (c) 2003 Jam Warehouse http://www.jamwarehouse.com * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @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 WHERE name<>'lastIndexUpdate' AND name<>'filesystemRoot' AND value<>''")) { $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) { // select the value from the db return lookupField("system_settings", "value", "name", $sSettingName); } function getInt($sSettingName) { // select the value from the db return (integer)lookupField("system_settings", "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->system_settings_table, "name", "name", $sSettingName)) { // the setting exists, so overwrite it if ($default->db->query("UPDATE $default->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->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; } } ?>