cremark.php

   1 <?php include ("config.php");
   2 function auth($userid, $password)
   3 {
   4         $sql = "SELECT username FROM users WHERE username='$userid' AND userpass='$password'";
   5         $result = mysql_query($sql);
   6         if (!mysql_num_rows($result))
   7                 return 0;
   8         else
   9         {
  10                 $query_data = mysql_fetch_row($result);
  11                 return $query_data[0];
  12         }
  13 }
  14 if (!$user)
  15 {
  16         echo "Invalid userID.";
  17         exit;
  18 }
  19 $username = auth($uname, $pword);
  20 if (!$username)
  21 {
  22         echo "You are not <a href=login.php>Logged In</a>.";
  23         exit;
  24 }
  25 $sql = "SELECT * FROM users WHERE username='$uname'";
  26 $result = mysql_query($sql);
  27 $myrow = mysql_fetch_array($result);
  28 if ($myrow["level"] <= 49)
  29 {
  30         echo "You cannot be here.";
  31         exit;
  32 }
  33 $sql = "SELECT * FROM users WHERE userid='$user'";
  34 $result = mysql_query($sql);
  35 $myrow = mysql_fetch_array($result);
  36 $toptit = "Generated Message for ".$myrow["username"]." userID ".$myrow["userid"];
  37 $usename = $myrow["username"];
  38 $posttime = time();
  39 $datedate = date("Y-n-j H:i");
  40 $sql = "INSERT INTO topics (topicname,boardnum,topicby,timesec,active,postdate) VALUES ('$toptit','15','$usename','$posttime','1','$datedate')";
  41 $result = mysql_query($sql);
  42 $topicid = mysql_insert_id($db);
  43 $bodbod = "<b>Username: </b>".$myrow["username"];
  44 $sql = "INSERT INTO messages (topic,messby,messsec,messbody,mesboard,theorder,postdate) VALUES ('$topicid','$usename','$posttime','$bodbod','15','1','$datedate')";
  45 $result = mysql_query($sql);
  46 $message = mysql_insert_id($db);
  47 $reason2 = "Generated Message";
  48 $sql = "INSERT INTO marked (reason,markwho,message,topic,board,active,markedtimes,reason2) VALUES ('4','$usename','$message','$topicid','15','1','1','$reason2')";
  49 $result = mysql_query($sql);
  50 echo "Message Generated.  Please check the <a href=modme.php>Mod queue</a>.";
  51 exit;
  52 ?>