[飞飞架设][教程] 有关飞飞V15注册问题 wwwjihe原创

最近也不少人问起我，为何创建好数句库不能注册的问题！我就在这里说说吧！

因为ACCOUNT_DBF数句库少了一个注册存储过程，V14的数句库是自带有的，一般V15数句库注册是用ASP，但我们这里通常都是PHP注册所以我们要加回一个存储过程的脚本就可以！

createaccount 就是这个！以下就是它的代码！

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER 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, teste
r, 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', 'Z', GETDATE(), @DateActivated, '20990101', '20050101', 'O')
END


哈哈，！这里可能看到有部份初学者头痛吧，我打包上传一个简单注册网页吧
点击进入下载－V15简单注册网页.rar

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER 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, teste
r, 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\', \'Z\', GETDATE(), @DateActivated, \'20990101\', \'20050101\', \'O\')
END

导入ACC  注册网页就可以用了  

什么是    导入ACC    ？？？？？？？？？？

什么是    导入ACC    ？？？？？？？？？？