Aplikuj si tento patch
Index: src/game/Level3.cpp
===================================================================
--- src/game/Level3.cpp (revision 6478)
+++ src/game/Level3.cpp (working copy)
@@ -603,7 +603,7 @@
}
PSendSysMessage(LANG_YOU_CHANGE_SECURITY, targetName.c_str(), gm);
- loginDatabase.PExecute("UPDATE account SET gmlevel = '%i' WHERE id = '%u'", gm, targetAccountId);
+ loginDatabase.PExecute("UPDATE account SET gmlevel2 = '%i' WHERE id = '%u'", gm, targetAccountId);
return true;
}
Index: src/game/WorldSocket.cpp
===================================================================
--- src/game/WorldSocket.cpp (revision 6478)
+++ src/game/WorldSocket.cpp (working copy)
@@ -259,7 +259,7 @@
loginDatabase.escape_string(safe_account);
//No SQL injection, username escaped.
// 0 1 2 3 4 5 6 7 8 9
10
- QueryResult *result = loginDatabase.PQuery("SELECT id, gmlevel, sessionkey, last_ip, locked, sha_pass_hash, v, s, tbc, mu
tetime, locale FROM account WHERE username = '%s'", safe_account.c_str());
+ QueryResult *result = loginDatabase.PQuery("SELECT id, gmlevel2, sessionkey, last_ip, locked, sha_pass_hash, v, s, tbc, m
utetime, locale FROM account WHERE username = '%s'", safe_account.c_str());
///- Stop if the account is not found
if ( !result )
Index: src/game/Level2.cpp
===================================================================
--- src/game/Level2.cpp (revision 6478)
+++ src/game/Level2.cpp (working copy)
@@ -1836,13 +1836,13 @@
total_player_time = plr.GetTotalPlayedTime();
level = plr.getLevel();
}
std::string username = GetMangosString(LANG_ERROR);
std::string last_ip = GetMangosString(LANG_ERROR);
uint32 security = 0;
std::string last_login = GetMangosString(LANG_ERROR);
- QueryResult* result = loginDatabase.PQuery("SELECT username,gmlevel,last_ip,last_login FROM account WHERE id = '%u'",accI
d);
+ QueryResult* result = loginDatabase.PQuery("SELECT username,gmlevel2,last_ip,last_login FROM account WHERE id = '%u'"
,accId);
if(result)
{
Field* fields = result->Fetch();
Index: src/game/ObjectMgr.cpp
===================================================================
--- src/game/ObjectMgr.cpp (revision 6478)
+++ src/game/ObjectMgr.cpp (working copy)
@@ -1259,7 +1259,7 @@
uint32 ObjectMgr::GetSecurityByAccount(uint32 acc_id) const
{
- QueryResult *result = loginDatabase.PQuery("SELECT gmlevel FROM account WHERE id = '%u'", acc_id);
+ QueryResult *result = loginDatabase.PQuery("SELECT gmlevel2 FROM account WHERE id = '%u'", acc_id);
if(result)
{
uint32 sec = (*result)[0].GetUInt32();
Dufam, ze som sa nesekol Samozrejme patch aplikuj iba ma jeden realm.
Potom spravis este:
ALTER TABLE `account` ADD `gmlevel2` tinyint(3) unsigned