members-loop.php

<?php

/**
 * BuddyPress - Members Loop
 *
 * Querystring is set via AJAX in _inc/ajax.php - bp_legacy_theme_object_filter()
 *
 * @package BuddyPress
 * @subpackage bp-legacy
 */

?>

<?php do_action( 'bp_before_members_loop' ); ?>

<?php if ( bp_has_members( bp_ajax_querystring( 'members' ) ) ) : ?>

    <ul id="members-list" class="item-list" role="main">

            <?php

            if($_GET['get']):
                $query = $_GET['get'];
                $user_results = new WP_User_Query(
                        array(
                            'search' => "$query*",
                            'search_columns' => array( 'display_name'),
                            'meta_query' => array (
                                'relation' => 'OR',
                                array(
                                    'key'       => 'first_name',
                                    'value'     => "$query",
                                    'compare'   => 'LIKE'
                                )
                            )
                ));
                $reults_count = count($user_results->results);
                var_dump($user_results);

                foreach ( $user_results->results as $user ):
                    $author_id = $user->ID;

                    global $wpdb;
                    $bp_groups = $wpdb->prefix.'bp_groups';
                    $bp_groups_members = $wpdb->prefix.'bp_groups_members';
                    $bp_groups_groupmeta = $wpdb->prefix.'bp_groups_groupmeta';

                    $sql = "SELECT `$bp_groups`.`name` FROM `$bp_groups_members` INNER JOIN `$bp_groups_groupmeta` ON `$bp_groups_members`.`group_id` = `$bp_groups_groupmeta`.`group_id` LEFT JOIN `$bp_groups` ON `$bp_groups`.`id` = `$bp_groups_members`.`group_id` WHERE `meta_key`='gtags_group_tags' AND (`meta_value` LIKE '%Associate members%' OR `meta_value` LIKE '%Label members%') AND `user_id` = ".$author_id." LIMIT 0,1";



                    $company = $wpdb->get_var($sql);
                                ?>

            <li <?php bp_group_class(); ?>>
                    <a href="<?php echo home_url().'/members/'.$user->user_login; ?>">
                        <?php echo bp_core_fetch_avatar ( array( 'item_id' => $user->ID) ); ?>
                    </a>
                    <div class="txtb clearfix">
                        <a href="<?php echo home_url().'/members/'.$user->user_login; ?>" title="<?php echo trim($user->display_name);?>">
                            <strong><?php echo trim($user->display_name);; ?></strong><br>
                            <?php echo $company; ?>

                        </a>
                            <div class="action">
                                <?php do_action( 'bp_directory_members_actions' ); ?>
                            </div>
                    </div>
                </li>
                                <?php

                            endforeach;

            else:

            ?>

    <?php while ( bp_members('type=alphabetical') ) : bp_the_member(); ?>

                <li <?php bp_group_class(); ?>>
                    <a href="<?php bp_member_permalink(); ?>">
                        <?php bp_member_avatar(); ?>
                    </a>
                    <div class="txtb clearfix">
                        <a href="<?php bp_member_permalink(); ?>" title="<?php bp_member_name(); ?>">
                            <strong><?php echo xprofile_get_field_data('name', bp_get_member_user_id()); ?></strong> <?php bp_member_last_active(); ?><br>
                            <?php
                            $author_id = bp_get_member_user_id();

                            global $wpdb;
                            $bp_groups = $wpdb->prefix.'bp_groups';
                            $bp_groups_members = $wpdb->prefix.'bp_groups_members';
                            $bp_groups_groupmeta = $wpdb->prefix.'bp_groups_groupmeta';

                            $sql = "SELECT `$bp_groups`.`name` FROM `$bp_groups_members` INNER JOIN `$bp_groups_groupmeta` ON `$bp_groups_members`.`group_id` = `$bp_groups_groupmeta`.`group_id` LEFT JOIN `$bp_groups` ON `$bp_groups`.`id` = `$bp_groups_members`.`group_id` WHERE `meta_key`='gtags_group_tags' AND (`meta_value` LIKE '%Associate members%' OR `meta_value` LIKE '%Label members%') AND `user_id` = ".$author_id." LIMIT 0,1";



                            $company = $wpdb->get_var($sql);
                            ?>


                                <?php echo $company; ?>

                        </a>
                            <div class="action">
                                <?php do_action( 'bp_directory_members_actions' ); ?>
                            </div>
                    </div>
                </li>
    <?php endwhile;
        endif; ?>

    </ul>


    <?php if(!$_GET['get']): ?>
        <div id="pag-top" class="pagination">

        <div class="pagination-links" id="member-dir-pag-top">

            <?php bp_members_pagination_links(); ?>

        </div>

    </div>
    <?php endif; ?>

<?php else: ?>

    <div id="message" class="info">
        <p><?php _e( "Sorry, no members were found.", 'buddypress' ); ?></p>
    </div>

<?php endif; ?>