From 4328a215de9cdf89587a9399ce1e87878702c7a0 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Sat, 10 Jul 2010 09:44:11 +0000
Subject: [PATCH] Table types InnoDB/MEMORY added

---
 inc/language/optimize_de.php               |  2 ++
 inc/modules/admin/what-optimize.php        |  2 +-
 templates/de/html/admin/admin_optimize.tpl | 12 ++++++++++++
 3 files changed, 15 insertions(+), 1 deletion(-)

diff --git a/inc/language/optimize_de.php b/inc/language/optimize_de.php
index e3ef284a34..441b99dcf7 100644
--- a/inc/language/optimize_de.php
+++ b/inc/language/optimize_de.php
@@ -50,6 +50,8 @@ addMessages(array(
 	'OPTIMIZE_TOTAL_SIZE' => "Gesamtgr&ouml;sse",
 	'OPTIMIZE_GAIN_SIZE' => "Eingespart",
 	'OPTIMIZE_STATUS_OK' => "Nein",
+	'OPTIMIZE_STATUS_TABLE_DOES_NOT_SUPPORT_OPTIMIZE_DOING_RECREATE_ANALYZE_INSTEAD' => "Keine Unterst&uuml;tzung (1)",
+	'OPTIMIZE_STATUS_THE_STORAGE_ENGINE_FOR_THE_TABLE_DOESNT_SUPPORT_OPTIMIZE' => "Keine Unterst&uuml;tzung (2)",
 	'OPTIMIZE_STATUS_UNSUPPORTED' => "Nicht m&ouml;glich",
 	'OPTIMIZE_STATUS_OPTIMIZED' => "Optimiert.",
 	'OPTIMIZE_DB_TOTAL_TABLES' => "Gesamtzahl angelegter Tabellen",
diff --git a/inc/modules/admin/what-optimize.php b/inc/modules/admin/what-optimize.php
index 2f73c933e6..68724755f3 100644
--- a/inc/modules/admin/what-optimize.php
+++ b/inc/modules/admin/what-optimize.php
@@ -58,7 +58,7 @@ foreach ($DATA['tables'] as $row_array) {
 	if (empty($row_array[1])) $row_array[1] = 'NONE';
 
 	// Get optimization status
-	$REP = '{--OPTIMIZE_STATUS_' . strtoupper($row_array[1]) . '--}';
+	$REP = '{--OPTIMIZE_STATUS_' . str_replace('__', '_', str_replace(',', '', str_replace('+', '', str_replace("'", '', str_replace(' ', '_', strtoupper($row_array[1])))))) . '--}';
 
 	$OPT = '{--OPTIMIZE_STATUS_UNSUPPORTED--}';
 
diff --git a/templates/de/html/admin/admin_optimize.tpl b/templates/de/html/admin/admin_optimize.tpl
index f67c421e93..10c56e8172 100644
--- a/templates/de/html/admin/admin_optimize.tpl
+++ b/templates/de/html/admin/admin_optimize.tpl
@@ -21,3 +21,15 @@
 	</tr>
 </table>
 </div>
+
+<div class="admin_note" align="left">
+	<strong>Aufl&ouml;sung der Zahlen in Klammern:</strong>
+	<ol>
+		<li>Tabellen mit dem Typ &quot;InnoDB&quot; brauchen nicht optimiert
+		werden und sollten eher neu erstellt (nicht l&ouml;schen und neu
+		anlegen!) und dann analysiert werden. Dies unterst&uuml;tzt {?TITLE?}
+		noch nicht.</li>
+		<li>Tabellen mit dem Typ &quot;Speicher/Heap&quot; k&ouml;nnen nicht
+		optimiert werden.</li>
+	</ol>
+</div>
-- 
2.39.5