- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `admin_id`=%s AND `action_menu`='%s' AND `what_menu`='%s' LIMIT 1",
+ $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `admin_id`=%s AND `action_menu`='%s' AND `what_menu`='%s' LIMIT 1",
array(
bigintval(postRequestElement('admin_id')),
postRequestElement('action_menu'),
postRequestElement('what_menu')
), __FILE__, __LINE__);
array(
bigintval(postRequestElement('admin_id')),
postRequestElement('action_menu'),
postRequestElement('what_menu')
), __FILE__, __LINE__);
- if (SQL_HASZERONUMS($result)) {
+ if (ifSqlHasZeroNumRows($result)) {
// Finally add the new ACL
// Finally add the new ACL
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_admins_acls` (`admin_id`,`action_menu`,`what_menu`,`access_mode`)
-VALUES (%s,'%s','%s','%s')",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_admins_acls` (
+ `admin_id`,
+ `action_menu`,
+ `what_menu`,
+ `access_mode`
+) VALUES (
+ %s,
+ '%s',
+ '%s',
+ '%s'
+)",
array(
bigintval(postRequestElement('admin_id')),
postRequestElement('action_menu'),
postRequestElement('what_menu'),
array(
bigintval(postRequestElement('admin_id')),
postRequestElement('action_menu'),
postRequestElement('what_menu'),
- postRequestElement('mode')
+ postRequestElement('do')
), __FILE__, __LINE__);
$content = '{--ADMIN_ADMINS_ACL_SAVED--}';
// Update cache when installed
), __FILE__, __LINE__);
$content = '{--ADMIN_ADMINS_ACL_SAVED--}';
// Update cache when installed
- if (isExtensionActive('cache')) {
- if ($GLOBALS['cache_instance']->loadCacheFile('admin_acls')) $GLOBALS['cache_instance']->removeCacheFile();
- $result = 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__);