wzshop

Thanks for your reply. I understand what you mean. I found 2 bits of code which might be the part you mean.

$query = "SELECT ID FROM {$wpdb->users}";
          $user_ids = $wpdb->get_col($query,0);

          foreach ($user_ids as $user_id)
          {
            $profile = MnglUser::get_stored_profile_by_id($user_id);

and

$order_by  = ((!empty($order_by))?" ORDER BY {$order_by}":'');
    $limit_str = (($limit > 0)?" LIMIT {$offset},{$limit}":'');
    $query = "SELECT ID FROM {$wpdb->users} {$where}{$order_by}{$limit_str}";

    $user_ids = $wpdb->get_col($query,0);
    $profiles = array();

    if(empty($user_ids))
      return false;

    foreach ($user_ids as $user_id)
    {
      $curr_profile = MnglUser::get_stored_profile_by_id($user_id);

      if($curr_profile)
        $profiles[] = $curr_profile;
    }

    return $profiles;
  }

Is there any way you can help me further based upon the above info? Would really appreciate it!
Thanks a lot for yr time.

One more, final i promise, question. I use the mingle community plugin for my weblog. Now within that plugin there’s an option to show a directory (list) of all the members (usernames). Now what i want is to not only show the usernames, but also some other additional (user specific) info from another table.

Now i found the script that echo’s the usernames in mingle:

<?php

  $avatar_thumb_size = 64;

  if(is_array($profiles))
  {
    foreach ($profiles as $key => $profile)
    {
      $avatar_link = $profile->get_avatar($avatar_thumb_size);

      $full_name = $profile->screenname;

      if(!empty($search_query))
      {
        $full_name = preg_replace( "#({$search_query})#i", "<span class=\"mngl-search-match\">$1</span>", $full_name );
      }
?>

What i really would like is to also show information per user from the table: “wp_mngl_custom_field_values” and then echo the values where the field_id=’1′ and echo the value where the field_id=’2′.

Hope i made myself clear this time and that ur willing to help me out one more time;)

Thanks a lot again!
Kind regards,
Robbert

Waa, thanks a lot again.. it WORKS!

Thanks a lot!;)

Oops, sorry about that.
What i want seems to be quite simple.

The mingle database structure is like this:

field_id     user_id     value
1            1           Name
2            1           season
3            1           age
1            2           Name
2            2           season
3            2           age

Now what i want is to echo someones name, with the season value ‘winter’ from the table: wp_mngl_custom_field_values

So if season is winter, echo name.

Hope thats more clear, and thanks a lot for yr time!

Sorry to bother you again; but what if i want a more simple function (at least i thought it would be but still cant work it out):

What i would like is the function to echo a certain variable where the value of another field is “Winter” from 1 and the same table. Tried something like this:

<?php
$sql = "
SELECT value WHERE field_id ='2'
FROM wp_mngl_custom_field_values
WHERE value = 'Winter' AND field_id ='1'";
$logins = $wpdb->get_results($sql);
foreach ($logins as $login) {
echo $login->value;
}
?>

Could you pls help me out 1 more time?
Thanks a lot in advance!

@keesiemeijer and @vtxyzzy thanks alot, worked out!

Cheers;)

Hi vtxyzzy,

First of all, thanks a lot for your help. I wasn’t really aware of the JOIN possibility so made me a bit smarter already;)

I tested the script and watched for typos, but the echo gave me 0 results, still i am sure that i do have 2 users with that certain value. Maybe you know what’s the error?

Thanks a lot in advance!

thanks for your reply, but i only found plugins where i was able to manually add my posts to social media.. Quite some work, so i was wondering if there was a tool available that could do that automaticly;)

thanks again.

He guys,

This really looks great!
I installed the wp private message plugin and I added the code to my profile page of alkivia. I use alkivia in comination with theme my profile in order to customize the profile page.

It adds this link: https://www.xxx.nl/v2/wp-admin/profile.php?page=wp-private-messages/wpu_private_messages.php&wpu=newpm&id=3&name=wzshop

But because of theme my profile the link redirects to https://www.nownet.nl/v2/profile/?page=wp-private-messages/wpu_private_messages.php&wpu=newpm&id=3&name=wzshop

which means i get a 404. What can/should i do about this?

Thanks A LOT!! and looking forward to the Trebour extension as well!

sorry, found it myself

<?php echo get_avatar($user->ID, ‘140’);?>

Thanks for your reply. Tried buddypress a while ago but didn’t really find it a easy to customize script. Can’t find the pm system? and don’t understand the groups/forum thing…? Maybe someone can explain or someone has other suggestions?

Thanks a lot!

thanks for your quick answer.. ive found these already but i am actually looking for one with featured thumbnails on the side.. so people can click on them and read more about that specific thumbail..

Hope you know what i mean;) any ideas?