SensorAndSwitch Haus-Automation auf Webserver-Basis

ctlmgr_ctl r telcfg settings/Journal0/Number

<?xml
version="1.0" encoding="iso-8859-1">

<?xml version="1.0" encoding="UTF-8"?>

<?php
date_default_timezone_set('Europe/Berlin');
$strDatenbank = 'sqlite:/var/media/NEW_LINK/sensorandswitch/sensorandswitch.db3';
$dbh = new PDO($strDatenbank);
?>

<?php
require_once("db.php");
try {
$count = $dbh->exec("CREATE TABLE IF NOT EXISTS besucher (Hits INTEGER PRIMARY KEY, Zeit VARCHAR(255), IP VARCHAR(255), Agent VARCHAR(255))");
$count = $dbh->exec("INSERT INTO besucher (Zeit, IP, Agent) VALUES ('$_SERVER[REQUEST_TIME]','$_SERVER[REMOTE_ADDR]','$_SERVER[HTTP_USER_AGENT]')");
$dbh = null;
}
catch(PDOException $e) {
echo $e->getMessage();
}
?>

require_once("log.php");

<?php
$thisPage = "Besucher";
require_once("db.php");
try {
$sth = $dbh->prepare('SELECT * FROM besucher ORDER BY "Hits" DESC');
$sth->execute();
echo '<table border="1" style="background:fixed 0% 0% repeat olive url(/rte/img/bg.jpg);table-layout:fixed;border:3px double olive;border-collapse:inherit;border-spacing:3px 5px;">
<caption>Besucher</caption>
<thead><tr><th>Hits</th><th>Zeit</th><th>Client</th><th>User-Agent</th></tr></thead>
<tfoot><tr><td>Hits</td><td>Zeit</td><td>Client</td><td>User-Agent</td></tr></tfoot>
';
while($Zeile = $sth->fetch(PDO::FETCH_ASSOC)) {
echo '<tbody><tr><td>'.$Zeile['Hits'].'</td><td>'.date('r', $Zeile["Zeit"]).'</td><td>'.$Zeile['IP'].'</td><td>'.$Zeile["Agent"].'</td></tr></tbody>';
}
echo '</table>';
$dbh = null;
}
catch(PDOException $e) {
echo $e->getMessage();
}
?>

<?php
if ($_GET["info"]=="status") {
$Status=shell_exec('printf "%s %s %s %s %s</br>" $(uptime)');
$Status="P#<div style='position:relative;top:-10px;text-align:center;font-size:18px;'>".$Status."</div>*HTML#";
}
echo $Status;
?>

cat conf/sensorandswitch.conf|grep MAILPHP
MAILPHP=http://fritz.box:81/sensorandswitch/sasmail.php

<?php
error_reporting(0);
require_once "db.php";
//$count = $dbh->exec("CREATE TABLE IF NOT EXISTS pseudodevice (id INTEGER PRIMARY KEY, active VARCHAR(255))");
//$count = $dbh->exec("INSERT INTO pseudodevice (active) VALUES ('1')");
if ($_GET["info"]=="status") {
$sth = $dbh->prepare('SELECT * FROM pseudodevice ORDER BY "id" DESC');
$sth->execute();
$Status = $sth->fetch(PDO::FETCH_ASSOC);
if ($Status['active']=="0") {
echo "S#".trim($Status['active'])."#";
}
if ($Status['active']=="1") {
echo "S#".trim($Status['active'])."#";
}
}
if ($_GET["schalter"]=="1") {
$count = $dbh->exec("INSERT INTO pseudodevice (active) VALUES ('1')");
$sth = $dbh->prepare('SELECT * FROM pseudodevice ORDER BY "id" DESC');
$sth->execute();
$Status = $sth->fetch(PDO::FETCH_ASSOC);
if ($Status['active']=="1") {
echo "S#".trim($Status['active'])."#";
}}
if ($_GET["schalter"]=="0") {
$count = $dbh->exec("INSERT INTO pseudodevice (active) VALUES ('0')");
$sth = $dbh->prepare('SELECT * FROM pseudodevice ORDER BY "id" DESC');
$sth->execute();
$Status = $sth->fetch(PDO::FETCH_ASSOC);
if ($Status['active']=="0") {
echo "S#".trim($Status['active'])."#";
}}
exit;
?>