$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')); } // 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; 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 .= " ".$content['id']."   ".$content['field_name']." ".$content['selection']." \n"; // Switch color $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); // Load template loadTemplate('admin_config_register', false, $OUT); // [EOF] ?>