| USE [ACCOUNT_DBF] |
| GO |
| /****** Object: StoredProcedure [dbo].[webCreateAcc] Script Date: 08/17/2009 21:30:28 ******/ |
| SET ANSI_NULLS ON |
| GO |
| SET QUOTED_IDENTIFIER ON |
| GO |
| CREATE PROCEDURE [dbo].[webCreateAcc] |
| @account VARCHAR(15), |
| @password VARCHAR(36), |
| @email VARCHAR(120) |
| 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, email) |
| VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O', @email) |
| END |
| --ELSE BEGIN |
| --print '->Account exists = ' |
| --print @account |
| --END |