First add ban by Hardwareid and Mac in your src.
Tutorial> http://forum.ragezone.com/f790/release-ban-mac-address-simple-1009589/Tutorial> http://forum.ragezone.com/f791/tutorial-ban-hardware-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:
Add below:
Save
Credits: @Yuri-BR, @pymode and me
Sorry for my bad English.
Tutorial> http://forum.ragezone.com/f790/release-ban-mac-address-simple-1009589/Tutorial> http://forum.ragezone.com/f791/tutorial-ban-hardware-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.
Last edited: