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?
Umm and btw, what i need to do for a 1 mill rup / mob for everywhere...
Thanks for reply/help.
