X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_admins.php;h=5d36456f403c3d47398ea4a334e9365e2ede0b1a;hb=dd3f996989d9fd027b007fe829ae7356f3780b37;hp=e79b70adc4dabc6ea0696fc4b9a688519d4d0232;hpb=7fabfadce30a7bea7ce3ad1f1e2e7e5e616f2669;p=mailer.git diff --git a/inc/modules/admin/what-config_admins.php b/inc/modules/admin/what-config_admins.php index e79b70adc4..5d36456f40 100644 --- a/inc/modules/admin/what-config_admins.php +++ b/inc/modules/admin/what-config_admins.php @@ -51,7 +51,7 @@ if ((isPostRequestElementSet('edit')) && ($SEL > 0)) { // Edit ACLs $OUT = ''; $SW = 2; foreach (postRequestElement('sel') as $id => $selected) { - // Load data for the ID + // Load data for the id $result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($adminId, $action, $what, $mode) = SQL_FETCHROW($result); @@ -85,7 +85,7 @@ if ((isPostRequestElementSet('edit')) && ($SEL > 0)) { } elseif ((isPostRequestElementSet('change')) && ($SEL > 0)) { // Change entries foreach (postRequestElement('sel') as $id => $selected) { - // Secure ID + // Secure id $id = bigintval($id); // Update entries @@ -110,7 +110,7 @@ if ((isPostRequestElementSet('edit')) && ($SEL > 0)) { // Delete ACLs $OUT = ''; $SW = 2; foreach (postRequestElement('sel') as $id => $selected) { - // Load data for the ID + // Load data for the id $result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($admin, $action, $what, $mode) = SQL_FETCHROW($result); @@ -212,7 +212,7 @@ VALUES ('%s','%s','%s','%s')", loadTemplate('admin_settings_saved', false, $content); } else { // List all ACLs - $result_acls = SQL_QUERY("SELECT id, admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` ORDER BY admin_id, id", __FILE__, __LINE__); + $result_acls = SQL_QUERY('SELECT `id`, `admin_id`, `action_menu`, `what_menu`, `access_mode` FROM `{?_MYSQL_PREFIX?}_admins_acls` ORDER BY `admin_id` ASC, `id` ASC', __FILE__, __LINE__); // Entries found? if (SQL_NUMROWS($result_acls) > 0) {