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
|