<?php

const ET_CONNECTIONS = [
/* standard connection for meta database */		
		ET_SYSTEM_CONNECTION => array(
				PHPGRID_DB_DISPLAY_NAME=>"niota meta",
				PHPGRID_DB_HOSTNAME=>ET_HOST[ET_METADATA_CONNECTION],
				PHPGRID_DB_USERNAME=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_USERNAME],
				PHPGRID_DB_PASSWORD=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_PASSWORD],				
				PHPGRID_DB_NAME=>"niota_system", /* dont change if not urgent */
				PHPGRID_DB_TYPE=>"mysqli",
				PHPGRID_DISPLAY_NUMBER_DECIMALPOINT=>",",
				PHPGRID_DB_CHARSET=>"utf-8",
				PHPGRID_SOURCE_DATE_FORMAT=>"Y-m-d",
				PHPGRID_DISPLAY_DATE_FORMAT=>"Y-m-d",
				PHPGRID_SOURCE_DATETIME_FORMAT=>"d-b-y h:i:s,f A",
				PHPGRID_DISPLAY_DATETIME_FORMAT=>"Y-m-d H:i:s",
				PHPGRID_DB_PW_ENCRYPTED => ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_ENCRYPTED]

		),
		ET_METADATA_CONNECTION => array(
				PHPGRID_DB_DISPLAY_NAME=>"niota meta",
				PHPGRID_DB_HOSTNAME=>ET_HOST[ET_METADATA_CONNECTION],
				PHPGRID_DB_USERNAME=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_USERNAME],
				PHPGRID_DB_PASSWORD=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_PASSWORD],				
				PHPGRID_DB_NAME=>"niota_meta", /* <-- enter you client specific meta db here */
				PHPGRID_DB_TYPE=>"mysqli",
				PHPGRID_DISPLAY_NUMBER_DECIMALPOINT=>",",
				PHPGRID_DB_CHARSET=>"utf-8",
				PHPGRID_SOURCE_DATE_FORMAT=>"Y-m-d",
				PHPGRID_DISPLAY_DATE_FORMAT=>"Y-m-d",
				PHPGRID_SOURCE_DATETIME_FORMAT=>"d-b-y h:i:s,f A",
				PHPGRID_DISPLAY_DATETIME_FORMAT=>"Y-m-d H:i:s",
				PHPGRID_DB_PW_ENCRYPTED => ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_ENCRYPTED]

		),		
		"niota_import"=>array(
				PHPGRID_DB_DISPLAY_NAME=>"niota import",
				PHPGRID_DB_HOSTNAME=>ET_HOST[ET_METADATA_CONNECTION],
				PHPGRID_DB_USERNAME=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_USERNAME],
				PHPGRID_DB_PASSWORD=>ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_PASSWORD],				
				PHPGRID_DB_NAME=>"niota_deploy",
				PHPGRID_DB_TYPE=>"mysqli",
				PHPGRID_DISPLAY_NUMBER_DECIMALPOINT=>",",
				PHPGRID_DB_CHARSET=>"utf-8",
				PHPGRID_SOURCE_DATE_FORMAT=>"Y-m-d",
				PHPGRID_DISPLAY_DATE_FORMAT=>"Y-m-d",
				PHPGRID_SOURCE_DATETIME_FORMAT=>"d-b-y h:i:s,f A",
				PHPGRID_DISPLAY_DATETIME_FORMAT=>"Y-m-d H:i:s",
				PHPGRID_DB_PW_ENCRYPTED => ET_LOGIN[ET_METADATA_CONNECTION][LOGIN_ENCRYPTED]
		),
		ET_ZAGREUS_CONNECTION => array (
				PHPGRID_WS_DISPLAY_NAME		=> "zagreus WS",
				PHPGRID_WS_ENDPOINT 		=> ET_HOST[ET_ZAGREUS_CONNECTION] . "/zagreus/services/ws/zagreuswebbaseservice",
				PHPGRID_WSDL_LOCATION 		=> ET_HOST[ET_ZAGREUS_CONNECTION] . "/zagreus/zagreuswebbaseservice.wsdl",
				PHPGRID_DB_USERNAME			=> ET_LOGIN[ET_ZAGREUS_CONNECTION][LOGIN_USERNAME],
				PHPGRID_DB_PASSWORD			=> ET_LOGIN[ET_ZAGREUS_CONNECTION][LOGIN_PASSWORD],
				PHPGRID_CONN_TYPE		 	=> CONN_TYPE_WEBSERVICE, 
				PHPGRID_DB_PW_ENCRYPTED 	=> ET_LOGIN[ET_ZAGREUS_CONNECTION][LOGIN_ENCRYPTED]
		)		
];

// possible PHPGRID_DB_CHARSET values: AL32UTF8, iso-8859-2, utf8
//DATE and DATETIME formats:
//Y: 	year, 4 digits
//y: 	year 2 digits
//m:	month, numeric (00-12)
//M:	month name (January-December)
//d:	day of month, numeric (00-31)
//H:	hour (00-23)
//h,I:	hour (01-12)
//i:	minutes, numeric (00-59)
//s,S:	seconds (00-59)
//p:	am/pm
//r:	time, 12-hour (hh:mm:ss) followed by AM or PM)
//T:	time, 24 hour (hh:mm:ss)
//f:	microseconds (000000-999999)
//b:	month, numeric (00-12) only for Oracle connections


?>
