<?
include ("global.php");
include ("secure/db_data.php");


$question = $_GET["question"];
$start = $_GET["start"];
$userid = $_GET["userid"];
$language = $_GET["language"];

settype($question, "string");
settype($start, "integer");
settype($userid, "string");
settype($language, "string");

if ($userid=='') $userid='-1';


$global_db = mysql_connect($server01,$user01,$passwd01);

if ((mysql_select_db($db01,$global_db)))
{

	if ($question== "User_General")

	{
		$user_age = $HTTP_POST_VARS["user_age"];
		if ($user_age == ""){$user_age = '0';}

		$user_sex = $HTTP_POST_VARS["user_sex"];
		if ($user_sex == ""){$user_sex = '0';}

		$user_specialistType = $HTTP_POST_VARS["user_specialistType"];
		if ($user_specialistType == ""){$user_specialistType = '0';}

		$user_surgery = $HTTP_POST_VARS["user_surgery"];
		if ($user_surgery == ""){$user_surgery = '0';}

		$user_liversurgery = $HTTP_POST_VARS["user_liversurgery"];
		if ($user_liversurgery == ""){$user_liversurgery = '0';}

		$user_computer = $HTTP_POST_VARS["user_computer"];
		if ($user_computer == ""){$user_computer = '0';}

		$user_3d = $HTTP_POST_VARS["user_3d"];
		if ($user_3d == ""){$user_3d = '0';}

		$query = "INSERT INTO lst_eva_user (Age,Sex,Specialization,Surgery,Liversurgery,Computer,3D) VALUES ($user_age,$user_sex,'$user_specialistType',$user_surgery,$user_liversurgery,$user_computer,$user_3d);";
		$result = mysql_query($query);
		//echo $query;

		$query = "SELECT ID FROM lst_eva_user ORDER BY ID DESC LIMIT 1;";
		$result = mysql_query($query);

		$row = mysql_fetch_array($result);
		$userid = $row["ID"];

		$planning_experience = $HTTP_POST_VARS["planning_experience"];
		if ($planning_experience == ""){$planning_experience = '0';}
		
		$planning_benefit = $HTTP_POST_VARS["planning_benefit"];
		if ($planning_benefit == ""){$planning_benefit = '0';}
		
		$training_need = $HTTP_POST_VARS["training_need"];
		if ($training_need == ""){$training_need = '0';}
		$training_need_comment = $HTTP_POST_VARS["training_need_comment"];
		if ($training_need_comment == ""){$training_need_comment = '0';}

		$query = "UPDATE lst_eva_user SET Planning_Experience= $planning_experience,Planning_Benefit=$planning_benefit,Training_Need=$training_need,Training_Need_Comment='$training_need_comment' WHERE id = $userid;";
		$result = mysql_query($query);
		//echo $query;

	}

	else if ($question=="LST_General")
		{

		//$lst_case = $HTTP_POST_VARS["lst_case[]"];
		//if ($lst_case[0] == ""){$lst_case = '0';}
		
		$lst_case = $HTTP_POST_VARS["lst_case"];

		while (list ($key,$val) = @each ($lst_case)) { 
			$test = $test.$val.",";
		} 
		
		$lst_general = $HTTP_POST_VARS["lst_general"];
		if ($lst_general == ""){$lst_general = '0';}

		$lst_usability = $HTTP_POST_VARS["lst_usability"];
		if ($lst_usability == ""){$lst_usability = '0';}

		$lst_workflow = $HTTP_POST_VARS["lst_workflow"];
		if ($lst_workflow == ""){$lst_workflow = '0';}
		
		$lst_workflow_comment = $HTTP_POST_VARS["lst_workflow_comment"];
		if ($lst_workflow_comment == ""){$lst_workflow_comment = '0';}
		
		$lst_recommend = $HTTP_POST_VARS["lst_recommend"];
		
		while (list ($key,$val) = @each ($lst_recommend)) { 
			$test2 = $test2.$val.",";
		}
		
		
		$lst_recommend_comment = $HTTP_POST_VARS["lst_recommend_comment"];
		if ($lst_recommend_comment == ""){$lst_recommend_comment = '0';}
		
		$lst_expert = $HTTP_POST_VARS["lst_expert"];
		if ($lst_expert == ""){$lst_expert = '0';}
		
		$lst_enjoy = $HTTP_POST_VARS["lst_enjoy"];
		if ($lst_enjoy == ""){$lst_expert = '0';}
		
		//$query = "UPDATE lst_eva_rating SET LST_General= $lst_general,LST_Usability='$lst_usability',LST_Workflow=$lst_workflow WHERE id = $userid;";
		$query = "INSERT INTO lst_eva_rating (User_Id,LST_Case,LST_General,LST_Usability,LST_Workflow,LST_Workflow_Comment,LST_Recommend,LST_Recommend_Comment,LST_Expert,LST_Enjoy) VALUES ($userid,'$test',$lst_general,$lst_usability,$lst_workflow,'$lst_workflow_comment','$test2','$lst_recommend_comment',$lst_expert,$lst_enjoy);";
		$result = mysql_query($query);
	}
	else if ($question=="LST_Interface")
			{

		//$lst_font = $HTTP_POST_VARS["lst_font"];
		//if ($lst_font == ""){$lst_font = '0';}
		//$lst_font_comment = $HTTP_POST_VARS["lst_font_comment"];
		//if ($lst_font_comment == ""){$lst_font_comment = '0';}

		//$lst_bigviewer = $HTTP_POST_VARS["lst_bigviewer"];
		//if ($lst_bigviewer == ""){$lst_bigviewer = '0';}
		//$lst_bigviewer_comment = $HTTP_POST_VARS["lst_bigviewer_comment"];
		//if ($lst_bigviewer_comment == ""){$lst_bigviewer_comment = '0';}

		//$lst_controlpanel = $HTTP_POST_VARS["lst_controlpanel"];
		//if ($lst_controlpanel == ""){$lst_controlpanel = '0';}
		//$lst_controlpanel_comment = $HTTP_POST_VARS["lst_controlpanel_comment"];
		//if ($lst_controlpanel_comment == ""){$lst_controlpanel_comment = '0';}

		//$lst_complexity = $HTTP_POST_VARS["lst_complexity"];
		//if ($lst_complexity == ""){$lst_complexity = '0';}
		//$lst_complexity_comment = $HTTP_POST_VARS["lst_complexity_comment"];
		//if ($lst_complexity_comment == ""){$lst_complexity_comment = '0';}

		$lst_controltext1 = $HTTP_POST_VARS["lst_controltext1"];
		if ($lst_controltext1 == ""){$lst_controltext1 = '0';}

		$lst_controltext2 = $HTTP_POST_VARS["lst_controltext2"];
		if ($lst_controltext2 == ""){$lst_controltext2 = '0';}
	

		$lst_helptext1 = $HTTP_POST_VARS["lst_helptext1"];
		if ($lst_helptext1 == ""){$lst_helptext1 = '0';}

		$lst_helptext2 = $HTTP_POST_VARS["lst_helptext2"];
		if ($lst_helptext2 == ""){$lst_helptext2 = '0';}
		$lst_helptext2_comment = $HTTP_POST_VARS["lst_helptext2_comment"];
		if ($lst_helptext2_comment == ""){$lst_helptext2_comment = '0';}

		//$query = "UPDATE lst_eva_rating SET LST_Font=$lst_font,LST_BigViewer=$lst_bigviewer,LST_ControlPanel=$lst_controlpanel,LST_Complexity=$lst_complexity,LST_HelpText1=$lst_helptext1,LST_HelpText2=$lst_helptext2,LST_ControlText1=$lst_controltext1,LST_ControlText2=$lst_controltext2,LST_Font_Comment='$lst_font_comment',LST_BigViewer_Comment='$lst_bigviewer_comment',LST_ControlPanel_Comment='$lst_controlpanel_comment',LST_Complexity_Comment='$lst_complexity_comment',LST_HelpText2_Comment='$lst_helptext2_comment',LST_ControlText2_Comment='$lst_controltext2_comment' WHERE User_Id = $userid;";
		$query = "UPDATE lst_eva_rating SET LST_HelpText1=$lst_helptext1,LST_HelpText2=$lst_helptext2,LST_ControlText1=$lst_controltext1,LST_ControlText2=$lst_controltext2,LST_HelpText2_Comment='$lst_helptext2_comment' WHERE User_Id = $userid;";
		$result = mysql_query($query);
		//echo $query;

	}
	else if ($question=="LST_Feedback_Waiting_Error")
			{

		$lst_feedback = $HTTP_POST_VARS["lst_feedback"];
		if ($lst_feedback == ""){$lst_feedback = '0';}


		$lst_waiting = $HTTP_POST_VARS["lst_waiting"];
		if ($lst_waiting == ""){$lst_waiting = '0';}
		$lst_waiting_comment = $HTTP_POST_VARS["lst_waiting_comment"];


		$lst_waitingnumber = $HTTP_POST_VARS["lst_waitingnumber"];
		if ($lst_waitingnumber == ""){$lst_waitingnumber = '0';}


		$lst_error = $HTTP_POST_VARS["lst_error"];
		if ($lst_error == ""){$lst_error = '0';}


		$lst_errortype = $HTTP_POST_VARS["lst_errortype"];
		if ($lst_errortype == ""){$lst_errortype = '0';}
		$lst_errortype_comment = $HTTP_POST_VARS["lst_errortype_comment"];
		if ($lst_errortype_comment == ""){$lst_errortype_comment = '0';}


		$query = "UPDATE lst_eva_rating SET LST_Feedback=$lst_feedback,LST_Waiting=$lst_waiting,LST_WaitingNumber=$lst_waitingnumber,LST_Error=$lst_error,LST_ErrorType=$lst_errortype,LST_ErrorType_Comment='$lst_errortype_comment' WHERE User_Id = $userid;";
		$result = mysql_query($query);
		//echo $query;

	}

	else if ($question=="LST_Learnability")
			{

		$lst_learnability = $HTTP_POST_VARS["lst_learnability"];
		if ($lst_learnability == ""){$lst_learnability = '0';}


		$lst_learnabilityuser = $HTTP_POST_VARS["lst_learnabilityuser"];
		if ($lst_learnabilityuser == ""){$lst_learnabilityuser = '0';}

		$lst_learntime = $HTTP_POST_VARS["lst_learntime"];
		if ($lst_learntime == ""){$lst_learntime = '0';}
		$lst_learntime_comment = $HTTP_POST_VARS["lst_learntime_comment"];
		if ($lst_learntime_comment == ""){$lst_learntime_comment = '0';}


		$query = "UPDATE lst_eva_rating SET LST_Learnability=$lst_learnability,LST_LearnabilityUser='$lst_learnabilityuser',LST_Learntime=$lst_learntime,LST_Learntime_Comment='$lst_learntime_comment' WHERE User_Id = $userid;";
		$result = mysql_query($query);
		//echo $query;

	}

	else if ($question=="Compare_Versions")
			{

		$lst_firsteval = $HTTP_POST_VARS["lst_firsteval"];
		if ($lst_firsteval == ""){$lst_firsteval = '0';}


		$lst_version = $HTTP_POST_VARS["lst_version"];
		if ($lst_version == ""){$lst_version = '0';}


		$lst_versionwaiting = $HTTP_POST_VARS["lst_versionwaiting"];
		if ($lst_versionwaiting == ""){$lst_versionwaiting = '0';}


		$lst_versionhandling = $HTTP_POST_VARS["lst_versionhandling"];
		if ($lst_versionhandling == ""){$lst_versionhandling = '0';}
		
		$lst_versionlearn = $HTTP_POST_VARS["lst_versionlearn"];
		if ($lst_versionlearn == ""){$lst_versionlearn = '0';}

		$lst_version_comment = $HTTP_POST_VARS["lst_version_comment"];
		if ($lst_version_comment == ""){$lst_version_comment = '0';}
		
		$query = "UPDATE lst_eva_rating SET LST_FirstEval=$lst_firsteval,LST_Version=$lst_version,LST_VersionWaiting=$lst_versionwaiting,LST_VersionHandling=$lst_versionhandling,LST_VersionLearn=$lst_versionlearn,LST_Version_Comment='$lst_version_comment' WHERE User_Id = $userid;";
		$result = mysql_query($query);
		//echo $query;

	}

}
else
{
	echo "Fehler bei Verbindungsaufbau zur Datenbank<br>";
	echo mysql_error();
}

mysql_close;






$nextStep = "";

if ($start == 1)		// hier wurden allg. Userdaten abgefragt
{
	$nextStep = "User_General";
	$nr = 1;

}
else if ($question == "User_General")		// hier wurden allg. Userdaten abgefragt
{
	$nextStep = "LST_General";
	$nr = 2;
}

else if ($question == "LST_General")
{
	$nextStep = "LST_Interface";
	$nr = 3;
}

else if ($question == "LST_Interface")
{
	$nextStep = "LST_Feedback_Waiting_Error";
	$nr = 4;
}
else if ($question == "LST_Feedback_Waiting_Error")
{
	$nextStep = "LST_Learnability";
	$nr = 5;
}

else if ($question == "LST_Learnability")
{
	$nextStep = "Compare_Versions";
	$nr = 6;
}

else if ($question == "Compare_Versions")
{
	$nextStep = "";
	$nr = 7;
}

$finish=0;
if ($nextStep == "") $finish=1;


if ($language == "en")
{
header("Location: input_en.php?question=$nextStep&userid=$userid&nr=$nr&finish=$finish");
}
else if ($language == "deu")
{
header("Location: input.php?question=$nextStep&userid=$userid&nr=$nr&finish=$finish");
}

?>