[Request] dbo.createAccount

[aoyamananami]

can someone lend me a sql tbl for . createAccount?

thanks in advance!

[KingKeesie]

Hu you mean ACCOUNT.tbl

[babyminion]

Originally Posted by aoyamananami

can someone lend me a sql tbl for . createAccount?

thanks in advance!

Here you go!

 Spoiler

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount]
@ VARCHAR(15),
@ VARCHAR(32)

AS

SET NOCOUNT ON

DECLARE @Activated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @) BEGIN
INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname)
VALUES @, @, @, 'T', 'A', 'F')

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

INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
VALUES @, 'A000', '2', 'F', GETDATE(), @Activated, '20990101', '20050101', 'O')

END