解决当你的角色到了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/)