X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_email.php;h=754f36912f8fb3a297293f1ae253cd83d0eea341;hb=ab92fb7241d00636b0eb940f147449758820cba1;hp=674a428890253aa70188ddf54106e1c5e8872e0f;hpb=3594ba2ef6d12870b9e9a9c7fff63a8c0e587ca0;p=mailer.git
diff --git a/inc/modules/admin/what-config_email.php b/inc/modules/admin/what-config_email.php
index 674a428890..754f36912f 100644
--- a/inc/modules/admin/what-config_email.php
+++ b/inc/modules/admin/what-config_email.php
@@ -45,16 +45,16 @@ if (empty($_POST['max'])) unset($_POST['add_max']);
if (isset($_POST['add_max'])) {
// Save all settings
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_max_receive WHERE value='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_max_receive` WHERE value='%s' LIMIT 1",
array(bigintval($_POST['max'])), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 0) {
// Add this value (including comment)
- SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_max_receive (value, comment) VALUES ('%s','%s')",
+ SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_max_receive` (value, comment) VALUES ('%s','%s')",
array(bigintval($_POST['max']), $_POST['comment']),__FILE__, __LINE__);
$content = MAX_VALUE_SAVED;
} else {
// Value does alread exists!
- $content = "".MAX_VALUE_ALREADY."";
+ $content = "".MAX_VALUE_ALREADY."";
}
// Free memory
@@ -72,13 +72,13 @@ if (isset($_POST['add_max'])) {
switch ($_GET['do'])
{
case "edit": // Change entries
- SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_max_receive SET value='%s', comment='%s' WHERE id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_max_receive` SET value='%s', comment='%s' WHERE id=%s LIMIT 1",
array(bigintval($_POST['val'][$id]), $_POST['comm'][$id], $id),__FILE__, __LINE__);
$TEXT = MRECEIVE_SAVED;
break;
case "del":
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_max_receive WHERE id=%s LIMIT 1",
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_max_receive` WHERE id=%s LIMIT 1",
array($id), __FILE__, __LINE__);
$TEXT = MRECEIVE_DELETED;
break;
@@ -95,7 +95,7 @@ if (isset($_POST['add_max'])) {
foreach ($_POST['sel'] as $id => $value)
{
// Load data
- $result = SQL_QUERY_ESC("SELECT value, comment FROM "._MYSQL_PREFIX."_max_receive WHERE id=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT value, comment FROM `{!_MYSQL_PREFIX!}_max_receive` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
list($value, $comment) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
@@ -121,7 +121,7 @@ if (isset($_POST['add_max'])) {
$SW = 2; $OUT = "";
foreach ($_POST['sel'] as $id => $value) {
// Load data
- $result = SQL_QUERY_ESC("SELECT value, comment FROM "._MYSQL_PREFIX."_max_receive WHERE id=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT value, comment FROM `{!_MYSQL_PREFIX!}_max_receive` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
list($value, $comment) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
@@ -143,7 +143,7 @@ if (isset($_POST['add_max'])) {
// Load main template
LOAD_TEMPLATE("admin_config_email_edit");
} else {
- $result = SQL_QUERY("SELECT id, value, comment FROM "._MYSQL_PREFIX."_max_receive ORDER BY value", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT id, value, comment FROM `{!_MYSQL_PREFIX!}_max_receive` ORDER BY value", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// List already existing entries for editing
$SW = 2; $OUT = "";