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:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 04/22/2014 18:08:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]
@ServerID tinyint,
@UserUID int
AS
SET NOCOUNT ON
IF NOT EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW <= 3 )
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID AND Country <= 1
END
IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 30)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID
END
IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 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
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.