Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.72 KB | None | 0 0
  1.                                     string SQL = "SELECT (u.UserId,u.Username,u.Password,u.Status) FROM Users AS u";
  2.                                            SQL += "OUTER APPLY (SELECT b.BanId FROM Bans AS b WHERE @P0 >= b.Start AND @P0 <= b.Finish AND b.UserId = u.UserId AND b.GalaxyId = @P1) AS banCheck ";
  3.                                            SQL += "OUTER APPLY (SELECT gu.GalaxyId, gu.DisplayName FROM GalaxyUsers AS gu WHERE gu.GalaxyId = @P1 AND gu.UserId = u.UserId) AS galCheck ";
  4.                                            SQL+="WHERE u.Status = 0 AND u.Username = @P2 AND u.Password = @P3";
  5.  
  6.                                     DataTable res = DB.RunSQL(dx,SQL,DateTimeOffset.UtcNow,GalaxyId,Username,PasswordHash);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement