case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
// SQL commands to run
addDropTableSql('user_wernis');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_wernis` (
+ addCreateTableSql('user_wernis', "(
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`wernis_account` VARCHAR(255) NOT NULL DEFAULT '',
) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Transfered Wernis per user'");
// Confiuration
- addConfigAddSql("wernis_min_payout BIGINT(20) UNSIGNED NOT NULL DEFAULT '40000'");
- addConfigAddSql("wernis_min_withdraw BIGINT(20) UNSIGNED NOT NULL DEFAULT '5000'");
- addConfigAddSql("wernis_api_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
- addConfigAddSql("wernis_api_md5 VARCHAR(32) NOT NULL DEFAULT ''");
- addConfigAddSql("wernis_api_url VARCHAR(255) NOT NULL DEFAULT 'http://www.wds66.com/api/'");
+ addConfigAddSql('wernis_min_payout', "BIGINT(20) UNSIGNED NOT NULL DEFAULT '40000'");
+ addConfigAddSql('wernis_min_withdraw', "BIGINT(20) UNSIGNED NOT NULL DEFAULT '5000'");
+ addConfigAddSql('wernis_api_id', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+ addConfigAddSql('wernis_api_md5', "VARCHAR(32) NOT NULL DEFAULT ''");
+ addConfigAddSql('wernis_api_url', "VARCHAR(255) NOT NULL DEFAULT 'http://www.wds66.com/api/'");
// User data
addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD wernis_userid VARCHAR(6) NOT NULL DEFAULT ''");
addMemberMenuSql('main','wernis','Wernis-Ein-/Auszahlungen','N','Y', 11);
// Guest menu
- addGuestMenuSql('main','wernis_portal','WDS66-News','N','Y', 7);
+ addGuestMenuSql('main', 'wernis_portal', 'WDS66-News', 'N', 'Y', 7);
break;
case 'remove': // Do stuff when removing extension