"; print_r($_POST); echo ""; $_SESSION['fazplz']=$_POST['faz']; $GLOBALS['mysql']->insert("UPDATE var_temp SET wert='".$_POST['faz']."' WHERE id=2"); $back['lastnote']=$_POST['faz']; $back['success'] = true; $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 '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 'load_free_cars'; default: //--------------------- freie Fahrzeuge Nachts $key=0; //-- caddy nachts $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ=2 ORDER BY id"); while($row = $tempcar->fetch_assoc()) { $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ<6"); // LIKE = % (egal was da steht) $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'"); if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) { $seite['caddy'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++; } } //-- trp nachts $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ>2 ORDER BY id"); while($row = $tempcar->fetch_assoc()) { $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ<6"); $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'"); if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) { $seite['trp'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++; } } echo json_encode($seite); endswitch; ?>