All pastes #677213 Raw Edit

Someone

public text v1 · immutable
#677213 ·published 2007-08-31 20:08 UTC
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
?>