Automatically allow ultimate mode

[dragonite7]

Hello, Im wondering where the location to set ultimate mode unlocked automatically, when you create an account, rather than needing to make HM then relogging. If its in the psgame or DB somewhere I just need to be pointed in the right direction, Although im pretty sure ive looked everywhere in the DB...
Thanks

[TeddyBear94]

next time use search engine instead of asking for stuff that was already posted aswell as sql scripts already^^

[Truth1010]

He did mention that in his post Teddy, don't be so quick to jump.

As Teddy posted that will unlock UM at level 1

It does not however fix the need to "make a HM" first.
If you log into the account, and pick your side (fury/light) then log out and back in however. You may instantly create a UM.
As far as I know, other than using an edit of the instant level script from Castor. It isn't possible to make UM unlocked before ANY account actions are taken.

[dragonite7]

Thanks Truth, yes ive used the search engine and tried to figure it out myself for a while before posting here.
After some more searching ive found it talked about here, , Danco mentions that you can use a stored procedure to do it... hmmmm......

[Truth1010]

No, Danco mentions what I said. If you use that script from Castor and just make everything "level 1" as the example Castor shows. You'll make 4 UM characters, no matter which button (easy,normal,hard,ult) you click.

I don't believe it is possible to completely fix the UM thing to need no actions. Via Stored Proc or other means. I think it's called by the server itself. But I've never looked into fixing it, because if your too lazy to either make a HM to unlock UM, or re-log.. then.. I just laugh

[dragonite7]

Originally Posted by Truth1010

No, Danco mentions what I said. If you use that script from Castor and just make everything "level 1" as the example Castor shows. You'll make 4 UM characters, no matter which button (easy,normal,hard,ult) you click.

I don't believe it is possible to completely fix the UM thing to need no actions. Via Stored Proc or other means. I think it's called by the server itself. But I've never looked into fixing it, because if your too lazy to either make a HM to unlock UM, or re-log.. then.. I just laugh

OH yeah okay makes sense lol.. Well yeah.. the way I have it set up now is if you make any easy normal hard ultimate, you end up with ultimate char in game.. I guess its good enough..
It might be in the PS_Game ... it has to be somewhere....

[ShaiyaOmega]

On Mine I Set The User Max Grow to 3 at Account Creation.
That way even the first toon can be a UM.

My server uses a SP to create the account from the php input.
This is the part of it that makes every account have UM unlocked automatically.

INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
 ([ServerID],[UserUID],[Country],[MaxGrow],[Del])
 VALUES(1,(SELECT UserUID FROM [PS_UserData].[dbo].[Users_Master] WHERE UserID = @username),2,3,0)

[hootzoo]

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 12/14/2012 22:59:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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 <= 4 )
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 = 4 AND LEVEL >= 0)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 4 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

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

SELECT Country,MaxGrow FROM UserMaxGrow WHERE ServerID=@ServerID AND UserUID=@UserUID

SET NOCOUNT OFF

think thats it lol

[zargon05]

Omega has the best answer. During account registration just insert a row into UserMaxGrow table for that account with Country=3