Portions created by the Initial Developer are Copyright (C) 2008-2019 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ if ($domains_processed == 1) { //remove smarty cache foreach(glob(sys_get_temp_dir().'*.php') as $file) { unlink($file); } //ensure the login message is set, if new message exists $sql = "select count(*) as num_rows from v_default_settings "; $sql .= "where default_setting_category = 'login' "; $sql .= "and default_setting_subcategory = 'message' "; $sql .= "and default_setting_name = 'text' "; $num_rows = $database->select($sql, null, 'column'); if ($num_rows == 0) { // insert message $sql = "insert into v_default_settings "; $sql .= "("; $sql .= "default_setting_uuid, "; $sql .= "default_setting_category, "; $sql .= "default_setting_subcategory, "; $sql .= "default_setting_name, "; $sql .= "default_setting_value, "; $sql .= "default_setting_enabled, "; $sql .= "default_setting_description "; $sql .= ")"; $sql .= "values "; $sql .= "("; $sql .= "'e2bff94b-2c68-45ee-9141-d4cdb437c644', "; $sql .= "'login', "; $sql .= "'message', "; $sql .= "'text', "; $sql .= ":default_setting_value, "; $sql .= "'true', "; $sql .= "'' "; $sql .= ")"; $parameters['default_setting_value'] = $text['login-message_text']; $database->execute($sql, $parameters); unset($sql, $parameters); } else { // get current message value $sql = "select default_setting_uuid, default_setting_value "; $sql .= "from v_default_settings "; $sql .= "where default_setting_category = 'login' "; $sql .= "and default_setting_subcategory = 'message' "; $sql .= "and default_setting_name = 'text' "; $result = $database->select($sql, null, 'all'); if (is_array($result) && count($result) > 0) { foreach($result as $row) { $current_default_setting_uuid = $row["default_setting_uuid"]; $current_default_setting_value = $row["default_setting_value"]; break; } // compare to message in language file, update and enable if different $new_default_setting_value = str_replace("''", "'", $text['login-message_text'] ?? ''); if ($current_default_setting_value != $new_default_setting_value) { $sql = "update v_default_settings set "; $sql .= "default_setting_value = :default_setting_value, "; $sql .= "default_setting_enabled = 'true' "; $sql .= "where default_setting_uuid = :default_setting_uuid "; $parameters['default_setting_value'] = $text['login-message_text']; $parameters['default_setting_uuid'] = $current_default_setting_uuid; $database->execute($sql, $parameters); unset($sql, $parameters); } } unset($sql, $result, $row); } } ?>