All pastes #265236 Raw Edit

popo

public text v1 · immutable
·published 2006-12-03 03:22 UTC
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 
		
		}
		 ?>