<?php
session_start();

class Login {
  private $conn;

  public function __construct($conn=NULL) {
    $this->conn = $conn;
  }

  public function loginExists($username, $password) {
      $userQuery = mysql_query("SELECT * FROM users WHERE username='".$username."' AND password='".md5($password)."'") or die ('User Exists Query Error --- MySQL Error No: '.mysql_errno().' --- '.mysql_error());
      $userCount = mysql_num_rows($userQuery);
      $userRow = mysql_fetch_array($userQuery);
      return array("userCount"=>$userCount, "userRow"=>$userRow);
  }

  public function userLogAdd ($uid) {
      $userLogAddQuery = mysql_query('INSERT INTO userLog (userID) VALUES ("'.$uid.'")') or die ('User Log Add Query Error --- MySQL Error No: '.mysql_errno().' --- '.mysql_error());
      $logID = mysql_insert_id();
      return $logID;
  }

  public function userLogUpdate ($uid,$logID) {
      $uid = (isset($_SESSION['uid']) ? $_SESSION['uid'] : $uid);
      $logID = (isset($_SESSION['logID']) ? $_SESSION['logID'] : $logID);
      $userLogUpdateQuery = mysql_query('UPDATE userLog SET `logout`=NOW() WHERE userID="'.$uid.'" AND id="'.$logID.'"') or die ('User Log Update Query Error --- MySQL Error No: '.mysql_errno().' --- '.mysql_error());
  }

  public function userLogActive($uid) {
      $userLogActiveQuery = mysql_query('SELECT * FROM userLog WHERE userID="'.$uid.'" AND ISNULL(logout)') or die ('User Log Active Query Error --- MySQL Error No: '.mysql_errno().' --- '.mysql_error());
      $userLogActive = array();
      while ($fetch = mysql_fetch_assoc($userLogActiveQuery)) {
          $userLogActiveRow[] = $fetch;
      }
      return $userLogActiveRow;
  }
}
?>