How Add-Ons Modify the System
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000106888
This article outlines the system-level actions that occur when specific add-ons are activated, deactivated, or become inactive. Each add-on may trigger updates to database tables, disable outdated custom forms or widgets, or introduce new structural elements required for its functionality.
Understanding these adjustments provides clarity on how the platform maintains compatibility, prevents conflicts, and ensures that the most current features operate as intended.
Changes on Add-On Activation
Activating an add-on triggers a series of system updates, including data changes and the disabling of older custom forms or widgets when required.
One-Click Google Login
- Custom Forms Disabled: whmcs_signup_paid (renamed to whmcs_signup_paid_old), signup_free (renamed to signup_free_old), member_login (renamed to member_login_old)
- Custom Widgets Disabled: Bootstrap Theme - Success Page - Free Member Sign Up, Bootstrap Theme Framework, Bootstrap Theme - Account - Member Dashboard
- Data Updated: users_data table - google_id column added (if doesn't exist)
Automatic Lead Matching
- Data Updated: data_flows table created (if doesn't exist)
Reply to Member Reviews
- Custom Widgets Disabled: Account - Save Actions, Bootstrap Theme - Account - Reviews, Bootstrap Theme - Member Profile - Read Review
- Data Updated: data_categories table - profile_header, profile_results_layout, profile_footer updated for Reviews Post Type; category_header, search_results_div, category_footer updated for Reviews Post Type
Auto-Recurring Events
- Custom Forms Disabled: event_fields (renamed to event_fields_old, form_title appended with " old")
- Custom Widgets Disabled: Search - Post - Search Query, Bootstrap Theme - Display - Events Calendar, Bootstrap Theme - Footer - Scripts, Bootstrap Theme - Function - Events Calendar JSON Array, Bootstrap Theme - Account - Feature Body datatable, Bootstrap Theme - Single Post Page
- Data Updated: data_posts table - recurring_type column added; data_categories table - search_results_div and search_results_layout updated for event_fields
Click to Call Members
- Data Updated: data_categories table - search_results_div and category_footer updated for Member Listings Post Type
Member Profile Analytics
- Data Updated: data_categories table - search_results_div and category_footer updated for Member Listings Post Type
Lead Price by Category
- Data Updated: list_professions table - lead_price column added (DECIMAL(10,2)); list_services table - lead_price column added (DECIMAL(10,2))
Featured Blog Article Slider
- Data Updated: data_categories table - new record inserted for blog_article_fields
Pin Featured Posts
- Data Updated: data_posts table - sticky_post and sticky_post_expiration_date columns added; users_portfolio_groups table - sticky_post and sticky_post_expiration_date columns added
Private Member Chat
- Data Updated: chat_message_items table created (if doesn't exist); chat_message_threads table created (if doesn't exist)
Global Website Search
- Data Updated: list_seo_template table - new record inserted for seo_type = 'search_results_all'
Multi-Member Manager
- Data Updated: users_data table - parent_id column added (INT(11)); data_categories table - new record inserted for Sub Accounts Post Type
Predictive Keyword Search
- Data Updated: data_posts table - all records deleted where data_type = "98"; users_meta table - all records deleted where database = "data_posts" AND key LIKE "au%"
Billing Reminder Emails and Settings
- Data Updated: email_automation_settings table created
Community Comments
- Data Updated: comments table created
Bookmark My Favorites
- Data Updated: users_favorite table created
Event Calendar
- Data Updated: list_seo table - new record inserted for events-calendar page
Personal Post Feed
- Data Updated: list_seo_template table - new record inserted for seo_type = 'search_results_favorites'
Changes on Add-On Deactivation
When an add-on is deactivated, the system performs specific cleanup or reset actions to remove related configurations and return affected features to their default state.
Personal Post Feed
- Data Updated: list_seo_template table - record deleted where seo_type = 'search_results_favorites'; data_posts table - records deleted where data_type = 98 and post_title = 'personal_post_feed'
Featured Blog Article Slider
- Settings Updated: website_design_settings table - setting_value cleared where setting_value = 'Bootstrap Theme - Homepage - Featured Blog Posts Slider'
Results View Toggle
- Settings Updated: website_design_settings table - setting_value set to '0' where (setting_name = 'custom_198' AND setting_value = '1') OR (setting_name = 'custom_160' AND setting_value = '1')
Google Map Search Results
- Settings Updated: website_design_settings table - setting_value set to '0' where setting_name = 'custom_160' AND setting_value = '2'
Members-Only Content
- Data Updated: subscription_types table - search_membership_permissions updated to prepend 'visitor,' where it doesn't already contain 'visitor'
Hidden Member Profiles
- Data Updated: subscription_types table - search_membership_permissions updated (if doesn't contain "visitor": set to empty string; if contains "visitor": set to 'visitor', removing hidden membership plan IDs)
Global Website Search
- Data Updated: list_seo_template table - record deleted where seo_type = 'search_results_all'; data_posts table - records deleted where data_type = 98 and post_title = 'global_search'
Changes After Add-Ons Become Inactive
If an add-on becomes inactive, automated maintenance processes run in the background to keep related data current and prevent unnecessary buildup over time.
Admin Activity Tracking (When Inactive)
- Data Updated: website_notifications table - all records deleted that are more than 30 days old
- Note: This runs on every Admin Dashboard load when the add-on is inactive, automatically cleaning up old notification history older than 30 days
