Esempio n. 1
0
        $info = "";
        $info = $zibase->getSensorInfo($sensorlist[$i]['id']);
        updateProbe($sensorlist[$i], $info, $link, 'temperature');
        $query = "CREATE TABLE IF NOT EXISTS `temperature_" . $sensorlist[$i]['name'] . "` (`date` datetime NOT NULL, `temp` float NOT NULL, `hygro` float NOT NULL, PRIMARY KEY (`date`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;";
        mysql_query($query, $link);
    }
    if ($sensorlist[$i]['type'] == 'power') {
        $info = "";
        $info = $zibase->getSensorInfo($sensorlist[$i]['id']);
        updateProbe($sensorlist[$i], $info, $link, 'conso');
        $query = "CREATE TABLE IF NOT EXISTS `conso_" . $sensorlist[$i]['name'] . "` (`date` datetime NOT NULL, `conso` float NOT NULL, `conso_total` float NOT NULL, PRIMARY KEY (`date`))ENGINE=InnoDB DEFAULT CHARSET=latin1;";
        mysql_query($query, $link);
    }
    $i++;
}
$actionlist = $zibase->getActuatorList($idzibase, $tokenzibase);
$actionnb = count($actionlist);
$i = 0;
while ($i < $actionnb) {
    $info = "";
    $info = $zibase->getSensorInfo($actionlist[$i]['id']);
    updateProbe($actionlist[$i], $info, $link, 'actioneur');
    $query = "CREATE TABLE IF NOT EXISTS `periph_" . $actionlist[$i]['name'] . "` (`date` datetime NOT NULL, `actif` TINYINT(1) NOT NULL, PRIMARY KEY (`date`)) ENGINE=InnoDB DEFAULT CHARSET=latin1";
    mysql_query($query, $link);
    $i++;
}
$actionlist = $zibase->getSensorList($idzibase, $tokenzibase);
$actionnb = count($actionlist);
$i = 0;
while ($i < $actionnb) {
    $info = "";