| 1 |
|
|---|
| 2 | --
|
|---|
| 3 | -- Email Digest Mod
|
|---|
| 4 | -- Table structure for table `om_digests_subscribed_forums`
|
|---|
| 5 | --
|
|---|
| 6 |
|
|---|
| 7 | CREATE TABLE IF NOT EXISTS `om_digests_subscribed_forums` (
|
|---|
| 8 | `user_id` mediumint(8) NOT NULL DEFAULT '0',
|
|---|
| 9 | `forum_id` mediumint(8) NOT NULL DEFAULT '0',
|
|---|
| 10 | PRIMARY KEY (`user_id`,`forum_id`)
|
|---|
| 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|---|
| 12 |
|
|---|
| 13 | ALTER TABLE om_users ADD user_digest_type varchar(4) NOT NULL default 'NONE';
|
|---|
| 14 | ALTER TABLE om_users ADD user_digest_format varchar(4) NOT NULL default 'HTML';
|
|---|
| 15 | ALTER TABLE om_users ADD user_digest_show_mine tinyint(4) unsigned NOT NULL default '1';
|
|---|
| 16 | ALTER TABLE om_users ADD user_digest_send_on_no_posts tinyint(4) unsigned NOT NULL default '0';
|
|---|
| 17 | ALTER TABLE om_users ADD user_digest_send_hour_gmt decimal(5,2) unsigned NOT NULL default '0.00';
|
|---|
| 18 | ALTER TABLE om_users ADD user_digest_show_pms tinyint(4) unsigned NOT NULL default '1';
|
|---|
| 19 | ALTER TABLE om_users ADD user_digest_max_posts mediumint(8) unsigned default NULL;
|
|---|
| 20 | ALTER TABLE om_users ADD user_digest_min_words mediumint(8) unsigned default NULL;
|
|---|
| 21 | ALTER TABLE om_users ADD user_digest_remove_foes tinyint(4) unsigned NOT NULL default '0';
|
|---|
| 22 | ALTER TABLE om_users ADD user_digest_sortby varchar(13) NOT NULL default 'board';
|
|---|
| 23 | ALTER TABLE om_users ADD user_digest_max_display_words mediumint(8) unsigned default '0';
|
|---|
| 24 | ALTER TABLE om_users ADD user_digest_reset_lastvisit tinyint(4) unsigned NOT NULL default '1';
|
|---|
| 25 | ALTER TABLE om_users ADD user_digest_filter_type varchar(3) NOT NULL default 'ALL';
|
|---|
| 26 | ALTER TABLE om_users ADD user_digest_pm_mark_read tinyint(4) NOT NULL default '0';
|
|---|
| 27 | ALTER TABLE om_users ADD user_digest_new_posts_only tinyint(4) NOT NULL default '0';
|
|---|
| 28 |
|
|---|
| 29 | UPDATE om_users SET user_digest_type = 'NONE' WHERE TRIM(user_digest_type) = '';
|
|---|
| 30 | UPDATE om_users SET user_digest_format = 'HTML' WHERE TRIM(user_digest_format) = '';
|
|---|
| 31 | UPDATE om_users SET user_digest_sortby = 'board' WHERE TRIM(user_digest_sortby) = '';
|
|---|
| 32 | UPDATE om_users SET user_digest_filter_type = 'ALL' WHERE TRIM(user_digest_filter_type) = '' OR user_digest_filter_type = '0';
|
|---|
| 33 |
|
|---|
| 34 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_custom_stylesheet_path', 'prosilver/theme/digest_stylesheet.css', '0');
|
|---|
| 35 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_digests_title', 'phpBB Digests', '0');
|
|---|
| 36 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_enable_auto_subscriptions', '0', '0');
|
|---|
| 37 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_enable_custom_stylesheets', '0', '0');
|
|---|
| 38 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_host', 'phpbbservices.com', '0');
|
|---|
| 39 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_key_value', '', '0');
|
|---|
| 40 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_log_eol', 'HTML', '0');
|
|---|
| 41 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_log_path', '', '0');
|
|---|
| 42 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_max_items', '0', '0');
|
|---|
| 43 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_page_url', 'http://phpbbservices.com/digests/', '0');
|
|---|
| 44 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_require_key', '0', '0');
|
|---|
| 45 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_reset_log', '0', '0');
|
|---|
| 46 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_reset_log_date', '0', '0');
|
|---|
| 47 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_show_output', '1', '0');
|
|---|
| 48 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_check_all_forums', '1', '0');
|
|---|
| 49 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_filter_type', 'ALL', '0');
|
|---|
| 50 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_format', 'HTML', '0');
|
|---|
| 51 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_max_display_words', '0', '0');
|
|---|
| 52 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_max_posts', '0', '0');
|
|---|
| 53 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_min_words', '0', '0');
|
|---|
| 54 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_new_posts_only', '0', '0');
|
|---|
| 55 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_pm_mark_read', '0', '0');
|
|---|
| 56 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_remove_foes', '0', '0');
|
|---|
| 57 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_reset_lastvisit', '0', '0');
|
|---|
| 58 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_send_hour_gmt', '-1', '0');
|
|---|
| 59 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_send_on_no_posts', '0', '0');
|
|---|
| 60 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_show_mine', '1', '0');
|
|---|
| 61 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_show_pms', '1', '0');
|
|---|
| 62 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_sortby', 'board', '0');
|
|---|
| 63 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_user_digest_type', 'NONE', '0');
|
|---|
| 64 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_version', '2.2.2', '0');
|
|---|
| 65 | INSERT INTO om_config (config_name, config_value, is_dynamic) VALUES ('digests_weekly_digest_day', '0', '0');
|
|---|
| 66 |
|
|---|
| 67 | --
|
|---|
| 68 | -- Enable the forum digest module
|
|---|
| 69 | --
|
|---|
| 70 |
|
|---|
| 71 | INSERT INTO `om_modules` VALUES
|
|---|
| 72 | (191, 1, 1, '', 'ucp', 0, 55, 64, 'Digests', '', ''),
|
|---|
| 73 | (192, 1, 1, 'digests', 'ucp', 191, 56, 57, 'UCP_DIGESTS_BASICS', 'basics', ''),
|
|---|
| 74 | (193, 1, 1, 'digests', 'ucp', 191, 58, 59, 'UCP_DIGESTS_POSTS_SELECTION', 'posts_selection', ''),
|
|---|
| 75 | (194, 1, 1, 'digests', 'ucp', 191, 60, 61, 'UCP_DIGESTS_POST_FILTERS', 'post_filters', ''),
|
|---|
| 76 | (195, 1, 1, 'digests', 'ucp', 191, 62, 63, 'UCP_DIGESTS_ADDITIONAL_CRITERIA', 'additional_criteria', ''),
|
|---|
| 77 | (196, 1, 1, '', 'acp', 0, 267, 274, 'Digest Settings', '', ''),
|
|---|
| 78 | (197, 1, 1, 'board', 'acp', 196, 268, 269, 'ACP_DIGEST_GENERAL_SETTINGS', 'digest_general', 'acl_a_board'),
|
|---|
| 79 | (198, 1, 1, 'board', 'acp', 196, 270, 271, 'ACP_DIGEST_LOG_SETTINGS', 'digest_log', 'acl_a_board'),
|
|---|
| 80 | (199, 1, 1, 'board', 'acp', 196, 272, 273, 'ACP_DIGEST_USER_DEFAULT_SETTINGS', 'digest_user_defaults', 'acl_a_board'); |
|---|
