// Load only from array when there are lines!
if ((isset($cacheArray['admin_acls'])) && (is_array($cacheArray['admin_acls'])) && (count($cacheArray['admin_acls']) > 0)) {
// Load ACL from array
- foreach ($cacheArray['admin_acls']['admin_id'] as $id=>$aid_acls) {
+ foreach ($cacheArray['admin_acls']['admin_id'] as $id => $aid_acls) {
if ($aid == $aid_acls) {
// Okay, one line was found!
if ((!empty($act)) && ($cacheArray['admin_acls']['action_menu'][$id] == $act)) {
if (!empty($act))
{
// Main menu
- $result = SQL_QUERY_ESC("SELECT access_mode FROM "._MYSQL_PREFIX."_admins_acls WHERE admin_id=%d AND action_menu='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT access_mode FROM "._MYSQL_PREFIX."_admins_acls WHERE admin_id=%s AND action_menu='%s' LIMIT 1",
array(bigintval($aid), $act), __FILE__, __LINE__);
} elseif (!empty($wht)) {
// Sub menu
- $result = SQL_QUERY_ESC("SELECT access_mode FROM "._MYSQL_PREFIX."_admins_acls WHERE admin_id=%d AND what_menu='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT access_mode FROM "._MYSQL_PREFIX."_admins_acls WHERE admin_id=%s AND what_menu='%s' LIMIT 1",
array(bigintval($aid), $wht), __FILE__, __LINE__);
}
global $cacheInstance;
// Begin the update
- $cacheInstance_UPDATE = "0";
- foreach ($POST['login'] as $id=>$login) {
+ $cacheInstance_UPDATE = 0;
+ foreach ($POST['login'] as $id => $login) {
// Secure ID number
$id = bigintval($id);
email='%s',
default_acl='%s',
la_mode='%s'
-WHERE id=%d LIMIT 1",
+WHERE id=%s LIMIT 1",
array(
$login,
$POST['email'][$id],
login='%s'".$ADD.",
email='%s',
la_mode='%s'
-WHERE id=%d LIMIT 1",
+WHERE id=%s LIMIT 1",
array(
$login,
$POST['email'][$id],
function ADMINS_EDIT_ADMIN_ACCOUNTS ($POST) {
// Begin the edit loop
$SW = 2; $OUT = "";
- foreach ($POST['sel'] as $id=>$sel) {
+ foreach ($POST['sel'] as $id => $sel) {
// Secure ID number
$id = bigintval($id);
// Get the admin's data
- $result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM "._MYSQL_PREFIX."_admins WHERE id=%d LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
array($id), __FILE__, __LINE__);
if ((SQL_NUMROWS($result) == 1) && ($sel == 1)) {
// Entry found
if ($accounts > 1) {
// Delete accounts
$SW = 2; $OUT = "";
- foreach ($POST['sel'] as $id=>$sel) {
+ foreach ($POST['sel'] as $id => $sel) {
// Secure ID number
$id = bigintval($id);
// Get the admin's data
- $result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM "._MYSQL_PREFIX."_admins WHERE id=%d LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
array($id), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Entry found
// Remove the given accounts
function ADMINS_REMOVE_ADMIN_ACCOUNTS ($POST) {
// Begin removal
- $cacheInstance_UPDATE = "0";
- foreach ($POST['sel'] as $id=>$del) {
+ $cacheInstance_UPDATE = 0;
+ foreach ($POST['sel'] as $id => $del) {
// Secure ID number
$id = bigintval($id);
// Delete only when it's not your own account!
if (($del == 1) && (GET_ADMIN_ID(get_session('admin_login')) != $id)) {
// Rewrite his tasks to all admins
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET assigned_admin='0' WHERE assigned_admin='%s'",
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET assigned_admin=0 WHERE assigned_admin=%s",
array($id), __FILE__, __LINE__);
// Remove account
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins WHERE id=%d LIMIT 1",
+ $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
array($id), __FILE__, __LINE__);
$cacheInstance_UPDATE = "1";