query("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and typ in (3,4,5,17) ORDER BY tour");
$key=0;
while($row = $tourd->fetch_assoc()) {
$back[$key]['id']=$row['id'];
if($row['fahrer']==0) {
$back['$tour']="";
} else {
if ($row['smsstatus']==0) { $back[$key]['tour']=""; }
if ($row['smsstatus']==1) { $back[$key]['tour']=""; }
if ($row['smsstatus']==2) { $back[$key]['tour']=""; }
if ($row['smsstatus']==3) { $back[$key]['tour']=""; }
if ($row['smsstatus']==4) { $back[$key]['tour']=""; }
if ($row['smsstatus']==5) { $back[$key]['tour']=""; }
if ($row['smsstatus']==8) { $back[$key]['tour']=""; }
if ($row['smsstatus']==20) { $back[$key]['tour']=""; }
if ($row['smsstatus']==99) { $back[$key]['tour']=""; }
}
$key++;
}
echo json_encode($back);
//echo $back;
//$template->assign('data', $tourd);
//$template->assign('content', 'tpl/ajax/sms_nacht.tpl');
?>