<?php
	/**
	 * Copyright 2000, 2001, 2002 Philipp von Klitzing
	 * Copyright 2003, 2004, 2005, 2006, 2007, 2008, 2009 Wim van Ravesteijn
	 *
	 * This file is part of AEGEE-Europe Statutory Event Applications.
	 *
	 * AEGEE-Europe Statutory Event Applications 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 3 of the License, or (at your option) any later version.
	 *
	 * AEGEE-Europe Statutory Event Applications 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 AEGEE-Europe Statutory Event Applications.  If not, see
	 * <http://www.gnu.org/licenses/>.
	 */
/*The database for setup consists of the following parts:
 * SetupID			smallint(5): unique ID of the option
 * Name					varchar(30): the name of the variable ($setup['Name']=Value)
 * Value				varchar(150): the value for the variable
 * RegEx				varchar(100): the regular expresion the value should comply with. You can use the following:
 *										[a|b|c]:	Value should be 'a', 'b' or 'c'. It can be more than one character
 *									[url]:		A url should be provided, starting with http(s)://
 *									[email]:	An e-mail address should be provided
 *									[int]:		An integer value should be provided
 *									/(   )/:	Value will be checked against the regular expresion
 *									[date]:		A date in the format dd.mm.yyyy
 *									[phone]:	A phone/fax number should be provided
 *									[bool]:		'true' or 'false' should be provided. It will be transfered to a real bool
 * Explain			varchar(10): A text explaining the variable
 * ac_edit			enum('yes','no'): people with edit access can change the value
 * ac_editall		enum('yes','no'): people with editall access can change the value
 * ac_localorg	enum('yes','no'): people with localorg access can change the value
 * ac_chair			enum('yes','no'): people with chair access can change the value
 * ac_admin			enum('yes','no'): people with admin access can change the value
 */

	$res = doquery("SELECT `Name`, `Value`, `RegEx` FROM `setup`");
	while( $row=mysql_fetch_array($res) ) {
		switch( $row['RegEx'] ) {
			case "[bool]":
				if( $row['Value']=="true" )
					$setup[ $row['Name'] ]=true;
				else
					$setup[ $row['Name'] ]=false;
				break;
			default:
				$setup[ $row['Name'] ]=$row['Value'];
				break;
		}
	}
?>