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
|
<?php
class Visibilityapi extends Migration {
function description() {
return 'Copy visibilitydata from old json compress';
}
function up() {
$sql = "CREATE TABLE IF NOT EXISTS `user_visibility_settings` (
`user_id` varchar(32) NOT NULL DEFAULT '',
`visibilityid` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL,
`category` int(2) NOT NULL,
`name` varchar(128) NOT NULL,
`state` int(2) NULL,
`plugin` int(11),
`identifier` varchar(64) NOT NULL,
PRIMARY KEY (`visibilityid`),
KEY `parent_id` (`parent_id`),
KEY `identifier` (`identifier`),
KEY `userid` (`user_id`)
) ENGINE=MyISAM";
$db = DBManager::get();
$stmt = $db->prepare($sql);
$stmt->execute();
$result = $db->query("SELECT value FROM config WHERE field = 'HOMEPAGE_VISIBILITY_DEFAULT' ORDER BY is_default LIMIT 1");
$default_visibility = constant($result->fetchColumn());
$sql = "SELECT `user_id` FROM `auth_user_md5`";
$stmt = $db->prepare($sql);
$stmt->execute();
while ($result = $stmt->fetch(PDO::FETCH_ASSOC)) {
$user = User::find($result['user_id']);
Visibility::createDefaultCategories($user->user_id);
//copy all homepage visibility
$elements = $user->getHomepageElements();
if (is_array($elements)) {
foreach ($elements as $key => $state) {
if ($state['visibility'] != $default_visibility) {
Visibility::addPrivacySetting($state['name'], $key, $state['identifier'], 1, $about->auth_user['user_id'], $state['visibility']);
}
}
}
}
}
function down() {
}
}
?>
|
