completando voce coloca isso na pagina de comentarios na linha do author voce coloca
<?php
function getUserByName($username, $withAttr = false, $attr = '') {
$req = $link->query("SELECT ID FROM usuarios WHERE username = '$username'");
$res = mysqli_fetch_assoc($req);
if ($withAttr)
return $res[$attr];
return $res;
}
function getRankByID($id) {
$req = $link->query("SELECT * FROM rangos WHERE id = $id");
$res = mysqli_fetch_assoc($req);
return $res;
}
?>
<?php
$query = $link->query('SELECT * FROM comentarios WHERE noticia_id = "'.$noticia_id.'" ORDER BY id DESC limit 200');
while($row = mysqli_fetch_array($query))
{
?>
<li>
<div class="comment-main-level">
<!-- Avatar -->
<div class="comment-avatar"><a href="perfil.php?user=<?php echo $row['username'];?>"><img oncontextmenu="return false" src="<?php echo $row['avatar'];?>" alt=""></a></div>
<!--comentario -->
<div class="comment-box">
<div class="comment-head" >
<h6 class="comment-name"><a href="perfil.php?user=<?php echo $row['username'];?>"><?php echo $row['username'];?><?php echo $res['nombre'];?></a></h6>
<span></span>
</div>
<div class="comment-content">
ficaria assim pelo meus calculos ficaria assim ; voce so mudaria essa linha (ja mudei no codigo acima)
<h6 class="comment-name"><a href="perfil.php?user=<?php echo $row['username'];?>"><?php echo $row['username'];?><?php echo $res['nombre'];?></a></h6>
// <?php echo $res['nombre'];?> voce puxaria a tabela nombre de rangos pois o return da function getRank puxa ja o usuario
