[HELP] DB Error Guild Income

[R.U.S.H]

DB:ERROR Update GuildInfo Set GuIncomeMoney=1656536821416188 WHERE GuNum=12
DB:01000, NativeError:3621, [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
DB:ERROR Update GuildInfo Set GuIncomeMoney=1495589021035869 WHERE GuNum=2
DB:01000, NativeError:3621, [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.


I saw this error returned by the agent server. Can you help me locate the problem?

 

[Jolin88]

too high income, higher number than the database can save
reduce gold rates in your server and reduce guild income at default.charclass

 

[R.U.S.H]

thanks for the fast reply, i'll try to edit the default.charclass. btw, what particular line do i have to edit?

 

[Jolin88]

fMONEY_DROP_SCALE 0.9f // gold drop rate

fMAX_COMMISSION 50 // max Tax
fDEFAULT_COMMISSION 5 // min tax
fEARNING_RATE 0.5f // how much % of the tax enters the safe at E room

 

[R.U.S.H]

so it means that i have lower down the fEARNING_RATE to decrease the tax? what about sql database column entries?

 

[Jolin88]

the error comes because there is already too much gold and SQL cannot save that huge number, you should maybe reset it or lower it manually by editing it at the database
and by reducing EARNING_RATE you will reduce the speed of the gold increase inside the safe

 

[R.U.S.H]

ok i got it and going to try to touch the sql db after shutting down my server for a moment. thanks again for the info ^^

 

[eifelzocker]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Wars] ON [dbo].[GuildInfo]
after update
as
BEGIN

Update [GuildInfo] set [GuildInfo].GuIncomeMoney = 2500000000.00000
From GuildInfo
Where GuIncomeMoney >= 2500000000.00000

End

***********************************************
try above trigger that what Im using to avoid bank bug. . ^_^
my maximum gold income in bank is 2.5B. . i hope it will works to you. .

goto RanGame1>dbo.GuildInfo>Triggers right click and make new trigger

That's It. . ^_^

 

[NaMiSwAn]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Wars] ON [dbo].[GuildInfo]
after update
as
BEGIN

Update [GuildInfo] set [GuildInfo].GuIncomeMoney = 2500000000.00000
From GuildInfo
Where GuIncomeMoney >= 2500000000.00000

End

***********************************************
try above trigger that what Im using to avoid bank bug. . ^_^
my maximum gold income in bank is 2.5B. . i hope it will works to you. .

goto RanGame1>dbo.GuildInfo>Triggers right click and make new trigger

That's It. . ^_^

how to execute this trigger.. because if i click execute have a eror..