X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_register.php;h=12d75fc4c9b9e7a0cb917693339a0596c069d40d;hb=a16ae225264a183dc4adf24c2d931df231d2ffc7;hp=401ea9c85cf1ea83f96abe2ed82c3ef8745b9578;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git diff --git a/inc/modules/admin/what-config_register.php b/inc/modules/admin/what-config_register.php index 401ea9c85c..12d75fc4c9 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", - array($value, bigintval($id), $value),__FILE__, __LINE__); - } - loadTemplate('admin_settings_saved', false, getMessage('REGISTER_ADMIN_CHANGES_SAVED')); -} + // 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__); + + // 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__); -$OUT = ''; $SW = 2; +$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'] = getMessage(strtoupper($content['field_name'])); + $content['field_name'] = '{--' . strtoupper($content['field_name']) . '--}'; // Add more data - $content['sw'] = $SW; - $content['selection'] = addSelectionBox('yn', $content['field_required'], "sel[".$content['id']."]"); + $content['selection'] = addSelectionBox('yn', $content['field_required'], 'sel[' . $content['id'] . ']'); // @TODO Move this HTML code into a template - $OUT .= " - ".$content['id']." -   ".$content['field_name']." - - ".$content['selection']." - -\n"; - - // Switch color - $SW = 3 - $SW; -} + $OUT .= loadTemplate('admin_config_register_row', true, $content); +} // END - while // Free memory SQL_FREERESULT($result);