public function Listar()
{
$connection = new ConexionModel();
$query = "select * from sitio;";
$resultado = $connection->ejecutarSelect($query);
return $resultado;
}
public function Validar($usuario, $pass)
{
$connection = new ConexionModel();
$query = "SELECT * from login where User='******' and AES_DECRYPT(Pass,'1111')='{$pass}'";
$resultado = $connection->ejecutarSelect($query);
return $resultado;
}
public function Listar()
{
$connection = new ConexionModel();
$query = "select cuenta.id,sitio_idsitio as idsitio,aes_decrypt(cuenta.pass,'1111') as pass,sitio.enlace as sitio,email,usuario,ultimaMod,login.User \n from (cuenta inner join sitio on sitio.idsitio=cuenta.sitio_idsitio) inner join \n login on login.Id=cuenta.login_Id;";
$resultado = $connection->ejecutarSelect($query);
return $resultado;
}
