function save_pin_status($pin_nr,$command,$save_db_to_storage) { // save DB $static_db = open_static_data_db(); $results = $static_db->query('update pins set enabled = ' . $command . ' where id = ' . $pin_nr . ' ;'); $static_db->close(); if ($save_db_to_storage) save_static_db_in_storage(); }
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(); }