另一种注册低版本mu账号方式
Published: Comment: No Comments
Last Modified:2023-12-13 02:19:06
在SQL SERVERk 建立一个存储过程
:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE WUYIN_REG_MU_MEMB
@uid <I>var</I>char(40),
@uname <I>var</I>char(40),
@uemail <I>var</I>char(100),
@upwd <I>var</I>char(40),
@uquestion <I>var</I>char(40),
@uanswer <I>var</I>char(40),
@ucode <I>var</I>char(40)
AS
declare @uguid int
if exists(select memb___id from MEMB_INFO where memb___id=@uid)
begin
print '0'
end
else
begin
print '1'
SET NO_BROWSETABLE OFF
Insert into MEMB_INFO
(memb___id,memb_name,mail_addr,memb__pwd,fpas_ques,fpas_answ,sno__numb,post_code,addr_info,addr_deta,tel__numb,phon_numb,job__code,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code)
values(@uid,@uname,@uemail,@upwd,@uquestion,@uanswer,'1','1234','1234',@ucode,'23123','23434','12',getdate(),getdate(),getdate(),getdate(),'0','0','0')
select @uguid=SCOPE_IDENTITY()
SET NO_BROWSETABLE ON
SET NO_BROWSETABLE OFF
Insert into VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_Hour,Surplus_Point,Surplus_Minute,Increase_Days)
values('2005','1','1234',@uid,@uname,@uguid,'7','6','3','6','6',getdate(),'0')
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
在idreg.asp的 125 行里改成如下:
sql="EXEC [DBO].[WUYIN_REG_MU_MEMB] '"&ps_loginname&"','"&ps_nickname&"','"&ps_email&"','"&ps_password&"','"&ps_question&"', '"&ps_answer&"','"&ps_person_id&"'"
这样就可以解决了。