or read the installation guide

EOM; $error_message_db_problem = << Dokeos database unavailable! EOM; $error_message_db_problem .= '


This portal is currently experiencing database issues. Please report this to the portal administrator. Thank you for your help.
'; if (!$already_installed) { //require('installedVersion.inc.php'); die($error_message_not_installed); } //Assigning a variable to avoid several useless calls to the database setting. // Do not over-user. This is only for this script's local use. $lib_path = api_get_path(LIBRARY_PATH); // Add the path to the pear packages to the include path //ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$lib_path.'pear'); ini_set('include_path', api_create_include_path_setting()); // This is for compatibility with MAC computers. ini_set('auto_detect_line_endings', '1'); // Include the libraries that are necessary everywhere require_once($lib_path.'database.lib.php'); require_once($lib_path.'display.lib.php'); require_once($lib_path.'text.lib.php'); require_once($lib_path.'security.lib.php'); // @todo: this shouldn't be done here. It should be stored correctly during installation if(empty($_configuration['statistics_database']) && $already_installed) { $_configuration['statistics_database'] = $_configuration['main_database']; } // connect to the server database and select the main dokeos database $dokeos_database_connection = @mysql_connect($_configuration['db_host'], $_configuration['db_user'], $_configuration['db_password']) or die ($error_message_db_problem); if (! $_configuration['db_host']) { die($error_message_db_problem); } unset($error_message_db_problem); unset($error_message_not_installed); // The Dokeos system has not been designed to use special SQL modes that were introduced since MySQL 5 api_sql_query("set session sql_mode='';", __FILE__, __LINE__); $selectResult = mysql_select_db($_configuration['main_database'],$dokeos_database_connection) or die ('
WARNING ! SYSTEM UNABLE TO SELECT THE MAIN DOKEOS DATABASE
'); /* -------------------------------------------- Initialization of the default encodings -------------------------------------------- */ // The platform's character set must be retrieved at this early moment. $sql = "SELECT selected_value FROM settings_current WHERE variable = 'platform_charset';"; $result = api_sql_query($sql, __FILE__, __LINE__); while ($row = @mysql_fetch_array($result)) { $charset = $row[0]; } if (empty($charset)) { $charset = "ISO-8859-15"; } api_mb_internal_encoding($charset); api_mb_regex_encoding($charset); api_iconv_set_encoding('iconv_internal_encoding', $charset); api_iconv_set_encoding('iconv_input_encoding', $charset); api_iconv_set_encoding('iconv_output_encoding', $charset); /* -------------------------------------------- RETRIEVING ALL THE DOKEOS CONFIG SETTINGS -------------------------------------------- */ if(!empty($_configuration['multiple_access_urls'])) { $_configuration['access_url'] = 1; $access_urls = api_get_access_urls(); $protocol = ((!empty($_SERVER['HTTPS']) && strtoupper($_SERVER['HTTPS'])!='OFF')?'https':'http').'://'; $request_url1 = $protocol.$_SERVER['SERVER_NAME'].'/'; $request_url2 = $protocol.$_SERVER['HTTP_HOST'].'/'; foreach($access_urls as $details) { if($request_url1 == $details['url'] or $request_url2 == $details['url']) { $_configuration['access_url'] = $details['id']; } } } else { $_configuration['access_url'] = 1; } //$sql="SELECT * FROM settings_current"; //$result=mysql_query($sql) or die(mysql_error()); // access_url == 1 is the default dokeos location if ($_configuration['access_url']!=1) { $url_info = api_get_access_url($_configuration['access_url']); if ($url_info['active']==1) { $settings_by_access = api_get_settings(null,'list',$_configuration['access_url'],1); foreach($settings_by_access as $row) { if (empty($row['variable'])) $row['variable']=0; if (empty($row['subkey'])) $row['subkey']=0; if (empty($row['category'])) $row['category']=0; $settings_by_access_list[ $row['variable'] ] [ $row['subkey'] ] [ $row['category'] ] = $row; } } } //echo '
';print_r($result_other_site);
$result = api_get_settings(null,'list',1);

//while ($row=mysql_fetch_array($result))
foreach($result as $row)
{	
	if ($_configuration['access_url']!=1)
	{
		if ($url_info['active']==1)
		{
			if (empty($row['variable']))
				$var=0;
			else
				$var=$row['variable'];
				
			if (empty($row['subkey']))
				$subkey=0;
			else
				$subkey=$row['subkey'];
				
			if (empty($row['category']))
				$category=0;
			else
				$category=$row['category'];	
		}
		
		if ($row['access_url_changeable']==1 && $url_info['active']==1)
		{		
			if ($settings_by_access_list[ $var ] [ $subkey ] [$category ]['selected_value'] !='')
			{
				if ($row['subkey']==NULL)
				{
					$_setting[$row['variable']]= $settings_by_access_list[ $var ] [ $subkey ] [$category ]['selected_value'];
				}
				else
				{
					$_setting[$row['variable']][$row['subkey']]=$settings_by_access_list[ $var ] [ $subkey ] [$category ]['selected_value'];
				}
			}
			else
			{
				if ($row['subkey']==NULL)
				{
					$_setting[$row['variable']]=$row['selected_value'];
				}
				else
				{
					$_setting[$row['variable']][$row['subkey']]=$row['selected_value'];
				}
			}
		}
		else
		{
			if ($row['subkey']==NULL)
			{
				$_setting[$row['variable']]=$row['selected_value'];
			}
			else
			{
				$_setting[$row['variable']][$row['subkey']]=$row['selected_value'];
			}
		}
		
	}
	else
	{			
		if ($row['subkey']==NULL)
		{
			$_setting[$row['variable']]=$row['selected_value'];
		}
		else
		{
			$_setting[$row['variable']][$row['subkey']]=$row['selected_value'];
		}		
	}	
}
//echo '
';print_r($_setting);echo '
'; // we have to store the settings for the plugins differently because it expects an array //$sql="SELECT * FROM settings_current WHERE category='plugins'"; //$result=mysql_query($sql) or die(mysql_error()); $result = api_get_settings('Plugins','list',$_configuration['access_url']); $_plugins=array(); //while ($row=mysql_fetch_array($result)) foreach($result as $row) { $key= $row['variable']; if (is_string($_setting[$key])) { $_setting[$key]=array(); } $_setting[$key][]=$row['selected_value']; $_plugins[$key][]=$row['selected_value']; } // include the local (contextual) parameters of this course or section require($includePath."/local.inc.php"); // ===== "who is logged in?" module section ===== require_once($includePath."/lib/online.inc.php"); // check and modify the date of user in the track.e.online table if (!$x=strpos($_SERVER['PHP_SELF'],'whoisonline.php')) { LoginCheck(isset($_user['user_id']) ? $_user['user_id'] : '',$_configuration['statistics_database']); } //load array Kses for Htmlpurifier require_once $includePath."/lib/formvalidator/Rule/allowed_tags.inc.php"; //load htmpurifier require_once $includePath."/lib/htmlpurifier/library/HTMLPurifier.auto.php"; global $config_purifier; $charset = api_get_setting('platform_charset'); $config_purifier = HTMLPurifier_Config::createDefault(); $config_purifier->set('Core', 'Encoding',$charset); $config_purifier->set('HTML', 'Doctype', 'XHTML 1.0 Transitional'); // ===== end "who is logged in?" module section ===== if(get_setting('server_type') == 'test') { /* -------------------------------------------- Server type is test - high error reporting level - only do addslashes on $_GET and $_POST -------------------------------------------- */ error_reporting(E_ALL & ~E_NOTICE); //error_reporting(E_ALL); //Addslashes to all $_GET variables foreach($_GET as $key=>$val) { if(!ini_get('magic_quotes_gpc')) { if(is_string($val)) { $_GET[$key]=addslashes($val); } } } //Addslashes to all $_POST variables foreach($_POST as $key=>$val) { if(!ini_get('magic_quotes_gpc')) { if(is_string($val)) { $_POST[$key]=addslashes($val); } } } } else { /* -------------------------------------------- Server type is not test - normal error reporting level - full fake register globals block -------------------------------------------- */ error_reporting(E_COMPILE_ERROR | E_ERROR | E_CORE_ERROR); if(!isset($HTTP_GET_VARS)) { $HTTP_GET_VARS=$_GET; } if(!isset($HTTP_POST_VARS)) { $HTTP_POST_VARS=$_POST; } if(!isset($HTTP_POST_FILES)) { $HTTP_POST_FILES=$_FILES; } if(!isset($HTTP_SESSION_VARS)) { $HTTP_SESSION_VARS=$_SESSION; } if(!isset($HTTP_SERVER_VARS)) { $HTTP_SERVER_VARS=$_SERVER; } // Register SESSION variables into $GLOBALS if(sizeof($HTTP_SESSION_VARS)) { if(!is_array($_SESSION)) { $_SESSION=array(); } foreach($HTTP_SESSION_VARS as $key=>$val) { $_SESSION[$key]=$HTTP_SESSION_VARS[$key]; $GLOBALS[$key]=$HTTP_SESSION_VARS[$key]; } } // Register SERVER variables into $GLOBALS if(sizeof($HTTP_SERVER_VARS)) { $_SERVER=array(); foreach($HTTP_SERVER_VARS as $key=>$val) { $_SERVER[$key]=$HTTP_SERVER_VARS[$key]; if(!isset($_SESSION[$key]) && $key != 'includePath' && $key != 'rootSys' && $key!= 'clarolineRepositorySys' && $key!= 'lang_path' && $key!= 'extAuthSource' && $key!= 'thisAuthSource' && $key!= 'main_configuration_file_path' && $key!= 'phpDigIncCn' && $key!= 'drs') { $GLOBALS[$key]=$HTTP_SERVER_VARS[$key]; } } } } /* ----------------------------------------------------------- LOAD LANGUAGE FILES SECTION ----------------------------------------------------------- */ // if we use the javascript version (without go button) we receive a get // if we use the non-javascript version (with the go button) we receive a post $user_language = ''; if(!empty($_GET['language'])) { $user_language = $_GET["language"]; } if (!empty($_POST["language_list"])) { $user_language = str_replace("index.php?language=","",$_POST["language_list"]); } // Checking if we have a valid language. If not we set it to the platform language. $valid_languages=api_get_languages(); if (!in_array($user_language,$valid_languages['folder'])) { $user_language=get_setting('platformLanguage'); } if (in_array($user_language,$valid_languages['folder']) and (isset($_GET['language']) OR isset($_POST['language_list']))) { $user_selected_language = $user_language; // $_GET["language"]; $_SESSION["user_language_choice"] = $user_selected_language; $platformLanguage = $user_selected_language; }else{ $platformLanguage = get_setting('platformLanguage'); } if (isset($_SESSION["user_language_choice"])) { $language_interface = $_SESSION["user_language_choice"]; } else { $language_interface = get_setting('platformLanguage'); } if (isset($_user['language'])) { $language_interface = $_user['language']; } if ($_course['language']) { $language_interface = $_course['language']; } // Sometimes the variable $language_interface is changed // temporarily for achieving translation in different language. // We need to save the genuine value of this variable and // to use it within the function get_lang(...). $language_interface_initial_value = $language_interface; /* * Include all necessary language files * - trad4all * - notification * - custom tool language files */ $language_files = array(); $language_files[] = 'trad4all'; $language_files[] = 'notification'; $language_files[] = 'accessibility'; if( isset($language_file) ) { if( !is_array($language_file)) { $language_files[] = $language_file; } else { $language_files = array_merge($language_files,$language_file); } } // Include all files (first english and then current interface language) $langpath = api_get_path(SYS_CODE_PATH).'lang/'; if (is_array($language_files)) { foreach($language_files as $index => $language_file) { include($langpath.'english/'.$language_file.'.inc.php'); $langfile = $langpath.$language_interface.'/'.$language_file.'.inc.php'; if (file_exists($langfile)) { include($langfile); } } } //load the charset param after langs because the $charset variable in //trad4all.inc.php might have set it and we don't want that $charset = api_get_setting('platform_charset'); if (empty($charset)) { $charset = 'ISO-8859-15'; } //Update of the logout_date field in the table track_e_login (needed for the calculation of the total connection time) if($_configuration['tracking_enabled'] && !isset($_SESSION['login_as']) && isset($_user)) { // if $_SESSION['login_as'] is set, then the user is an admin logged as the user $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN); $sql_last_connection="SELECT login_id, login_date FROM $tbl_track_login WHERE login_user_id='".$_user["user_id"]."' ORDER BY login_date DESC LIMIT 0,1"; $q_last_connection=api_sql_query($sql_last_connection); if(Database::num_rows($q_last_connection) > 0) { $i_id_last_connection=Database::result($q_last_connection,0,"login_id"); $s_sql_update_logout_date="UPDATE $tbl_track_login SET logout_date=NOW() WHERE login_id='$i_id_last_connection'"; api_sql_query($s_sql_update_logout_date); } } ?>