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
|
<?php
// Location handling: figure out location
$locationId = false;
if (Request::any('force', 0, 'int') === 1 && Request::any('module', false, 'string') === 'locations') {
// Force location for testing, but require logged in admin
if (User::load()) {
$locationId = Request::any('value', 0, 'int');
}
}
if ($locationId === false) {
$locationId = Location::getFromIpAndUuid($ip, $uuid);
}
$matchingLocations = array();
if ($locationId !== false) {
// Get all parents
$matchingLocations = Location::getLocationRootChain($locationId);
$configVars["SLX_LOCATIONS"] = implode(' ', $matchingLocations);
}
// Query location specific settings (from bottom to top)
if (!empty($matchingLocations)) {
// First get all settings for all locations we're in
$list = implode(',', $matchingLocations);
$res = Database::simpleQuery("SELECT locationid, setting, value FROM setting_location WHERE locationid IN ($list)");
$tmp = array();
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
$tmp[(int)$row['locationid']][$row['setting']] = $row['value'];
}
// $matchingLocations contains the location ids sorted from closest to furthest, so we use it to make sure the order
// in which they override is correct (closest setting wins, e.g. room setting beats department setting)
foreach ($matchingLocations as $lid) {
if (!isset($tmp[$lid]))
continue;
foreach ($tmp[$lid] as $setting => $value) {
if (!isset($configVars[$setting])) {
$configVars[$setting] = $value;
}
}
}
unset($tmp);
}
|