\n"; } function UID2DECT($UID) { global $con; $SQL = "SELECT DECT FROM `User` WHERE UID='$UID'"; $Erg = mysql_query($SQL, $con); return mysql_result($Erg, 0); } function RID2Room($RID) { global $con; $SQL = "SELECT Name FROM `Room` WHERE RID='$RID'"; $Erg = mysql_query($SQL, $con); return mysql_result($Erg, 0); } function TID2Engeltype($TID) { global $con; $SQL = "SELECT Name FROM `EngelType` WHERE TID='$TID'"; $Erg = mysql_query($SQL, $con); return mysql_result($Erg, 0); } $SQL = "SELECT Shifts.DateS, Shifts.RID, ShiftEntry.UID, ShiftEntry.TID ". "FROM `Shifts` INNER JOIN `ShiftEntry` ON `Shifts`.`SID` = `ShiftEntry`.`SID` "; if( $DebugDECT) $SQL .= "WHERE (Shifts.DateS>'2004-12-27 10:45:00' AND ". "Shifts.DateS<='2004-12-27 11:00:00');"; else $SQL .= "WHERE ((`Shifts`.`DateS`>'". gmdate("Y-m-d H:i:s", time()+3600+120). "') AND ". "(`Shifts`.`DateS`<='". gmdate("Y-m-d H:i:s", time()+3600+120+$StartTimeBeforEvent). "') );"; $Erg = mysql_query($SQL, $con); echo mysql_error($con); for( $i=0; $i0) { $SQL2 = "SELECT DECT FROM `User` WHERE ( `UID`='". mysql_result($Erg, $i, "UID"). "');"; $Erg2 = mysql_query($SQL2, $con); $Number = mysql_result($Erg2, 0, "DECT"); if( $Number!="") { $TimeH = substr( mysql_result($Erg, $i, "DateS"), 11, 2); $TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2); $TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2) - 5; if( $TimeM < 0 ) { $TimeM += 60; $TimeH -= 1; } if( $TimeH < 0 ) $TimeH += 24; if( strlen( $TimeH) == 1) $TimeH = "0".$TimeH; $Room = RID2Room( mysql_result($Erg, $i, "RID")); $EngelType = TID2Engeltype( mysql_result($Erg, $i, "TID")); DialNumber( $Number, $TimeH, $TimeM, $Room, $EngelType); } } } return 0; ?>