Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Serverside Modding => Topic started by: Kobiesan on February 01, 2018, 05:40:15 pm

Title: Anti-Multiboxing?
Post by: Kobiesan on February 01, 2018, 05:40:15 pm
I'm trying to counter multiboxing on my server and I am trying to achieve this with an SQL constraint. I know there is a way to disallow duplicate last_ip in auth.account but I want to allow 3 duplicate accounts from the same IP at a given time (I don't want to disallow friends/family/people in the same apartment complex to not be able to play). Is there a way to accomplish this or any better anti-multiboxing methods out there?
Title: Re: Anti-Multiboxing?
Post by: schlumpf on February 01, 2018, 07:20:03 pm
likely not without custom code.

SELECT COUNT(*) FROM auth.account WHERE last_ip = %1

should help
Title: Re: Anti-Multiboxing?
Post by: Kobiesan on February 01, 2018, 07:23:52 pm
Quote from: schlumpf on February 01, 2018, 07:20:03 pm
likely not without custom code.

SELECT COUNT(*) FROM auth.account WHERE last_ip = %1

should help

This runs once though. I want to have it constantly running to only allow no more than 3 duplicates.
Title: Re: Anti-Multiboxing?
Post by: schlumpf on February 01, 2018, 07:36:15 pm
run it on logging in?
Title: Re: Anti-Multiboxing?
Post by: Kobiesan on February 01, 2018, 08:05:41 pm
Quote from: schlumpf on February 01, 2018, 07:36:15 pm
run it on logging in?

How would I do that? Lua?
Title: Re: Anti-Multiboxing?
Post by: schlumpf on February 01, 2018, 08:28:00 pm
this hugely depends on your emulator and the version of it. at the point of handling log in, also execute that query.

trinity 3.3.5 would probably need to be patched here: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/Server/AuthSession.cpp#L335
Title: Re: Anti-Multiboxing?
Post by: Ascathos on February 02, 2018, 09:04:12 pm
Quote from: schlumpf on February 01, 2018, 08:28:00 pm
this hugely depends on your emulator and the version of it. at the point of handling log in, also execute that query.

trinity 3.3.5 would probably need to be patched here: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/Server/AuthSession.cpp#L335

I suggest writing a loginscript (New Script -> AccountScript) that checks on each login for duplicate ips. You should find your own algorithm for this though.

This would work though.
Title: Re: Anti-Multiboxing?
Post by: Kobiesan on February 02, 2018, 09:53:28 pm
Quote from: Ascathos on February 02, 2018, 09:04:12 pm
Quote from: schlumpf on February 01, 2018, 08:28:00 pm
this hugely depends on your emulator and the version of it. at the point of handling log in, also execute that query.

trinity 3.3.5 would probably need to be patched here: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/Server/AuthSession.cpp#L335

I suggest writing a loginscript (New Script -> AccountScript) that checks on each login for duplicate ips. You should find your own algorithm for this though.

This would work though.

A c++ script? Where do I put them?