viewmod.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 if ($myrow["level"] <= 49)
  20 {
  21         echo "You cannot be here.";
  22         exit;
  23 }
  24 if (!$user)
  25 {
  26         echo "Invalid userID.";
  27         exit;
  28 }
  29 include ("colors.inc");
  30 include ("top.inc");
  31 echo "<center><font face=arial size=6 color=black>Moderated Messages</font></center>";
  32 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>";
  33 if ($board)
  34 {
  35         echo " | <b><a href=topiclist.php?board=".$board.">Topic List</b></a>";
  36 }
  37 if ($topic)
  38 {
  39         echo " | <b><a href=messagelist.php?board=".$board."&topic=".$topic.">Message List</b></a>";
  40 }
  41 echo " | <b><a href=logout.php>Log Out</b></a></td></tr></table>";
  42 $sql = "SELECT * FROM users WHERE userid='$user'";
  43 $result = mysql_query($sql);
  44 $myrow = mysql_fetch_array($result);
  45 $usename22 = $myrow["username"];
  46 $sql = "SELECT * FROM modded WHERE modby='$usename22' ORDER BY modid DESC";
  47 $result = mysql_query($sql);
  48 while ($myrow = mysql_fetch_array($result))
  49 {
  50         $topicname = topicname($myrow["topic"]);
  51         $topicname = stripslashes($topicname);
  52         $bodbod = stripslashes($myrow["modbod"]);
  53         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=".$firstcolor."><font face=arial>".$bodbod."</td></tr></table>";
  54 }
  55 ?>