All pastes #466276 Raw Edit

Someone

public text v1 · immutable
#466276 ·published 2007-04-30 22:11 UTC
rendered paste body
if ($page == "idx"){
$getnews = mysql_query("SELECT * FROM mybb_posts WHERE fid = '2' ORDER BY tid DESC")or die("News:  ".mysql_error());
$n = mysql_fetch_array($getnews);
$getrep = mysql_query("SELECT * FROM mybb_posts WHERE replyto = '$n[tid]'")or die("Rep:  ".mysql_error());
$replies = mysql_num_rows($getrep);
while($news = mysql_fetch_array($getnews)){
$news[message] = str_replace("\n", "<br>", $news[message]);
$news[message] = str_replace("[b]", "<b>", $news[message]);
$news[message] = str_replace("[/b]", "</b>", $news[message]);
$news[message] = str_replace("[u]", "<u>", $news[message]);
$news[message] = str_replace("[/u]", "</u>", $news[message]);
$news[message] = str_replace("[i]", "<i>", $news[message]);
$news[message] = str_replace("[/i]", "</i>", $news[message]);
$news[message] = str_replace("[url=", "<a href=", $news[message]);
$news[message] = str_replace("]", ">", $news[message]);
$news[message] = str_replace("[", "<", $news[message]);
$news[message] = str_replace("[/url]", "</a>", $news[message]);
echo("
<td background='images/bar2.gif'>
<div style='float:left'>
<a href='http://www.flashnetworkonline.net/gmz/forums/showthread.php?tid=$news[tid]'>$news[subject]</a>
</div>
<div style='float:right'> 
<a href='http://www.flashnetworkonline.net/gmz/forums/member.php?action=profile&uid=$news[uid]'>$news[username]</a>
</div>
</td><tr>
<td valign='top' bgcolor='black'>
<font color='gold'>
$news[message]
</font>
</td><tr>
<td background='images/bar2.gif'><a href='http://www.flashnetworkonline.net/gmz/forums/showthread.php?tid=$news[tid]'>Replies ($replies)</a></td><tr>
<td background='images/bar3.gif'></td></tr></table><br><br>
<table width='600' height='22' cellspacing='1' bgcolor='grey'>
");
}