Thread: Forum Display Enhancements - Thread Listing Background Colors Like vBulletin.org
View Single Post
  #68  
Old 06-15-2008, 10:04 PM
PGAmerica PGAmerica is offline
 
Join Date: Mar 2008
Posts: 405
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, it seems that all are agreed that we need to allow for the users to have this option set to "yes" be default. And there are ways to do an sql query to set all current users to "yes", but this does not solve the problem with new users.

OK, I figured it out. If you want to make all the options set to "yes" by default. That is,
  • Enable for this forum category thread listing background colors? (Forum Manager)
  • Can this Usergroup Use the Forumdisplay Thread Listing Background Color? (Usergroup Manager)
  • Thread Listing Background Color Legend (UserCP)
All you have to do is the following:
Step 1:
Edit the "product-thread_listing_bgcolors_english.xml" file
Step 2:
Look for
Code:
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD bgcolors INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL"); 
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bgcolors INT( 10 ) UNSIGNED DEFAULT '0 NOT NULL");  
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN bgcolorspermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
and replace it with
Code:
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD bgcolors INT( 10 ) UNSIGNED DEFAULT '1' NOT NULL"); 
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bgcolors INT( 10 ) UNSIGNED DEFAULT '1' NOT NULL");  
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN bgcolorspermissions INT( 10 ) UNSIGNED DEFAULT '1' NOT NULL");
Step 3:
Upload the new product via the "Manage Products" link in your ACP
Step 4:
Enter the "Usergroup Manager" and edit any of the usergroups. This will rebuild the BitFields.

If you have already done this, just uninstall it, make the changes and then reinstall it.

It just worked for me perfectly.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01287 seconds
  • Memory Usage 1,767KB
  • 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
  • (2)bbcode_code
  • (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