X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-debug.php;h=886c13554816aef3bea08341631c74e8ffc2da47;hp=642a4ff0cffd7e0587a8817f2e5d52cbf12c9648;hb=1e6d7b906ac9481fc5120d7a1a5e6a4d7a509296;hpb=5f8c1a333627cd0145f778a6eebdb251f5bb40b6

diff --git a/inc/extensions/ext-debug.php b/inc/extensions/ext-debug.php
index 642a4ff0cf..886c135548 100644
--- a/inc/extensions/ext-debug.php
+++ b/inc/extensions/ext-debug.php
@@ -52,8 +52,8 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
 	// Table for debug log entries
 	$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_debug_log`";
 	$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_debug_log` (
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`sender_id` BIGINT(20) NOT NULL DEFAULT 0,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`sender_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
 `file` VARCHAR(255) NOT NULL DEFAULT '',
 `line` MEDIUMINT NOT NOT NULL DEFAULT 0,
@@ -68,8 +68,8 @@ PRIMARY KEY (`id`)
 	// Table against debug log abuse
 	$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_debug_log_abuse`";
 	$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_debug_log_abuse` (
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`client_id` BIGINT(20) NOT NULL DEFAULT 0,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`client_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
 `raw_data` LONGTEXT,
 `inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -80,7 +80,7 @@ PRIMARY KEY (`id`)
 	// Table on relay/server for client exchanges
 	$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_debug_client`";
 	$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_debug_client` (
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `key` VARCHAR(255) NOT NULL DEFAULT 'SELF',
 `url` VARCHAR(255) NOT NULL DEFAULT '',
 `webmaster` VARCHAR(255) NOT NULL DEFAULT '',
@@ -95,14 +95,14 @@ PRIMARY KEY (`id`)
 ) TYPE=MyISAM COMMENT='Debug clients'";
 
 	// Add this exchange as first client
-	$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_debug_client` (`url`,`title`,`webmaster`,`status`) VALUES ('".URL."','".MAIN_TITLE."','".WEBMASTER."','ACTIVE')";
+	$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_debug_client` (`url`,`title`,`webmaster`,`status`) VALUES ('{!URL!}','{!MAIN_TITLE!}','{!WEBMASTER!}','ACTIVE')";
 
 	// Table for debug log <-> client connection
 	$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_debug_client_log`";
 	$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_debug_client_log` (
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`client_id` BIGINT(20) NOT NULL DEFAULT 1,
-`log_id` BIGINT(20) NOT NULL DEFAULT 0,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`client_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
+`log_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 INDEX `client_log` (`client_id`,`log_id`),
 UNIQUE (`log_id`),
 PRIMARY KEY (`id`)
@@ -124,12 +124,13 @@ PRIMARY KEY (`id`)
 	$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('debug','config_debug','Einstellungen','&Auml;ndern Sie hier alle Einstellungen, wie auch den Debug-Modus - ob Client, Hub oder selber Server sein. Lesen Sie dazu die Anleitung unter DOCs/de/debug/README.txt durch! Oder kommen Sie in&#39;s Forum. Das Team von MXChange.org hilft Ihnen gerne weiter.',5)";
 
 	// Config entries
-	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_id` BIGINT(20) NOT NULL DEFAULT 0";
+	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0";
 	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_key` VARCHAR(255) NOT NULL DEFAULT ''";
 	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_mode` ENUM('CLIENT','RELAY','SERVER') NOT NULL DEFAULT 'CLIENT'";
 	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_new_log` ENUM('ACCEPT','FIRST','REG') NOT NULL DEFAULT 'FIRST'";
 	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_new_client` ENUM('ACTIVE','NEW','REG') NOT NULL DEFAULT 'NEW'";
-	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_reject_log` BIGINT(20) NOT NULL DEFAULT ".($_CONFIG['one_day'] * 30)."";
+	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_reject_log` BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getConfig('one_day') * 30)."";
+	$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `debug_master_url` VARCHAR(255) NOT NULL DEFAULT '{!SERVER_URL!}'";
 	break;
 
 case "remove": // Do stuff when removing extension
@@ -164,13 +165,13 @@ case "update": // Update an extension
 	}
 	break;
 
+case "test": // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305.
+	break;
+
 default: // Do stuff when extension is loaded
 	break;
 }
 
-// Language file prefix
-$EXT_LANG_PREFIX = "debug";
-
 // Keep this extension always active!
 $EXT_ALWAYS_ACTIVE = "Y";