View GitHub Repository backpack

Schedule Inspection
Subscribe
Passed
Push — master ( 627dee...dda2e2 )
by Michael
06:33 queued 02:34
created
Status
Category
Toggle Patches
admin/optimizer.php 1 patch
Switch Indentation   +39 added lines, -39 removed lines patch added patch discarded remove patch 
@@ -38,47 +38,47 @@
 
 block discarded – undo
38 38 
     $op = '';
39 39 
 }
40 40 
 switch ($op) {
41 
-    case 'conf_opt':
42 
-        echo _AM_PROCESS_EFFECTUE . '<br>';
43 
-        $r = $xoopsDB->queryF('SHOW TABLES');
44 
-        while (false !== ($row = $xoopsDB->fetchRow($r))) {
45 
-            $table[] = $row[0];
46 
-        }
47 
-        if (0 == count($table)) {
48 
-            $ok      = 0;
49 
-            $message = _AM_PASOK_PASTABLE;
50 
-            break;
51 
-        }
41 
+        case 'conf_opt':
42 
+            echo _AM_PROCESS_EFFECTUE . '<br>';
43 
+            $r = $xoopsDB->queryF('SHOW TABLES');
44 
+            while (false !== ($row = $xoopsDB->fetchRow($r))) {
45 
+                $table[] = $row[0];
46 
+            }
47 
+            if (0 == count($table)) {
48 
+                $ok      = 0;
49 
+                $message = _AM_PASOK_PASTABLE;
50 
+                break;
51 
+            }
52 52
53 
-        if (1 == count($table)) {
54 
-            $xoopsDB->queryF('LOCK TABLES `' . $table[0] . '` WRITE');
55 
-        } elseif (count($table) > 1) {
56 
-            $xoopsDB->queryF('LOCK TABLES `' . implode('` WRITE, `', $table) . '` WRITE');
57 
-        } else {
58 
-            $ok      = 0;
59 
-            $message = _AM_ERROR_UNKNOWN;
60 
-            break;
61 
-        }
62 
-        echo _AM_LOCK_BDD . '<br>';
63 
-        $t1 = time();
64 
-        foreach ($table as $val) {
65 
-            $b1 = time();
66 
-            if ($xoopsDB->query('OPTIMIZE TABLE `' . $val . '`')) {
67 
-                $b2         = time();
68 
-                $table_time = $b2 - $b1;
69 
-                echo _AM_OPTIMIZE . ' ' . $val . ' OK (' . _AM_TEMPS_ECOULE . ' : ' . format_time($table_time) . ')<br>';
53 
+            if (1 == count($table)) {
54 
+                $xoopsDB->queryF('LOCK TABLES `' . $table[0] . '` WRITE');
55 
+            } elseif (count($table) > 1) {
56 
+                $xoopsDB->queryF('LOCK TABLES `' . implode('` WRITE, `', $table) . '` WRITE');
57 
+            } else {
58 
+                $ok      = 0;
59 
+                $message = _AM_ERROR_UNKNOWN;
60 
+                break;
61 
+            }
62 
+            echo _AM_LOCK_BDD . '<br>';
63 
+            $t1 = time();
64 
+            foreach ($table as $val) {
65 
+                $b1 = time();
66 
+                if ($xoopsDB->query('OPTIMIZE TABLE `' . $val . '`')) {
67 
+                    $b2         = time();
68 
+                    $table_time = $b2 - $b1;
69 
+                    echo _AM_OPTIMIZE . ' ' . $val . ' OK (' . _AM_TEMPS_ECOULE . ' : ' . format_time($table_time) . ')<br>';
70 
+                }
70 71 
             }
71 
-        }
72 
-        $xoopsDB->queryF('UNLOCK TABLES');
73 
-        echo _AM_UNLOCK_BDD . '<br>';
74 
-        $t2         = time();
75 
-        $total_time = $t2 - $t1;
76 
-        echo _AM_TEMPS_TOT . ' : ' . format_time($total_time) . '<br>';
77 
-        echo '<p style="text-align: center;"><a href="index.php">' . _AM_RETURNTOSTART . '</a></p>';
78 
-        break;
79 
-    default:
80 
-        $ok = 1;
81 
-        xoops_confirm(['op' => 'conf_opt', 'ok' => 1], XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/admin/optimizer.php', _AM_OPT_WARNING . '<br>' . _AM_PRECISION . '<br>' . _AM_VERIF_SUR . '<br><a href="index.php">' . _AM_RETURNTOSTART . '</a>');
72 
+            $xoopsDB->queryF('UNLOCK TABLES');
73 
+            echo _AM_UNLOCK_BDD . '<br>';
74 
+            $t2         = time();
75 
+            $total_time = $t2 - $t1;
76 
+            echo _AM_TEMPS_TOT . ' : ' . format_time($total_time) . '<br>';
77 
+            echo '<p style="text-align: center;"><a href="index.php">' . _AM_RETURNTOSTART . '</a></p>';
78 
+            break;
79 
+        default:
80 
+            $ok = 1;
81 
+            xoops_confirm(['op' => 'conf_opt', 'ok' => 1], XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/admin/optimizer.php', _AM_OPT_WARNING . '<br>' . _AM_PRECISION . '<br>' . _AM_VERIF_SUR . '<br><a href="index.php">' . _AM_RETURNTOSTART . '</a>');
82 82 
 }
83 83 
 if (1 != $ok) {
84 84 
     echo $message;
Please login to merge, or discard this patch.