$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__); } LOAD_TEMPLATE('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['seleciton'] = ADD_SELECTION('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); // Remember rows in constant // @TODO Rewrite this constant define('__REGISTER_ROWS', $OUT); // Load template LOAD_TEMPLATE("admin_config_register"); // ?>