From 1a74df058945a82578f830daa35ac45c2f85913c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 4 Mar 2009 20:22:27 +0000 Subject: [PATCH] All 'online' table queries should be placed in ext-online.php --- inc/databases.php | 2 +- inc/extensions/ext-online.php | 3 ++- inc/extensions/ext-sql_patches.php | 4 +--- 3 files changed, 4 insertions(+), 5 deletions(-) diff --git a/inc/databases.php b/inc/databases.php index 2d50bba46b..0206c29ad8 100644 --- 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 a9679229b9..566cf4a919 100644 --- 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 545b10f258..dc98cdaf17 100644 --- 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 -- 2.39.2