X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-user.php;h=daa3137169c8aaa3d3877fa36b433c007c2889a9;hp=819fddcbee60447a3d56add3dcee60c1c154e340;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=16b311c338bb4f8436e2ed9e76cb1cd5f3741640;ds=sidebyside diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php index 819fddcbee..daa3137169 100644 --- a/inc/extensions/ext-user.php +++ b/inc/extensions/ext-user.php @@ -52,102 +52,102 @@ setExtensionAlwaysActive('Y'); switch (getExtensionMode()) { case 'register': // Do stuff when installation is running (modules.php?module=admin is called) addDropTableSql('user_cats'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_cats` ( - `id` BIGINT(22) NOT NULL AUTO_INCREMENT, - `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `cat_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, -PRIMARY KEY (`id`), + addCreateTableSql('user_cats', "( +`id` BIGINT(22) NOT NULL AUTO_INCREMENT, +`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`cat_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, +PRIMARY KEY (`id`), INDEX (`userid`), INDEX (`cat_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User->category connection data'"); addDropTableSql('user_data'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_data` ( - `userid` BIGINT(22) NOT NULL AUTO_INCREMENT, - `surname` VARCHAR(255) NOT NULL DEFAULT '', - `family` VARCHAR(255) NOT NULL DEFAULT '', - `street_nr` VARCHAR(255) NOT NULL DEFAULT '', - `country` VARCHAR(4) NOT NULL DEFAULT '', - `zip` VARCHAR(6) NOT NULL DEFAULT '', - `city` VARCHAR(255) NOT NULL DEFAULT '', - `email` VARCHAR(255) NOT NULL DEFAULT '', - `birth_day` CHAR(2) NOT NULL DEFAULT '01', - `birth_month` CHAR(2) NOT NULL DEFAULT '01', - `birth_year` VARCHAR(4) NOT NULL DEFAULT '1970', - `password` VARCHAR(255) NOT NULL DEFAULT '', - `max_mails` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `receive_mails` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `refid` BIGINT(22) NOT NULL DEFAULT 0, - `status` ENUM('UNCONFIRMED','CONFIRMED','LOCKED') NOT NULL DEFAULT 'UNCONFIRMED', - `user_hash` VARCHAR(255) NULL DEFAULT NULL, - `REMOTE_ADDR` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', - `last_online` VARCHAR(10) NOT NULL DEFAULT 0, - `last_module` VARCHAR(255) NOT NULL DEFAULT '', - `ref_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `total_logins` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `gender` ENUM('M','F') NOT NULL DEFAULT 'M', - `used_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, - `emails_sent` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `joined` VARCHAR(10) NOT NULL DEFAULT 0, - `last_update` VARCHAR(10) NOT NULL DEFAULT 0, - `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0, - `notified` ENUM('Y','N') NOT NULL DEFAULT 'N', - `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, - `last_login` VARCHAR(10) NOT NULL DEFAULT 0, - `login_failures` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `last_failure` TIMESTAMP NULL DEFAULT NULL, -PRIMARY KEY (`userid`), + addCreateTableSql('user_data', "( +`userid` BIGINT(22) NOT NULL AUTO_INCREMENT, +`surname` VARCHAR(255) NOT NULL DEFAULT '', +`family` VARCHAR(255) NOT NULL DEFAULT '', +`street_nr` VARCHAR(255) NOT NULL DEFAULT '', +`country` VARCHAR(4) NOT NULL DEFAULT '', +`zip` VARCHAR(6) NOT NULL DEFAULT '', +`city` VARCHAR(255) NOT NULL DEFAULT '', +`email` VARCHAR(255) NOT NULL DEFAULT '', +`birth_day` CHAR(2) NOT NULL DEFAULT '01', +`birth_month` CHAR(2) NOT NULL DEFAULT '01', +`birth_year` VARCHAR(4) NOT NULL DEFAULT '1970', +`password` VARCHAR(255) NOT NULL DEFAULT '', +`max_mails` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`receive_mails` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`refid` BIGINT(22) NOT NULL DEFAULT 0, +`status` ENUM('UNCONFIRMED','CONFIRMED','LOCKED') NOT NULL DEFAULT 'UNCONFIRMED', +`user_hash` VARCHAR(255) NULL DEFAULT NULL, +`REMOTE_ADDR` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', +`last_online` VARCHAR(10) NOT NULL DEFAULT 0, +`last_module` VARCHAR(255) NOT NULL DEFAULT '', +`ref_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`total_logins` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`gender` ENUM('M','F') NOT NULL DEFAULT 'M', +`used_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +`emails_sent` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`joined` VARCHAR(10) NOT NULL DEFAULT 0, +`last_update` VARCHAR(10) NOT NULL DEFAULT 0, +`last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0, +`notified` ENUM('Y','N') NOT NULL DEFAULT 'N', +`ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, +`last_login` VARCHAR(10) NOT NULL DEFAULT 0, +`login_failures` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`last_failure` TIMESTAMP NULL DEFAULT NULL, +PRIMARY KEY (`userid`), UNIQUE (`user_hash`), INDEX (`refid`), INDEX `status_mails` (`status`,`max_mails`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Main user data'"); addDropTableSql('user_points'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_points` ( - `id` BIGINT(22) NOT NULL AUTO_INCREMENT, - `userid` BIGINT(22) NOT NULL DEFAULT 0, - `ref_depth` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, - `points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, - `locked_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, -PRIMARY KEY (`id`), + addCreateTableSql('user_points', "( +`id` BIGINT(22) NOT NULL AUTO_INCREMENT, +`userid` BIGINT(22) NOT NULL DEFAULT 0, +`ref_depth` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, +`points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +`locked_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +PRIMARY KEY (`id`), INDEX (`userid`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User points (no used points)'"); addDropTableSql('user_links'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_links` ( - `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `stats_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `link_type` ENUM('NORMAL') NOT NULL DEFAULT 'NORMAL', -PRIMARY KEY (`id`), + addCreateTableSql('user_links', "( +`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, +`stats_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`link_type` ENUM('NORMAL') NOT NULL DEFAULT 'NORMAL', +PRIMARY KEY (`id`), INDEX (`userid`), INDEX (`stats_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Unconfirmed mails per user'"); addDropTableSql('user_stats'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_stats` ( - `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `payment_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `subject` VARCHAR(200) NOT NULL DEFAULT '', - `url` TINYTEXT NOT NULL, - `max_rec` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `timestamp_ordered` VARCHAR(10) NOT NULL DEFAULT '', - `pool_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `timestamp_sstart` VARCHAR(10) NOT NULL DEFAULT '', - `timestamp_send` VARCHAR(10) NOT NULL DEFAULT '', - `is_stats` ENUM('Y','N') NOT NULL DEFAULT 'N', -PRIMARY KEY (`id`), + addCreateTableSql('user_stats', "( +`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, +`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`payment_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`subject` VARCHAR(200) NOT NULL DEFAULT '', +`url` TINYTEXT NOT NULL, +`max_rec` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`timestamp_ordered` VARCHAR(10) NOT NULL DEFAULT '', +`pool_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`timestamp_sstart` VARCHAR(10) NOT NULL DEFAULT '', +`timestamp_send` VARCHAR(10) NOT NULL DEFAULT '', +`is_stats` ENUM('Y','N') NOT NULL DEFAULT 'N', +PRIMARY KEY (`id`), INDEX (`userid`), INDEX (`cat_id`), INDEX (`payment_id`), INDEX (`pool_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Mail statistics per user order'"); addDropTableSql('user_stats_data'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_stats_data` ( + addCreateTableSql('user_stats_data', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `stats_type` VARCHAR(255) NOT NULL DEFAULT 'unknown', @@ -196,7 +196,7 @@ INDEX (`stats_type`) case 'update': // Update an extension switch (getCurrentExtensionVersion()) { case '0.1.0': // SQL queries for v0.1 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `user_limit` INT(7) UNSIGNED NOT NULL DEFAULT 20"); + addConfigAddSql('user_limit', "INT(7) UNSIGNED NOT NULL DEFAULT 20"); // Update notes (these will be set as task text!) setExtensionUpdateNotes("Seitenweises Anzeigen der User-Liste ist nun möglich."); @@ -260,7 +260,7 @@ INDEX (`stats_type`) break; case '0.2.1': // SQL queries for v0.2.1 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `user_alpha` TINYINT(3) UNSIGNED NOT NULL DEFAULT 10"); + addConfigAddSql('user_alpha', "TINYINT(3) UNSIGNED NOT NULL DEFAULT 10"); addAdminMenuSql('setup','config_user','Mitgliederliste','Anzahl Mitglieder pro Seite, Anzahl Buchstaben pro Zeile usw.', 8); // Update notes (these will be set as task text!) @@ -334,8 +334,8 @@ INDEX (`stats_type`) break; case '0.3.4': // SQL queries for v0.3.4 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `select_user_zero_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y'"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `user_min_confirmed` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 10"); + addConfigAddSql('select_user_zero_refid', "ENUM('Y','N') NOT NULL DEFAULT 'Y'"); + addConfigAddSql('user_min_confirmed', "SMALLINT(5) UNSIGNED NOT NULL DEFAULT 10"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `rand_confirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0"); // Update notes (these will be set as task text!) @@ -345,10 +345,10 @@ INDEX (`stats_type`) case '0.3.5': // SQL queries for v0.3.5 addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `lock_reason` TINYTEXT"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `lock_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00'"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `user_delete_purge` BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getOneDay() * 30).""); + addConfigAddSql('user_delete_purge', "BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getOneDay() * 30).""); addAdminMenuSql('user', 'list_user_del', 'Löschungen auflisten', 'Listet die Löschungen von Usern auf.', 9); addDropTableSql('user_del'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_del` ( + addCreateTableSql('user_del', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `email` VARCHAR(255) NOT NULL DEFAULT '', @@ -382,7 +382,6 @@ PRIMARY KEY (`id`) addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_del` CHANGE `userid` `userid` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_links` CHANGE `stats_id` `stats_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_links` CHANGE `userid` `userid` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_links` CHANGE `bonus_id` `bonus_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_points` CHANGE `userid` `userid` BIGINT( 22 ) UNSIGNED NULL DEFAULT NULL"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_points` CHANGE `ref_depth` `ref_depth` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_refs` CHANGE `userid` `userid` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL"); @@ -398,11 +397,10 @@ PRIMARY KEY (`id`) addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid` IS NULL OR `cat_id` IS NULL"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_del` WHERE `userid` IS NULL"); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_links` SET `stats_id`=NULL WHERE `stats_id`=0"); - addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_links` SET `bonus_id`=NULL WHERE `bonus_id`=0"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid` IS NULL"); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_points` SET `ref_depth`=NULL WHERE `ref_depth`=0"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_points` WHERE `userid` IS NULL"); - addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid` IS NULL OR `refid` IS NULL OR `level` IS NULL"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid` IS NULL OR `refid` IS NULL OR `level` IS NULL"); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `cat_id`=NULL WHERE `cat_id`=0"); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `payment_id`=NULL WHERE `payment_id`=0"); addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `pool_id`=NULL WHERE `pool_id`=0"); @@ -419,7 +417,7 @@ PRIMARY KEY (`id`) addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` CHANGE `last_failure` `last_failure` TIMESTAMP NULL DEFAULT NULL"); // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Standartwert 0000-00-00 00:00:00 ist nun einfach NULL."); + setExtensionUpdateNotes("Standardwert 0000-00-00 00:00:00 ist nun einfach NULL."); break; } // END - switch break;