Question about this error..

09/15/2011 21:35 hatoska#1
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_drop_percentage] = 100 --> this will drop money always every kill
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min] = [gold_min] * 5 --> Actual rate = 500x
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max] = [gold_max] * 5 --> Actual rate = 500x
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min_2] = [gold_min_2] * 5 --> Actual rate = 500x
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max_2] = [gold_max_2] * 5 --> Actual rate = 500x
GO


im used that sql for increase the money drop. pressed F5 and i got that error message...

(6624 row(s) affected)
Msg 8115, Level 16, State 2, Line 2
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 2
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 2
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 2
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.


what i have to do? :o

Umm and btw, what i need to do for a 1 mill rup / mob for everywhere...

Thanks for reply/help.
09/16/2011 01:29 lawlywood#2
arithmetic overflow usually appears if some settings are too high. I got an arithmetical overflow from the gameserver while putting to much money in the warehouse
09/16/2011 02:43 amrmohamed37#3
just use the code that make every thing 0 in shops ~~ use the search button