<?php
require_once "dbconf.php";

class BENUTZER
{

private $conn;

  public function__construct()
  {
    $database = new Database();
    $db = $database->dbConnection();
    $this->$conn = $db;
  }

  public function query($sql)
  {
    $stmt = $this->$conn->prepare($sql);
    return $stmt;
  }

  public function lastID()
  {
    $stmt =  $this->$conn->lastInsertID();
    return $stmt;
  }

  public function register($userEmail, $userName, $userNachname, $userWebSubdomain, $userPasswort, $verifyCode)
  {
    try
    {
       $passwort = md5($userPasswort);
       $stmt = $this->$conn->prepare("INSERT INTO userRegister
        (userEmail, userName, userNachname, userWebSubdomain, userPasswort, verifyCode)
                                      VALUES
        (:userEmail, :userName, :userNachname, :userWebSubdomain, :userPasswort, :verifyCode)");

       $stmt->bindparam(":userEmail", $userEmail);
       $stmt->bindparam(":userName", $userName);
       $stmt->bindparam(":userNachname", $userNachname);
       $stmt->bindparam(":userWebSubdomain", $userWebSubdomain);
       $stmt->bindparam(":userPasswort", $userPasswort);
       $stmt->bindparam(":verifyCode", $verifyCode);
    }
    catch(PDOException $ex)
    {
      echo $ex->getMessage();
    }
  }

  public function anmelden($userEmail, $userPasswort)
  {
    try
    {
      $stmt = $this->$conn->prepare("SELECT * FROM userRegister WHERE userEmail = :email");
      $stmt->execute(array(":email"=>$userEmail));
      $userRow=$stmt->fetch(PDO::FETCH_ASSOC);

      if($stmt->rowcount() == 1)
      {
        if ($userRow["userStatus"] == "Y")
        {
          if ($userRow["userPasswort"] == md5($userPasswort)) {
             $_SESSION["userSession"] == $userRow["userID"];
             return true;
           }
          else{
            header("Location: index.php?fehler");
            exit;
          }
        }
        else
        {
          header("Location: index.php?nicht_aktiv");
          exit;
        }
        }
      else
      {
        header("Location: index.php?fehler");
        exit;
      }
      }
      catch(PDOException $ex)
      {
       echo $ex->getMessage();
      }
     }

    public function ist_angemeldet()
    {
      if(issets($_SESSION["userSession"])){
        return true;
      }
    }

    public function umleiten($url)
    {
      header("Location: $url");
    }

    public function abmelden()
    {
      session_destroy();
      $_SESSION["userSession"] = false;
    }

    public function send_server_email($email, $nachricht, $grund)
    {
      require '../mailer/PHPMailerAutoload.php';

      /*$mail = new PHPMailer();
      $mail->IsSMTP();
      $mail->SMTPDebug  = 0;
      $mail->SMTPAuth   = true;
      $mail->SMTPSecure = "ssl";
      $mail->Host       = "smtp.gmail.com";
      $mail->Port       = 465;
      $mail->AddAddress($email);
      $mail->Username="yourgmailid@gmail.com";
      $mail->Password="yourgmailpassword";
      $mail->SetFrom('you@yourdomain.com','Coding Cage');
      $mail->AddReplyTo("you@yourdomain.com","Coding Cage");
      $mail->Subject    = $subject;
      $mail->MsgHTML($message);
      $mail->Send();
      */

      $mail = new PHPMailer;

      $mail->From = "testphpjohn@gmail.com";
      $mail->FromName = "Testphp";

      //To address and name
      $mail->addAddress($email, "Aktivieren");
      $mail->addAddress("recepient1@example.com"); //Recipient name is optional

      //Address to which recipient will reply
      $mail->addReplyTo("testphpjohn@gmail.com", "John Okken");

      //CC and BCC
      $mail->addCC("cc@example.com");
      $mail->addBCC("bcc@example.com");

      //Send HTML or Plain Text email
      $mail->isHTML(true);
      $mail->Subject    = $subject;
      $mail->MsgHTML($message);
      $mail->Send();
    }
  }
?>