Advertisement
TLama

Untitled

Feb 28th, 2014
347
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.60 KB | None | 0 0
  1. function validateUser(const UserName, Password: string): Boolean;
  2. var
  3.   MD5: TIdHashMessageDigest5;
  4. begin
  5.   Result := False;
  6.  
  7.   MD5 := TIdHashMessageDigest5.Create;
  8.   try
  9.     sqlqry1.Close;
  10.     sqlqry1.SQL.Text := 'SELECT COUNT(*) login_id FROM login WHERE ' +
  11.       'login_username = :username AND login_password = :password';
  12.     sqlqry1.Params.ParamByName('username').AsString := UserName;
  13.     sqlqry1.Params.ParamByName('password').AsString := MD5.HashBytesAsHex(MD5.HashString(Password));
  14.     sqlqry1.Open;
  15.  
  16.     Result := sqlqry1.Fields[0].AsInteger > 0;
  17.   finally
  18.     MD5.Free;
  19.   end;
  20. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement