X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-debug.php;h=a34086e34170c8ff111dba457aecd6e83d1093dd;hb=7ae4b1624e25f14bd70f57dc00b410674f849f7f;hp=cd044dd81daba64a6c9718b516d19b2443694b63;hpb=14f8d98a50a5474ecbe5e0a7d5e80fad706458fa;p=mailer.git diff --git a/inc/extensions/ext-debug.php b/inc/extensions/ext-debug.php index cd044dd81d..a34086e341 100644 --- a/inc/extensions/ext-debug.php +++ b/inc/extensions/ext-debug.php @@ -14,8 +14,6 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009, 2010 by Mailer Developer Team * @@ -70,7 +68,7 @@ switch (getExtensionMode()) { `inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, INDEX (`sender_id`), PRIMARY KEY (`id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Debug log data'"); +) TYPE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Debug log data'"); // Table against debug log abuse addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_debug_log_abuse`'); @@ -82,7 +80,7 @@ PRIMARY KEY (`id`) `inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, INDEX (`client_id`), PRIMARY KEY (`id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Debug log abuse'"); +) TYPE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Debug log abuse'"); // Table on relay/server for client exchanges addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_debug_client`'); @@ -99,7 +97,7 @@ PRIMARY KEY (`id`) UNIQUE (`key`), UNIQUE (`url`), PRIMARY KEY (`id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Debug clients'"); +) TYPE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Debug clients'"); // Add this exchange as first client addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_debug_client` (`url`,`title`,`webmaster`,`status`) VALUES ('{?URL?}','{?MAIN_TITLE?}','{?WEBMASTER?}','ACTIVE')"); @@ -113,7 +111,7 @@ PRIMARY KEY (`id`) INDEX `client_log` (`client_id`,`log_id`), UNIQUE (`log_id`), PRIMARY KEY (`id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Debug client <-> log connection'"); +) TYPE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Debug client <-> log connection'"); // Guest menus addGuestMenuSql('debug',NULL,'Debug-System','Y','Y',2); @@ -136,7 +134,7 @@ PRIMARY KEY (`id`) addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_mode` ENUM('CLIENT','RELAY','SERVER') NOT NULL DEFAULT 'CLIENT'"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_new_log` ENUM('ACCEPT','FIRST','REG') NOT NULL DEFAULT 'FIRST'"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_new_client` ENUM('ACTIVE','NEW','REG') NOT NULL DEFAULT 'NEW'"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_reject_log` BIGINT(20) UNSIGNED NOT NULL DEFAULT " . (getConfig('ONE_DAY') * 30)); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_reject_log` BIGINT(20) UNSIGNED NOT NULL DEFAULT " . (getOneDay() * 30)); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `debug_master_url` VARCHAR(255) NOT NULL DEFAULT '{?SERVER_URL?}'"); break;