* * This template is called from single-board.php and is only accessed when * the URL endpoint is 'members' */ if ($members) { echo '<main>'; foreach ($members as $member) { // get user info $member_id = $member['board_members_user']['ID']; $member_screen_name = $member['board_members_user']['display_name']; $member_username = $member['board_members_user']['user_nicename']; $member_description = $member['board_members_user']['user_description']; $member_home_url = get_bloginfo('home') . '/author/' . $member_username; // count stats $quotecount = count_user_posts_by_type($member_id, 'quote'); $boardcount = count_user_posts_by_type($member_id, 'board'); //$follower_count = $wpdb->get_var( "SELECT COUNT(*) FROM wp_qb_followers WHERE follower_id = '$member_id'" ); // member thumbnail if (has_wp_user_avatar($member_id)) { $avatar = get_wp_user_avatar_src($member_id, 80); } else { $avatar = DEFAULT_THUMBNAIL; } // member background if ($background_id = get_user_meta($member_id, 'user_background', true)) { $upload_directory = wp_upload_dir(); $background_src = $wpdb->get_var("SELECT meta_value FROM {$wpdb->postmeta} WHERE post_id = '" . $background_id . "' AND meta_key = '_wp_attached_file'"); $user_background = $upload_directory['baseurl'] . '/' . $background_src; } else { $user_background = DEFAULT_BACKGROUND; }
<span><?php if (bp_is_active('xprofile')) { echo bp_get_profile_field_data('field=' . $ifield . '&user_id=' . $instructor); } ?> </span> <h3><?php echo bp_core_get_userlink($instructor); ?> </h3> <strong><a href="<?php echo get_author_posts_url($instructor) . 'instructing-courses/'; ?> "><?php _e('Courses by Instructor ', 'wplms_modern'); echo '<span>' . count_user_posts_by_type($instructor, 'course') . '</span></a>'; ?> </strong> </div> <?php ?> </div> <?php } } else { echo '<div id="message"><p>' . __('No Instructors found.', 'wplms_modern') . '</p></div>'; } ?> </div> </div>
function bp_course_get_instructor_course_count_for_user($id = NULL) { if (!isset($id)) { $id = bp_loggedin_user_id(); } if (function_exists('count_user_posts_by_type')) { return count_user_posts_by_type($id, BP_COURSE_SLUG); } else { return 0; } }
<span> ( <span><?php echo $points == "" ? 0 : $points; ?> </span> ) </span></a></li> <?php } } ?> <li><i class="icon-file-alt"></i><a href="<?php echo esc_url(add_query_arg("u", esc_attr($get_query_var), get_page_link(vpanel_options('post_user_page')))); ?> "><?php _e("Posts", "vbegy"); ?> <span> ( <span><?php echo count_user_posts_by_type($user_login->ID, "post"); ?> </span> ) </span></a></li> <li><i class="icon-asterisk"></i><?php _e("Best Answers", "vbegy"); ?> <span> ( <span><?php echo $the_best_answer == "" ? 0 : $the_best_answer; ?> </span> ) </span></li> <?php if (vpanel_options("show_point_favorite") == 1 || $owner == true) { ?> <li class="authors_follow"><i class="icon-user-md"></i><a href="<?php echo esc_url(add_query_arg("u", esc_attr($get_query_var), get_page_link(vpanel_options('i_follow_user_page')))); ?>
include TEMPLATEPATH . '/header.php'; } $base_author_url = get_bloginfo('home') . '/author/' . $user_url_nicename; if ($current_page_user_id == $current_user->ID) { $home_feed_url = get_bloginfo('home'); $post_status = array('private', 'publish'); $public_only = false; } else { $home_feed_url = $base_author_url; $post_status = 'publish'; $public_only = true; } $count_faves = "SELECT COUNT(*)\r\n FROM {$wpdb->postmeta}\r\n INNER JOIN {$wpdb->posts} ON post_id = ID\r\n WHERE meta_key LIKE 'quote_fave_%_quote_fave_user'\r\n AND meta_value = '{$current_page_user_id}'\r\n AND post_status <> 'trash'"; // stats for current user $author_quote_count = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->postmeta} WHERE meta_key = 'quote_author' AND meta_value = {$current_page_user_id}"); $current_user_boards = count_user_posts_by_type($current_page_user_id, 'board', $public_only); $current_user_faves = $wpdb->get_var($count_faves); // $current_user_followers = $wpdb->get_var( "SELECT COUNT(*) FROM wp_qb_followers WHERE user_id = '$current_page_user_id'" ); // $current_user_following = $wpdb->get_var( "SELECT COUNT(*) FROM wp_qb_followers WHERE follower_id = '$current_page_user_id'" ); // used a couple of times $upload_directory = wp_upload_dir(); // get user background if ($background_id = get_user_meta($current_page_user_id, 'user_background', true)) { $background_src = $wpdb->get_var("SELECT meta_value FROM {$wpdb->postmeta} WHERE post_id = '" . $background_id . "' AND meta_key = '_wp_attached_file'"); $author_cover_photo = $upload_directory['baseurl'] . '/' . $background_src; } else { $author_cover_photo = DEFAULT_BACKGROUND; } // determine what kind of author we're viewing (get current author role) $author_info = get_user_by('id', $current_page_user_id); $author_role = implode(', ', $author_info->roles);
* * This template is called from author.php and is only accessed when * the URL endpoint is 'following' */ $query = "SELECT * FROM wp_qb_followers WHERE follower_id = '{$current_page_user_id}'"; if ($followings = $wpdb->get_results($query)) { foreach ($followings as $following) { $following = get_user_by('id', $following->user_id); $following_url = home_url('/') . 'author/' . $following->user_nicename; // get user avatar, and specify a fallback if (!($following_avatar = get_wp_user_avatar_src($following->ID, 80))) { $following_avatar = DEFAULT_THUMBNAIL; } // count stats $quotecount = count_user_posts_by_type($following->ID, 'quote'); $boardcount = count_user_posts_by_type($following->ID, 'board'); // member background if ($background_id = get_user_meta($following->ID, 'user_background', true)) { $upload_directory = wp_upload_dir(); $background_src = $wpdb->get_var("SELECT meta_value FROM {$wpdb->postmeta} WHERE post_id = '" . $background_id . "' AND meta_key = '_wp_attached_file'"); $user_background = $upload_directory['baseurl'] . '/' . $background_src; } else { $user_background = DEFAULT_BACKGROUND; } // description if (strlen($following->description = get_user_meta($following->ID, 'description', true)) > 200) { $following->description = substr($following->description, 0, 200) . '...'; } elseif (empty($following->description)) { $following->description = '<em>Alas, this user has nothing interesting to say.</em>'; } // determine if current user is following this member, and show the proper button