function get_sensor_name_list () {
$sensor_list = apc_fetch('sensor_list');
//var_dump($sensor_list);
if (!$sensor_list) // if not available in APC then read the list from DB, then save the list in APC
{
//echo "must read sesnor list from db";
$static_db = open_static_data_db(true);
$results = $static_db->query('SELECT * FROM sensor_names;');
while ($row = $results->fetchArray()) {
$sensor_id = $row['id'];
$sensor_name = $row['sensor_name'];
$sensor_list[$sensor_id] = $sensor_name;
//var_dump($sensor_list);
// save the sensor list in APC
}
$static_db->close();
apc_store('sensor_list', $sensor_list);
}
return $sensor_list;
}
/**
* log in with post data
*/
private function dologinWithPostData()
{
// check login form contents
// if (empty($_POST['user_name'])) {
// $this->errors[] = "Username field was empty.";
// } elseif (empty($_POST['user_password'])) {
if (empty($_POST['user_password'])) {
$this->errors[] = "Password field was empty.";
} elseif (!empty($_POST['user_password'])) {
$access_password = apc_fetch('access_password');
if (!$access_password) {
// get password from static DB
$static_db = open_static_data_db();
$results = $static_db->query('SELECT * FROM login_password');
while ($row = $results->fetchArray()) {
$access_password = $row['Password'];
}
apc_store('access_password', $access_password);
}
//error_log("-------------------------------------" . $access_password);
// create a database connection, using the constants from config/db.php (which we loaded in index.php)
// $this->db_connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
// change character set to utf8 and check it
// if (!$this->db_connection->set_charset("utf8")) {
// $this->errors[] = $this->db_connection->error;
// }
// if no connection errors (= working database connection)
// if (!$this->db_connection->connect_errno) {
// escape the POST stuff
// $user_name = $this->db_connection->real_escape_string($_POST['user_name']);
// database query, getting all the info of the selected user (allows login via email address in the
// username field)
/* $sql = "SELECT user_name, user_email, user_password_hash
FROM users
WHERE user_name = '" . $user_name . "' OR user_email = '" . $user_name . "';";
$result_of_login_check = $this->db_connection->query($sql);
*/
// if this user exists
// if ($result_of_login_check->num_rows == 1) {
// get result row (as an object)
// $result_row = $result_of_login_check->fetch_object();
// using PHP 5.5's password_verify() function to check if the provided password fits
// the hash of that user's password
// if (password_verify($_POST['user_password'], $result_row->user_password_hash)) {
if ($_POST['user_password'] == $access_password) {
// write user data into PHP SESSION (a file on your server)
$_SESSION['user_name'] = "harvestgenie";
$_SESSION['user_email'] = "";
$_SESSION['user_login_status'] = 1;
} else {
$this->errors[] = "Wrong password. Try again.";
}
/* } else {
$this->errors[] = "This user does not exist.";
}*/
/* } else {
$this->errors[] = "Database connection problem.";
}*/
}
}
function save_trigger($trigger_id, $description)
{
$static_db = open_static_data_db();
//error_log(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>" . $trigger_id . $description);
if ($trigger_id == 0) {
$results = $static_db->query('INSERT INTO triggers values (NULL,"' . $description . '",0);');
} else {
$results = $static_db->query('UPDATE triggers SET `description` = "' . $description . '" where `id` = ' . $trigger_id . ';');
}
$static_db->close();
save_static_db_in_storage();
}
function get_pin_status ($pin_nr) {
$static_db = open_static_data_db();
$results = $static_db->query('select enabled from pins where id = ' . $pin_nr . ' ;');
if ($row = $results->fetchArray()) {
//var_dump($row);
$pin_status = $row['enabled'];
}
$static_db->close();
return $pin_status;
}
