|  | @@ 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'); |