case '0.3.2': // SQL queries for v0.3.2
// Connection table between the menu system and the "logical area system"
addDropTableSql('admin_menu_las');
- addCreateTableSql('admin_menu_las', "(
+ addCreateTableSql('admin_menu_las', "
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`la_id` VARCHAR(255) NOT NULL DEFAULT '',
`la_action` VARCHAR(255) NOT NULL DEFAULT '',
`la_what` VARCHAR(255) NOT NULL DEFAULT '',
+PRIMARY KEY (`id`),
INDEX (`la_id`),
INDEX (`la_action`),
-INDEX (`la_what`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'");
+INDEX (`la_what`)",
+ 'Menu system -> LAS');
// All "logical areas" together
addDropTableSql('admin_menu_las_data');
- addCreateTableSql('admin_menu_las_data', "(
+ addCreateTableSql('admin_menu_las_data', "
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`la_id` VARCHAR(255) NOT NULL DEFAULT '',
`la_title` VARCHAR(255) NOT NULL DEFAULT '',
`la_posx` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`la_posy` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`id`),
UNIQUE KEY (`la_id`),
INDEX (`la_posx`),
-INDEX (`la_posy`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS position and title data'");
+INDEX (`la_posy`)",
+ 'LAS position and title data');
// Which menu do you like?
addConfigAddSql('admin_menu', "ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'");
// The statistics table
addDropTableSql('admin_las_stats');
- addCreateTableSql('admin_las_stats', "(
+ addCreateTableSql('admin_las_stats', "
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`type` ENUM('la','action','what') NOT NULL DEFAULT 'what',
`clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-INDEX (`admin_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS click data'");
+PRIMARY KEY (`id`),
+INDEX (`admin_id`)",
+ 'LAS click data');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Admin-abhängig werden nun Klicks im Admin-Menü gezählt, die zur automatischen Anpassung des Menüs in den logischen Bereichen diennen. Dieses "intelligente Unbauen" können Sie auch ganz abschalten.");
case '0.3.5': // SQL queries for v0.3.5
// List accounts with no referal
- addMemberMenuSql('stats', NULL, 'Statistiken', 'Y', 'N', 4);
- addMemberMenuSql('stats', 'stats2', 'Framekiller-Mails', 'Y', 'N', 2);
- addMemberMenuSql('extras', NULL, 'Extras', 'Y', 'N', 5);
- addMemberMenuSql('rals', NULL, 'Rallyes', 'Y', 'N', 6);
- addMemberMenuSql('account', NULL, 'Ihr Account', 'Y', 'N', 7);
+ addMemberMenuSql('stats', NULL, 'Statistiken', 4);
+ addMemberMenuSql('stats', 'stats2', 'Framekiller-Mails', 2);
+ addMemberMenuSql('extras', NULL, 'Extras', 5);
+ addMemberMenuSql('rals', NULL, 'Rallyes', 6);
+ addMemberMenuSql('account', NULL, 'Ihr Account', 7);
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='stats', `sort`=1, `title`='Klick-Mails' WHERE `what`='stats' LIMIT 1");
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='extras', `sort`=3 WHERE `what`='reflinks' LIMIT 1");
break;
case '0.5.4': // SQL queries for v0.5.4
- addMemberMenuSql('main', 'reflist', 'Ref-Übersicht', 'N', 'Y', 5);
+ addMemberMenuSql('main', 'reflist', 'Ref-Übersicht', 5);
// Depends on refback extension
addExtensionDependency('refback');
case '0.5.9': // SQL queries for v0.5.9
// Table 'filters' is vital because many functionality depends on it, so don't remove it
- addCreateTableSql('filters', "(
+ addCreateTableSql('filters', "
`filter_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`filter_name` VARCHAR(50) NOT NULL DEFAULT '',
`filter_function` VARCHAR(100) NOT NULL DEFAULT '',
`filter_active` ENUM('N','Y') NOT NULL DEFAULT 'Y',
`filter_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-UNIQUE `name_function` (`filter_name` , `filter_function`),
-PRIMARY KEY (`filter_id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Filter system'");
+PRIMARY KEY (`filter_id`),
+UNIQUE `name_function` (`filter_name` , `filter_function`)",
+ 'Filter system');
+
+ // Admin menu
addAdminMenuSql('setup','list_filter','Filter-Management', 'Zeigt alle im System registrierten Filter an und lässt diese de- bzw. wieder aktivieren.', 17);
// Update notes (these will be set as task text!)
case '0.7.0': // SQL queries for 0.7.0
// Table definition
addDropTableSql('dns_cache');
- addCreateTableSql('dns_cache', "(
+ addCreateTableSql('dns_cache', "
`hostname` VARCHAR(255) NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`added` DATETIME NOT NULL,
PRIMARY KEY (`hostname`),
-INDEX (`ip`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Cache for DNS requests'");
+INDEX (`ip`)",
+ 'Cache for DNS requests');
// Configuration
addConfigAddSql('dns_cache_timeout', 'BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
break;
case '0.7.7': // SQL queries for v0.7.7
- addMemberMenuSql('earn', NULL, 'Verdienen', 'Y', 'N', 2);
+ addMemberMenuSql('earn', NULL, 'Verdienen', 2);
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='earn', `sort`=1 WHERE `what`='unconfirmed' LIMIT 1");
// Update notes (these will be set as task text!)
case '0.8.0': // SQL queries for v0.8.0
// Points account data
addDropTableSql('points_data');
- addCreateTableSql('points_data', "(
+ addCreateTableSql('points_data', "
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`ext_name` VARCHAR(255) NOT NULL DEFAULT '',
`column_name` VARCHAR(255) NOT NULL DEFAULT 'points',
`locked_mode` ENUM('LOCKED','UNLOCKED') NOT NULL DEFAULT 'LOCKED',
`payment_method` ENUM('DIRECT','REF') NOT NULL DEFAULT 'REF',
PRIMARY KEY(`id`),
-INDEX (`ext_name`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Points account data'");
+INDEX (`ext_name`)",
+ 'Points account data');
// Admin menu
addAdminMenuSql('setup','list_point_accounts','Guthabenkonten...','Veralten Sie hier bequem Einstellungen zu den Guthabenkonten.',5);