moddedmes.php

   1 <?php include ("config.php");
   2 function topicname($topicnum)
   3 {
   4         $sql = "SELECT * FROM topics WHERE topicid='$topicnum'";
   5         $result = mysql_query($sql);
   6         $myrow = mysql_fetch_array($result);
   7         return $myrow["topicname"];
   8 }
   9
  10 $username = auth();
  11 if (!$username)
  12 {
  13         echo "You are not <a href=login.php>Logged In</a>.";
  14         exit;
  15 }
  16 $sql = "SELECT * FROM users WHERE username='$uname'";
  17 $result = mysql_query($sql);
  18 $myrow = mysql_fetch_array($result);
  19 echo "<center><font face=arial size=6 color=black>Moderated Messages</font></center>";
  20 echo "<table width=100%><tr align=center><td bgcolor=".$titlecolor."><font face=arial><b><a href=user.php>".$myrow["username"]." (".$myrow["level"].")</b></a> | <b><a href=index.php>Board List</b></a>";
  21 if (isset($_GET['board']))
  22 {
  23         echo " | <b><a href=topiclist.php?board=".$_GET['board'].">Topic List</b></a>";
  24 }
  25 if (isset($_GET['topic']))
  26 {
  27         echo " | <b><a href=messagelist.php?board=".$_GET['board']."&topic=".$_GET['topic'].">Message List</b></a>";
  28 }
  29 echo " | <b><a href=logout.php>Log Out</b></a></td></tr></table>";
  30 $sql = "SELECT * FROM modded WHERE modby='$uname' ORDER BY modid DESC";
  31 $result = mysql_query($sql);
  32 while ($myrow = mysql_fetch_array($result))
  33 {
  34         $topicname = topicname($myrow["topic"]);
  35         $topicname = stripslashes($topicname);
  36         $bodbod = stripslashes($myrow["modbod"]);
  37         echo "<table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor."><font face=arial><b>Board:</b> ".$myrow["board"]." | <b>Topic: </b>".$topicname." | <b>Moderation ID:</b> ".$myrow["modid"]." | <b>From:</b> ".$myrow["modby"]."</td></tr><tr><td bgcolor=".$secondcolor."><font face=arial>".$bodbod."</td></tr></table>";
  38 }
  39 ?>