A more account question about restricting user login

[Freetate]

I am a beginner, and I want to restrict my server so that my players can only log in with no more than 3 IDs on the same IP or computer, so that the game can run better.

I hope to get a complete and detailed solution. The SQL I use is heidiSQL. How can I limit it?

[Era-Lusiphur]

You can attempt to restrict to the best of your abilities and the most stubborn or devious players will generally find a way, and then it comes down to other players reporting them or observation.

A fairly simple solution would be to make an adjustment here:

server/src/login/login_session.cpp

Line 58 in 59aea03

if (multiple_ip_count > 1)

    if (multiple_ip_count > 1) {
        ShowInfo("Detected %i instances from %s. Returning best account match.\n", multiple_ip_count, ip2str(ip, nullptr));
        if (multiple_ip_count > 3) {
            ShowInfo("Detected %i instances from %s. limit has been reached. \n", multiple_ip_count, ip2str(ip, nullptr));
            return nullptr;
        }
    }

That should work as a crude method of limiting players to 3 instances, but it is not perfect.

I know @zach2good and some others have brainstormed on a better solution, but it likely wouldn't occur until someone rewrites or makes large adjustments to the login server (and possibly xiloader as well!).

[Freetate]

//////// 19/03/2012 Fix for 1 IP -> Many Accounts
// Simply increases "serviced" by 1 every time a login is returned via an IP address.
// The result is the illusion of independancy (though really it's not!)
unsigned int minserv           = 1000;
int          multiple_ip_count = 3;
for (auto& i : login_sd_list)
{
    if (i->client_addr == ip)
    {
        multiple_ip_count++;
        if (i->serviced < minserv)
        {
            minserv = i->serviced;
        }
    }
}

if (multiple_ip_count > 1) {
    ShowInfo("Detected %i instances from %s. Returning best account match.\n", multiple_ip_count, ip2str(ip, nullptr));
    if (multiple_ip_count > 3) {
        ShowInfo("Detected %i instances from %s. limit has been reached. \n", multiple_ip_count, ip2str(ip, nullptr));
        return nullptr;
    }
}

I set up my player to still be able to log in with more than 3 IDs, please see if mine is correct
thank you very much！~