X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_register.php;h=4cba9e31e0f586254a849fad3a5f506c91b5a801;hb=995488beda665a1fc3de65df95f2d1ae236d1245;hp=c4bf6bc8379ae5d6bcb1a137fe4dcfa06242b2a8;hpb=76b1b077bda73310c536f658d3a9bb5e12232f39;p=mailer.git diff --git a/inc/modules/admin/what-config_register.php b/inc/modules/admin/what-config_register.php index c4bf6bc837..4cba9e31e0 100644 --- a/inc/modules/admin/what-config_register.php +++ b/inc/modules/admin/what-config_register.php @@ -18,6 +18,7 @@ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * + * Copyright (c) 2009, 2010 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -39,22 +40,32 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // END - if // Add description as navigation point addMenuDescription('admin', __FILE__); // Do we want to save changes? if (isFormSent()) { - foreach (postRequestElement('sel') as $id => $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')); -} + // 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__); +$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 @@ -66,16 +77,16 @@ while ($content = SQL_FETCHARRAY($result)) { // @TODO Move this HTML code into a template $OUT .= " - ".$content['id']." -   ".$content['field_name']." - - ".$content['selection']." - + ".$content['id']." + ".$content['field_name']." + + ".$content['selection']." + \n"; // Switch color $SW = 3 - $SW; -} +} // END - while // Free memory SQL_FREERESULT($result);