$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 $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` 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'] . ']'); // @TODO Move this HTML code into a template $OUT .= loadTemplate('admin_config_register_row', true, $content); } // END - while // Free memory SQL_FREERESULT($result); // Load template loadTemplate('admin_config_register', false, $OUT); // [EOF] ?>