X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-admins.php;h=b23f0f1377ff800405fc2dc5bd11f08b732f828e;hb=44c5b87eca387e02d33b4c0e728920aeca2a9840;hp=b721f0b8dbd67b9d44b19018592817ac2fd3cd40;hpb=52690b87d4382bd4bc15905068ab99bb70b1e3c9;p=mailer.git
diff --git a/inc/extensions/ext-admins.php b/inc/extensions/ext-admins.php
index b721f0b8db..b23f0f1377 100644
--- a/inc/extensions/ext-admins.php
+++ b/inc/extensions/ext-admins.php
@@ -52,7 +52,7 @@ switch ($EXT_LOAD_MODE)
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE action='admins' LIMIT 1";
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', '', 'Admin-Management', 'Administratoren anlegen, löschen oder Passwort/E-Mail Adresse ändern.', '1')";
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', NULL, 'Admin-Management', 'Administratoren anlegen, löschen oder Passwort/E-Mail Adresse ändern.', '1')";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', 'admins_add', 'Admin hinzufügen', 'Neuen Admin-Account anlegen', '0')";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', 'admins_edit', 'Admin-Account ändern', 'Bestehende Admin-Accounts bearbeiten: E-Mail-Adresse, Passwort und/oder Login-Name ändern.', '1')";
break;
@@ -90,20 +90,20 @@ case "update": // Update an extension
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', 'config_admins', 'ACL einstellen', 'Richten Sie Zugriffskontrollzeilen für jeden Admin individuell ein, um ihm nur bestimmte Bereiche des Admin-Bereiches zugänglich zu machen oder zu sperren.', '4')";
// Which is the default setting when you create a new admin login?
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl enum('deny', 'allow') not null default 'deny'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
// Default is deny everything
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl enum('deny', 'allow') not null default 'deny'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
// But allow current admin everything (THIS SHALL BE YOU!)
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admins SET default_acl='allow' WHERE login='".get_session('admin_login')."' LIMIT 1";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_acls";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_acls (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-action_menu varchar(255) not null default '',
-what_menu varchar(255) not null default '',
-access_mode enum('deny', 'allow') not null default 'deny',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+action_menu VARCHAR(255) NOT NULL DEFAULT '',
+what_menu VARCHAR(255) NOT NULL DEFAULT '',
+access_mode ENUM('deny', 'allow') NOT NULL DEFAULT 'deny',
KEY (admin_id),
PRIMARY KEY (id)
) TYPE=MyISAM";
@@ -113,15 +113,15 @@ PRIMARY KEY (id)
break;
case "0.3.1": // SQL queries for v0.3.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id bigint(20) not null auto_increment";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id BIGINT(20) NOT NULL AUTO_INCREMENT";
break;
case "0.4.0": // SQL queries for v0.4.0
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_mails";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_mails (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-mail_template varchar(255) not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+mail_template VARCHAR(255) NOT NULL,
KEY (admin_id),
PRIMARY KEY (id)
) TYPE=MyISAM";
@@ -184,7 +184,7 @@ PRIMARY KEY (id)
case "0.5.3": // SQL queries for v0.5.3
// Update notes (these will be set as task text!)
- $UPDATE_NOTES = "Seit Patch 340 überflüssige HTML-Tags entfernt.";
+ $UPDATE_NOTES = "Seit Patch 340 überflüssige HTML-Tags entfernt.";
break;
case "0.5.4": // SQL queries for v0.5.4
@@ -259,7 +259,7 @@ PRIMARY KEY (id)
break;
case "0.6.7": // SQL queries for v0.6.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode enum('global', 'OLD', 'NEW') not null default 'global'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode ENUM('global', 'OLD', 'NEW') NOT NULL DEFAULT 'global'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Namenskonflikt zwischen den Erweiterungen admins und (kommender) contact. Beseitigung eines Fehlers HTTP_POSR_VARS beim Ändern von Administratoren.";
@@ -287,7 +287,7 @@ default: // Do stuff when extension is loaded
$EXT_LANG_PREFIX = "admins";
// Extension is always active?
-$EXT_ALWAYS_ACTIVE = 'N';
+$EXT_ALWAYS_ACTIVE = "N";
//
?>