From 75448045cfe70054c8f4bae1bcfaf9bb0f70d330 Mon Sep 17 00:00:00 2001 From: Moritz helios Rudert Date: Wed, 1 Jun 2011 12:13:39 +0200 Subject: fixes --- services/cron_dect.php | 106 ++++++++++++++++++++++--------------------------- 1 file changed, 48 insertions(+), 58 deletions(-) (limited to 'services/cron_dect.php') diff --git a/services/cron_dect.php b/services/cron_dect.php index b5e338c6..57d12e0f 100755 --- a/services/cron_dect.php +++ b/services/cron_dect.php @@ -1,61 +1,51 @@ -'2007-07-09 09:45:00' AND ". - "Shifts.DateS<='2007-07-09 11:00:00');"; -else - $SQL .= "WHERE ((`Shifts`.`DateS`>'". gmdate("Y-m-d H:i:s", time()+120+$gmdateOffset). "') AND ". - "(`Shifts`.`DateS`<='". gmdate("Y-m-d H:i:s", time()+120+$gmdateOffset+$StartTimeBeforEvent). "') );"; - -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); - -$Z=0; -for( $i=0; $i0) - { - $DECTnumber = UID2DECT(mysql_result($Erg, $i, "UID")); - if( $DECTnumber!="") - { - echo "dial $DECTnumber\n"; - DialNumberIAX( $DECTnumber, - mysql_result($Erg, $i, "DateS"), - mysql_result($Erg, $i, "RID"), - mysql_result($Erg, $i, "TID")); - DialNumberModem( $DECTnumber, - mysql_result($Erg, $i, "DateS")); - if( $Z++>10) - { - $Z=0; - sleep(30); - } - } +'2007-07-09 09:45:00' AND ". + "Shifts.DateS<='2007-07-09 11:00:00');"; + else + $SQL .= "WHERE ((`Shifts`.`DateS`>'". gmdate("Y-m-d H:i:s", time()+120+$gmdateOffset). "') AND ". + "(`Shifts`.`DateS`<='". gmdate("Y-m-d H:i:s", time()+120+$gmdateOffset+$StartTimeBeforEvent). "') );"; + + $Erg = mysql_query($SQL, $con); + echo mysql_error($con); + + $Z = 0; + + for($i = 0; $i < mysql_num_rows($Erg); $i++) { + if(mysql_result($Erg, $i, "UID") > 0) { + $DECTnumber = UID2DECT(mysql_result($Erg, $i, "UID")); + + if($DECTnumber != "") { + echo "dial $DECTnumber\n"; + DialNumberIAX( $DECTnumber, mysql_result($Erg, $i, "DateS"), mysql_result($Erg, $i, "RID"), mysql_result($Erg, $i, "TID")); + DialNumberModem( $DECTnumber, mysql_result($Erg, $i, "DateS")); + + if($Z++ > 10) { + $Z = 0; + sleep(30); + } + } + } } -} - -return 0; - + return 0; ?> - -- cgit v1.2.3-54-g00ecf