helpme.php

   1 <html>
   2 <?php include ("config.php");
   3 function getuser($mess)
   4 {
   5         $sql = "SELECT * FROM messages WHERE messageid='$mess'";
   6         $result = mysql_query($sql);
   7         $myrow = mysql_fetch_array($result);
   8         return $myrow["messby"];
   9 }
  10 function getuser2($username)
  11 {
  12         $sql = "SELECT * FROM users WHERE username='$username'";
  13         $result = mysql_query($sql);
  14         $myrow = mysql_fetch_array($result);
  15         return $myrow["username"];
  16 }
  17 function getboard($board)
  18 {
  19         $sql = "SELECT * FROM boards WHERE boardid='$board'";
  20         $result = mysql_query($sql);
  21         $myrow = mysql_fetch_array($result);
  22         return $myrow["boardname"];
  23 }
  24 function gettopic($topic)
  25 {
  26         $sql = "SELECT * FROM topics WHERE topicid='$topic'";
  27         $result = mysql_query($sql);
  28         $myrow = mysql_fetch_array($result);
  29         return $myrow["topicname"];
  30 }
  31 function getreason($reason, $sugid)
  32 {
  33         if ($reason == 1)
  34                 return "Intelligent.";
  35         if ($reason == 2)
  36                 return "Informitive.";
  37         if ($reason == 3)
  38                 return "Funny.";
  39         if ($reason == 4)
  40         {
  41                 $sql = "SELECT * FROM suggest WHERE sugid='$sugid'";
  42                 $result = mysql_query($sql);
  43                 $myrow = mysql_fetch_array($result);
  44                 return $myrow["reason2"];
  45         }
  46 }
  47 $sql = "SELECT * FROM users WHERE username='$uname'";
  48 $result = mysql_query($sql);
  49 $myrow = mysql_fetch_array($result);
  50 if (!$myrow["level"] >= 50)
  51 {
  52         echo "You cannot view this page.";
  53         exit;
  54 }
  55 if ($myrow["level"] >= 50)
  56 {
  57         include ("colors.inc");
  58         include ("top.inc");
  59         echo "<center><font color=black>Last Mod: ";
  60         readfile("/var/www/html/boards/lastmod2.txt");
  61         echo "</center></font><br><br>";
  62         $numrow = getuser2($uname);
  63         $fp = fopen("/var/www/html/boards/lastmod2.txt", "w");
  64         fwrite($fp, $numrow);
  65         fclose($fp);
  66         $sql = "SELECT * FROM suggest WHERE active='1' AND sugtimes>='2'";
  67         $result = mysql_query($sql);
  68         echo "<table width=100% bgcolor=".$titlecolor."><Tr align=center><td><font face=arial><b>Multiply Suggested Messages</b></td></tr></table>";
  69         echo "<table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor."><font face=arial><b>SuggestionID</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Suggested Times</font></td><td bgcolor=".$secondcolor."><b><font face=arial>User Suggested</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Board</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Topic</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Reason</font></td></tr>";
  70         while ($myrow = mysql_fetch_array($result))
  71         {
  72                 $reason = getreason($myrow["reason"], $myrow["sugid"]);
  73                 $topic = gettopic($myrow["topic"]);
  74                 $board = getboard($myrow["board"]);
  75                 $who = getuser($myrow["message"]);
  76                 echo "<tr><td bgcolor=".$firstcolor."><font face=arial><a href=dosum2.php?message=".$myrow["message"]."&topic=".$myrow["topic"]."&board=".$myrow["board"]."&sugid=".$myrow["sugid"].">".$myrow["sugid"]."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["sugtimes"]."</td><td bgcolor=".$firstcolor."><font face=arial>".$who."</td><td bgcolor=".$firstcolor."><font face=arial>".$board."</td><td bgcolor=".$firstcolor."><font face=arial><a href=messagelist.php?board=".$myrow["board"]."&topic=".$myrow["topic"].">".$topic."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$reason."</td></tr>";
  77         }
  78         echo "</table>";
  79         $sql = "SELECT * FROM suggest WHERE active='1' AND sugtimes='1' ORDER BY sugid ASC";
  80         $result = mysql_query($sql);
  81         echo "<table width=100% bgcolor=".$titlecolor."><Tr align=center><td><font face=arial><b>Singly Suggested Messages</b></td></tr></table>";
  82         echo "<table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor."><font face=arial><b>SuggestionID</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Suggested By</font></td><td bgcolor=".$secondcolor."><b><font face=arial>User Suggested</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Board</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Topic</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Reason</font></td></tr>";
  83         while ($myrow = mysql_fetch_array($result))
  84         {
  85                 $reason = getreason($myrow["reason"], $myrow["sugid"]);
  86                 $topic = gettopic($myrow["topic"]);
  87                 $board = getboard($myrow["board"]);
  88                 $who = getuser($myrow["message"]);
  89                 echo "<tr><td bgcolor=".$firstcolor."><font face=arial><a href=dosum2.php?message=".$myrow["message"]."&topic=".$myrow["topic"]."&board=".$myrow["board"]."&sugid=".$myrow["sugid"].">".$myrow["sugid"]."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["sugwho"]."</td><td bgcolor=".$firstcolor."><font face=arial>".$who."</td><td bgcolor=".$firstcolor."><font face=arial>".$board."</td><td bgcolor=".$firstcolor."><font face=arial><a href=messagelist.php?board=".$myrow["board"]."&topic=".$myrow["topic"].">".$topic."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$reason."</td></tr>";
  90         }
  91         echo "</table>";
  92         echo "<center><table><tr align=center><td><a href=topiclist.php?board=1><font color=blue>Return to CE</font></a></td></tr></table>";
  93 }
  94 ?>