num_rows;
if($rowcount > 0)
{
$result2 = mysqli_fetch_array($res, MYSQLI_ASSOC);
$friendSQL = $result2['ID'];
mysqli_free_result($res);
$user_check_query = "SELECT ID FROM ucp_friends WHERE playerName = '$username' AND friendName = '$friend_id' OR playerName = '$friend_id' AND friendName = '$username' LIMIT 1";
$res = mysqli_query($link, $user_check_query);
$rowcount = $res->num_rows;
if($rowcount > 0)
{
$result2 = mysqli_fetch_array($res, MYSQLI_ASSOC);
$friendPending = $result2['friendPending'];
if($friendPending == 1) $error_message = "There's already a pending request between you two.";
else $error_message = "You're already friends with this user.";
}
else
{
mysqli_free_result($res);
$user_check_query = "INSERT INTO ucp_friends (`friendID`, `playerID`, `friendName`, `playerName`) VALUES ($friendSQL, $playersqlid, '$friend_id', '$username')";
$res = mysqli_query($link, $user_check_query);
$insert = mysqli_insert_id($link);
mysqli_free_result($res);
$user_check_query = "INSERT INTO `notifications` (`master`, `sender`, `friend`) VALUES ('$friendSQL', '$username', '$insert')";
$res = mysqli_query($link, $user_check_query);
mysqli_free_result($res);
$success_message = "Friend request successfully sent.";
}
}
else $error_message = "This user doesn't exist.";
}
}
?>