<?php
//This option should be provided based on the devices present in the current environment only
require_once "Includes/header.php";
if (!ENV_logged_on() || $_SESSION['ROOT'] != $_SESSION['userid']) {
header("Location: /Home.php");
}
$dev = array("light_bulb", "fan_ceil", "fan_table", "light_cfl", "light_table");
$mid = $_SESSION['MID'];
$query = "SELECT * FROM riot4.ENV_settings WHERE id=?";
$params = array($mid);
$statement_count = sqlsrv_query($conn, $query, $params);
if (isset($_POST['Update'])) {
while ($row = sqlsrv_fetch_array($statement_count)) {
$d = $row['Device'];
$dev = array_diff($dev, array($d));
$ad_rm = isset($_POST[$d]);
$ar = 0;
if ($ad_rm) {
$ar = 1;
}
if ($ar) {
$query = "DELETE FROM riot4.ENV_settings WHERE id=? AND Device=?";
$params = array($mid, $d);
sqlsrv_query($conn, $query, $params);
}
}
foreach ($dev as $d) {
$ad_rm = isset($_POST[$d]);
$ar = 1;
if ($ad_rm) {
<?php
require_once "Includes/header.php";
if (!logged_on() || ENV_logged_on()) {
header("Location: /Home.php");
}
$query = "SELECT * FROM riot4.users WHERE id = ?";
$params = array($_SESSION['userid']);
$statement = sqlsrv_query($conn, $query, $params);
if (sqlsrv_has_rows($statement)) {
$row = sqlsrv_fetch_array($statement);
if (!is_null($row['logged_MID'])) {
$msg = "Your account is beign used elsewhere.Please logoff from that environment before logging in here.";
header("Location: /userPref_settings.php?Message=" . urlencode($msg));
}
}
if (isset($_POST['Dev_Login'])) {
$Envir_ID = $_POST['Chip_ID'];
$password = $_POST['OTP'];
$valid = FALSE;
$query = "SELECT * FROM riot4.ENV WHERE id = ?";
$params = array($Envir_ID);
$statement = sqlsrv_query($conn, $query, $params);
if (sqlsrv_has_rows($statement)) {
$row = sqlsrv_fetch_array($statement);
if ($row['OTP'] == $password) {
$_SESSION['ENV_OTP'] = $row['OTP'];
$_SESSION['MID'] = $row['id'];
$_SESSION['ROOT'] = $row['root'];
$query_update = "UPDATE riot4.users SET logged_MID = ? WHERE id = ?";
$params = array($Envir_ID, $_SESSION['userid']);
<li class="nav-expander">
<a href="/Home.php#Desc1">Device</a>
</li>
<li class="nav-expander">
<a href="/Home.php#Desc2">Preference</a>
</li>
</ul>
</nav>
<div id="Lowerband_right">
<ul class="dev-navigation">
<li class="nav-expander">
<?php
if (logged_on() && !ENV_logged_on()) {
?>
<a href="/userPref_settings.php"><div id="Settings">My Settings</div></a>
<?php
}
if (ENV_logged_on()) {
?>
<a href="/userPref_settings.php"><div id="Settings">My Settings</div></a>
<a href="/env_settings.php"><div id="Settings">Env Settings</div></a>
<?php
}
?>
</li>
</ul>
</div>
</div>
</div>
</header>
<center>
