All 'online' table queries should be placed in ext-online.php

diff --git a/inc/databases.php b/inc/databases.php
index 2d50bba46b81a775881925b6d61d0882795e0fc2..0206c29ad8258bde4ec68f1b7b47a9ac7497d6d1 100644 (file)
--- a/inc/databases.php
+++ b/inc/databases.php
@@ -98,7 +98,7 @@ define('SERVER_URL', "http://www.mxchange.org");
 
 // Current SVN revision
 //define('CURR_SVN_REVISION', getActualVersion(0));
-define('CURR_SVN_REVISION', "823");
+define('CURR_SVN_REVISION', "824");
 define('CURR_SVN_DATE'    , getActualVersion(1));
 define('CURR_SVN_VERSION' , getActualVersion(2));
 

diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php
index a9679229b922bf9623d2a80300b006c4b52df50a..566cf4a9191b35d9dbea267cf0dcf4cd46435eff 100644 (file)
--- a/inc/extensions/ext-online.php
+++ b/inc/extensions/ext-online.php
@@ -62,7 +62,8 @@ is_member ENUM('Y','N') NOT NULL DEFAULT 'N',
 timestamp VARCHAR(10) NOT NULL DEFAULT 0,
 PRIMARY KEY(id),
 KEY(userid),
-KEY(refid)
+KEY(refid),
+KEY `admin_member` (`is_admin`,`is_member`)
 ) TYPE={!_TABLE_TYPE!}");
        ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','usr_online','Online-Statistik','Eine Liste von derzeit "Online" Usern. Doppelte Einträge könnte auf mangelnden Cookie-Support des Browsers oder auf einen Spider hindeuten.', 1)");
        break;

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 545b10f2583751a9a6737bfb6f316ac29febbfeb..dc98cdaf170f1c43b60e1ce4c9095320cc4e842e 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -533,10 +533,8 @@ PRIMARY KEY (id)
                break;
 
        case "0.4.2": // SQL queries for v0.4.2
-               ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_online` ADD INDEX `admin_member` (`is_admin`,`is_member`)");
-
                // Update notes (these will be set as task text!)
-               EXT_SET_UPDATE_NOTES("Neuen Schlüssel zur Online-Tabelle hinzugefügt.");
+               EXT_SET_UPDATE_NOTES("Nicht mehr gültiges Update.");
                break;
 
        case "0.4.3": // SQL queries for v0.4.3