'; print_r($row_nichtda); echo''; error_reporting(E_ALL); ini_set('display_errors',0); header('Content-Type: text/html; charset=utf-8'); //----------------------------------------------------- $wochentag=date(w); $jahr = (int)date('Y'); $kw_aktuell = (int)date('W'); $time=time(); $ptime=$time-22000; //----------------------------------------------------- //----------------------------------------------------- //----------------------------------------------------- $testcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and aktiv<90 and besitz<4 and typ<3 ORDER BY kz"); $key=0; //mini pkw & caddy while($row = $testcar->fetch_assoc()) { $t=date('j',$time); $m=date('n',$time); $j=date('Y',$time); // kein Eintrag, fahrzeug nicht eingesetzt $test_kal = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE tag='".$t."' and monat='".$m."' and jahr='".$j."' and fid='".$row['id']."'"); if($test_kal['num_rows'] == 0) { $test_tour2 = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE time>'".$ptime."' and time<'".$time."' and auto='".$row['id']."'"); if($test_tour2['num_rows'] == 0) { $test_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE time>'".$time."' and auto='".$row['id']."' ORDER BY time"); if($test_tour['num_rows'] == 0) { $info[$key]['car'] =$row['kz']; $info[$key]['time']=0; $info[$key]['ort'] =$row['standort']; $key++; } else { if($test_tour['typ']!=8) { if($test_tour['typ']!=15) { $info[$key]['time']=$test_tour['time']; $info[$key]['rest']=round(($test_tour['time']-$time)/3600); $info[$key]['car'] =$row['kz']; $info[$key]['ort'] =$row['standort']; $key++; } } } } } } $template->assign('info', $info); $template->assign('content', 'tpl/ajax/pi_freecar.tpl'); ?>