@@ 38-49 (lines=12) @@ | ||
35 | $connection = \OC_DB::getConnection(); |
|
36 | $chunkedPermissionList = array_chunk($updatedRows, $chunkSize, true); |
|
37 | ||
38 | foreach ($chunkedPermissionList as $subList) { |
|
39 | $statement = "UPDATE `*PREFIX*share` SET `permissions` = CASE `id` "; |
|
40 | //update share table |
|
41 | $ids = implode(',', array_keys($subList)); |
|
42 | foreach ($subList as $id => $permission) { |
|
43 | $statement .= "WHEN " . $connection->quote($id, \PDO::PARAM_INT) . " THEN " . $permission . " "; |
|
44 | } |
|
45 | $statement .= ' END WHERE `id` IN (' . $ids . ')'; |
|
46 | ||
47 | $query = OCP\DB::prepare($statement); |
|
48 | $query->execute(); |
|
49 | } |
|
50 | ||
51 | } |
|
52 | ||
@@ 107-120 (lines=14) @@ | ||
104 | $chunkedShareList = array_chunk($shares, $chunkSize, true); |
|
105 | $connection = \OC_DB::getConnection(); |
|
106 | ||
107 | foreach ($chunkedShareList as $subList) { |
|
108 | ||
109 | $statement = "UPDATE `*PREFIX*share` SET `file_target` = CASE `id` "; |
|
110 | //update share table |
|
111 | $ids = implode(',', array_keys($subList)); |
|
112 | foreach ($subList as $id => $target) { |
|
113 | $statement .= "WHEN " . $connection->quote($id, \PDO::PARAM_INT) . " THEN " . $connection->quote('/Shared' . $target, \PDO::PARAM_STR); |
|
114 | } |
|
115 | $statement .= ' END WHERE `id` IN (' . $ids . ')'; |
|
116 | ||
117 | $query = OCP\DB::prepare($statement); |
|
118 | ||
119 | $query->execute(array()); |
|
120 | } |
|
121 | ||
122 | // set config to keep the Shared folder as the default location for new shares |
|
123 | \OCA\Files_Sharing\Helper::setShareFolder('/Shared'); |