Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Help with website

Initiate Mage
Joined
Mar 16, 2014
Messages
10
Reaction score
0
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
 
Experienced Elementalist
Joined
Feb 18, 2009
Messages
225
Reaction score
13
Check your stored procedure.

Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount] 
 [USER=162874]account[/USER] 	VARCHAR(15),
 [USER=2000229135]pas[/USER]sword 	VARCHAR(32)

AS

SET NOCOUNT  ON

DECLARE [USER=27358]date[/USER]Activated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = [USER=162874]account[/USER]) BEGIN
	INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) 
		VALUES  [USER=162874]account[/USER], [USER=2000229135]pas[/USER]sword, [USER=2000229135]pas[/USER]sword, 'T', 'A', 'F')

	SET [USER=27358]date[/USER]Activated =  CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
	--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = [USER=27358]date[/USER]Yesterday WHERE account = [USER=1335]user[/USER]id		
	--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
	--	VALUES  [USER=162874]account[/USER], 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

	INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
		VALUES  [USER=162874]account[/USER], 'A000', '2', 'F', GETDATE(), [USER=27358]date[/USER]Activated, '20990101', '20050101', 'O')

END

What website files are you using?
 
Back
Top