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
|
<?php
class Termsconfig extends Migration
{
public function description()
{
return 'Add global config entry for "TERMS_CONFIG"';
}
public function up()
{
$query = "INSERT INTO `config` (
`field`, `value`, `type`,
`range`, `section`, `mkdate`, `chdate`,
`description`
) VALUES (
:field, :value, 'array', 'global', 'global',
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description
)";
$statement = DBManager::get()->prepare($query);
$statement->bindValue(':field', 'TERMS_CONFIG');
$statement->bindValue(':value', json_encode(['compulsory' => false, 'denial_message' => '']));
$statement->bindValue(':description', 'In case the terms are not compulsory, user can deny them.' .
'if denial_message is not set, a default text is displayed.');
$statement->execute();
}
public function down()
{
$query = "DELETE FROM `config` WHERE `field` = :field";
$statement = DBManager::get()->prepare($query);
$statement->bindValue(':field', 'TERMS_CONFIG');
$statement->execute();
}
}
|
