#include "AuthSession.h"

Public Member Functions
void	LoadResult (Field *fields)

	AccountInfo (Field *fields)

Public Attributes
uint32	Id = 0

std::string	Login

bool	IsLockedToIP = false

std::string	LockCountry

std::string	LastIP

uint32	FailedLogins = 0

bool	IsBanned = false

bool	IsPermanentlyBanned = false

AccountTypes	SecurityLevel = SEC_PLAYER

::SessionKey	SessionKey

uint8	Expansion

int64	MuteTime

LocaleConstant	Locale

uint32	Recruiter

std::string	OS

bool	IsRectuiter

AccountTypes	Security

uint32	TotalTime

Detailed Description

Constructor & Destructor Documentation

◆ AccountInfo()

AccountInfo::AccountInfo ( Field * fields )

inlineexplicit

    {
        //           0             1          2         3               4            5           6         7            8     9           10          11
        // SELECT a.id, a.sessionkey, a.last_ip, a.locked, a.lock_country, a.expansion, a.mutetime, a.locale, a.recruiter, a.os, a.totaltime, aa.gmLevel,
        //                                                           12    13
        // ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id
        // FROM account a
        // LEFT JOIN account_access aa ON a.id = aa.AccountID AND aa.RealmID IN (-1, ?)
        // LEFT JOIN account_banned ab ON a.id = ab.id
        // LEFT JOIN account r ON a.id = r.recruiter
        // WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1
        Id = fields[0].Get<uint32>();
        SessionKey = fields[1].Get<Binary, SESSION_KEY_LENGTH>();
        LastIP = fields[2].Get<std::string>();
        IsLockedToIP = fields[3].Get<bool>();
        LockCountry = fields[4].Get<std::string>();
        Expansion = fields[5].Get<uint8>();
        MuteTime = fields[6].Get<int64>();
        Locale = LocaleConstant(fields[7].Get<uint8>());
        Recruiter = fields[8].Get<uint32>();
        OS = fields[9].Get<std::string>();
        TotalTime = fields[10].Get<uint32>();
        Security = AccountTypes(fields[11].Get<uint8>());
        IsBanned = fields[12].Get<uint64>() != 0;
        IsRectuiter = fields[13].Get<uint32>() != 0;
 
        uint32 world_expansion = sWorld->getIntConfig(CONFIG_EXPANSION);
        if (Expansion > world_expansion)
            Expansion = world_expansion;
 
        if (Locale >= TOTAL_LOCALES)
            Locale = LOCALE_enUS;
    }

References CONFIG_EXPANSION, Expansion, Field::Get(), Id, IsBanned, IsLockedToIP, IsRectuiter, LastIP, Locale, LOCALE_enUS, LockCountry, MuteTime, OS, Recruiter, Security, SESSION_KEY_LENGTH, sWorld, TOTAL_LOCALES, and TotalTime.

Member Function Documentation

◆ LoadResult()

void AccountInfo::LoadResult ( Field * fields )

{
    //          0        1          2           3             4             5
    // SELECT a.id, a.username, a.locked, a.lock_country, a.last_ip, a.failed_logins,
    //                                 6                                        7
    // ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate,
    //                                 8                                             9
    // ipb.unbandate > UNIX_TIMESTAMP() OR ipb.unbandate = ipb.bandate, ipb.unbandate = ipb.bandate,
    //      10
    // aa.gmlevel (, more query-specific fields)
    // FROM account a LEFT JOIN account_access aa ON a.id = aa.id LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 LEFT JOIN ip_banned ipb ON ipb.ip = ? WHERE a.username = ?
 
    Id = fields[0].Get<uint32>();
    Login = fields[1].Get<std::string>();
    IsLockedToIP = fields[2].Get<bool>();
    LockCountry = fields[3].Get<std::string>();
    LastIP = fields[4].Get<std::string>();
    FailedLogins = fields[5].Get<uint32>();
    IsBanned = fields[6].Get<bool>() || fields[8].Get<bool>();
    IsPermanentlyBanned = fields[7].Get<bool>() || fields[9].Get<bool>();
    SecurityLevel = static_cast<AccountTypes>(fields[10].Get<uint8>()) > SEC_CONSOLE ? SEC_CONSOLE : static_cast<AccountTypes>(fields[10].Get<uint8>());
 
    // Use our own uppercasing of the account name instead of using UPPER() in mysql query
    // This is how the account was created in the first place and changing it now would result in breaking
    // login for all accounts having accented characters in their name
    Utf8ToUpperOnlyLatin(Login);
}