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

1 files changed, 9 insertions, 10 deletions

diff --git a/src/game/Level1.cpp b/src/game/Level1.cpp
index 1d99b0d68e6..4163aaa40e1 100644
--- a/src/game/Level1.cpp
+++ b/src/game/Level1.cpp
@@ -25,6 +25,7 @@
 #include "World.h"
 #include "ObjectMgr.h"
 #include "Player.h"
+#include "AccountMgr.h"
 #include "Opcodes.h"
 #include "Chat.h"
 #include "Log.h"
@@ -483,12 +484,10 @@ bool ChatHandler::HandleGMTicketAssignToCommand(const char* args)
         return false;
 
     std::string targm = targetgm;
-
     if(!normalizePlayerName(targm))
-        return true;
+        return false;
 
     Player *cplr = m_session->GetPlayer();
-    std::string gmname;
     GM_Ticket *ticket = objmgr.GetGMTicket(ticketGuid);
 
     if(!ticket || ticket->closed != 0)
@@ -496,24 +495,24 @@ bool ChatHandler::HandleGMTicketAssignToCommand(const char* args)
         SendSysMessage(LANG_COMMAND_TICKETNOTEXIST);
         return true;
     }
+    
     uint64 tarGUID = objmgr.GetPlayerGUIDByName(targm.c_str());
     uint64 accid = objmgr.GetPlayerAccountIdByGUID(tarGUID);
-    QueryResult *result = loginDatabase.PQuery("SELECT 'gmlevel', 'RealmID' FROM account_access WHERE id = '%u'", accid);
+    uint32 gmlevel = accmgr.GetSecurity(accid, realmID);
 
-    Field * fields = result->Fetch();
-    uint32 gmlevel = fields[0].GetUInt32();
-    uint32 SecurityRealmID = fields[1].GetUInt32();
-
-    if(!tarGUID|| !result || gmlevel < SEC_MODERATOR || (SecurityRealmID != realmID && SecurityRealmID != -1))
+    if(!tarGUID || gmlevel == SEC_PLAYER)
     {
         SendSysMessage(LANG_COMMAND_TICKETASSIGNERROR_A);
         return true;
     }
+
     if(ticket->assignedToGM == tarGUID)
     {
         PSendSysMessage(LANG_COMMAND_TICKETASSIGNERROR_B, ticket->guid);
         return true;
     }
+
+    std::string gmname;
     objmgr.GetPlayerNameByGUID(tarGUID, gmname);
     if(ticket->assignedToGM != 0 && ticket->assignedToGM != cplr->GetGUID())
     {
@@ -1790,7 +1789,7 @@ bool ChatHandler::HandleModifyScaleCommand(const char* args)
         return false;
 
     float Scale = (float)atof((char*)args);
-    if (Scale > 10.0f || Scale <= 0.1f)
+    if (Scale > 10.0f || Scale < 0.1f)
     {
         SendSysMessage(LANG_BAD_VALUE);
         SetSentErrorMessage(true);