This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu
Pages: [1]

Author Topic: Anti-Multiboxing?  (Read 1503 times)

Kobiesan

  • Registred Member
  • Wiki Incarnate
  • *****
  • Posts: 161
    • View Profile
Anti-Multiboxing?
« 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?
Logged

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: Anti-Multiboxing?
« Reply #1 on: February 01, 2018, 07:20:03 pm »
likely not without custom code.

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

should help
Logged

Kobiesan

  • Registred Member
  • Wiki Incarnate
  • *****
  • Posts: 161
    • View Profile
Re: Anti-Multiboxing?
« Reply #2 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.
Logged

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: Anti-Multiboxing?
« Reply #3 on: February 01, 2018, 07:36:15 pm »
run it on logging in?
Logged

Kobiesan

  • Registred Member
  • Wiki Incarnate
  • *****
  • Posts: 161
    • View Profile
Re: Anti-Multiboxing?
« Reply #4 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?
Logged

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: Anti-Multiboxing?
« Reply #5 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
Logged

Ascathos

  • Moderators
  • Creator of Worlds
  • *****
  • Posts: 1129
    • View Profile
Re: Anti-Multiboxing?
« Reply #6 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.
Logged

Kobiesan

  • Registred Member
  • Wiki Incarnate
  • *****
  • Posts: 161
    • View Profile
Re: Anti-Multiboxing?
« Reply #7 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?
Logged
Pages: [1]