Previous fix fixed, a lot constants rewritten (unfinished)

[mailer.git] / inc / modules / admin / what-config_register.php

diff --git a/inc/modules/admin/what-config_register.php b/inc/modules/admin/what-config_register.php
index 2a31fd6155cfd456ee7d108d883e0c2a951a5f47..21e4c6d53a4ed3142cbf5f359c13b3d4706f2e57 100644 (file)
--- a/inc/modules/admin/what-config_register.php
+++ b/inc/modules/admin/what-config_register.php
@@ -43,26 +43,26 @@ 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",
+               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
        $name =  constant(strtoupper($name));
 
-       $OUT .= "<TR>
-  <TD align=\"center\" class=\"switch_sw".$SW." bottom2 right2\">".$id."</TD>
-  <TD class=\"switch_sw".$SW." bottom2 right2\">&nbsp;&nbsp;".$name."</TD>
-  <TD align=\"center\" class=\"switch_sw".$SW." bottom2 right2\">
+       $OUT .= "<tr>
+  <td align=\"center\" class=\"switch_sw".$SW." bottom2 right2\">".$id."</td>
+  <td class=\"switch_sw".$SW." bottom2 right2\">&nbsp;&nbsp;".$name."</td>
+  <td align=\"center\" class=\"switch_sw".$SW." bottom2 right2\">
     ".ADD_SELECTION("yn", $required, "sel[".$id."]")."
-  </TD>
-</TR>\n";
+  </td>
+</tr>\n";
        $SW = 3 - $SW;
 }