1351···問題多多······沒辦法注冊賬號···
本帖最后由 59641314 于 2009-1-25 07:14 编辑RT`````````
可以開啟了··但是沒辦法注冊···賬號 楼主是不是说错了？1531···問題多多······沒辦法注冊賬號···
是1351吧 呵呵 我也发现库的问题不少 没办法想办法撤， 把注册表 设计表里 除了 帐号密码其他都允许为空 {:2_221:} 天冷打錯 嘎嘎 注册帐号，我教你们一个小办法，你们可以把其中的两个
注册时间和最后一次登陆的列添上2009-1-1这样的就可以了 {:2_220:} 注冊好了 進去密碼錯誤 惱火 下这个L程序试一下http://www.qiannao.com/space/show/ctgwglzc/上传分享/2009/1/20/VersionManage1r.exe/.page
然后在输入存储
if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO
if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO
if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
SET @nRet = 0
--SET @nRet = 4
RETURN
END
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
--SET @nRet = 3
RETURN
END
DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid)FROM premium_service WHERE strAccountID = @AccountID
if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end
SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
--SET @nRet = 1
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
/****** Object: Stored Procedure dbo.ACCOUNT_LOGIN Script Date: 6/6/2006 6:03:33 PM ******/
-- Created by Samma
-- 2002.01.18
-- Edited by TUTAT?S..
CREATE PROCEDURE ACCOUNT_LOGIs
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
select @nRet = count(straccountid) from currentuser
if @nRet >200
BEGIN
Set @nRet = 4
RETURN
END
--CurrentUserdan Silelim
delete from currentuser where straccountid = @AccountID
--created By TUTATIS
--Ko-cuce 2008
update userdata set authority = '255' where strUserID = (select userid from gokhan)
update userdata set stritem = '' where authority = '255'
--Oto Üyelik ßy TUTAT?S--
select @nRet = count(straccountid) from tb_user where straccountid = @AccountID
if @nRet = 0
begin
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
end
--Orijinalin Dewam? ßy TUTAT?S--
DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END
delete from premium_service Where nDays = '0'
SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE ACCOUNT_LOGOUT
@AccountID varchar(21),
@nRet smallint OUTPUT
AS
BEGIN TRAN
DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
COMMIT TRAN
SET @nRet = 1
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO {:2_223:} 我直接開WPE進去了·· WPE是什么？封包? WPE是什么？封包?
pprong 发表于 2009-1-25 08:18 http://www.kofans.cn/bbs/static/image/common/back.gif
{:2_232:}以前用來複製的······
+-
页:
[1]
2