1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
<?php
/**
* webtrees: online genealogy
* Copyright (C) 2015 webtrees development team
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
namespace Fisharebest\Webtrees;
/**
* Provide an interface to the wt_site_setting table.
*/
class Site {
/**
* Everything from the wt_site_setting table.
*
* @var array
*/
private static $settings = null;
/**
* Get the site’s configuration settings
*
* @param string $setting_name
*
* @return string|null
*/
public static function getPreference($setting_name) {
// There are lots of settings, and we need to fetch lots of them on every page
// so it is quicker to fetch them all in one go.
if (self::$settings === null) {
self::$settings = Database::prepare(
"SELECT SQL_CACHE setting_name, setting_value FROM `##site_setting`"
)->fetchAssoc();
}
// A setting that hasn't yet been set?
if (!array_key_exists($setting_name, self::$settings)) {
self::$settings[$setting_name] = null;
}
return self::$settings[$setting_name];
}
/**
* Set the site’s configuration settings.
*
* @param string $setting_name
* @param string|int|bool $setting_value
*/
public static function setPreference($setting_name, $setting_value) {
// Only need to update the database if the setting has actually changed.
if (self::getPreference($setting_name) != $setting_value) {
if ($setting_value === null) {
Database::prepare(
"DELETE FROM `##site_setting` WHERE setting_name = :setting_name"
)->execute(array(
'setting_name' => $setting_name,
));
} else {
Database::prepare(
"REPLACE INTO `##site_setting` (setting_name, setting_value)" .
" VALUES (:setting_name, LEFT(:setting_value, 255))"
)->execute(array(
'setting_name' => $setting_name,
'setting_value' => $setting_value,
));
}
self::$settings[$setting_name] = $setting_value;
Log::addConfigurationLog('Site setting "' . $setting_name . '" set to "' . $setting_value . '"');
}
}
}
|
