1a25f0a04SGreg Roach<?php 2a25f0a04SGreg Roach/** 3a25f0a04SGreg Roach * webtrees: online genealogy 4*1062a142SGreg Roach * Copyright (C) 2018 webtrees development team 5a25f0a04SGreg Roach * This program is free software: you can redistribute it and/or modify 6a25f0a04SGreg Roach * it under the terms of the GNU General Public License as published by 7a25f0a04SGreg Roach * the Free Software Foundation, either version 3 of the License, or 8a25f0a04SGreg Roach * (at your option) any later version. 9a25f0a04SGreg Roach * This program is distributed in the hope that it will be useful, 10a25f0a04SGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of 11a25f0a04SGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12a25f0a04SGreg Roach * GNU General Public License for more details. 13a25f0a04SGreg Roach * You should have received a copy of the GNU General Public License 14a25f0a04SGreg Roach * along with this program. If not, see <http://www.gnu.org/licenses/>. 15a25f0a04SGreg Roach */ 1676692c8bSGreg Roachnamespace Fisharebest\Webtrees; 17a25f0a04SGreg Roach 18a25f0a04SGreg Roach/** 1976692c8bSGreg Roach * Provide an interface to the wt_site_setting table. 20a25f0a04SGreg Roach */ 21a25f0a04SGreg Roachclass Site { 22a25f0a04SGreg Roach /** 23a25f0a04SGreg Roach * Everything from the wt_site_setting table. 24a25f0a04SGreg Roach * 25a25f0a04SGreg Roach * @var array 26a25f0a04SGreg Roach */ 2715d603e7SGreg Roach private static $preferences = []; 28a25f0a04SGreg Roach 29a25f0a04SGreg Roach /** 30a25f0a04SGreg Roach * Get the site’s configuration settings 31a25f0a04SGreg Roach * 32a25f0a04SGreg Roach * @param string $setting_name 3315d603e7SGreg Roach * @param string $default 34a25f0a04SGreg Roach * 3515d603e7SGreg Roach * @return string 36a25f0a04SGreg Roach */ 3715d603e7SGreg Roach public static function getPreference($setting_name, $default = '') { 38a25f0a04SGreg Roach // There are lots of settings, and we need to fetch lots of them on every page 39a25f0a04SGreg Roach // so it is quicker to fetch them all in one go. 4015d603e7SGreg Roach if (empty(self::$preferences)) { 4115d603e7SGreg Roach self::$preferences = Database::prepare( 42a25f0a04SGreg Roach "SELECT SQL_CACHE setting_name, setting_value FROM `##site_setting`" 43a25f0a04SGreg Roach )->fetchAssoc(); 44a25f0a04SGreg Roach } 45a25f0a04SGreg Roach 4615d603e7SGreg Roach if (!array_key_exists($setting_name, self::$preferences)) { 4715d603e7SGreg Roach self::$preferences[$setting_name] = $default; 48a25f0a04SGreg Roach } 49a25f0a04SGreg Roach 5015d603e7SGreg Roach return self::$preferences[$setting_name]; 51a25f0a04SGreg Roach } 52a25f0a04SGreg Roach 53a25f0a04SGreg Roach /** 54a25f0a04SGreg Roach * Set the site’s configuration settings. 55a25f0a04SGreg Roach * 56a25f0a04SGreg Roach * @param string $setting_name 5715d603e7SGreg Roach * @param string $setting_value 58a25f0a04SGreg Roach */ 59a25f0a04SGreg Roach public static function setPreference($setting_name, $setting_value) { 6015d603e7SGreg Roach if (self::getPreference($setting_name) !== $setting_value) { 61a25f0a04SGreg Roach Database::prepare( 62a25f0a04SGreg Roach "REPLACE INTO `##site_setting` (setting_name, setting_value)" . 63b6d24f4fSMichael Schramm " VALUES (:setting_name, LEFT(:setting_value, 2000))" 6413abd6f3SGreg Roach )->execute([ 65a25f0a04SGreg Roach 'setting_name' => $setting_name, 66a25f0a04SGreg Roach 'setting_value' => $setting_value, 6713abd6f3SGreg Roach ]); 68a25f0a04SGreg Roach 6915d603e7SGreg Roach self::$preferences[$setting_name] = $setting_value; 70a25f0a04SGreg Roach 7172292b7dSGreg Roach Log::addConfigurationLog('Site preference "' . $setting_name . '" set to "' . $setting_value . '"'); 72a25f0a04SGreg Roach } 73a25f0a04SGreg Roach } 74a25f0a04SGreg Roach} 75