ADD_DESCR("admin", __FILE__);
// Do we want to save changes?
-if (isset($_POST['ok'])) {
- foreach ($_POST['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",
+if (IS_FORM_SENT()) {
+ foreach (REQUEST_POST('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__);
}
LOAD_TEMPLATE("admin_settings_saved", false, 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__);
+$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)) {
// Get constant value