<?php
session_start();
 
$i = $_POST["username"];
$e = $_POST["password"];
 
$conn = mysql_connect("localhost", "PeterJones", "sksksksks");
mysql_select_db("PeterJones");
 
$q=("SELECT username FROM users WHERE username = '$i' AND password ='$e' ");
$result=mysql_query($q) or die(mysql_error());
$row= mysql_fetch_array($result);
 
if(mysql_num_rows($result)==0)
 
{	
}
else 
{
// Correct password : set up the authentication session variable
    // and store the user ID in it
    $_SESSION["gatekeeper"] = $i;  
 
}
 
mysql_close($conn);
 
?>

<?php
//Your login code here
$user_id = $id; //id of logged in user however u store this
$arrFriendlist = new array();
$q = @mysql_query("SELECT friend_id FROM friends WHERE user_id = $user_id AND  active = 1");
while($r = @mysql_fetch_array($q)){
array_push($arrFriendList, $r['friend_id']);
}
//also have to get friends where request was reversed
$q = @mysql_query("SELECT user_id FROM friends WHERE friend_id = $user_id AND  active = 1");
while($r = @mysql_fetch_array($q)){
array_push($arrFriendList, $r['user_id']);
}
?>

<?php
$mem_id = $_GET['id']; // GRab the id of member you want to view
if(in_array($mem_id,$arrFriendList)){
//code to show member details
}else{
 echo "sorry but this user isn't your friend";
}
?>

<?php 
session_start(); 
$a = $_SESSION["gatekeeper"];
$conn = mysql_connect("localhost", "PeterJones", "PeterJones");
mysql_select_db("JonesPeter");
 
 if ( !isset ($_SESSION["gatekeeper"]))
{
	echo "You're not logged in. Go away!";
 
}
else 
{
 
$result=mysql_query("SELECT * FROM users WHERE username = '$a'");
 
while($row=mysql_fetch_array($result))
{
    echo "You are logged in as!";
    echo " $row[username] <br />";
 
  // How do I make the currently user's online friends to display like this????? Please help me on this one as well!!!
    echo " Online friends  <br> <br />";
	//John, Josh, Joseph etc ???? Please help me on this one as well!!!!
 
    echo " Search for your Friends  <br> <br />";
}
 
}
 
?>
 
<form method="post" action="search.php"   
<label for="username">Name</label>
<input type="text" name="username" />  
<input type="submit" value="Search" />    
</form>
</body>
 
	<div>
	<a href="logout.php"> Logout</a>

$Friends = ""; //string of friends
foreach( $arrFriends as $item=>$value){
$q = @mysql_query("SELECT username, user_id FROM users WHERE user_id = $value");
while($r = @mysql_fetch_array($q)){
$Friends .= $r['username']."<br />";
}
}

+------------------+---------------------+--------+-----------+
| Field            | Type                | Null   | Default   |
+------------------+---------------------+--------+-----------+
| user_id          | mediumint(8)        | NO     | 0         |
| zebra_id         | mediumint(8)        | NO     | 0         |
| friend           | tinyint(1)          | NO     | 0         |
| foe              | tinyint(1)          | NO     | 0         |
| active           | tinyint(1)          | NO     | 0         |
+------------------+---------------------+--------+-----------+

// login to the database
 
$query="SELECT * FROM phpbb_zebra WHERE (user_id = '$_SESSION[user_id]' AND zebra_id = '$profile_id') OR (zebra_id = '$_SESSION[user_id]' AND user_id = '$profile_id')";
$result = mysql_query($query,$cnx);
$row = mysql_num_rows($result);
 
if ($row == 1) { // means the relationship exist, whether it's active or not
   while($row = mysql_fetch_assoc($result)) {
      if ($row['active'] == 1) {
      echo "You are a friend of this user.";
      } else {
      echo "You've already sent a friend request to this user";
      }
   }
} else { // if the relationship don't exist
echo "<a href='add_friend.php?zebra_id=".$profile_id."'>Add this user as a friend</a>";
}

// login to the database
 
if ((!isset($_GET['zebra_id'])) || (!isset($_SESSION['user_id']))) {
header("Location: index.php"); exit(); // the zebra_id variable is not set in the URL, or there is no user logged in, so get out the page
}
 
$profile_id = $_GET['zebra_id'];
 
$query="SELECT * FROM phpbb_zebra WHERE (user_id = '$_SESSION[user_id]' AND zebra_id = '$profile_id') OR (zebra_id = '$_SESSION[user_id]' AND user_id = '$profile_id')";
$result = mysql_query($query,$cnx);
$row = mysql_num_rows($result);
 
if ($row == 1) { // check again for the existence of the relationship
   while($row = mysql_fetch_assoc($result)) {
      if ($row['active'] == 1) {
      echo "You are a friend of this user.";
      } else {
      echo "You've already sent a friend request to this user";
      }
   }
} else { // the relationship don't exist, so it's time for the real job
   $insert_query = "INSERT INTO phpbb_zebra ('user_id', 'zebra_id', 'friend') VALUES ('$_SESSION[user_id]', '$profile_id', '1')";
   $insert_result = mysql_query($insert_query,$cnx);
   if (!$insert_result) {
      // error here
   } else {
      echo "The request has been sent.";
   }
}

// login to the database
$query = "SELECT * FROM phpbb_zebra WHERE zebra_id = '$_SESSION[user_id]' AND active = '0'";
$result = mysql_query($query,$cnx);
$row = mysql_num_rows($result);
if ($row > 0) { // there are new requests
   echo "<a href='requests.php'>You have ".$row." new friend requests</a>";
} else {
 echo "No new requests.";
}