<?php

class AccountData extends Factory{


 function AccountData()
 {
  $this->elem = array(
  "id" => null,
  "name" => null,
  "password" => null,
  "activated" => null,
  "access_level" => null,
  "membership" => null,
  "last_server" => null,
  "last_ip" => null,
  );
 }

 function SelectById($id)
 {
  $sql = "SELECT id,
                 name,
                 password,
                 activated,
                 access_level,
                 membership,
                 last_server,
                 last_ip
            FROM ".MYSQL_BASE_LS.".account_data
           WHERE id = ".mysql_real_escape_string($id);

  return $this->PopulateObject($sql);
 }

 function FazerLogin()
 {
  $sql = "SELECT id,
                 name,
                 password,
                 activated,
                 access_level,
                 membership,
                 last_server,
                 last_ip
            FROM ".MYSQL_BASE_LS.".account_data
     WHERE activated = 1
       AND name = '".mysql_real_escape_string($this->name)."'
       AND password = '".mysql_real_escape_string($this->password)."'";

  if($this->PopulateObject($sql))
  {  
   return true;
  }else{
   return false;
  }
 }

 function isPassword()
 {
  $sql = "SELECT id,
                 name,
                 password,
                 activated,
                 access_level,
                 membership,
                 last_server,
                 last_ip
            FROM ".MYSQL_BASE_LS.".account_data
     WHERE activated = 1
       AND id = '".mysql_real_escape_string($this->id)."'
       AND password = '".mysql_real_escape_string($this->password)."'";

  if($this->PopulateObject($sql))
  {  
   return true;
  }else{
   return false;
  }
 }

 function CanInsert()
 {
  $sql = "SELECT name
            FROM ".MYSQL_BASE_LS.".account_data
           WHERE name = '".mysql_escape_string($this->name)."'";

  $query = mysql_query($sql, $GLOBALS["conn"]);

  if($rs = mysql_fetch_assoc($query))
  {
   return false;
  }

  return true;
 }

 function getTotalAccounts()
 {
  $total = 0;
  
  $sql = "SELECT count(*) as total
            FROM ".MYSQL_BASE_LS.".account_data 
           ";

  $query = mysql_query($sql, $GLOBALS["conn"]) or die(mysql_error());

  if($rs = mysql_fetch_assoc($query))
  {
   $total =  $rs["total"];
  }
  
  mysql_free_result($query);

  return $total;
 }

 function LoadByPost()
 {
  if($_POST != "")
  {
   $this->PopulateByPost();
   
   if($this->password != "")   
    $this->password = cryptPassword($this->password);
  }
 }

 function LoadByGet()
 {
  if($_GET != "")
  {
   $this->PopulateByGet();

   if($this->password != "")   
    $this->password = cryptPassword($this->password);
  }
 }


 function Insert()
 {
  return $this->db_insert(MYSQL_BASE_LS.".account_data");
 }


 function Update()
 {
  $where  = "id = ".mysql_real_escape_string($this->id);
  return $this->db_update(MYSQL_BASE_LS.".account_data", $where);
 }


 function LoadLista($order = "1 DESC")
 {
  if($_GET["pag"] > 0)
   $this->pag = $_GET["pag"];

  $sql = "SELECT id,
                   name,
                   password,
                   activated,
                   access_level,
                 membership,
                   last_server,
                   last_ip
            FROM ".MYSQL_BASE_LS.".account_data
           WHERE 1 = 1 ";

  $this->Populate($sql, $order);
 }


 function LoadCombo($value = "")
 {
  $sql = "SELECT id,
                   name,
                   password,
                   activated,
                   access_level,
                 membership,
                   last_server,
                   last_ip
            FROM ".MYSQL_BASE_LS.".account_data
        ORDER BY 1";

  $this->PopulateCombo($sql,$value);
 }
}
?>