Help with website

Results 1 to 2 of 2
  1. #1
    Apprentice dasaver is offline
    MemberRank
    Mar 2014 Join Date
    10Posts

    Help with website

    I am having a problem i have just about everything set up for the website. when i go to make an account for my flyff server it creates the account but it only creates the account in ACCOUNT_TBL_DETAIL and not in the ACCOUNT_TBL. so every time i go to log into this new account it says that the log in is incorrect because the account isnt in the ACCOUNT_TBL.
    hopeing someone can help me


  2. #2
    (つ•̀ᴥ•́)つ Marvinoo is offline
    MemberRank
    Feb 2009 Join Date
    245Posts

    Re: Help with website

    Check your stored procedure.

    Code:
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE PROCEDURE [dbo].[createaccount] 
     @account 	VARCHAR(15),
     @password 	VARCHAR(32)
    
    AS
    
    SET NOCOUNT  ON
    
    DECLARE @dateActivated AS CHAR(8)
    
    IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
    	INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) 
    		VALUES  @account, @password, @password, 'T', 'A', 'F')
    
    	SET @dateActivated =  CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
    	--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @dateYesterday WHERE account = @userid		
    	--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
    	--	VALUES  @account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')
    
    	INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
    		VALUES  @account, 'A000', '2', 'F', GETDATE(), @dateActivated, '20990101', '20050101', 'O')
    
    END
    What website files are you using?



Advertisement