<?php
	function param($param_name, $fatal = true) {
		global $params, $db;
		if (!is_array($params)) {
			$params = array();
		}
		
		if (!isset($params[$param_name])) {
			$sql = "SELECT * FROM parameters WHERE parameter_name='$param_name'";
			$row = $db->sql_fetchrow($db->sql_query($sql));
			if (isset($row['parameter_value'])) {
				$params[$param_name] = $row['parameter_value'];
			} else { //parameter does not exist
				if ($fatal) {
					trigger_error("PARAMETER [$param_name] DOES NOT EXIST IN THE DATABASE");
					exit;
				} else {
					return false; //"[PARAMETER $param_name NOT FOUND]";
				}
			}
		}
		return $params[$param_name];
	}
	
	function add_param($param_name, $param_value, $param_group = '', $param_title = '', $param_description = '', $param_function_use = '', $param_function_set = '') {
		global $params;
		
		del_param($param_name);
		$sql = "INSERT INTO parameters(parameter_name, parameter_value, parameter_title, parameter_description, parameter_function_use, parameter_function_set, parameter_dateadded)
								VALUES (  '$param_name',  '$param_value',  '$param_title',  '$param_description',  '$param_function_use',  '$param_function_set', now())";
		executesql($sql, __LINE__, __FILE__);
		
		$params[$param_name] = $param_value;
	}
	
	function del_param($param_name) {
		$param_name = addslashes($param_name);
		$sql = "DELETE FROM parameters
				WHERE parameter_name = '$param_name'
				LIMIT 1";
		executesql($sql, __LINE__, __FILE__);
	}
	
	function del_params($param_group) {
		$param_group = addslashes($param_group);
		if ($param_group != '') {
			$sql = "DELETE FROM parameters
					WHERE parameter_group = '$param_group'";
			executesql($sql, __LINE__, __FILE__);
		}
	}
?>