--- alx-src/trunk/alxconfig-ng/functions/config_sessions.sh	2005/04/12 20:46:52	239
+++ alx-src/trunk/alxconfig-ng/functions/config_sessions.sh	2005/04/28 22:45:05	272
@@ -1,4 +1,4 @@
-# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.3 2005-04-12 20:45:55 niro Exp $
+# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.7 2005-04-28 22:45:05 niro Exp $
 # configures ica-sessions on the host via mysql db settings
 
 get_sessions_settings()
@@ -10,7 +10,7 @@
 
 	#get settings from database
 	all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
-			"select session from cfg_sessions where serial='${ALX_SERIAL}'")
+			"select filename from cfg_sessions where serial='${ALX_SERIAL}'")
 
 	#split'em up and put in an array (only if $all not zero)
 	declare -i i=0
@@ -29,22 +29,119 @@
 	export ALX_SESSIONS
 }
 
+get_autostart_settings()
+{
+	#get settings from database
+	ALX_AUTOSTART=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+			"select session from cfg_autostart where serial='${ALX_SERIAL}'")
+
+	export ALX_AUTOSTART
+}
+
+generate_ica_session_files()
+{
+	local all_ids
+	local i
+	local x
+	local server
+	local ses_session
+	local ses_filename
+	local ses_username
+	local ses_domain
+	local ses_password
+	local ses_browseradrs
+	local ses_colors
+
+	#get settings from database
+	all_ids=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+			"select id from cfg_sessions where serial='${ALX_SERIAL}'")
+
+	for i in ${all_ids}
+	do
+		# get settings
+		ses_session=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select session from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		ses_filename=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select filename from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		ses_username=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select username from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		ses_domain=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select domain from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		ses_password=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select password from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		ses_browseradrs=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+				"select browseradrs from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
+
+		# get the right colors
+		ses_colors=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
+			"select depth from cfg_graphic where serial='${ALX_SERIAL}'")
+		case ${ses_colors} in
+			24) ses_colors="8";;
+			16) ses_colors="4";;
+			8) ses_colors="2";;
+			*) ses_colors="2";;
+		esac
+
+		# write session files
+		echo '[WFClient]' > ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'Version=2' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		OLD_IFS="$IFS"
+		IFS=";"
+		declare -i x=0
+		for server in ${ses_browseradrs}
+		do
+			(( x++ ))
+			echo "TcpBrowserAddress${x}=${server}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		done
+		IFS="${OLD_IFS}"
+		unset x
+		unset OLD_IFS
+		
+		echo 'ScreenPercent=0' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+
+		echo '[ApplicationServers]' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "${ses_session}=" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		
+		echo "[${ses_session}]" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "Address=${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "InitialProgram=#${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'DesiredColor=${ses_colors}' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'TransportDriver=TCP/IP' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'WinStationDriver=ICA 3.0' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "ClearPassword=${ses_password}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "Username=${ses_username}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo "Domain=${ses_domain}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'UseFullScreen=Yes' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+		echo 'NoWindowManager=True' >> ${ALX_ICA_SESSIONS}/${ses_filename}
+	done
+}
+
 config_sessions()
 {
+	# generate ica session files
+	generate_ica_session_files
+
 	#first of all get the vars
 	get_sessions_settings
+	get_autostart_settings
 
 	local count=${#ALX_SESSIONS[*]}
 	local icon
+	local i
 
 	# DEBUG
-	declare -i i=0
-	echo count=${count}
-	echo "Number of new sessions: ${count}"
-	for ((i=0; i < count; i++))
-	do
-		echo "${i} - ${ALX_SESSIONS[${i}]}"
-	done
+# 	declare -i i=0
+# 	echo count=${count}
+# 	echo "Number of new sessions: ${count}"
+# 	for ((i=0; i < count; i++))
+# 	do
+# 		echo "${i} - ${ALX_SESSIONS[${i}]}"
+# 	done
 
 	# now setup fluxbox for user station
 
@@ -62,6 +159,13 @@
 	cat ${ALX_SKELETONS}/fluxbox/apps \
 		> ${ALX_UNPRIV_HOME}/.fluxbox/apps
 
+	# add autostart session
+	if [[ ${ALX_AUTOSTART} != "" ]]
+	then
+		echo "[startup] {wfica ${ALX_ICA_SESSIONS}/${ALX_AUTOSTART}}" \
+			>> ${ALX_UNPRIV_HOME}/.fluxbox/apps
+	fi
+
 	# fluxbox hotkeys
 	cat ${ALX_SKELETONS}/fluxbox/apps \
 		> ${ALX_UNPRIV_HOME}/.fluxbox/keys