[Tutorial] One account per IP

Results 1 to 7 of 7
  1. #1
    Banned MUIT0L0K0 is offline
    BannedRank
    Jan 2014 Join Date
    Colorado V2Location
    110Posts

    [Tutorial] One account per IP

    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 by MUIT0L0K0; 16-10-15 at 01:08 PM.


  2. #2
    Apprentice Betinho Limeira is offline
    MemberRank
    Dec 2013 Join Date
    16Posts

    Re: [Tutorial] One account per IP

    Thanks.

  3. #3
    Alpha Member javaz97 is offline
    MemberRank
    May 2006 Join Date
    HellLocation
    1,537Posts

    Re: [Tutorial] One account per IP

    not for internet cafe

  4. #4
    Novice WARDEAD is offline
    MemberRank
    Dec 2014 Join Date
    CraftLandiaLocation
    1Posts

    Re: [Tutorial] One account per IP

    thank you

  5. #5
    Member Suycune is offline
    MemberRank
    Apr 2015 Join Date
    New York, New YLocation
    72Posts

    Re: [Tutorial] One account per IP

    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

  6. #6
    Apprentice naighost0123 is offline
    MemberRank
    Aug 2015 Join Date
    19Posts

    Re: [Tutorial] One account per IP

    How to setting 10 ID/IP

  7. #7
    Novice ittipong is offline
    MemberRank
    Aug 2014 Join Date
    1Posts

    Re: [Tutorial] One account per IP

    Thank



Advertisement