Script for UM preunlocked or unlocked at lvl 1?

[AriezOMG]

Does anyone have a script that I can enter into SQL or a edit I can do to my registration form to have UM preunlocked?

EDIT: Code Discovered thanks to the majority of posters on this thread.

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 >= 0)
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 >= 0)
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

[lilprohacker]

just change it so that when a user registers that their max grow is already set to 3 or so.

[AriezOMG]

how do i do that? ive been looking at the processor.php for a while and can't find it.

[ProfNerwosol]

You need to change procedure in MSSQL not the registration script.

[AriezOMG]

how prof how please help >.<

[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 >= 40)
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 >= 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

SET NOCOUNT OFF
GO

[ShaiyaUnited]

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 40)

40 mean you get UM at lvl 40 =)

[AriezOMG]

You know people, would love and thank anyone who made a guide on this procedure.

[Jaden151]

thanks so much

[cosong]

pity but ps_game.exe i thought have default opened HM and script does'nt work with preunlock HM after NM 40 lvl....may any idea to find it in ps_game, or maybe that are in other problem?

[AriezOMG]

You know it's a petty bump, but say if I was to change the required level for UM to 0, would that make it preunlocked?

[ShaiyaUnited]

Yes i guess.

[AriezOMG]

Anyone tried that and know if it works for sure?

[ProfNerwosol]

I took a look at the procedures and I think there are two things that can be done.

1 - modify one of the ps_*.exe server files, whichever calls the procedure [usp_Save_Char_Maxgrow_E], to pass Grow=3 instead of Grow=1. This will be rather permanent and any changed will require server restart.
2 - it's easier and I think it will work better in the long run. Just set the value in [usp_Save_Char_Maxgrow_E] to Grow=3 before it updates the UserMaxGrow table. You can be a nasty Admin and change the value while the server is working so new users won't get UM unlocked.

[lilprohacker]

removed