• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

[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