Script for UM preunlocked or unlocked at lvl 1?

[FeatherDust]

Ok, i'm looking exactly where your telling me to, but i'm not even finding that table. >.<

[Clonaid]

Originally Posted by shinru2004

go to ps_Userdata expand then go to Programability then Stored Procedures and find usp_Read_user_maxgrow_R then right click go to modify and paste this


CREATE Proc 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 >= 1)
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 >= 1)
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
GO

there ya go m8

[jakoo]

hi everyone
im a noob only 2nd month learning pserver
i dont know how to edit ps_game.exe teach me pls
i want to edit like this
but this script doesnt work, on a new account hard modes still open and lvl31 hm unlocked UM


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

[Bаne]

Originally Posted by jakoo

hi everyone
im a noob only 2nd month learning pserver
i dont know how to edit ps_game.exe teach me pls
i want to edit like this
but this script doesnt work, on a new account hard modes still open and lvl31 hm unlocked UM


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

The issue and this thread were fixed and done...last year.

so you good sir just necroed the thread


reported..

[jakoo]

The issue and this thread were fixed and done...last year.

Sorry Bane thats why i posted here. cuz they r knows that issue
i have only 2 probs before i test to public my server
1st unlock modes
2nd edit stat reset stone.correct number of stats
can u tell me how to fix them or where i can find?

[Scruple]

This was discussed and explained a few times. Search Function is a wonderful thing.



you do the same thing for the Skill/Stat stones it is 4 locations for those