X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-adminedit.php;h=de04b2d671ef3fb6ff4d376f34f6df33afff93cd;hb=96dfdd6b8e6a56d6594c3525e5fd2a066697a6de;hp=ff42b89782d79cc27e01897d93bf36005557e859;hpb=74ebef603ce49e3e311a29527572a24670131889;p=mailer.git
diff --git a/inc/modules/admin/what-adminedit.php b/inc/modules/admin/what-adminedit.php
index ff42b89782..de04b2d671 100644
--- a/inc/modules/admin/what-adminedit.php
+++ b/inc/modules/admin/what-adminedit.php
@@ -1,7 +1,7 @@
0) && (!isDemoM
`action`='%s',
`what`='%s',
`descr`='%s'
-WHERE ".$AND." AND id=%s LIMIT 1",
+WHERE ".$AND." AND `id`=%s LIMIT 1",
array(
$menu,
postRequestElement('sel_action', $sel),
@@ -213,9 +213,9 @@ WHERE ".$AND." AND id=%s LIMIT 1",
if ((!empty($tid)) && (!empty($fid))) {
// Sort menu
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
array(bigintval(getRequestElement('tid')), bigintval($fid)), __FILE__, __LINE__);
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
array(bigintval(getRequestElement('fid')), bigintval($tid)), __FILE__, __LINE__);
}
}
@@ -247,13 +247,13 @@ WHERE ".$AND." AND id=%s LIMIT 1",
$data['navi'] = '';
if (($data['sort'] == '0') || (($data['sort'] == 1) && (!empty($SUB)))) {
// Is highest position
- $data['navi'] = "{--LOWER--}";
+ $data['navi'] = '{--LOWER--}';
} elseif ($cnt == $max) {
// Is lowest position
- $data['navi'] = "{--HIGHER--}";
+ $data['navi'] = '{--HIGHER--}';
} elseif ($data['sort'] > 0) {
// Anything else between highest and lowest
- $data['navi'] = "{--HIGHER--}/{--LOWER--}";
+ $data['navi'] = '{--HIGHER--}/{--LOWER--}';
}
// Fix empty elements for constant (fixes display bugs in Firefox)