在存储过程里myst_login的AS下面加入:
--------------------------不用注册直接输入账号密码即时注册--------------------------------------------------
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
------------------------------------------------------------------------------------------------------
适用于不用MD5加密密码的库 |