<?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>