helpme.php

   1 <html>
   2 <?
   3 include("con.inc");
   4 function getuser($mess) {
   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) return "Intelligent.";
  34 if ($reason==2) return "Informitive.";
  35 if ($reason==3) return "Funny.";
  36 if ($reason==4)
  37 {
  38 $sql="SELECT * FROM suggest WHERE sugid='$sugid'";
  39 $result=mysql_query($sql);
  40 $myrow=mysql_fetch_array($result);
  41 return $myrow["reason2"];
  42 }
  43 }
  44 $sql="SELECT * FROM users WHERE username='$uname'";
  45 $result=mysql_query($sql);
  46 $myrow=mysql_fetch_array($result);
  47 if (!$myrow["level"]>=50)
  48 {
  49 echo "You cannot view this page.";
  50 exit;
  51 }
  52 if ($myrow["level"]>=50)
  53 {
  54 include("colors.inc");
  55 include("top.inc");
  56 echo "<center><font color=black>Last Mod: ";
  57 readfile("/var/www/html/boards/lastmod2.txt");
  58 echo "</center></font><br><br>";
  59 $numrow=getuser2($uname);
  60 $fp=fopen("/var/www/html/boards/lastmod2.txt", "w");
  61 fwrite($fp,$numrow);
  62 fclose($fp);
  63 $sql="SELECT * FROM suggest WHERE active='1' AND sugtimes>='2'";
  64 $result=mysql_query($sql);
  65 echo "<table width=100% bgcolor=".$titlecolor."><Tr align=center><td><font face=arial><b>Multiply Suggested Messages</b></td></tr></table>";
  66 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>";
  67 while ($myrow=mysql_fetch_array($result))
  68 {
  69 $reason=getreason($myrow["reason"],$myrow["sugid"]);
  70 $topic=gettopic($myrow["topic"]);
  71 $board=getboard($myrow["board"]);
  72 $who=getuser($myrow["message"]);
  73 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>";
  74 }
  75 echo "</table>";
  76 $sql="SELECT * FROM suggest WHERE active='1' AND sugtimes='1' ORDER BY sugid ASC";
  77 $result=mysql_query($sql);
  78 echo "<table width=100% bgcolor=".$titlecolor."><Tr align=center><td><font face=arial><b>Singly Suggested Messages</b></td></tr></table>";
  79 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>";
  80 while ($myrow=mysql_fetch_array($result))
  81 {
  82 $reason=getreason($myrow["reason"],$myrow["sugid"]);
  83 $topic=gettopic($myrow["topic"]);
  84 $board=getboard($myrow["board"]);
  85 $who=getuser($myrow["message"]);
  86 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>";
  87 }
  88 echo "</table>";
  89 echo "<center><table><tr align=center><td><a href=topiclist.php?board=1><font color=blue>Return to CE</font></a></td></tr></table>";
  90 }
  91 ?>