X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-task.php;h=cb67054e1843bc72fcca06c2354150b7312c2283;hb=efd47a9f6e4f5b6aeed00fb239f99f0df1b99982;hp=2b43107b561b38e108b3710b870a5393331629f3;hpb=9725980ca9c052e5c1a9edb8b815e8506b876448;p=mailer.git diff --git a/inc/extensions/ext-task.php b/inc/extensions/ext-task.php index 2b43107b56..cb67054e18 100644 --- a/inc/extensions/ext-task.php +++ b/inc/extensions/ext-task.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -41,20 +41,27 @@ if (!defined('__SECURITY')) { } // END - if // Version number -setThisExtensionVersion('0.3.2'); +setThisExtensionVersion('0.3.3'); -// Version history array (add more with , '0.1.0' and so on) -setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6', '0.0.7', '0.0.8', '0.0.9', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2')); +// Version history array (add more with , '0.0.1' and so on) +setExtensionVersionHistory(array('0.0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6', '0.0.7', '0.0.8', '0.0.9', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2', '0.3.3')); // Keep this extension always active! setExtensionAlwaysActive('Y'); switch (getExtensionMode()) { - case 'register': // Do stuff when installation is running (modules.php?module=admin is called) + case 'setup': // Do stuff when installation is running // SQL commands to run addAdminMenuSql('task', NULL, 'Aufgaben-Management','Erweitertes Aufgaben-Management zur leichten verwaltung der vom System erzeugten Aufgaben.',1); addAdminMenuSql('task','list_task','Aufgaben auflisten','Alle Ihnen zugewiesenen Aufgaben auflisten (keine Updates).',1); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `status`='SOLVED' WHERE `status`='CLOSED'"); + // These SQL updates has been moved from ext-sql_patches to here + addExtensionAddTableIndexSql('task_system', 'task_type', '(`task_type`)'); + addExtensionAddTableIndexSql('task_system', 'status', '(`status`)'); + addExtensionAddTableIndexSql('task_system', 'task_created', '(`task_created`)'); + addExtensionAddTableFulltextSql('task_system', 'subject', '(`subject`)'); + addExtensionAddTableIndexSql('task_system', 'subject', '(`subject`)'); + addExtensionAddTableIndexSql('task_system', 'subject', '(`subject`)'); break; case 'remove': // Do stuff when removing extension @@ -75,13 +82,8 @@ switch (getExtensionMode()) { case 'update': // Update an extension switch (getCurrentExtensionVersion()) { case '0.0.1': // SQL queries for v0.0.1 - addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_extensions` SET ext_has_css='Y' WHERE `ext_name`='task' AND ext_has_css='N' LIMIT 1"); - - // This update depends on sql_patches update! - addExtensionDependency('sql_patches'); - // Update notes (these will be set as task text!) - setExtensionUpdateNotes("CSS-Datei kann per Admin-Bereich ein- und ausgeschaltet werden."); + setExtensionUpdateNotes("Veraltetes Update entfernt."); break; case '0.0.1': // SQL queries for v0.0.1 @@ -178,7 +180,7 @@ switch (getExtensionMode()) { case '0.2.0': // SQL queries for v0.2.0 // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Alle Administratoren, Referal-Banner und aktivierte Referal-Banner werden nun eingeblendet."); + setExtensionUpdateNotes("Alle Administratoren, Referral-Banner und aktivierte Referral-Banner werden nun eingeblendet."); break; case '0.2.1': // SQL queries for v0.2.1 @@ -193,7 +195,7 @@ switch (getExtensionMode()) { case '0.2.3': // SQL queries for v0.2.3 // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Sortierungsreihenfolge grundlegend geändert: Es wird jetzt nach Mitglieder-Id, Aufgabenbereich, Infos und nach dem Erstellunsdatum sortiert."); + setExtensionUpdateNotes("Sortierungsreihenfolge grundlegend geändert: Es wird jetzt nach Mitglieds-Id, Aufgabenbereich, Infos und nach dem Erstellunsdatum sortiert."); break; case '0.2.4': // SQL queries for v0.2.4 @@ -237,12 +239,19 @@ switch (getExtensionMode()) { break; case '0.3.2': // SQL queries for v0.3.2 - // This update depends on user update - addExtensionDependency('sql_patches'); - // Update notes (these will be set as task text!) setExtensionUpdateNotes("Hängt nun von ext-user ab."); break; + + case '0.3.3': // SQL queries for v0.3.3 + addExtensionChangeTableColumnSql('task_system', 'assigned_admin', 'assigned_admin', 'BIGINT(20) UNSIGNED NULL DEFAULT NULL'); + addExtensionChangeTableColumnSql('task_system', 'userid', 'userid', 'BIGINT(20) UNSIGNED NULL DEFAULT NULL'); + addExtensionSql('UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=NULL WHERE `assigned_admin`=0'); + addExtensionSql('UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `userid`=NULL WHERE `userid`=0'); + + // Update notes (these will be set as task text!) + setExtensionUpdateNotes("Zugewiesener Admin und User-Id dürfen nun NULL sein."); + break; } // END - switch break; @@ -256,7 +265,7 @@ switch (getExtensionMode()) { break; default: // Unknown extension mode - logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName())); + reportBug(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName())); break; } // END - switch