[MOD] Buddy List || Friend List

[Lucifix]

Hi great mod!

Is there a way to show user friends listed directly in his profile?

[thunderstrike]

Is there a way to show user friends listed directly in his profile?

Is URL link to point at friends from profile ?

[Lucifix]

I manage to add friends id in profile but I don't have time to change id to name:

In member.php before //--- END FRIENDSLIST MOD --- ADD:

Code: [Select]

$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id = ".$user_row['user_id']."";
    $user_friends_info = $site_db->query_firstrow($sql);
    $num_rows_all = 0;
    if (!empty($user_friends_info['user_friend_ids'])) {
    $friends_id_sql = str_replace(" ", "<br>", trim($user_friends_info['user_friend_ids']));
//here you need to make while and if sentece to get user name

}else{
$friends_id_sql=0;
}

    $site_template->register_vars(array(
          "lang_friendslist_add", $lang['lang_friendslist_add'],
  "user_friends" => $friends_id_sql
    ));
then in your profile template add:

Code: [Select]

{user_friends}

[thunderstrike]

Can no while with query_firstrow - only query.

change id to name

$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id = ".$user_row['user_id']."";
    $result = $site_db->query_firstrow($sql);

for:

if (empty($user_select_row_cache)) {
$sql = "SELECT " . get_user_table_field("", "user_id") . get_user_table_field(", ", "user_name") . "
           FROM ".USERS_TABLE."
           WHERE " . get_user_table_field("", "user_id") . " = ".$user_row['user_id'];
$user_friends_info = $site_db->query($sql);
$user_select_row_cache = array();
while ($row = $site_db->fetch_array($result)) {
    // Change ID to name.
    $user_select_row_cache[$row[$user_table_fields['user_id']]] = $row[$user_table_fields['user_name']];
}

[Lucifix]

I made it work with this code:

Code: [Select]

$sql_friends = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id = ".$user_row['user_id']."";
$friends_row = $site_db->query_firstrow($sql_friends);

  if (!empty($friends_row['user_friend_ids'])) {
    $split_keywords = explode(" ", $friends_row['user_friend_ids']);
    $friends_id = "";
    foreach ($split_keywords as $key => $val) {
$sql1 = "SELECT user_name
        FROM ".USERS_TABLE."
        WHERE user_id = $val";
$friends_name = $site_db->query_firstrow($sql1);
$fname = $friends_name['user_name'];

      $friends_id .= (($keywords != "" ) ? ", " : "")."<a href=\"".$site_sess->url("/portfolio/".urlencode($fname))."\">$fname</a><br>";
    }
  }
  else {
    $friends_id = REPLACE_EMPTY;
  }


    $site_template->register_vars(array(
      "lang_friendslist_add", $lang['lang_friendslist_add'],
  "user_friends" => $friends_id
    ));

[thunderstrike]

Ah ! so this was you want.

$sql_friends = "SELECT *
        FROM ".USERS_TABLE."
        WHERE " . get_user_table_field("", "user_id") . " = ".$user_row[$user_table_fields['user_id']];
   $friends_row = $site_db->query_firstrow($sql_friends);
   
  if (!empty($friends_row['user_friend_ids'])) {
    $split_keywords = explode(" ", $friends_row['user_friend_ids']);
    $friends_id = "";
    foreach ($split_keywords as $key => $val) {
      $sql1 = "SELECT " . get_user_table_field("", "user_name") . "
        FROM ".USERS_TABLE."
        WHERE " . get_user_table_field("", "user_id") . " = " . $val;
   $friends_name = $site_db->query_firstrow($sql1);
   $fname = $friends_name[$user_table_fields['user_name']];

      $friends_id .= ((isset($keywords) && strlen(trim($keywords)) > 0) ? ", " : "")."<a href=\"".$site_sess->url("/portfolio/".urlencode($fname))."\">$fname</a><br>";
    }
  }
  else {
    $friends_id = REPLACE_EMPTY;
  }


       $site_template->register_vars(array(
      "lang_friendslist_add", $lang['lang_friendslist_add'],
     "user_friends" => (int)$friends_id
    ));   

[fast]

the mod limit displaying 20 users on one site, there is no way to switch to the next site when you have more than 20 friends. how do i implement this?

[thunderstrike]

I no find 20 for limit in MOD ...

[fast]

do you have paging with this mod? i dont... 

[thunderstrike]

Sorry, I no have.

[glitzer]

Hi,

how i have to change the line

  ^{$friends_id .= (($keywords != "" ) ? ", " : "")."<a href=\"".$site_sess->url("/portfolio/".urlencode($fname))."\">$fname</a><br>";}

that it link to the members profile?

"Porfolio" is not a right link.

another question:
In the Download is a second install with "install_friendslist2.php".

do i need to also install this?

Please help,
thanks,
Glitzer

[thunderstrike]

$friends_id .= (($keywords != "" ) ? ", " : "")."<a href=\"".$site_sess->url("/portfolio/".urlencode($fname))."\">$fname</a><br>";

I check in friendslist.php file and I think is this:

Code: [Select]

$friends_id .= (($keywords != "" ) ? ", " : "")."<a href=\"".$site_sess->url($friendslist_url)."\">$fname</a><br>";


In the Download is a second install with "install_friendslist2.php".

Yes.

[glitzer]

Hi Thunderstrike,

thank you for trying help me, but ^{$friends_id .= (($keywords != "" ) ? ", " : "")."<a href=\"".$site_sess->url($friendslist_url)."\">$fname</a><br>";}
is not the correct one.

I donīt have "portfolio" on my site.

I need the correct Url to the Members profile.

has anybody a idea?

[thunderstrike]

I need the correct Url to the Members profile.

And which page this from for put this link ?

[glitzer]

Hi Thunderstrike..

on the Members profile.html

i attach you my problem..i hope this helps ..to understand me