[Tutorial] One Account per HardwarID/Mac/Ip

[TCLgames]

First add ban by Hardwareid and Mac in your src.
Tutorial> http://forum.ragezone.com/f790/relea...imple-1009589/Tutorial> http://forum.ragezone.com/f791/tutor...re-id-1004900/
Now let's add the restrictions in the database.
Open: WZ_ACCOUNT_CREATE
Search: @in_Email varchar(128),
Add below
@in_HardwareID varchar(14),
@in_Mac varchar(14),


New Search:

-- 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:

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

if exists (SELECT CustomerID from HWID_Log WHERE HardwareID=@in_HardwareID) beginselect 2 as ResultCode, 'HWID is already registered' as ResultMsg;return;end

if exists (SELECT CustomerID from Mac_Log WHERE Mac=@in_Mac) beginselect 2 as ResultCode, 'MAC is already registered' as ResultMsg;return;end

Save :)


Credits: @Yuri-BR, @pymode and me :)


Sorry for my bad English.

[MentaL]