|
|
| |
$camname" );
?>
\n");
print( "\n");
print( "\n");
print( "\n");
} else {
print( " ![](\"GetCamImage.php?cam=$camera\") " );
}
?>
|
");
print(" | ");
print(" | $itemname | " );
print(" ");
print(" ");
print(" ");
print(" ");
print(" ");
print(" $itemdesc");
if (substr($itemcode, 0, 1) == 'P') {
print("
");
$enabled = 0;
for ($j = 0; $j < mssql_num_rows( $result2 ); ++$j) {
$itemline = mssql_fetch_row( $result2 );
if ($itemline[0]==$itemcode & $present=='AWAKE') {
if ($itemline[1] <= date("H:i") & $itemline[2] >= date("H:i")) {
$enabled = 1;
}
}
}
if ($enabled==1) {
$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP)
or die("Unable to create socket\n");
if (socket_connect($socket, "192.168.0.160", 9010)) {
socket_setopt($socket, SOL_SOCKET, SO_BROADCAST, 1);
$socmsg = "STS $itemcode" . chr(13) . chr(10);
socket_write($socket, $socmsg, strlen($socmsg));
$retval = socket_recv($socket, $buffer, 1024, 0);
}
socket_close($socket);
if ($buffer=="") {
$light = 0;
} else {
$light = substr($buffer, strlen($socmsg));
}
switch ($light)
{
case 0:
print("This light is now off");
break;
case 100:
print("This light is now on");
break;
default:
print("This light is now $light%");
break;
}
print( "
![](\"../General/Images/Spacer.gif\") " );
print( " | " );
if ($stream==1) {
$streamstr = "&stream=1";
} else {
$streamstr = "";
}
print( "" );
if ($light==100) {
print("![](\"../General/Images/Button_on2.gif\") | " );
if ($itemcode=='P11') {
print("![](\"../General/Images/Button_off1.gif\") | " );
} else {
print(" | " );
}
} else {
print("![](\"../General/Images/Button_on1.gif\") | " );
print("![](\"../General/Images/Button_off2.gif\") | " );
}
} else {
print("Control of this light is now disabled, please try again later.");
}
}
if (substr($itemcode, 0, 2) == 'RC') {
print("
");
$enabled = 0;
for ($j = 0; $j < mssql_num_rows( $result2 ); ++$j) {
$itemline = mssql_fetch_row( $result2 );
if ($itemline[0]==$itemcode & $present=='AWAKE') {
if ($itemline[1] <= date("H:i") & $itemline[2] >= date("H:i")) {
$enabled = 1;
}
}
}
if ($enabled==1) {
print( " " );
$buffer = "";
$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP)
or die("Unable to create socket\n");
if (socket_connect($socket, "192.168.0.173", 9000)) {
socket_setopt($socket, SOL_SOCKET, SO_BROADCAST, 1);
socket_write($socket, "?" . chr(13) . chr(10), 3);
$retval = socket_recv($socket, $buffer, 1024, 0);
}
socket_close($socket);
if ($buffer=="") {
$direction = "B";
$iplock = "";
} else {
$direction = substr($buffer, 0, 1);
$iplock = substr($buffer, 2, strlen($buffer)-2);
}
print( "" );
if ($iplock=="" | $iplock==$REMOTE_ADDR) {
if ($direction=="B" | $direction=="L") {
print("![](\"../General/Images/Button_left1.gif\") | " );
} else {
print("![](\"../General/Images/Button_left2.gif\") | " );
}
if ($direction=="B" | $direction=="R") {
print("![](\"../General/Images/Button_right1.gif\") | " );
} else {
print("![](\"../General/Images/Button_right2.gif\") | " );
}
} else {
print("Control of the camera is now locked by another IP-Address, try again in a few minutes. | ");
}
} else {
print("Control of the camera is now disabled, please try again later.");
}
}
print(" ");
print(" ");
print(" ");
print(" | ");
print(" ");
print(" ");
print("
");
if (substr($itemcode, 0, 1) != 'P' | $itemcount == 1) {
print("");
print(" ");
print(" | $itemname Log | " );
print(" ");
print(" ");
print(" ");
print(" ");
print(" ");
print(" | ");
}
if (substr($itemcode, 0, 1) == 'P' & $itemcount == 1) {
$query = "SELECT Aantal FROM LogCount WHERE LogItem = '$itemcode'";
$result4 = mssql_query( $query, $connection );
$itemline = mssql_fetch_row( $result4 );
$logcount = $itemline[0];
$query = "SELECT StartDate FROM LogFirst WHERE LogItem = '$itemcode'";
$result5 = mssql_query( $query, $connection );
$itemline = mssql_fetch_row( $result5 );
$logstart = date("F j, Y", strtotime($itemline[0]));
print("This light has been switched $logcount times since $logstart");
print(" | ");
print(" ");
}
if ($camera==3 & !$stream==1) {
print(" ");
print(" | ");
print(" ");
print(" ");
print("
");
print("");
print(" ");
print(" | Streaming | " );
print(" ");
print(" ");
print(" ");
print(" ");
print(" ");
print(" | ");
print("Click here to make this cam streaming.");
print(" | ");
print(" ");
}
if (substr($itemcode, 0, 2) == 'DB') {
$database = mssql_select_db( "DoorLog" );
$query = "SELECT Aantal FROM RingCount";
$result4 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result4 );
$logcount = $logline[0];
$query = "SELECT StartDate FROM RingStart";
$result5 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result5 );
$logstart = date("F j, Y", strtotime($logline[0]));
$query = "SELECT RingOn, RingOut, RingTime FROM DoorRing ORDER BY RingOn DESC";
$result6 = mssql_query( $query, $connection );
print("The doorbell has been rung $logcount times since $logstart
");
print(" ");
print(" ");
$logtable = '';
for ($logidx=1; $logidx<=6; $logidx++) {
$logline = mssql_fetch_row( $result6 );
if ($logline[2]=='') {
$seconds = 1;
} else {
$seconds = round(100 * $logline[2]) / 100;
}
$logtable = "| " . date("d M Y", strtotime($logline[0])) . " | " . date("H:i", strtotime($logline[0])) . " | $seconds seconds | " . $logtable;
}
print($logtable);
}
if (substr($itemcode, 0, 2) == 'DO') {
$database = mssql_select_db( "DoorLog" );
$query = "SELECT Aantal FROM OpenCount";
$result4 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result4 );
$logcount = $logline[0];
$query = "SELECT StartDate FROM OpenStart";
$result5 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result5 );
$logstart = date("F j, Y", strtotime($logline[0]));
$query = "SELECT DoorOpen, DoorClose, DoorTime FROM DoorOpen ORDER BY DoorOpen DESC";
$result6 = mssql_query( $query, $connection );
print("The frontdoor has been opened $logcount times since $logstart
");
print(" ");
print(" ");
$logtable = '';
for ($logidx=1; $logidx<=6; $logidx++) {
$logline = mssql_fetch_row( $result6 );
if ($logline[2]=='') {
$seconds = 1;
} else {
$seconds = round(100 * $logline[2]) / 100;
}
$logtable = "| " . date("d M Y", strtotime($logline[0])) . " | " . date("H:i", strtotime($logline[0])) . " | $seconds seconds | " . $logtable;
}
print($logtable);
}
if (substr($itemcode, 0, 2) == 'ZF') {
$database = mssql_select_db( "DoorLog" );
$query = "SELECT Aantal FROM FridgeCount";
$result4 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result4 );
$logcount = $logline[0];
$query = "SELECT StartDate FROM FridgeStart";
$result5 = mssql_query( $query, $connection );
$logline = mssql_fetch_row( $result5 );
$logstart = date("F j, Y", strtotime($logline[0]));
$query = "SELECT DoorOpen, DoorClose, DoorTime FROM FridgeOpen ORDER BY DoorOpen DESC";
$result6 = mssql_query( $query, $connection );
print("The fridge has been opened $logcount times since $logstart
");
print(" ");
print(" ");
$logtable = '';
for ($logidx=1; $logidx<=6; $logidx++) {
$logline = mssql_fetch_row( $result6 );
if ($logline[2]=='') {
$seconds = 1;
} else {
$seconds = round(100 * $logline[2]) / 100;
}
$logtable = "| " . date("d M Y", strtotime($logline[0])) . " | " . date("H:i", strtotime($logline[0])) . " | $seconds seconds | " . $logtable;
}
print($logtable);
}
if (substr($itemcode, 0, 2) == 'RC') {
print("Nothing is logged yet.");
print(" ");
print(" ");
}
if (substr($itemcode, 0, 1) != 'P' | $itemcount == 1) {
print(" ");
print(" | ");
print(" ");
print(" ");
print("
");
}
$database = mssql_select_db( "HouseControl" );
}
?>
|
|
" );
if ($i<3) print( "" );
}
?>
|
|
" );
if ($i<6) print( "" );
}
?>
|
|
|
|