Thread: Administrative and Maintenance Tools - Commbull (Community Bulletin) 5.1b
View Single Post
  #114  
Old 03-12-2010, 01:28 PM
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Posts: 2,601
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by inciarco View Post
Interesting Newsletter Mod.

I have 3 questions:

-1. Is there a way/option to Exclude Certain Usergroups from Getting the Newsletter?
(this is very important because even if the users are subscribed to threads, for some usergroups would be nice for them Not to receive Newsletters).
Yes.

Quote:
Originally Posted by inciarco View Post
-2. How can I Massive Disable the Option "Receive Community Bulletin Newsletters"?
(I can see that is Enabled by Default but I need to disable it for Existing Users once this Mod Installed)
You can use a MySQL database query:

Code:
UPDATE {prefix-if-used}user SET receivebulletin = '0';
Quote:
Originally Posted by inciarco View Post
-3. How can I choose for the "Receive Community Bulletin Newsletters" to be Disabled by Default?
(I think is better to let the Users Choose if the want to be Included on the Newsletter and not to Force them to Receive the First One to Choose to be Excluded)
You can use phpMyAdmin to modify table user.receivebulletin to set default to 0. That way any new members will also have it set to default.

Or, if you haven't yet installed it,

1. edit product-Commbull.xml
2. at around line 22, find

Code:
if (!isset($user_cols['receivebulletin'])) $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null");
3. change the '1' to '0'

Code:
if (!isset($user_cols['receivebulletin'])) $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '0' not null");
4. at around line 27, find

Code:
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET receivebulletin=1");
5. change to

Code:
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET receivebulletin=0");
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01268 seconds
  • Memory Usage 1,780KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete