VGOEmulator.net

Code: Select all

void Net::HandleNewSession(shared_ptr<Client>& client, PacketStruct *packet_struct) {
    const char *account_id, *session_id;

    account_id = packet_struct->GetString32("AccountId");
    session_id = packet_struct->GetString32("SessionId");

    LogInfo(LOG_NET, 0, "New Session: Account ID: %s  Session ID: '%s'", account_id, session_id);

    client->SetAccountID(atoul(account_id));
    client->SetSessionID(session_id);

    //We know need to request the account name from login :/
    //Yeah, it's the only way to do it since world does not have access to login's database.
    //Once we get the account info, do the rest in SendAccountInfo below
    login.SendAccountInfoRequest(client->GetAccountID(), client->GetConnectionID());
}

Code: Select all

bool LoginDatabase::LoadAccountInfo(shared_ptr<Client>& client) {
	DatabaseResult result;
    char *session_id_esc = NULL;
    bool success = true;

    if ((session_id_esc = database.Escape(client->GetSessionID())) == NULL)
        return false;

	LogDebug(LOG_ACCOUNT, 0, "Loading Account info...");

	success = database.Select(&result, "SELECT a.`account_id`,a.`account_name`\n"
                                       "FROM `ls_sessions` s\n"
                                       "INNER JOIN `ls_accounts` a ON a.`account_id`=s.`session_account_id`\n"
                                       "WHERE s.`session_id`='%s'", session_id_esc);

    free(session_id_esc);

    if (!success) {
        LogError(LOG_DATABASE, 0, "Error getting account information for session ID '%s': %s", client->GetSessionID(), database.GetError());
        return false;
    }

    if (!result.Next()) {
        LogError(LOG_DATABASE, 0, "No account information found for session ID '%s'", client->GetSessionID());
        LogError(LOG_DATABASE, 0, "If you're testing, simply create an entry in the session table with the session ID '%s'", client->GetSessionID());
        return false;
    }

    client->SetAccountID(result.GetUInt32(0));
    client->SetAccountName(result.GetString(1));
	
	LogDebug(LOG_ACCOUNT, 0, "Loaded Account: %s (%u)", client->GetAccountName(), client->GetAccountID());

	return true;
}