X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_register.php;h=9e69dc1d17e6f312b05338f94760a9e4c1eb6c83;hb=101e5f161c0c367c022c9288398226a57f3919d7;hp=21e4c6d53a4ed3142cbf5f359c13b3d4706f2e57;hpb=7c9cf221f2f7ef99d45fc233bf346c9f9168ef3e;p=mailer.git diff --git a/inc/modules/admin/what-config_register.php b/inc/modules/admin/what-config_register.php index 21e4c6d53a..9e69dc1d17 100644 --- a/inc/modules/admin/what-config_register.php +++ b/inc/modules/admin/what-config_register.php @@ -1,7 +1,7 @@ $value) { - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_must_register` SET field_required='%s' WHERE id=%s AND field_required != '%s' LIMIT 1", +if (isFormSent()) { + // Begin counting + $count = 0; + + // Update all entries + foreach (postRequestParameter('sel') as $id => $value) { + // Update database + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_must_register` SET `field_required`='%s' WHERE `id`=%s AND `field_required` != '%s' LIMIT 1", array($value, bigintval($id), $value),__FILE__, __LINE__); - } - LOAD_TEMPLATE("admin_settings_saved", false, REGISTER_ADMIN_CHANGES_SAVED); -} + + // Get affected rows + $count += SQL_AFFECTEDROWS(); + } // END - foreach + + // Output message for updated entries + displayMessage('{%message,ADMIN_REGISTER_CHANGES_SAVED=' . $count . '%}'); +} // END - if // List all register values -$result = SQL_QUERY("SELECT id, field_name, field_required FROM `{!_MYSQL_PREFIX!}_must_register` ORDER BY `id`", __FILE__, __LINE__); -$SW = 2; $OUT = ""; -while (list($id, $name, $required) = SQL_FETCHROW($result)) { - // Get constant value - $name = constant(strtoupper($name)); +$result = SQL_QUERY("SELECT `id`, `field_name`, `field_required` FROM `{?_MYSQL_PREFIX?}_must_register` ORDER BY `id` ASC", __FILE__, __LINE__); +$OUT = ''; +while ($content = SQL_FETCHARRAY($result)) { + // Get language string + $content['field_name'] = '{--' . strtoupper($content['field_name']) . '--}'; + + // Add more data + $content['selection'] = addSelectionBox('yn', $content['field_required'], 'sel[' . $content['id'] . ']'); - $OUT .= "