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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
<?php
/*
* SCROTT IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
* MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
* IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
* OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
* ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
* OTHER DEALINGS IN THE SOFTWARE.
*
* For more information, please refer to UNLICENSE
*/
require_once "class/database.class.php";
/*
* Interface for accessing and updating Scrott administrative settings
*/
abstract class settings
{
/*
* Get the value stored for the given key, or NULL if key is not
* set.
*/
private static function getValue(string $key) : ?string
{
$key = database::esc($key);
$query = "SELECT value FROM settings WHERE name = '" . $key . "'";
$res = database::query($query);
if (count($res) == 0)
return NULL;
return $res[0]['value'];
}
/*
* Store the given (key, value) pair, overwriting key in the
* database if already present.
*/
private static function setValue(string $key, string $value) : void
{
$key = database::esc($key);
$value = database::esc($value);
if (self::getValue($key) === NULL)
$query = "INSERT INTO settings (name, value) VALUES ('" . $key . "', '" . $value . "')";
else
$query = "UPDATE settings SET value = '" . $value . "' WHERE name = '" . $key . "'";
database::query($query);
}
/*
* Get the value for an option and optionally update it. Returns
* the stored value for this option, or the given default value
* if not found. If a value update takes place, the new value
* is returned.
*/
private static function option(string $key, string $deflt, ?string $value) : string
{
if ($value !== NULL)
self::setValue($key, $value);
if (($res = self::getValue($key)) !== NULL)
return $res;
return $deflt;
}
/*
* GETTERS AND SETTERS FOR GLOBAL OPTIONS ...
*/
/*
* Do we force connections to use HTTPS?
*/
public static function sslOnly(?bool $value = NULL) : bool
{
return self::option("sslOnly", false, $value);
}
/*
* Do we allow anybody to signup their own account?
*/
public static function allowPublicSignup(?bool $value = NULL) : bool
{
return self::option("allowPublicSignup", false, $value);
}
/*
* SMTP email address
*/
public static function smtpEmailAddress(?string $value = NULL) : string
{
return self::option("smtpEmailAddress", "", $value);
}
/*
* SMTP FROM name
*/
public static function smtpFrom(?string $value = NULL) : string
{
return self::option("smtpFrom", "", $value);
}
/*
* SMTP server address
*/
public static function smtpServer(?string $value = NULL) : string
{
return self::option("smtpServer", "", $value);
}
/*
* SMTP port number
*/
public static function smtpPort(?int $value = NULL) : int
{
return self::option("smtpPort", 25, $value);
}
/*
* SMTP security
* Should be '', 'ssl', or 'tls'. See the 'SMTPSecure' property
* from PHP Mailer module.
*/
public static function smtpSecurity(?string $value = NULL) : string
{
return self::option("smtpSecurity", "", $value);
}
/*
* SMTP username
*/
public static function smtpUname(?string $value = NULL) : string
{
return self::option("smtpUname", "", $value);
}
/*
* SMTP password
*/
public static function smtpPasswd(?string $value = NULL) : string
{
return self::option("smtpPasswd", "", $value);
}
}
?>
|
