modme.php

   1 <?
   2 include("con.inc");
   3 function auth($userid, $password) {
   4 $sql="SELECT username FROM users WHERE username='$userid' AND userpass='$password'";
   5 $result=mysql_query($sql);
   6 if(!mysql_num_rows($result)) return 0;
   7 else {
   8 $query_data=mysql_fetch_row($result);
   9 return $query_data[0];
  10 }
  11 }
  12 function getuser($mess) {
  13 $sql="SELECT * FROM messages WHERE messageid='$mess'";
  14 $result=mysql_query($sql);
  15 $myrow=mysql_fetch_array($result);
  16 return $myrow["messby"];
  17 }
  18 function getuser2($username)
  19 {
  20 $sql="SELECT * FROM users WHERE username='$username'";
  21 $result=mysql_query($sql);
  22 $myrow=mysql_fetch_array($result);
  23 return $myrow["username"];
  24 }
  25 function getboard($board)
  26 {
  27 $sql="SELECT * FROM boards WHERE boardid='$board'";
  28 $result=mysql_query($sql);
  29 $myrow=mysql_fetch_array($result);
  30 return $myrow["boardname"];
  31 }
  32 function gettopic($topic)
  33 {
  34 $sql="SELECT * FROM topics WHERE topicid='$topic'";
  35 $result=mysql_query($sql);
  36 $myrow=mysql_fetch_array($result);
  37 return $myrow["topicname"];
  38 }
  39 function getreason($reason,$markid)
  40 {
  41 if ($reason==1) return "Stupid.";
  42 if ($reason==2) return "Annoying.";
  43 if ($reason==3) return "Bad Language.";
  44 if ($reason==5) return "Illegal.";
  45 if ($reason==4)
  46 {
  47 $sql="SELECT * FROM marked WHERE markid='$markid'";
  48 $result=mysql_query($sql);
  49 $myrow=mysql_fetch_array($result);
  50 return $myrow["reason2"];
  51 }
  52 }
  53 $username=auth($uname,$pword);
  54 if (!$username)
  55 {
  56 echo "You are not <a href=login.php>Logged In</a>.";
  57 }
  58 $sql="SELECT * FROM users WHERE username='$uname'";
  59 $result=mysql_query($sql);
  60 $myrow=mysql_fetch_array($result);
  61 if (!$myrow["level"]>=50)
  62 {
  63 echo "You cannot view this page.";
  64 exit;
  65 }
  66 if ($myrow["level"]>=50)
  67 {
  68 include("colors.inc");
  69 include("top.inc");
  70 echo "<center><font color=black>Last Mod: ";
  71 readfile("/var/www/html/boards/lastmod1.txt");
  72 echo "</center></font><br><br>";
  73 $numrow=getuser2($uname);
  74 $fp=fopen("/var/www/html/boards/lastmod1.txt", "w");
  75 fwrite($fp,$numrow);
  76 fclose($fp);
  77 echo "<table width=100%><tr align=center><td bgcolor=".$titlecolor."><font face=arial><b>Multiply Marked Messages</b></td></tr></table>";
  78 echo "<table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor."><font face=arial><b>MessageID</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Marked Times</font></td><td bgcolor=".$secondcolor."><b><font face=arial>User Marked</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>";
  79 $sql="SELECT * FROM marked WHERE active='1' AND markedtimes>='2'";
  80 $result=mysql_query($sql);
  81 while ($myrow=mysql_fetch_array($result))
  82 {
  83 $reason=getreason($myrow["reason"],$myrow["markid"]);
  84 $topic=gettopic($myrow["topic"]);
  85 $board=getboard($myrow["board"]);
  86 $who=getuser($myrow["message"]);
  87 echo "<tr><td bgcolor=".$firstcolor."><font face=arial><a href=dosum.php?message=".$myrow["message"]."&topic=".$myrow["topic"]."&board=".$myrow["board"]."&marked=".$myrow["markid"].">".$myrow["markid"]."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["markedtimes"]."</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."</td><td bgcolor=".$firstcolor."><font face=arial>".$reason."</td></tr>";
  88 }
  89 echo "</table>";
  90 echo "<table width=100%><tr align=center><td bgcolor=".$titlecolor."><font face=arial><b>Singly Marked Messages</b></td></tr></table>";
  91 echo "<table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor."><font face=arial><b>MessageID</font></td><td bgcolor=".$secondcolor."><b><font face=arial>Marked By</font></td><td bgcolor=".$secondcolor."><b><font face=arial>User Marked</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>";
  92 $sql="SELECT * FROM marked WHERE active='1' AND markedtimes='1' ORDER BY markid ASC";
  93 $result=mysql_query($sql);
  94 while ($myrow=mysql_fetch_array($result))
  95 {
  96 $reason=getreason($myrow["reason"],$myrow["markid"]);
  97 $topic=gettopic($myrow["topic"]);
  98 $board=getboard($myrow["board"]);
  99 $who=getuser($myrow["message"]);
 100 echo "<tr><td bgcolor=".$firstcolor."><font face=arial><a href=dosum.php?message=".$myrow["message"]."&topic=".$myrow["topic"]."&board=".$myrow["board"]."&marked=".$myrow["markid"].">".$myrow["markid"]."</a></td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["markwho"]."</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."</td><td bgcolor=".$firstcolor."><font face=arial>".$reason."</td></tr>";
 101 }
 102 echo "</table>";
 103 echo "<center><table><tr align=center><td><a href=topiclist.php?board=1><font color=blue>Return to CE</font></a></td></tr></table>";
 104 }
 105 ?>