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
|
<?php
/**
* open_personal_file_areas.php
*
*
* @author Jan-Hendrik Willms <tleilax+studip@gmail.com>
* @license GPL2 or any later version
*/
class OpenPersonalFileAreas extends Migration
{
public function description()
{
return 'Create config entries for open personal file areas';
}
public function up()
{
$query = "INSERT IGNORE INTO `config`
(`config_id`, `field`, `value`, `is_default`, `type`, `range`, `section`,
`mkdate`, `chdate`, `description`)
VALUES (:id, :field, :value, 1, :type, 'global', 'files',
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description)";
$statement = DBManager::get()->prepare($query);
$statement->execute([
':id' => md5(uniqid('PERSONALDOCUMENT_OPEN_ACCESS')),
':field' => 'PERSONALDOCUMENT_OPEN_ACCESS',
':value' => (int) false,
':type' => 'boolean',
':description' => 'Schaltet die persönlichen Dateibereiche zur Einsicht für alle Nutzer frei',
]);
$statement->execute([
':id' => md5(uniqid('PERSONALDOCUMENT_OPEN_ACCESS_ROOT_PRIVILEDGED')),
':field' => 'PERSONALDOCUMENT_OPEN_ACCESS_ROOT_PRIVILEDGED',
':value' => (int) true,
':type' => 'boolean',
':description' => 'Erlaubt Root-Accounts das Verändern von persönlichen Dateibereiche im Namen fremder Nutzer',
]);
}
public function down()
{
DBManager::get()->query("DELETE FROM config WHERE field IN ('PERSONALDOCUMENT_OPEN_ACCESS', 'PERSONALDOCUMENT_OPEN_ACCESS_ROOT_PRIVILEDGED')");
}
}
|
