nextcloud / serverinfo

lib/DatabaseStatistics.php

Spacing +15 added lines, -15 removed lines

@@ -73,7 +73,7 @@ 
 		$row = $result->fetch();
 		$result->closeCursor();
 		if ($row) {
-			return $this->cleanVersion($row['version']);
+			return $this->cleanVersion($row[ 'version' ]);
 		}
 		return 'N/A';
 	}
@@ -93,12 +93,12 @@ 
 		switch ($this->config->getSystemValue('dbtype')) {
 			case 'mysql':
 				$db_name = $this->config->getSystemValue('dbname');
-				$sql = 'SHOW TABLE STATUS FROM `' . $db_name . '`';
+				$sql = 'SHOW TABLE STATUS FROM `'.$db_name.'`';
 				$result = $this->connection->executeQuery($sql);
 				$database_size = 0;
 				while ($row = $result->fetch()) {
-					if ((isset($row['Type']) && $row['Type'] !== 'MRG_MyISAM') || (isset($row['Engine']) && ($row['Engine'] == 'MyISAM' || $row['Engine'] == 'InnoDB'))) {
-						$database_size += $row['Data_length'] + $row['Index_length'];
+					if ((isset($row[ 'Type' ]) && $row[ 'Type' ] !== 'MRG_MyISAM') || (isset($row[ 'Engine' ]) && ($row[ 'Engine' ] == 'MyISAM' || $row[ 'Engine' ] == 'InnoDB'))) {
+						$database_size += $row[ 'Data_length' ] + $row[ 'Index_length' ];
 					}
 				}
 				$result->closeCursor();
@@ -109,8 +109,8 @@ 
 					$database_size = filesize($this->config->getSystemValue('dbhost'));
 				} else {
 					$params = $this->connection->getParams();
-					if (file_exists($params['path'])) {
-						$database_size = filesize($params['path']);
+					if (file_exists($params[ 'path' ])) {
+						$database_size = filesize($params[ 'path' ]);
 					}
 				}
 				break;
@@ -121,11 +121,11 @@ 
 				$result = $this->connection->executeQuery($sql);
 				$row = $result->fetch();
 				$result->closeCursor();
-				if ($row['proname'] == 'pg_database_size') {
+				if ($row[ 'proname' ] == 'pg_database_size') {
 					$database = $this->config->getSystemValue('dbname');
 					if (strpos($database, '.') !== false)
 					{
-						list($database, ) = explode('.', $database);
+						list($database,) = explode('.', $database);
 					}
 					$sql = "SELECT oid
 						FROM pg_database
@@ -133,19 +133,19 @@ 
 					$result = $this->connection->executeQuery($sql);
 					$row = $result->fetch();
 					$result->closeCursor();
-					$oid = $row['oid'];
-					$sql = 'SELECT pg_database_size(' . $oid . ') as size';
+					$oid = $row[ 'oid' ];
+					$sql = 'SELECT pg_database_size('.$oid.') as size';
 					$result = $this->connection->executeQuery($sql);
 					$row = $result->fetch();
 					$result->closeCursor();
-					$database_size = $row['size'];
+					$database_size = $row[ 'size' ];
 				}
 				break;
 			case 'oci':
 				$sql = 'SELECT SUM(bytes) as dbsize
 					FROM user_segments';
 				$result = $this->connection->executeQuery($sql);
-				$database_size = ($row = $result->fetch()) ? $row['dbsize'] : false;
+				$database_size = ($row = $result->fetch()) ? $row[ 'dbsize' ] : false;
 				$result->closeCursor();
 				break;
 		}
@@ -159,10 +159,10 @@ 
 	 * @return string `5.6.27`
 	 */
 	protected function cleanVersion($version) {
-		$matches = [];
+		$matches = [ ];
 		preg_match('/^(\d+)(\.\d+)(\.\d+)/', $version, $matches);
-		if (isset($matches[0])) {
-			return $matches[0];
+		if (isset($matches[ 0 ])) {
+			return $matches[ 0 ];
 		}
 		return $version;
 	}