解決當你的角色到了185級或者錢多于500000000時會被自動封停。
打開儲存過程 _Role_Update
這里解釋了用戶計費功能,但最后的兩
~~~
if @Level>=185
begin
select @GameIP=isnull(F_GameIP,'') from T_LoggedUser where F_UserName=@UserName
select @GameName=F_Name from t_Game where F_IP=@GameIP
insert into T_RoleStop(F_Username,F_GameIP,F_GameName,F_UpdateTime,F_Desc) values(@UserName,@GameIP,@GameName,getdate(),'等級異常,當前等級:'+cast(@Level as char(20)))
update T_UserCore set F_StopTime=dateadd(year,50,getdate()) where F_UserName=@UserName
end
if @NewMoney>=500000000
begin
select @GameIP=isnull(F_GameIP,'') from T_LoggedUser where F_UserName=@UserName
select @GameName=F_Name from t_Game where F_IP=@GameIP
insert into T_RoleStop(F_Username,F_GameIP,F_GameName,F_UpdateTime,F_Desc) values(@UserName,@GameIP,@GameName,getdate(),'金錢異常,當前金錢:'+cast(@NewMoney as char(20)))
update T_UserCore set F_StopTime=dateadd(year,50,getdate()) where F_UserName=@UserName
end
~~~
誰加進去的?或者數據庫太舊?都沒所謂了,如何解決,不用再寫了吧。
轉載注明出處:[乜都講D](https://blog.ztjal.info/)