X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-sponsor.php;h=f70114da9cb4e5ab967f3165b69bdaee5b5cc407;hb=e8ca54fe91872ab95a6ffdc4f1268bf18889021d;hp=db17a5eb8e3c3fc2ae42b8075c4bd53979bf44f4;hpb=55dd61bf035773f00ba0f7f3b56a5299b2ac9693;p=mailer.git

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index db17a5eb8e..f70114da9c 100644
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -86,7 +86,7 @@ switch (getExtensionMode()) {
 `last_change` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
 `status` ENUM('UNCONFIRMED','PENDING','CONFIRMED','LOCKED') NOT NULL DEFAULT 'UNCONFIRMED',
 `receive_warnings` ENUM('Y','N') NOT NULL DEFAULT 'Y',
-`warning_interval` BIGINT(20) UNSIGNED NOT NULL DEFAULT '".(getConfig('ONE_DAY')*7)."',
+`warning_interval` BIGINT(20) UNSIGNED NOT NULL DEFAULT '".(getOneDay()*7)."',
 `points_amount` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 `points_used` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 `refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -372,6 +372,17 @@ PRIMARY KEY (`id`)
 		//
 		addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `sponsor_ref_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 100.00000");
 		addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `sponsor_min_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 1000.00000");
+		//
+		// Register module
+		//
+		addModuleSql('sponsor','Y','Y','N','N');
+		addModuleSql('sponsor_confirm','Y','Y','N','N');
+		addModuleSql('sponsor_ref','Y','Y','N','N');
+
+		// Update name, if not yet set
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `title`='Sponsorbereich' WHERE `module`='sponsor' AND `title`='' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `title`='Sponsor-Bestätigung' WHERE `module`='sponsor_confirm' AND `title`='' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `title`='Sponsor-Referallink' WHERE `module`='sponsor_ref' AND `title`='' LIMIT 1");
 		break;
 
 	case 'remove': // Do stuff when removing extension
@@ -399,6 +410,7 @@ PRIMARY KEY (`id`)
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y', `locked`='N' WHERE `what`='sponsor' LIMIT 1");
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_sponsor_menu` SET `active`='Y' WHERE active='N'");
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_sponsor_registry` SET `is_active`='Y' WHERE `is_active`='N'");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='N', `hidden`='N', `admin_only`='N', `mem_only`='N' WHERE `module` IN ('sponsor','sponsor_confirm','sponsor_ref') LIMIT 3");
 		break;
 
 	case 'deactivate': // Do stuff when admin deactivates this extension
@@ -407,6 +419,7 @@ PRIMARY KEY (`id`)
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='N', `locked`='Y' WHERE `what`='sponsor' LIMIT 1");
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_sponsor_menu` SET `active`='N' WHERE `active`='Y'");
 		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_sponsor_registry` SET `is_active`='N' WHERE `is_active`='Y'");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='Y' WHERE `module` IN ('sponsor','sponsor_confirm','sponsor_ref') LIMIT 3");
 		break;
 
 	case 'update': // Update an extension