另一种注册低版本mu账号方式


Published:   Comment: No Comments

游戏数据库

在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&"'"


这样就可以解决了。

none
Last Modified:2023-12-13 02:19:06

我有话说