Create an account with IP checking

CapBlackShot · Nov 24, 2013

Hello, RageZONE!

At the moment, I use the global key (XXXX-XXXX-XXXX-XXXX) for register. But I would like to know if I can create an tool to allow just one account by IP.

If someone wants to release it or assist in the creation, I will thank you.

Mateuus · Nov 24, 2013

WZ_ACCOUNT_CREATE

add

Code:

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

CapBlackShot · Nov 24, 2013

Mateuus said:

WZ_ACCOUNT_CREATE

add

Code:

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

Thank you so much!

Mateuus said:

WZ_ACCOUNT_CREATE

add

Code:

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

Taking advantage, can I set an number of accounts by IP? Thank you!

Create an account with IP checking

CapBlackShot

Newbie Spellweaver

Mateuus

Junior Spellweaver

CapBlackShot

Newbie Spellweaver