Problem with UM Unlock at User_Max_Grow_R

04/22/2014 18:25 drachentypi#1
Hey, I have a problem with the UM Unlock Skript.
It worked but there is a bug, and I don't know why or how.
I used the proc given in dbo.Read_User_Max_Grow_R.
I did this in order to unlock the Ultimate mode with a level 30 HM, so my Proc looks like this:

The problem is if you log in then log back off, without taking a fraction and you log in you got the Ultimate mode unlocked. I don't get how or why.
04/22/2014 18:42 nubness#2
Code:
SET NOCOUNT ON

IF EXISTS (SELECT Grow FROM Chars WHERE ServerID = @ServerID AND UserUID = @UserUID AND GROW >= 2 AND LEVEL >= 30)
BEGIN
     UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID = @ServerID AND UserUID = @UserUID
END

SELECT Country, MaxGrow FROM UserMaxGrow WHERE ServerID = @ServerID AND UserUID = @UserUID

SET NOCOUNT OFF
04/22/2014 18:59 drachentypi#3
Thank you, sorry stealing you time before you posted it I made it myself successfully. :)
04/22/2014 19:22 Autrux#4
#closed as request