Código PHP:
function PostReply($idpost){
$query = "SELECT ps.*,ps.date,DAYOFMONTH(ps.date) AS dia, DAYOFWEEK(ps.date) AS semana, MONTH(ps.date) AS mes, YEAR(ps.date) AS year, DATE_FORMAT(ps.date,'%h:%i %p') AS hora FROM post ps WHERE ps.idpost=".$idpost." AND ps.idcat=".$_GET['catforo']." AND ps.idforo=".$_GET['foro']."";
$result = mysql_query($query) or die("No se ha podido ejecutar la consulta ".$query.". Error: ".mysql_error());
$fetch = mysql_fetch_assoc($result);
# Consulta para saber el tema actual
$query_00 = "SELECT * FROM foros WHERE idcat=".$_GET['catforo']." AND idforo=".$_GET['foro']."";
$result_00 = mysql_query($query_00) or die("No se ha podido ejecutar la consulta ".$query_00.". Error: ".mysql_error());
$fetch_00 = mysql_fetch_assoc($result_00);
# Consulta para obtener los datos del usuario
$query_01 = "SELECT us.*, ps.*,count(ps.idpost) as cantpost, rp.*, count(rp.idreply) as cantreply, DAYOFMONTH(us.registerdate) AS dia, DAYOFWEEK(us.registerdate) AS semana, MONTH(us.registerdate) AS mes, YEAR(us.registerdate) AS year, DATE_FORMAT(us.registerdate,'%h:%i %p') AS hora FROM users us, post ps, reply rp WHERE ps.idpost=".$fetch['idpost']." AND ps.iduser=us.iduser GROUP BY ps.iduser,rp.iduser";
$result_01 = mysql_query($query_01) or die("No se ha podido ejecutar la consulta ".$query_01.". Error: ".mysql_error());
$fetch_01 = mysql_fetch_assoc($result_01);
$messages = $fetch_01['cantpost'] + $fetch_01['cantreply'];
# Consulta para mostrar las respuestas
$query_02 = "SELECT rp.*,us.* FROM reply rp, users us WHERE rp.idpost=".$fetch['idpost']." AND rp.iduser=us.iduser ORDER BY rp.idreply";
$result_02 = mysql_query($query_02) or die("No se ha podido ejecutar la consulta ".$query_02.". Error: ".mysql_error());
$fetch_02 = mysql_fetch_assoc($result_02);
echo "<table width='100%' border='0' cellpadding='0' cellspacing='1'>
<tr><td rowspan='2' class='center forobottom' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr><td class='userlogin'><span class='info' title='".$fetch_01['name']."'><a href='foros.php?action=show&what=userinfo&iduser=".$fetch_01['iduser']."&".SID."'>".$fetch_01['login']."</a></span></td></tr>
<tr>
<td class='center'><img src='images/avatar/".$fetch_01['avatar']."' alt='Avatar de ".$fetch_01['name']."' class='hand'></td>
</tr><tr><td class='center'>";
# Llamada a la función para representar los ranking de usuarios
Rank($fetch_01['rank']);
echo "</td>
</tr><tr><td class='txt'>";
MakeDate($fetch_01['dia'], $fetch_01['semana'], $fetch_01['mes'], $fetch_01['year'], $fetch_01['hora']);
echo "</td></tr><tr><td class='txt'>Mensajes: ".$messages."</td></tr><tr>
<td class='txt'>País: ".$fetch_01['country']."</td></tr></table></td>
<td width='39%' valign='top' class='txt td' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'>Publicado: ";
MakeDate($fetch['dia'], $fetch['semana'], $fetch['mes'], $fetch['year'], $fetch['hora']);
$formattext = BBCode(nl2br($fetch['text']));
echo "</td>
<td width='57%' valign='top' class='txt td' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'>Asunto: ".$fetch['subject']."</td>
</tr><tr>
<td colspan='2' valign='top' class='txt td style0'>".$formattext."</td>
</tr><tr>
<td colspan='3' class='center forotema style1 right'>Respuesta #".$fetch_02['idreply']."</td>";
# Obtenemos todas las posibles respuestas
$query1 = "SELECT ps.*,rp.*,rp.date,DAYOFMONTH(rp.date) AS dia, DAYOFWEEK(rp.date) AS semana, MONTH(rp.date) AS mes, YEAR(rp.date) AS year, DATE_FORMAT(rp.date,'%h:%i %p') AS hora FROM reply rp, post ps WHERE rp.idpost=ps.idpost LIMIT 0,15";
$result1 = mysql_query($query1) or die("No se ha podido ejecutar la consulta ".$query1.". Error: ".mysql_error());
while($fetch1 = mysql_fetch_assoc($result1)){
$_pagi_sql = "SELECT us.*, rp.* FROM users us, reply rp WHERE us.iduser=rp.iduser";
$_pagi_cuantos = 3;
include("paginator.inc.php");
while($fetch2 = mysql_fetch_assoc($_pagi_result)){
}
echo "<table width='100%' border='0' cellpadding='0' cellspacing='1'>
<tr><td rowspan='2' class='center forobottom' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr><td class='userlogin'><span class='info' title='".$fetch2['name']."'><a href='foros.php?action=show&what=userinfo&iduser=".$fetch2['iduser']."&".SID."'>".$fetch2['login']."</a></span></td></tr>
<tr>
<td class='center'><img src='images/avatar/".$fetch2['avatar']."' alt='Avatar de ".$fetch2['name']."' class='hand'></td>
</tr><tr><td class='center'>";
# Llamada a la función para representar los ranking de usuarios
Rank($fetch2['rank']);
echo "</td>
</tr><tr><td class='txt'>";
MakeDate($fetch1['dia'], $fetch1['semana'], $fetch1['mes'], $fetch1['year'], $fetch1['hora']);
echo "</td></tr><tr><td class='txt'>Mensajes: ".$messages."</td></tr><tr>
<td class='txt'>País: ".$fetch2['country']."</td></tr></table></td>
<td width='43%' valign='top' class='txt td' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'>Publicado: ";
MakeDate($fetch1['dia'], $fetch1['semana'], $fetch1['mes'], $fetch1['year'], $fetch1['hora']);
$formattext = BBCode(nl2br($fetch1['text']));
echo "</td>
<td width='44%' valign='top' class='txt td' style='padding-left:5px; padding-right:3px; padding-top:2px; padding-bottom:2px;'>Asunto: ".$fetch['subject']."</td>
</tr><tr>
<td colspan='2' valign='top' class='txt td style0'>".$formattext."</td>
</tr><tr>
<td colspan='3' class='center forotema'> </td></tr>";
}
echo "<tr>
<td colspan='3' class='center td txt'>".$_pagi_navegacion."</td></tr></table>";
}
Salu2
