阅读:1726回复:1
[教程] 有关飞飞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 |
|
100% |
沙发#
发布于:2011-10-29 15:30
我表示这东西过期了
|
|