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 = ""; $info = $zibase->getSensorInfo($actionlist[$i]['id']); updateProbe($actionlist[$i], $info, $link, 'capteur'); $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++; }