Removed deprecated 'hidden' column from mod_reg table.

[mailer.git] / inc / modules / admin / what-list_mods.php

diff --git a/inc/modules/admin/what-list_mods.php b/inc/modules/admin/what-list_mods.php
index e6fd6943e1be9302dadab0a0f38c8268360681d1..38ee36972a77d0e6f6dec0f064aea8899f55a086 100644 (file)
--- a/inc/modules/admin/what-list_mods.php
+++ b/inc/modules/admin/what-list_mods.php
@@ -53,7 +53,18 @@ if (isFormSent('edit')) {
                foreach (postRequestElement('sel') as $id => $sel) {
                        // Load module data
                        // @TODO This can be moved into mysql-function.php, see checkModulePermissions() function
-                       $result = sqlQueryEscaped("SELECT `id`, `module`, `title`, `locked`, `hidden`, `admin_only`, `mem_only` FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `id`=%s LIMIT 1",
+                       $result = sqlQueryEscaped('SELECT
+       `id`,
+       `module`,
+       `title`,
+       `locked`,
+       `admin_only`,
+       `mem_only`
+FROM
+       `{?_MYSQL_PREFIX?}_mod_reg`
+WHERE
+       `id`=%s
+LIMIT 1',
                                array(bigintval($id)), __FILE__, __LINE__);
 
                        // Load data
@@ -64,7 +75,6 @@ if (isFormSent('edit')) {
 
                        // Prepare array for the template
                        $content['locked']     = addSelectionBox('yn', $content['locked']    , 'locked', $id);
-                       $content['hidden']     = addSelectionBox('yn', $content['hidden']    , 'hidden', $id);
                        $content['admin_only'] = addSelectionBox('yn', $content['admin_only'], 'admin' , $id);
                        $content['mem_only']   = addSelectionBox('yn', $content['mem_only']  , 'member', $id);
 
@@ -97,7 +107,6 @@ if (isFormSent('edit')) {
 SET
        `title`='%s',
        `locked`='%s',
-       `hidden`='%s',
        `admin_only`='%s',
        `mem_only`='%s'
 WHERE
@@ -106,7 +115,6 @@ LIMIT 1",
                        array(
                                postRequestElement('title', $id),
                                postRequestElement('locked', $id),
-                               postRequestElement('hidden', $id),
                                postRequestElement('admin', $id),
                                postRequestElement('member', $id),
                                $id
@@ -126,7 +134,12 @@ LIMIT 1",
 if (!ifPostContainsSelections()) {
        // Load module data (We do not need to check if there's at least one...)
        $result = sqlQuery('SELECT
-       `id`, `module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`
+       `id`,
+       `module`,
+       `locked`,
+       `admin_only`,
+       `title`,
+       `mem_only`
 FROM
        `{?_MYSQL_PREFIX?}_mod_reg`
 ORDER BY