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
|
<?php
/**
* @author Jan-Hendrik Willms <tleilax+studip@gmail.com>
* @license GPL2 or any later version
*/
class AddUserConfigForAdminDisplaySettings extends Migration
{
public function description()
{
return 'Adds user config entry for "PLUGINADMIN_DISPLAY_SETTINGS"';
}
public function up()
{
$query = "INSERT INTO `config` (
`config_id`, `parent_id`, `field`, `value`, `is_default`,
`type`, `range`, `section`, `mkdate`, `chdate`, `description`
) VALUES (
MD5(:field), '', :field, :value, 1, 'array', 'user', '',
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description
)";
$statement = DBManager::get()->prepare($query);
$statement->bindValue(':field', 'PLUGINADMIN_DISPLAY_SETTINGS');
$statement->bindValue(':value', json_encode(['plugin_filter' => null, 'core_filter' => 'yes']));
$statement->bindValue(':description', 'Speichert die Darstellungseinstellungen der Pluginadministration');
$statement->execute();
}
public function down()
{
$query = "DELETE FROM `config` WHERE `field` = 'PLUGINADMIN_DISPLAY_SETTINGS'";
DBManager::get()->exec($query);
$query = "DELETE FROM `user_config` WHERE `field` = 'PLUGINADMIN_DISPLAY_SETTINGS'";
DBManager::get()->exec($query);
}
}
|
