Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tutorial] One account per IP

Banned
Banned
Joined
Jan 31, 2014
Messages
108
Reaction score
51
Go to Your Database In Your Navicat and Proceed With These Steps
Go Warz \ dbo \ Functions \ WZ_ACCOUNT_CREATE

Look for and Why
Code:
-- validate that email is unique
    if exists (SELECT CustomerID from Accounts WHERE email=@in_Email) begin
        select 2 as ResultCode, 'Email already in use' as ResultMsg;
        return;

    end


add below
Code:
-- validate that IP is unique --mt   
if exists (SELECT CustomerID from Accounts WHERE lastloginIP=@in_IP) begin
        select 2 as ResultCode, 'Already registered' as ResultMsg;
        return;
    end


Then go into your launcher and test if it is working Thanks!

---------------------------------------------------------------------------------------------

Sorry for not speak much English -GoogleTradutor-
Credits: @MUIT0L0K0
 
Last edited:
Custom Title Activated
Loyal Member
Joined
May 18, 2006
Messages
1,425
Reaction score
119
not for internet cafe
 
Newbie Spellweaver
Joined
Apr 1, 2015
Messages
72
Reaction score
6
how to remove it? coz i try to find this function but i don't found it any idea to disable this coz when i going to loggin from another ip i get ban from sql
 
Back
Top