[RESOLVED] friends show on profile

tommyc21

i need help with showing friends on profile in my profile.php so far i have

function friends($friends){
$sql select" from friends where addid='$profile[ID]' and accp='yes'";
$sql2 select" from friends where addedid='$profile[ID]' and accp='yes'";
$rows = 2;
$cols = 3;
$friends = 6;
}
echo("".friends()."");

can some 1 help me plz i dont realy no the function side that well

CoderDan

The function appears to have a number of problems to me (and would throw errors on parse):
1) the $sql select"etc is not assigning a variable properly, ie $sql = "select etc
2) the function never runs the queries, or uses the results.
3) the function assigns the last 3 variables ($rows, $cols, $friends) and then stops - it doesn't do anything with them.
4) the function does not return anything, so calling it with:
echo( "".friends()."" );
(which should be:
echo friends();
)
will have no output anyway.
5) the query references $profile array variable, which is not passed to the function ($friends is, but it's not used)

tommyc21

CoderDan;10921946 wrote:
The function appears to have a number of problems to me (and would throw errors on parse):
1) the $sql select"etc is not assigning a variable properly, ie $sql = "select etc
2) the function never runs the queries, or uses the results.
3) the function assigns the last 3 variables ($rows, $cols, $friends) and then stops - it doesn't do anything with them.
4) the function does not return anything, so calling it with:
echo( "".friends()."" );
(which should be:
echo friends();
)
will have no output anyway.
5) the query references $profile array variable, which is not passed to the function ($friends is, but it's not used)

ok i have changed it just can not show the out put any ideas

function getFriendNumber ( $IDp )
{
$sqlQuery = "SELECT COUNT(*) FROM friends WHERE ( addid='$rprofile[ID]' OR $rprofile[ID]' ) ANDacep`='1'";

return mysql_query($sqlQuery);

}
function showBlockFriends($IDp)
{
global $site;

	$sFriendList = ShowFriendList( $profile -> _iProfileID, $profile -> aMutualFriends );
	$iFriendNums = getFriendNumber( $profile -> _iProfileID );

	if( $sfriends )
	{
		ob_start();

		?>
			<div class="clear_both"></div>
			<?= $sfriends ?>
			<div class="clear_both"></div>
		<?

		$ret = ob_get_clean();

		$sFriendInfo = '<div class="caption_item"><a href="'.$site['url'].'viewFriends.php?iUser='.$addid -> _iProfileID.'">'.$iFriendNums.' '._t("_Friends").'</a></div>';

		echo DesignBoxContent( _t( $sCaption ), $ret, 1, $sFriendInfo );
	}
}

function ShowFriendList( $IDp, $aMutualFriends = 0 )
{
global $site;
global $max_thumb_width;
global $max_thumb_height;

if ($aMutualFriends == 0)
	$aMutualFriends = array();

$id = (int)$id;
$friend_list_query = "SELECT `users`.* FROM `friends`
							 LEFT JOIN `users` ON (`users`.`ID` = `friends`.`addedid` AND `friends`.`addid` = '$id' OR `users`.`ID` = `friends`.`addid` AND `friends`.`addedid` = '$id')
							 WHERE (`friends`.`addedid` = '$id' OR `friends`.`addid` = '$id') AND `friends`.`acep` = '1' ORDER BY `users`.`Picture` DESC LIMIT 12";

$friend_list_res = mysql_query("$friend_list_query");

$iCounter = 0;
$ret = '';

while ( $friend_list_arr = mysql_query( $friend_list_res ) )
{

   if (!array_key_exists($friend_list_arr['ID'], $aMutualFriends)){

	$iCounter ++;
	$sKey = '1';
	if( $iCounter == 3 )
		$sKey = '2';

	$ret .= '<div class="friends_thumb_'.$sKey.'">' . get_member_thumbnail($friend_list_arr['ID'], 'none') . '<div class="browse_nick"><a href="' . getProfileLink($friend_list_arr['ID']) . '">' . $friend_list_arr['username'] . '</a></div><div class="clear_both"></div></div>';

	if( $iCounter == 3)
		$iCounter = 0;
}


}

return $ret;

}

CoderDan

ok, firstly, I indented your code some, secondly, I modified your first query (getFriendNumber()). Thirdly, I'll paste it back inside [ PHP] and [ /PHP] tags (ignore the extra spaces inside them - I wanted them to display), so it's easier to read:

<?php
function getFriendNumber ( $IDp )
{
	$sqlQuery = "SELECT COUNT(*) FROM `friends` WHERE ( `addid`='$rprofile[ID]' OR `$rprofile[ID]' ) AND `acep`='1'";

$result = mysql_query( $sqlQuery ) or die( mysql_error( ) );

if ( $count = mysql_fetch_row( $result ) )
{
	return $count[0];
}
else
{
	return 0;
}
}

function showBlockFriends ( $IDp )
{
	global $site;

$sFriendList = ShowFriendList( $profile -> _iProfileID, $profile -> aMutualFriends );
$iFriendNums = getFriendNumber( $profile -> _iProfileID );

if ( $sfriends )
{
	ob_start();
?>
<div class="clear_both"></div>
<?= $sfriends ?>
<div class="clear_both"></div>
<?php
		$ret = ob_get_clean();

	$sFriendInfo = '<div class="caption_item"><a href="'.$site['url'].'viewFriends.php?iUser='.$addid -> _iProfileID.'">'.$iFriendNums.' '._t("_Friends").'</a></div>';

	echo DesignBoxContent( _t( $sCaption ), $ret, 1, $sFriendInfo );
}
}

function ShowFriendList( $IDp, $aMutualFriends = 0 )
{
	global $site;
	global $max_thumb_width;
	global $max_thumb_height;

if ( $aMutualFriends == 0 )
	$aMutualFriends = array();

$id = (int)$id;
$friend_list_query = "SELECT `users`.* FROM `friends`
	LEFT JOIN `users` ON (`users`.`ID` = `friends`.`addedid` AND `friends`.`addid` = '$id' OR `users`.`ID` = `friends`.`addid` AND `friends`.`addedid` = '$id')
	WHERE (`friends`.`addedid` = '$id' OR `friends`.`addid` = '$id') AND `friends`.`acep` = '1' ORDER BY `users`.`Picture` DESC LIMIT 12";

$friend_list_res = mysql_query("$friend_list_query");

$iCounter = 0;
$ret = '';

while ( $friend_list_arr = mysql_query( $friend_list_res ) )
{
	if ( !array_key_exists( $friend_list_arr['ID'], $aMutualFriends ) )
	{
		$iCounter ++;
		$sKey = '1';
		if ( $iCounter == 3 )
			$sKey = '2';

		$ret .= '<div class="friends_thumb_'.$sKey.'">' . get_member_thumbnail($friend_list_arr['ID'], 'none') . '<div class="browse_nick"><a href="' . getProfileLink($friend_list_arr['ID']) . '">' . $friend_list_arr['username'] . '</a></div><div class="clear_both"></div></div>';

		if ( $iCounter == 3 )
			$iCounter = 0;
	}
}

return $ret;
}

tommyc21

never mind not showing so i just did it in basic php not as good but dose the trick

                        $query2 = "SELECT * from friends as a,users as b where a.addid='$rprofile[ID]' and b.ID=a.addedid order by a.associd DESC limit 4";
    $command2 = mysql_query ($query2)
		or die($db_error);
    while($result2 = mysql_fetch_array($command2))
    {
			print "<center><td><a href=\"profile.php?name=".$result2[username]."\" target=\"_blank\"><img src=\"photos/$result2[mainpath]\" border=\"0\" width=\"70\" height=\"60\" /><center></a>";
		}
    print "<tr height=\"7\"><td colspan=\"4\"></td></tr></table><br><br>";

tommyc21

thanks any way 🙂

CoderDan

Well that final code looks nice and clean 🙂 remember to mark the thread closed.