rendered paste body <?php
$id223 = $_GET['id'];
$id223 = mysql_real_escape_string($id223);
$query213 = mysql_query("SELECT * FROM thread WHERE fid = $id223 ORDER BY datetime DESC");
$row88 = mysql_fetch_array($query213);
$tid15 = $row88['id'];
$tid156 = mysql_real_escape_string($tid15);
$reply225 = mysql_num_rows(mysql_query("SELECT * FROM reply WHERE topicid = $tid156 ORDER BY datetime DESC LIMIT 1"));
$reply24 = mysql_query("SELECT * FROM reply WHERE topicid = $tid156 ORDER BY datetime DESC LIMIT 1");
if($reply225 > 0){
$row05 = mysql_fetch_array($reply24);
$time = $row05['time'];
$date = $row05['date'];
$auth = $row05['author'];
?>
<td width="35%" align="center" height="40"><font color="#6D7883" size="1"><?php echo $date; ?><br></font><font color="#9AA3A9" size="1"><?php echo $time; ?></font></td>
<td width="65%" align="center"><font size="1">Made by:<br><?php
$sql12 = mysql_query("SELECT * FROM users WHERE username = '$auth'");
$rowz = mysql_fetch_array($sql12);
$t3hlink = $rowz['id'];
$numnum = mysql_num_rows($sql12);
if($numnum == '1'){
echo '[<a href="/split/profile.php?id='.$t3hlink.'">'.$auth.'</a>';?>]</font>
<?php }else{
echo '«Deleted»';
}
?>
</td>
<?php
}else{
//////// IF NO REPLYS \\\\\\\\\\
$id22 = $_GET['id'];
$id22 = mysql_real_escape_string($id22);
$query25 = mysql_query("SELECT * FROM thread WHERE fid = $id22 ORDER BY datetime DESC LIMIT 1");
$row46 = mysql_fetch_array($query25);
$dater = $row46['date'];
$timer = $row46['time'];
$auther = $row46['author'];
?>
<td width="40%" align="center" height="40"><font color="#6D7883" size="1"><?php echo $dater; ?><br></font><font color="#9AA3A9" size="1"><?php echo $timer; ?></font></td>
<td width="60%" align="center"><font size="1">Made by:<br><?php
$sql16 = mysql_query("SELECT * FROM users WHERE username = '$auther'");
$rowz1 = mysql_fetch_array($sql16);
$thlink = $rowz1['id'];
$numnum1 = mysql_num_rows($sql16);
if($numnum1 == '1'){
echo '[<a href="/split/profile.php?id='.$thlink.'">'.$auther.'</a>';?>]</font>
<?php }else{
echo '«Deleted»';
}
?>
</td>
<?php
}
?>