X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_register.php;h=0744101ffcd8a986c932942b5320640480875f2f;hb=1c4e78c5d68b97b82a3b930aa6db1e6df188f653;hp=f4b0a39b97d39ecb3687fabf074559101fe6190f;hpb=357b2ca133fc1f89db74097955c366cb4bee6996;p=mailer.git diff --git a/inc/modules/admin/what-config_register.php b/inc/modules/admin/what-config_register.php index f4b0a39b97..0744101ffc 100644 --- a/inc/modules/admin/what-config_register.php +++ b/inc/modules/admin/what-config_register.php @@ -1,7 +1,7 @@ $value) { - $result = 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); -} +if (isFormSent()) { + // Begin counting + $cnt = 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__); + + // Get affected rows + $cnt += SQL_AFFECTEDROWS(); + } // END - foreach + + // Output message for updated entries + loadTemplate('admin_settings_saved', false, getMaskedMessage('REGISTER_ADMIN_CHANGES_SAVED', $cnt)); +} // 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)) { - $eval = "\$name = ".strtoupper($name).";"; - eval($eval); - $OUT .= " - ".$id." -   ".$name." - - ".ADD_SELECTION("yn", $required, "sel[".$id."]")." - -\n"; +$result = SQL_QUERY("SELECT `id`, `field_name`, `field_required` FROM `{?_MYSQL_PREFIX?}_must_register` ORDER BY `id` ASC", __FILE__, __LINE__); +$OUT = ''; $SW = 2; +while ($content = SQL_FETCHARRAY($result)) { + // Get language string + $content['field_name'] = getMessage(strtoupper($content['field_name'])); + + // Add more data + $content['sw'] = $SW; + $content['selection'] = addSelectionBox('yn', $content['field_required'], 'sel[' . $content['id'] . ']'); + + // @TODO Move this HTML code into a template + $OUT .= loadTemplate('admin_config_register_row', true, $content); + + // Switch color $SW = 3 - $SW; -} +} // END - while // Free memory SQL_FREERESULT($result); -// Remember rows in constant -define('__REGISTER_ROWS', $OUT); - // Load template -LOAD_TEMPLATE("admin_config_register"); +loadTemplate('admin_config_register', false, $OUT); -// +// [EOF] ?>