1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<?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;
?>
|
