diff options
author | maanuel <none@none> | 2009-12-22 15:35:44 -0300 |
---|---|---|
committer | maanuel <none@none> | 2009-12-22 15:35:44 -0300 |
commit | fafad0a3a4b53c58dadfb2d2003f763ebea331ae (patch) | |
tree | 094ed65b6c00c01ba87e9132f71a29b72e442883 /src/trinitycore/RASocket.cpp | |
parent | ce3073111e4365b7502efc4443038a437419e239 (diff) |
Added new function "GetSecurity(targetAccountId, gmRealmID);" by ogeraisi.
Fixed command .account set gmlevel
Fixed command .ticket assing by Sundark/ogeraisi.
Improvements in .modify scale by ogeraisi.
Repaired Remote Access by Sundark.
The original patch of the access by realms was from ogeraisi/Kudlaty, not ilixiumemu like commit 6710 say.
--HG--
branch : trunk
Diffstat (limited to 'src/trinitycore/RASocket.cpp')
-rw-r--r-- | src/trinitycore/RASocket.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/trinitycore/RASocket.cpp b/src/trinitycore/RASocket.cpp index 15043bde3ef..ad8b748a687 100644 --- a/src/trinitycore/RASocket.cpp +++ b/src/trinitycore/RASocket.cpp @@ -154,7 +154,7 @@ void RASocket::OnRead() ///- Escape the Login to allow quotes in names loginDatabase.escape_string(login); - QueryResult* result = loginDatabase.PQuery("SELECT aa.gmlevel FROM account_access aa, account a WHERE a.username = '%s' AND aa.id = a.id",login.c_str()); + QueryResult* result = loginDatabase.PQuery("SELECT aa.gmlevel FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = '%s'",login.c_str ()); ///- If the user is not found, deny access if(!result) |