public List<Dictionary<string, object>> RetriveNicknames have a wrong sql query

GameProgressive / UniSpyServer

An Open source GameSpy emulator written in C#

GNU Affero General Public License v3.0

134 stars 18 forks source link

public List<Dictionary<string, object>> RetriveNicknames have a wrong sql query #7

Closed koujiangheng closed 5 years ago

koujiangheng commented 5 years ago

return Query("SELECT profiles.nick, profiles.uniquenick FROM profiles " + "INNER JOIN users ON profiles.userid=users.userid " + "WHERE LOWER(users.email)='@P0' AND LOWER(users.password)='@P1'" , email.ToLowerInvariant(), password.ToLowerInvariant()); please check this