All pastes #798594 Raw Edit

Untitled

public cpp v1 · immutable
#798594 ·published 2007-11-26 22:04 UTC
rendered paste body
        if(type == "account")        {            //NO SQL injection as name is escaped            QueryResult *resultAccounts = loginDatabase.PQuery("SELECT `id` FROM `account` WHERE `username` = '%s'",nameOrIP.c_str());            if(!resultAccounts)                return false;            Field* fieldsAccount = resultAccounts->Fetch();            account = fieldsAccount->GetUInt32();            delete resultAccounts;        }        else if(type == "character")        {            normalizePlayerName(nameOrIP);            //NO SQL injection as name is escaped            QueryResult *resultAccounts = CharacterDatabase.PQuery("SELECT `account` FROM `character` WHERE `name` = '%s'",nameOrIP.c_str());            if(!resultAccounts)                return false;            Field* fieldsAccount = resultAccounts->Fetch();            account = fieldsAccount->GetUInt32();            delete resultAccounts;        }// ------------------------------------------------        if(type == "account")        {            //NO SQL injection as name is escaped            QueryResult *resultAccounts = loginDatabase.PQuery("SELECT `id` FROM `account` WHERE `username` = '%s'",nameOrIP.c_str());        }        else if(type == "character")        {            normalizePlayerName(nameOrIP);            //NO SQL injection as name is escaped            QueryResult *resultAccounts = CharacterDatabase.PQuery("SELECT `account` FROM `character` WHERE `name` = '%s'",nameOrIP.c_str());        }        if(!resultAccounts)            return false;        Field* fieldsAccount = resultAccounts->Fetch();        account = fieldsAccount->GetUInt32();        delete resultAccounts;