rendered paste body<?php
include "db.php";
include "bbcode.php";
function show_categories() {
$query = mysql_query("select * from p_cat order by cat_id desc");
echo "<table width=100%>";
while($row1 = mysql_fetch_array($query)) {
$color = ($i % 2) ? 'c0c0c0' : '989898';
$query2 = mysql_query("select * from p_posts where post_cat LIKE '%$row1[post_cat]%' limit 1");
echo "<tr valign=top><Td bgcolor=".$color."><font size=4><a href=?action=f&id=$row1[cat_name]>$row1[cat_name]</a></font><br><font size=1>$row1[cat_desc]</font></td>";
while($row2=mysql_fetch_array($query2)) {
$last_post = $row2[post_topic];
echo "<td bgcolor=".$color." width=25%>".substr($last_post,0,25)." ...</td></tr>";
}//endwhile
$i++;
}//endwhile
echo "</table>";
}//end show_categories
function show_forums() {
$id = clean($_GET[id]);
$query = mysql_query("select * from p_forums where f_cat LIKE '%$id%' order by f_id desc");
echo "<table>";
while($row = mysql_Fetch_array($query)) {
echo "<tr><Td><a href=?action=p&id=$row[f_id]>$row[f_name]</a></td><td>byrdsfv43</td></tr>";
}//end while
echo "</table>";
}//end show_forums
function show_posts() {
$f = clean($_GET[id]);
$query = mysql_query("select * from p_posts where post_id LIKE '%$f%'");
while($row = mysql_fetch_array($query)) {
echo "<a href=?action=view_post&id=$row[post_id]>$row[post_topic]</a><br>";
}//end while
}//end show posts
function show_post() {
$id = clean($_GET[id]);
$query = mysql_query("select * from p_posts where post_id = '$id'");
while($row = mysql_fetch_array($query)) {
echo "<table width=100% border=0><tr><td width=100>post id/name</td><td>$row[post_id] / $row[post_topic]</td></tr>
<tr><td width=100>posted by</td><td>$row[post_poster]</td></tr>
<tr><td colspan=2>".bbcode($row[post_post])."</td></tr></table><hr>";
}//end while
}//end show post
function clean_for_code($str) {
$str = htmlentities($str);
return $str;
}//end clean_for_code
function clean($str) {
$str = htmlspecialchars($str);
$str = stripslashes($str);
return $str;
}//end clean
function latest_posts() {
$query = mysql_query("select * from p_posts") or dei(mysql_error());
while($row = mysql_fetch_array($query)) {
echo $row[post_topic]."<br>";
}//endwhile
}//end latest posts
function search_forum() {
echo "search";
}//end search forums
?>