systemnot.php

   1 <?php include "config.php";
   2 function getlevel($username)
   3 {
   4         $sql = "SELECT * FROM users WHERE username='$username'";
   5         $result = mysql_query($sql);
   6         $myrow = mysql_fetch_array($result);
   7         return $myrow["level"];
   8 }
   9 function auth($userid, $password)
  10 {
  11         $sql = "SELECT username FROM users WHERE username='$userid' AND userpass='$password'";
  12         $result = mysql_query($sql);
  13         if (!mysql_num_rows($result))
  14                 return 0;
  15         else
  16         {
  17                 $query_data = mysql_fetch_row($result);
  18                 return $query_data[0];
  19         }
  20 }
  21 function getuserid($username)
  22 {
  23         $sql = "SELECT * FROM users WHERE username='$username'";
  24         $result = mysql_query($sql);
  25         $myrow = mysql_fetch_array($result);
  26         return $myrow["userid"];
  27 }
  28 $username = auth($uname, $pword);
  29 if (!$username)
  30 {
  31         echo "You are not <a href=login.php>Logged in</a>.";
  32         exit;
  33 }
  34 $userid = getuserid($uname);
  35 $sql = "SELECT * FROM systemnot WHERE sendto='$userid' AND active='1'";
  36 $result = mysql_query($sql);
  37 $userlevel = getlevel($uname);
  38 while ($myrow = mysql_fetch_array($result))
  39 {
  40         if ($myrow["sentfrom"] == 1)
  41         {
  42                 $from = "A Moderator";
  43         }
  44         if ($myrow["sentfrom"] == 2)
  45         {
  46                 $from = "An Administrator";
  47         }
  48         if ($myrow["sentfrom"] == 3)
  49         {
  50                 $from = "Mgmt";
  51         }
  52         if ($myrow["sentfrom"] == 4)
  53         {
  54                 $from = "The Game";
  55         }
  56         $sysbod = stripslashes($myrow["sysbod"]);
  57         echo "<b>From:</b> ".$from." | <b>At:</b> ".$myrow["sentat"]."<br>".$sysbod;
  58         if ($userlevel >= 50)
  59         {
  60                 echo "<br><br><a href=sendsys.php?user=".$myrow["userid"].">Reply</a> | <a href=http://rhn.skwerl.net/boards/topiclist.php?board=1>CE</a>";
  61         }
  62         echo "<br><br>";
  63 }
  64 $sql = "UPDATE users SET notify='0' WHERE userid='$userid'";
  65 $result = mysql_query($sql);
  66 $sql = "UPDATE systemnot SET active='0' WHERE sendto='$userid'";
  67 $result = mysql_query($sql);
  68 echo "<center>All system notifications are deleted as you view them.";
  69 ?>