[Request] How skip filling serial-key

Results 1 to 3 of 3
  1. #1
    My Status --> LukasCCB is online now
    Grand MasterRank
    Apr 2013 Join Date
    CracolandiaLocation
    1,189Posts

    [Request] How skip filling serial-key

    Hello


    I want to do that when the player clicks Register it automatically skips the part serial key, serial key auto populates the, type Deathz!


    some help?
    thank you in =)
    Last edited by DNC; 17-06-14 at 04:49 AM.


  2. #2
    Member jojo5528 is offline
    MemberRank
    Feb 2014 Join Date
    Mesod, Tak, ThaLocation
    33Posts

    Re: How skip filling serial-key

    i know some fix it...
    the launcher will skip the filling serial-key page (when you press register button it'll go to the register page)

    in fuction WZ_ACCOUNT_CREATE

    on the top line put this
    SET NOCOUNT ON;
    example
    ALTER PROCEDURE [dbo].[WZ_ACCOUNT_CREATE] @in_IP varchar(64),
    @in_Email varchar(128),
    @in_Password varchar(64),
    @in_ReferralID int,
    @in_SerialKey varchar(128),
    @in_SerialEmail varchar(128)
    AS
    BEGIN
    SET NOCOUNT ON;

    -- Close Register from Launcher
    -- select 2 as ResultCode, 'Registeration from Patcher/Launcher was closed.' as ResultMsg;
    -- return;

    --
    -- NOTE: add new ResultCodes to updater CUpdater::CreateAccThreadEntry
    --



    -- check for serial key
    --declare @keyResultCode int = 99
    --declare @keyCustomerID int = 99
    --declare @keySerialType int = 99
    --exec [BreezeNet].[dbo].[BN_WarZ_SerialGetInfo]
    -- @in_SerialKey,
    -- @in_SerialEmail,
    -- @keyResultCode out,
    -- @keyCustomerID out,
    -- @keySerialType out

    --if(@keyResultCode <> 0 or @keyCustomerID > 0) begin
    -- select 3 as ResultCode, 'Serial not valid' as ResultMsg;
    -- return
    --end
    declare @keySerialType int = 2 -- Legend Package
    ps.sorry for my bad english

  3. #3
    My Status --> LukasCCB is online now
    Grand MasterRank
    Apr 2013 Join Date
    CracolandiaLocation
    1,189Posts

    Re: How skip filling serial-key

    existing

    my WZ_ACCOUNT_CREATE

    Code:
    
    -- ----------------------------
    -- Procedure structure for [WZ_ACCOUNT_CREATE]
    -- ----------------------------
    
    
    ALTER PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
    	@in_IP varchar(64),
    	@in_Email varchar(128),
    	@in_Password varchar(64),
    	@in_ReferralID int,
    	@in_SerialKey varchar(128),
    	@in_SerialEmail varchar(128)
    AS
    BEGIN
    	SET NOCOUNT ON;
    	-- Close Register from Launcher
    	-- select 2 as ResultCode, 'Registeration from Patcher/Launcher was closed.' as ResultMsg;
    	-- return;
    		
    	--
    	-- NOTE: add new ResultCodes to updater CUpdater::CreateAccThreadEntry
    	--
    	
    
    
    -- check for serial key
    	--declare @KEYResultCode int = 99
    	--declare @KEYCustomerID int = 99
    	--declare @KeyserialType int = 99
    	--exec [BreezeNet].[dbo].[BN_WarZ_SerialGetInfo]
    		--	@in_SerialKey,
    		--	@in_SerialEmail,
    		-- @KEYResultCode out,
    		-- @KEYCustomerID out,
    		-- @KeyserialType out
    								
    	--if @KEYResultCode <> 0 or @KEYCustomerID > 0) begin
    	--	select 3 as ResultCode, 'Serial not valid' as ResultMsg;
    	--	return
    	--end
    	declare @KeyserialType int = 1 -- Pionner
    
    
    -- check if that account was created and refunded before (status 999)
    	declare @ReFundCustomerID int = 0
    	select @ReFundCustomerID=CustomerID from Accounts WHERE email=@in_Email and AccountStatus=999
    	if @ReFundCustomerID > 0) begin
    		-- change email to some unique one so it can be used again.
    		declare @dateTime varchar(128)
    		set @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') + REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','')
    		declare @ReFundedEmail varchar(128) = '(' + @dateTime + ') ' + @in_Email
    		update Accounts set email @ReFundedEmail where CustomerID @ReFundCustomerID
    	end
    	
    -- 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
    	
    -- create user
    	declare @MD5FromPwd varchar(100)
    	exec FN_CreateMD5Password @in_Password, @MD5FromPwd OUTPUT
    	INSERT INTO Accounts ( 
    		email,
    		MD5Password,
    		dateregistered,
    		ReferralID,
    		lastlogindate,
    		lastloginIP
    	) VALUES (
    		@in_EMail,
    	 @MD5FromPwd,
    		GETDATE(),
    		@in_ReferralID,
    		GETDATE(),
    		@in_IP
    	)
    
    
    	-- get new CustomerID
    	declare @CustomerID int
    	SELECT @CustomerID=CustomerID from Accounts where email=@in_Email
    
    
    -- create all needed user tables
    	INSERT INTO UsersData (
    		CustomerID,
    		AccountType,
    		dateregistered
    	) VALUES (
    	 @CustomerID,
    	 @KeyserialType,
    		GETDATE()
    	)
    
    
    
    
    update UsersData set GamePoints=(GamePoints+4260) where CustomerID @CustomerID
    	
    	-- guest accounts have 48hrs play time (sync with WZ_ACCOUNT_APPLYKEY also)
    	if @KeyserialType = 3) begin
    		declare @dateActiveUntil datetime = DATEADD(hour, 48, GETDATE())
    		update UsersData set DateActiveUntil @dateActiveUntil where CustomerID @CustomerID
    	end
    	
    -- register CustomerID in BreezeNet
    	-- exec [BreezeNet].[dbo].[BN_WarZ_SerialSetCustomerID] @in_SerialKey, @CustomerID
    
    
    -- default items and bonuses for account types
    
    
    	exec FN_AddItemToUser @CustomerID, 20174, 2000 -- hero: regular guy
    
    
    	-- CBT TEST HEROES
    	exec FN_AddItemToUser @CustomerID, 20182, 2000
    	exec FN_AddItemToUser @CustomerID, 20184, 2000
    
    
    	-- 10 of each
    	--declare @i int = 0
    	--while(@i < 10) begin
    	--	set @i = @i + 1
    
    
    	--	exec FN_AddItemToUser @CustomerID, 101306, 2000 -- Flashlight
    	--	exec FN_AddItemToUser @CustomerID, 101261, 2000 -- Bandages
    	--	exec FN_AddItemToUser @CustomerID, 101296, 2000 -- Can of Soda
    	--	exec FN_AddItemToUser @CustomerID, 101289, 2000 -- Granola Bar
    	--end
    
    
    -- BONUSES for packages - do not forget to sync them with [WZ_ACCOUNT_APPLYKEY]
    	
    	-- success
    	select 0 as ResultCode
    	select @CustomerID as CustomerID, @KeyserialType as 'AccountType'
    
    
    	return
    END



Advertisement