X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-nickname.php;h=618d44b9f92184a1cf8706357b5d18a6e94bf864;hb=1fd39b2564946ce7f19776abab8d65a31928fba1;hp=d2891ce10b57b443b22a61c3d539459188d9b540;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa;p=mailer.git diff --git a/inc/extensions/ext-nickname.php b/inc/extensions/ext-nickname.php index d2891ce10b..618d44b9f9 100644 --- a/inc/extensions/ext-nickname.php +++ b/inc/extensions/ext-nickname.php @@ -40,7 +40,7 @@ // Some security stuff... if (!defined('__SECURITY')) { die(); -} +} // END - if // Version number setThisExtensionVersion('0.1.9'); @@ -60,7 +60,7 @@ switch (getExtensionMode()) { // SQL commands to run addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='nickname'"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what` IN ('config_nickname','list_nickname')"); - addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_nickname_history`"); + addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_nickname_history`'); break; case 'activate': // Do stuff when admin activates this extension @@ -176,16 +176,16 @@ switch (getExtensionMode()) { case '0.1.9': // SQL queries for v0.1.9 addAdminMenuSql('user','list_nickname','Nickname-Historie','Listet alle verwendeten Nicknames der Mitglieder auf.', 12); - addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_nickname_history`"); + addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_nickname_history`'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_nickname_history` ( -id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, -nickname VARCHAR(255) NOT NULL DEFAULT '', -added TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -last_used TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', -INDEX userid (userid), -INDEX (last_used DESC), -PRIMARY KEY (id) +`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, +`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`nickname` VARCHAR(255) NOT NULL DEFAULT '', +`added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, +`last_used` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', +INDEX `userid` (`userid`), +INDEX (`last_used` DESC), +PRIMARY KEY (`id`) ) TYPE={?_TABLE_TYPE?} COMMENT='History of used nicknames'"); // Update notes (these will be set as task text!) @@ -204,9 +204,9 @@ PRIMARY KEY (id) break; default: // Unknown extension mode - logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s detected.", getExtensionMode())); + logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName())); break; -} +} // END - switch -// +// [EOF] ?>