// 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,
// 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,
// 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 '',
) 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`)
$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('debug','config_debug','Einstellungen','Ä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'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)."";
break;
case "remove": // Do stuff when removing 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;
}