Forum Replies Created
-
(I need the quotes around $group, so
$more_sql[‘group’] = $wpdb->prepare(“cm.meta_key = ‘groups’ AND cm.meta_value LIKE ‘%%”$group”%%'”);
print_r($more_sql[‘group’]);
returns
cm.meta_key = ‘groups’ AND cm.meta_value LIKE ‘%”8″%
as it should (thanks !)
then
print_r(“SELECT DISTINCT {$fields_to_get}
FROM {$bp->classifieds->table_name} c
INNER JOIN {$bp->classifieds->table_name_classifiedmeta} cm ON cm.classified_id = c.id
{$query_where}
{$group_by}
{$sort_by}
{$order}
{$pag_sql}
“);
works but not with prepare :
print_r($wpdb->prepare( “SELECT DISTINCT {$fields_to_get}
FROM {$bp->classifieds->table_name} c
INNER JOIN {$bp->classifieds->table_name_classifiedmeta} cm ON cm.classified_id = c.id
{$query_where}
{$group_by}
{$sort_by}
{$order}
{$pag_sql}
“));
which returns nothing…
help!
I’ve done a plugin for that.
BuddyPress is fun
https://buddypress.org/forums/topic/new-plugin-buddypress-real-names
Here’s a piece of code to replace the displayed nickname by name+firstname.
change $first_name_field_id and $name_field_id to match your fields.
/**
NAME + FIRSTNAME | START
*/
function user_name_firstname($fullname,$user_id=false) {
global $bp;
global $site_members_template;
$first_name_field_id=40;
$name_field_id=39;
if ( !$user_id ) $user_id=bp_get_the_site_member_user_id();
if ( function_exists(‘xprofile_install’) ) {
$first_name= xprofile_get_field_data($first_name_field_id, $user_id );
$name = xprofile_get_field_data($name_field_id, $user_id );
if ($name) {
$fullname = $name;
if ($first_name) $fullname.
‘ ‘.$first_name;}
wp_cache_set( ‘bp_user_fullname_’ . $user_id, $fullname, ‘bp’ );
}
return apply_filters( ‘user_name_firstname’, $fullname );
}
add_filter( ‘bp_get_the_site_member_name’, ‘user_name_firstname’,9);
/**
NAME + FIRSTNAME | END
*/
Now I have to find a way to order the directory member results by Name+Firstname… Any idea ?
Well, I agree with WordPressfan…
But i’m still stuck
