<?php

if(isset($_GET['a']))
		$action=$_GET['a'];
else
	$action='load_free_cars';
switch($action):

case 'car_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET auto='".$_POST['car']."' WHERE id='".$_POST['tourID']."'");
	$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$_POST['car']."'");
	$row_tourl = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'");
	$row_tourx = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row_tourl['tour']."'");
	$back['lastnote']="Fahrzeug ".$row_autox['kz']." für Tour ".$row_tourx['tour']." gespeichert.";
	$back['success'] = true;
	$back['alt'] = 5;
	echo json_encode($back);	
break;

case 'user_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET fahrer='".$_POST['user']."' WHERE id='".$_POST['tourID']."'");
	$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_POST['user']."'");
	$row_tourl = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'");
	$row_tourx = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row_tourl['tour']."'");
	$back['lastnote']="Fahrer ".$row_fahrer['name']." für Tour ".$row_tourx['tour']." gespeichert.";
	$back['success'] = true;
	$back['alt'] = 5;
	echo json_encode($back);
	
break;

case 'time_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$_POST['time']."' WHERE id='".$_POST['tourID']."'");
	$back['success'] = true;
	$back['lastnote']="Uhrzeit auf ".$_POST['time']." geändert.";	
	$back['alt'] = 5;
	echo json_encode($back);

	
break;

case 'info_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET infotext='".$_POST['info']."' WHERE id='".$_POST['tourID']."'");
	$back['success'] = true;
	$back['lastnote']="Information: ".$_POST['info']." hinzugefügt.";
	$back['alt'] = 5;
	echo json_encode($back);
		
break;

case 'load_planinfo';
default:


echo json_encode($ersatz);


endswitch;
	

?>