diff options
Diffstat (limited to 'admin/dect_cron.php')
| -rwxr-xr-x | admin/dect_cron.php | 69 |
1 files changed, 0 insertions, 69 deletions
diff --git a/admin/dect_cron.php b/admin/dect_cron.php deleted file mode 100755 index 00119567..00000000 --- a/admin/dect_cron.php +++ /dev/null @@ -1,69 +0,0 @@ -<?PHP - - -include ("./inc/db.php"); -include ("./inc/config.php"); -include ("./inc/funktion_modem.php"); - -//ausfuerungs Ruetmuss (in s) -$StartTimeBeforEvent = (60/4)*60; - - - - -function UID2DECT($UID) -{ - include ("./inc/db.php"); - - $SQL = "SELECT DECT FROM `User` WHERE UID='$UID'"; - $Erg = mysql_query($SQL, $con); - - return mysql_result($Erg, 0); -} - - -$SQL = "SELECT Shifts.DateS, ShiftEntry.UID ". - "FROM `Shifts` INNER JOIN `ShiftEntry` ON `Shifts`.`SID` = `ShiftEntry`.`SID` ". - "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). "') );"; -// "WHERE (Shifts.DateS>'2004-12-27 10:45:00' AND ". -// "Shifts.DateS<='2004-12-27 11:00:00');"; - -$Erg = mysql_query($SQL, $con); - -echo mysql_error($con); - -for( $i=0; $i<mysql_num_rows($Erg); $i++) -{ -// echo mysql_result($Erg, $i, "UID"); - if( mysql_result($Erg, $i, "UID")>0) - { - $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; - - SetWackeup( $Number, $TimeH, $TimeM); - } - } -} - -return 0; - -?> - |