New question : o

05/16/2010 23:17 whiteyadam#1
Where can i change the requirments for Ultimate mode or make it auto unlocked for new accounts?
05/17/2010 10:57 13latrix#2
The procedure you need to modify is "usp_Read_User_MaxGrow_R" located in GameData.

This what default looks like..

IF NOT EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW <= 3 )
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 1 WHERE ServerID=@ServerID AND UserUID=@UserUID AND Country <= 1
END

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 1 AND LEVEL >= 40)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 2 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

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

SELECT Country,MaxGrow FROM UserMaxGrow WHERE ServerID=@ServerID AND UserUID=@UserUID
05/17/2010 11:21 whiteyadam#3
Thanks :)