Automatically allow ultimate mode

12/14/2012 14:08 dragonite7#1
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 :)
12/14/2012 14:57 TeddyBear94#2
[Only registered and activated users can see links. Click Here To Register...] next time use search engine instead of asking for stuff that was already posted aswell as sql scripts already^^
12/14/2012 15:01 Truth1010#3
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.
12/14/2012 15:13 dragonite7#4
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, [Only registered and activated users can see links. Click Here To Register...] , Danco mentions that you can use a stored procedure to do it... hmmmm......
12/14/2012 15:19 Truth1010#5
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 :)
12/14/2012 15:32 dragonite7#6
Quote:
Originally Posted by Truth1010 View Post
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.... :)
12/15/2012 00:55 ShaiyaOmega#7
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.


Code:
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)
12/15/2012 08:05 hootzoo#8
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
12/16/2012 20:05 zargon05#9
Omega has the best answer. During account registration just insert a row into UserMaxGrow table for that account with Country=3