WordPress.org
Get WordPress

Plugin Directory

Changeset 3087273


Ignore:
Timestamp:
05/15/2024 03:58:52 PM (23 months ago)
Author:
mintunmedia
Message:

Update to version 2.3.5 from GitHub

Location:
groups-for-membermouse
Files:
16 edited
1 copied

Legend:

Unmodified
Added
Removed

  • groups-for-membermouse/tags/2.3.5/groups-for-membermouse.php

    r3012189 r3087273  
    44 * Plugin Name: Groups for MemberMouse
    55 * Description: Adds group support to MemberMouse. You can define different types of groups allowing a single customer to pay for multiple seats and members to join existing groups for free or for a price based on how you configure the group type. <strong>Requires MemberMouse to activate and use.</strong>
    6  * Version: 2.3.4
     6 * Version: 2.3.5
    77 * Author: Mintun Media
    88 * Plugin URI:  https://www.mintunmedia.com
    … …  
    2020
    2121define('MGROUP_TESTING', false);
     22
     23global $wpdb;
     24$useLegacyDB = get_option("mm-option-use-legacy-db", null); // checking for custom option that's set in MM ^3.0. Allowing for logic to set the appropriate DB prefix
     25define('MGROUPS_PREFIX', $useLegacyDB === null || $useLegacyDB == 1 ? '' : $wpdb->prefix);
    2226
    2327/**

  • groups-for-membermouse/tags/2.3.5/includes/change_group_cost.php

    r2856767 r3087273  
    2222
    2323    $costVal = 0;
    24     $productSql     = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$levelId."' ORDER BY p.name ASC";
     24    $productSql     = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$levelId."' ORDER BY p.name ASC";
    2525    $productResults = $wpdb -> get_results($productSql);
    2626    echo '<td>';

  • groups-for-membermouse/tags/2.3.5/includes/class.shortcodes.php

    r2857907 r3087273  
    149149      <?php if ($status_type != 'inactive') {
    150150        echo $edit_group_name_link;
    151      
     151
    152152        if ($signup_link_control != 'hide') {
    153153          echo $signup_link_content;
    … …  
    159159    </div>
    160160
    161     <!-- TODO create a JS action that refreshes the page & changes the query param for 'search'. -->
     161  <!-- TODO create a JS action that refreshes the page & changes the query param for 'search'. -->
    162162    <div class="search-input-container">
    163163      <input type="text" id="members-search-input<? echo '-'.$count ?>" placeholder="Search Members by Email or Name" aria-placeholder="Search Members by Email or Name" value="<?php if($count == $countID) { echo $search; } ?>">
    … …  
    176176        $userResult    = $wpdb->get_row($userSql);
    177177        $registered    = $userResult->user_registered;
    178         $memSql        = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     178        $memSql        = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    179179        $memResult    = $wpdb->get_row($memSql);
    180180        $firstName     = $memResult->first_name;
    … …  
    183183        $phone         = empty($memResult->phone) ? "&mdash;" : $memResult->phone;
    184184        $membershipId  = $memResult->membership_level_id;
    185         $levelSql     = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     185        $levelSql     = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    186186        $levelResult  = $wpdb->get_row($levelSql);
    187187        $redirecturl      = "";
    … …  
    255255      <div class="member-count">
    256256        <p>
    257         <? echo ($status_type == 'inactive') ? 'Deactivated Members: ' : 'Members: ';
    258         echo sizeof($filteredData);
    259         if($status_type != 'inactive') { echo '/'. $group_size; } ?>
     257          <? echo ($status_type == 'inactive') ? 'Deactivated Members: ' : 'Members: ';
     258          echo sizeof($filteredData);
     259          if($status_type != 'inactive') { echo '/'. $group_size; } ?>
    260260        </p>
    261261      </div>
    … …  
    487487            $userResult    = $wpdb->get_row($userSql);
    488488            $registered    = $userResult->user_registered;
    489             $memSql        = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     489            $memSql        = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    490490            $memResult    = $wpdb->get_row($memSql);
    491491            $firstName     = $memResult->first_name;

  • groups-for-membermouse/tags/2.3.5/includes/config.php

    r2856767 r3087273  
    9898    <tbody>
    9999<?php   foreach($results as $res):
    100             $leadermemSql       = "SELECT name FROM mm_membership_levels WHERE id = '".$res -> leader_memlevel."'";
     100            $leadermemSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '".$res -> leader_memlevel."'";
    101101            $leadermemResult    = $wpdb -> get_row($leadermemSql);
    102102            $leaderCost         = "";
    103103            if(!empty($res -> group_leader_cost)):
    104                 $leaderSql          = "SELECT name FROM mm_products WHERE id = '".$res -> group_leader_cost."'";
     104                $leaderSql          = "SELECT name FROM ". MGROUPS_PREFIX ."mm_products WHERE id = '".$res -> group_leader_cost."'";
    105105                $leaderResult       = $wpdb -> get_row($leaderSql);
    106106                $leaderCost         = $leaderResult -> name;
    107107            endif;
    108108
    109             $membermemSql       = "SELECT name FROM mm_membership_levels WHERE id = '".$res -> member_memlevel."'";
     109            $membermemSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '".$res -> member_memlevel."'";
    110110            $membermemResult    = $wpdb -> get_row($membermemSql);
    111111            $memberCost         = "";
    112112            if(!empty($res -> group_member_cost)):
    113                 $memberSql          = "SELECT name FROM mm_products WHERE id = '".$res -> group_member_cost."'";
     113                $memberSql          = "SELECT name FROM ". MGROUPS_PREFIX ."mm_products WHERE id = '".$res -> group_member_cost."'";
    114114                $memberResult       = $wpdb -> get_row($memberSql);
    115115                $memberCost         = $memberResult -> name;
    … …  
    153153        <h3>Notices</h3>
    154154        <table class="widefat" id="mm-data-grid">
    155             <thead>
     155        <thead>
    156156                <tr>
    157157                    <th>Name</th>

  • groups-for-membermouse/tags/2.3.5/includes/create_group.php

    r2856767 r3087273  
    3333    endif;
    3434endif;
    35 $leaderSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$leader_memlevel."' ORDER BY p.name ASC";
     35$leaderSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$leader_memlevel."' ORDER BY p.name ASC";
    3636$leaderResults  = $wpdb -> get_results($leaderSql);
    3737
    38 $memberSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$member_memlevel."' ORDER BY p.name ASC";
     38$memberSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$member_memlevel."' ORDER BY p.name ASC";
    3939$memberResults  = $wpdb -> get_results($memberSql);
    4040?>
    … …  
    7777                            <i class="fa fa-circle-o-notch fa-spin fa-2x" aria-hidden="true"></i>
    7878                        </div>
    79 
    8079                    </div>
    8180                    <div class="groupError" id="leadermemlevelErr"></div>

  • groups-for-membermouse/tags/2.3.5/includes/manage_groups.php

    r2856767 r3087273  
    126126                $userResult     = $wpdb->get_row($userSql);
    127127                $registered     = $userResult->user_registered;
    128                 $memSql             = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     128                $memSql             = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    129129                $memResult      = $wpdb->get_row($memSql);
    130130                $firstName      = $memResult->first_name;
    … …  
    134134                $statusId       = $memResult->status;
    135135                $membershipId   = $memResult->membership_level_id;
    136                 $levelSql       = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     136                $levelSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    137137                $levelResult    = $wpdb->get_row($levelSql);
    138138                $membershipName = $levelResult->name;

  • groups-for-membermouse/tags/2.3.5/includes/manage_groups_admin.php

    r2856767 r3087273  
    157157                $userResult     = $wpdb->get_row($userSql);
    158158                $registered     = $userResult->user_registered;
    159                 $memSql           = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     159                $memSql           = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    160160                $memResult      = $wpdb->get_row($memSql);
    161161                $firstName      = $memResult->first_name;
    … …  
    163163                $email            = $userResult->user_email;
    164164                $membershipId   = $memResult->membership_level_id;
    165                 $levelSql       = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     165                $levelSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    166166                $levelResult    = $wpdb->get_row($levelSql);
    167167                $membershipName = $levelResult->name;

  • groups-for-membermouse/tags/2.3.5/readme.txt

    r2867087 r3087273  
    33Tags: membermouse, member management, membership site, groups, mm groups, groups for membermouse, membermouse groups
    44Requires at least: 4.8
    5 Tested up to: 5.9
     5Tested up to: 6.5.3
    66Requires PHP: 5.6
    77Stable tag: trunk
    … …  
    7070== Changelog ==
    7171
     722.3.5
     73- BUG FIX: There was a compatibility bug when using Membermouse 3.0 and up due to their database changes. This bug has been fixed and backwards compatibility and support has been added to prevent issues if running a membermouse version prior to 3.0 and up.
     74
    72752.3.2
    7376- BUG FIX: Fixed a PHP8 compatibility issue causing issues when creating a group leader

  • groups-for-membermouse/trunk/groups-for-membermouse.php

    r3012189 r3087273  
    44 * Plugin Name: Groups for MemberMouse
    55 * Description: Adds group support to MemberMouse. You can define different types of groups allowing a single customer to pay for multiple seats and members to join existing groups for free or for a price based on how you configure the group type. <strong>Requires MemberMouse to activate and use.</strong>
    6  * Version: 2.3.4
     6 * Version: 2.3.5
    77 * Author: Mintun Media
    88 * Plugin URI:  https://www.mintunmedia.com
    … …  
    2020
    2121define('MGROUP_TESTING', false);
     22
     23global $wpdb;
     24$useLegacyDB = get_option("mm-option-use-legacy-db", null); // checking for custom option that's set in MM ^3.0. Allowing for logic to set the appropriate DB prefix
     25define('MGROUPS_PREFIX', $useLegacyDB === null || $useLegacyDB == 1 ? '' : $wpdb->prefix);
    2226
    2327/**

  • groups-for-membermouse/trunk/includes/change_group_cost.php

    r2856767 r3087273  
    2222
    2323    $costVal = 0;
    24     $productSql     = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$levelId."' ORDER BY p.name ASC";
     24    $productSql     = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$levelId."' ORDER BY p.name ASC";
    2525    $productResults = $wpdb -> get_results($productSql);
    2626    echo '<td>';

  • groups-for-membermouse/trunk/includes/class.shortcodes.php

    r2857907 r3087273  
    149149      <?php if ($status_type != 'inactive') {
    150150        echo $edit_group_name_link;
    151      
     151
    152152        if ($signup_link_control != 'hide') {
    153153          echo $signup_link_content;
    … …  
    159159    </div>
    160160
    161     <!-- TODO create a JS action that refreshes the page & changes the query param for 'search'. -->
     161  <!-- TODO create a JS action that refreshes the page & changes the query param for 'search'. -->
    162162    <div class="search-input-container">
    163163      <input type="text" id="members-search-input<? echo '-'.$count ?>" placeholder="Search Members by Email or Name" aria-placeholder="Search Members by Email or Name" value="<?php if($count == $countID) { echo $search; } ?>">
    … …  
    176176        $userResult    = $wpdb->get_row($userSql);
    177177        $registered    = $userResult->user_registered;
    178         $memSql        = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     178        $memSql        = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    179179        $memResult    = $wpdb->get_row($memSql);
    180180        $firstName     = $memResult->first_name;
    … …  
    183183        $phone         = empty($memResult->phone) ? "&mdash;" : $memResult->phone;
    184184        $membershipId  = $memResult->membership_level_id;
    185         $levelSql     = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     185        $levelSql     = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    186186        $levelResult  = $wpdb->get_row($levelSql);
    187187        $redirecturl      = "";
    … …  
    255255      <div class="member-count">
    256256        <p>
    257         <? echo ($status_type == 'inactive') ? 'Deactivated Members: ' : 'Members: ';
    258         echo sizeof($filteredData);
    259         if($status_type != 'inactive') { echo '/'. $group_size; } ?>
     257          <? echo ($status_type == 'inactive') ? 'Deactivated Members: ' : 'Members: ';
     258          echo sizeof($filteredData);
     259          if($status_type != 'inactive') { echo '/'. $group_size; } ?>
    260260        </p>
    261261      </div>
    … …  
    487487            $userResult    = $wpdb->get_row($userSql);
    488488            $registered    = $userResult->user_registered;
    489             $memSql        = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     489            $memSql        = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    490490            $memResult    = $wpdb->get_row($memSql);
    491491            $firstName     = $memResult->first_name;

  • groups-for-membermouse/trunk/includes/config.php

    r2856767 r3087273  
    9898    <tbody>
    9999<?php   foreach($results as $res):
    100             $leadermemSql       = "SELECT name FROM mm_membership_levels WHERE id = '".$res -> leader_memlevel."'";
     100            $leadermemSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '".$res -> leader_memlevel."'";
    101101            $leadermemResult    = $wpdb -> get_row($leadermemSql);
    102102            $leaderCost         = "";
    103103            if(!empty($res -> group_leader_cost)):
    104                 $leaderSql          = "SELECT name FROM mm_products WHERE id = '".$res -> group_leader_cost."'";
     104                $leaderSql          = "SELECT name FROM ". MGROUPS_PREFIX ."mm_products WHERE id = '".$res -> group_leader_cost."'";
    105105                $leaderResult       = $wpdb -> get_row($leaderSql);
    106106                $leaderCost         = $leaderResult -> name;
    107107            endif;
    108108
    109             $membermemSql       = "SELECT name FROM mm_membership_levels WHERE id = '".$res -> member_memlevel."'";
     109            $membermemSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '".$res -> member_memlevel."'";
    110110            $membermemResult    = $wpdb -> get_row($membermemSql);
    111111            $memberCost         = "";
    112112            if(!empty($res -> group_member_cost)):
    113                 $memberSql          = "SELECT name FROM mm_products WHERE id = '".$res -> group_member_cost."'";
     113                $memberSql          = "SELECT name FROM ". MGROUPS_PREFIX ."mm_products WHERE id = '".$res -> group_member_cost."'";
    114114                $memberResult       = $wpdb -> get_row($memberSql);
    115115                $memberCost         = $memberResult -> name;
    … …  
    153153        <h3>Notices</h3>
    154154        <table class="widefat" id="mm-data-grid">
    155             <thead>
     155        <thead>
    156156                <tr>
    157157                    <th>Name</th>

  • groups-for-membermouse/trunk/includes/create_group.php

    r2856767 r3087273  
    3333    endif;
    3434endif;
    35 $leaderSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$leader_memlevel."' ORDER BY p.name ASC";
     35$leaderSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$leader_memlevel."' ORDER BY p.name ASC";
    3636$leaderResults  = $wpdb -> get_results($leaderSql);
    3737
    38 $memberSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM mm_membership_level_products AS lp LEFT JOIN mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$member_memlevel."' ORDER BY p.name ASC";
     38$memberSql      = "SELECT lp.product_id AS product_id,p.id AS id,p.name AS name FROM ". MGROUPS_PREFIX ."mm_membership_level_products AS lp LEFT JOIN ". MGROUPS_PREFIX ."mm_products AS p ON lp.product_id = p.id WHERE lp.membership_id ='".$member_memlevel."' ORDER BY p.name ASC";
    3939$memberResults  = $wpdb -> get_results($memberSql);
    4040?>
    … …  
    7777                            <i class="fa fa-circle-o-notch fa-spin fa-2x" aria-hidden="true"></i>
    7878                        </div>
    79 
    8079                    </div>
    8180                    <div class="groupError" id="leadermemlevelErr"></div>

  • groups-for-membermouse/trunk/includes/manage_groups.php

    r2856767 r3087273  
    126126                $userResult     = $wpdb->get_row($userSql);
    127127                $registered     = $userResult->user_registered;
    128                 $memSql             = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     128                $memSql             = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    129129                $memResult      = $wpdb->get_row($memSql);
    130130                $firstName      = $memResult->first_name;
    … …  
    134134                $statusId       = $memResult->status;
    135135                $membershipId   = $memResult->membership_level_id;
    136                 $levelSql       = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     136                $levelSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    137137                $levelResult    = $wpdb->get_row($levelSql);
    138138                $membershipName = $levelResult->name;

  • groups-for-membermouse/trunk/includes/manage_groups_admin.php

    r2856767 r3087273  
    157157                $userResult     = $wpdb->get_row($userSql);
    158158                $registered     = $userResult->user_registered;
    159                 $memSql           = "SELECT * FROM mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
     159                $memSql           = "SELECT * FROM ". MGROUPS_PREFIX ."mm_user_data WHERE wp_user_id = '" . $gMemRes->member_id . "'";
    160160                $memResult      = $wpdb->get_row($memSql);
    161161                $firstName      = $memResult->first_name;
    … …  
    163163                $email            = $userResult->user_email;
    164164                $membershipId   = $memResult->membership_level_id;
    165                 $levelSql       = "SELECT name FROM mm_membership_levels WHERE id = '" . $membershipId . "'";
     165                $levelSql       = "SELECT name FROM ". MGROUPS_PREFIX ."mm_membership_levels WHERE id = '" . $membershipId . "'";
    166166                $levelResult    = $wpdb->get_row($levelSql);
    167167                $membershipName = $levelResult->name;

  • groups-for-membermouse/trunk/readme.txt

    r2867087 r3087273  
    33Tags: membermouse, member management, membership site, groups, mm groups, groups for membermouse, membermouse groups
    44Requires at least: 4.8
    5 Tested up to: 5.9
     5Tested up to: 6.5.3
    66Requires PHP: 5.6
    77Stable tag: trunk
    … …  
    7070== Changelog ==
    7171
     722.3.5
     73- BUG FIX: There was a compatibility bug when using Membermouse 3.0 and up due to their database changes. This bug has been fixed and backwards compatibility and support has been added to prevent issues if running a membermouse version prior to 3.0 and up.
     74
    72752.3.2
    7376- BUG FIX: Fixed a PHP8 compatibility issue causing issues when creating a group leader
Note: See TracChangeset for help on using the changeset viewer.