Quote:
Originally Posted by GeneraL_SchnitzeL
why all unicum / nighmares fail :O? other tamerates?
|
the problem is the tame rates of them are 0 so you have to change it to be able to tame them
open query and past each of these in it (separate not together )
1-
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage] = [taming_percentage]*100000
WHERE [taming_percentage] > 0.0000
GO
2-
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage] = "x"
WHERE [taming_percentage] < [taming_id]
GO
3-
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage] = [taming_percentage]/100000
WHERE [taming_percentage] > 0
GO
"x" is th tame rate of the hawk or harpy in your sever * 100000
I'm not an expert in SQL server so my way is long but I am sure it can be summarized in one query instead of 3