Updated the media type of some font types

TTF and TTF have now the same media type
Official since 2013 and supported by Firefox and Chrome
https://www.iana.org/assignments/media-types/application/font-sfnt

Introducing support for Type1 fonts

1 files changed, 108 insertions, 81 deletions

diff --git a/lib/repair/repairmimetypes.php b/lib/repair/repairmimetypes.php
index e3f4402cfd5..06cd144bff4 100644
--- a/lib/repair/repairmimetypes.php
+++ b/lib/repair/repairmimetypes.php
@@ -2,6 +2,7 @@
 /**
  * Copyright (c) 2014 Vincent Petry <pvince81@owncloud.com>
  * Copyright (c) 2014 Jörn Dreyer jfd@owncloud.com
+ * Copyright (c) 2014 Olivier Paroz owncloud@oparoz.com
  * This file is licensed under the Affero General Public License version 3 or
  * later.
  * See the COPYING-README file.
@@ -16,32 +17,32 @@ class RepairMimeTypes extends BasicEmitter implements \OC\RepairStep {
 	public function getName() {
 		return 'Repair mime types';
 	}
-
-	private function fixOfficeMimeTypes() {
-		// update wrong mimetypes
-		$wrongMimetypes = array(
-			'application/mspowerpoint' => 'application/vnd.ms-powerpoint',
-			'application/msexcel' => 'application/vnd.ms-excel',
-		);
-
-		$existsStmt = \OC_DB::prepare('
+	
+	private static function existsStmt() {
+		return \OC_DB::prepare('
 			SELECT count(`mimetype`)
 			FROM   `*PREFIX*mimetypes`
 			WHERE  `mimetype` = ?
 		');
+	}
 
-		$getIdStmt = \OC_DB::prepare('
+	private static function getIdStmt() {
+		return \OC_DB::prepare('
 			SELECT `id`
 			FROM   `*PREFIX*mimetypes`
 			WHERE  `mimetype` = ?
 		');
+	}
 
-		$insertStmt = \OC_DB::prepare('
+	private static function insertStmt() {
+		return \OC_DB::prepare('
 			INSERT INTO `*PREFIX*mimetypes` ( `mimetype` )
 			VALUES ( ? )
 		');
+	}
 
-		$updateWrongStmt = \OC_DB::prepare('
+	private static function updateWrongStmt() {
+		return \OC_DB::prepare('
 			UPDATE `*PREFIX*filecache`
 			SET `mimetype` = (
 				SELECT `id`
@@ -49,106 +50,125 @@ class RepairMimeTypes extends BasicEmitter implements \OC\RepairStep {
 				WHERE `mimetype` = ?
 			) WHERE `mimetype` = ?
 		');
-
-		$deleteStmt = \OC_DB::prepare('
+	}
+	
+	private static function deleteStmt() {
+		return \OC_DB::prepare('
 			DELETE FROM `*PREFIX*mimetypes`
 			WHERE `id` = ?
 		');
-
+	}	
+		
+	private static function updateByNameStmt() {
+		return \OC_DB::prepare('
+			UPDATE `*PREFIX*filecache`
+			SET `mimetype` = (
+				SELECT `id`
+				FROM `*PREFIX*mimetypes`
+				WHERE `mimetype` = ?
+			) WHERE `name` LIKE ?
+		');
+	}
+	
+	private function repairMimetypes($wrongMimetypes) {
 		foreach ($wrongMimetypes as $wrong => $correct) {
-
-
 			// do we need to remove a wrong mimetype?
-			$result = \OC_DB::executeAudited($getIdStmt, array($wrong));
+			$result = \OC_DB::executeAudited(self::getIdStmt(), array($wrong));
 			$wrongId = $result->fetchOne();
 
 			if ($wrongId !== false) {
-
 				// do we need to insert the correct mimetype?
-				$result = \OC_DB::executeAudited($existsStmt, array($correct));
+				$result = \OC_DB::executeAudited(self::existsStmt(), array($correct));
 				$exists = $result->fetchOne();
 
-				if ( ! $exists ) {
-					// insert mimetype
-					\OC_DB::executeAudited($insertStmt, array($correct));
-				}
-
-				// change wrong mimetype to correct mimetype in filecache
-				\OC_DB::executeAudited($updateWrongStmt, array($correct, $wrongId));
+				if ( ! is_null($correct) ) {
+					if ( ! $exists ) {
+						// insert mimetype
+						\OC_DB::executeAudited(self::insertStmt(), array($correct));
+					}
 
+					// change wrong mimetype to correct mimetype in filecache
+					\OC_DB::executeAudited(self::updateWrongStmt(), array($correct, $wrongId));
+				}
+				
 				// delete wrong mimetype
-				\OC_DB::executeAudited($deleteStmt, array($wrongId));
+				\OC_DB::executeAudited(self::deleteStmt(), array($wrongId));
 
 			}
-
 		}
-
-		$updatedMimetypes = array(
-			'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
-			'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
-			'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
-		);
-
-		$updateByNameStmt = \OC_DB::prepare('
-			UPDATE `*PREFIX*filecache`
-			SET `mimetype` = (
-				SELECT `id`
-				FROM `*PREFIX*mimetypes`
-				WHERE `mimetype` = ?
-			) WHERE `name` LIKE ?
-		');
-
-		// separate doc from docx etc
+	}
+	
+	private function updateMimetypes($updatedMimetypes) {
+	
 		foreach ($updatedMimetypes as $extension => $mimetype ) {
-			$result = \OC_DB::executeAudited($existsStmt, array($mimetype));
+			$result = \OC_DB::executeAudited(self::existsStmt(), array($mimetype));
 			$exists = $result->fetchOne();
 
 			if ( ! $exists ) {
 				// insert mimetype
-				\OC_DB::executeAudited($insertStmt, array($mimetype));
+				\OC_DB::executeAudited(self::insertStmt(), array($mimetype));
 			}
 
 			// change mimetype for files with x extension
-			\OC_DB::executeAudited($updateByNameStmt, array($mimetype, '%.'.$extension));
+			\OC_DB::executeAudited(self::updateByNameStmt(), array($mimetype, '%.'.$extension));
 		}
 	}
 
-	private function fixAPKMimeType() {
-		$existsStmt = \OC_DB::prepare('
-			SELECT count(`mimetype`)
-			FROM   `*PREFIX*mimetypes`
-			WHERE  `mimetype` = ?
-		');
+	private function fixOfficeMimeTypes() {
+		// update wrong mimetypes
+		$wrongMimetypes = array(
+			'application/mspowerpoint' => 'application/vnd.ms-powerpoint',
+			'application/msexcel' => 'application/vnd.ms-excel',
+		);
 
-		$insertStmt = \OC_DB::prepare('
-			INSERT INTO `*PREFIX*mimetypes` ( `mimetype` )
-			VALUES ( ? )
-		');
+		self::repairMimetypes($wrongMimetypes);
 
+		$updatedMimetypes = array(
+			'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
+			'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+			'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
+		);
 
-		$updateByNameStmt = \OC_DB::prepare('
-			UPDATE `*PREFIX*filecache`
-			SET `mimetype` = (
-				SELECT `id`
-				FROM `*PREFIX*mimetypes`
-				WHERE `mimetype` = ?
-			) WHERE `name` LIKE ?
-		');
 
+		// separate doc from docx etc
+		self::updateMimetypes($updatedMimetypes);
+		
+	}
+	
+	private function fixApkMimeType() {
+		$updatedMimetypes = array(
+			'apk' => 'application/vnd.android.package-archive',
+		);
 
-		$mimeTypeExtension = 'apk';
-		$mimeTypeName = 'application/vnd.android.package-archive';
+		self::updateMimetypes($updatedMimetypes);
+	}
+	
+	private function fixFontsMimeTypes() {
+		// update wrong mimetypes
+		$wrongMimetypes = array(
+			'font' => null,
+			'font/opentype' => 'application/font-sfnt',
+			'application/x-font-ttf' => 'application/font-sfnt',
+		);
 
-		$result = \OC_DB::executeAudited($existsStmt, array($mimeTypeName));
-		$exists = $result->fetchOne();
+		self::repairMimetypes($wrongMimetypes);
+	
+		$updatedMimetypes = array(
+			'ttf' => 'application/font-sfnt',
+			'otf' => 'application/font-sfnt',
+			'pfb' => 'application/x-font',
+		);
 
-		if ( ! $exists ) {
-			// insert mimetype
-			\OC_DB::executeAudited($insertStmt, array($mimeTypeName));
-		}
+		self::updateMimetypes($updatedMimetypes);
+	}
+	
+	private function fixPostscriptMimeType() {
+		$updatedMimetypes = array(
+			'eps' => 'application/postscript',
+			'ps' => 'application/postscript',
+		);
 
-		// change mimetype for files with x extension
-		\OC_DB::executeAudited($updateByNameStmt, array($mimeTypeName, '%.'.$mimeTypeExtension));
+		self::updateMimetypes($updatedMimetypes);
 	}
 
 	/**
@@ -158,10 +178,17 @@ class RepairMimeTypes extends BasicEmitter implements \OC\RepairStep {
 		if ($this->fixOfficeMimeTypes()) {
 			$this->emit('\OC\Repair', 'info', array('Fixed office mime types'));
 		}
-
-		if ($this->fixAPKMimeType()) {
+		
+		if ($this->fixApkMimeType()) {
 			$this->emit('\OC\Repair', 'info', array('Fixed APK mime type'));
 		}
+		
+		if ($this->fixFontsMimeTypes()) {
+			$this->emit('\OC\Repair', 'info', array('Fixed fonts mime types'));
+		}
+		
+		if ($this->fixPostscriptMimeType()) {
+			$this->emit('\OC\Repair', 'info', array('Fixed Postscript mime types'));
+		}
 	}
-}
-
+}
\ No newline at end of file