|
You last visited: Today at 23:45
Advertisement
Automatically allow ultimate mode
Discussion on Automatically allow ultimate mode within the Shaiya Private Server forum part of the Shaiya category.
12/14/2012, 14:08
|
#1
|
elite*gold: 0
Join Date: Dec 2012
Posts: 4
Received Thanks: 0
|
Automatically allow ultimate mode
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
|
#2
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
next time use search engine instead of asking for stuff that was already posted aswell as sql scripts already^^
|
|
|
12/14/2012, 15:01
|
#3
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 391
|
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
|
#4
|
elite*gold: 0
Join Date: Dec 2012
Posts: 4
Received Thanks: 0
|
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......
|
|
|
12/14/2012, 15:19
|
#5
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 391
|
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
|
#6
|
elite*gold: 0
Join Date: Dec 2012
Posts: 4
Received Thanks: 0
|
Quote:
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....
|
|
|
12/15/2012, 00:55
|
#7
|
elite*gold: 0
Join Date: Jan 2011
Posts: 238
Received Thanks: 901
|
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
|
#8
|
elite*gold: 0
Join Date: Jun 2011
Posts: 345
Received Thanks: 241
|
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
|
#9
|
elite*gold: 0
Join Date: Aug 2010
Posts: 241
Received Thanks: 254
|
Omega has the best answer. During account registration just insert a row into UserMaxGrow table for that account with Country=3
|
|
|
|
Similar Threads
|
Change easy mode to ultimate mode in database
12/08/2012 - Shaiya Private Server - 3 Replies
Hello.
Any1 knows where can i change the easy mode to ultimate mode in database of any Character?
Greetings.
|
[Question]How Do i change ultimate mode to say..?
07/19/2011 - Shaiya Private Server - 5 Replies
Do i change ultimate mode to say something else when ur creating a new toon?
|
gunz The Ultimate God Mode
11/30/2010 - GunZ - 47 Replies
ok here goes this hack is very good for ppl who want to pretend they r god. with the ultimate god mode (u must wear certin items for the ultimate god mode).
Highlights of the hack:
-Renerd x2, Walcom S5 x2, and the Nico r2 ALL HAVE 1,800,000 BULLETS (no blanks) with the normal magizenes.they all also give you +25,000 HP and AP.
-all medpacks and repair kits have 100/100 kits.
-the Canox FG1 and FG2 both have 100/100 granades.
|
[Frage] Hard- und Ultimate-Mode
10/18/2010 - Shaiya - 6 Replies
Hi,
ich und nen kumpel waren auf der suche nach nem neuen free mmorpg und sind dabei auf shaiya gestoßen...
haben dann auch chars im hard mode hochgezogen bis auf lvl 20, aber als wir dann erfahren haben das man mit dem hard-mode nur ein levelcap bis 40 hat (Stimmt das?), und somit das eigentliche max-level 60 nur mit ultimate mode zu erreichen ist aufgehört.
meine fragen nun,
- Kann man mit dem Hard-Mode bis lvl 60 spielen?
- Welche Möglichkeiten gibt es aktuell, um eine...
|
All times are GMT +2. The time now is 23:45.
|
|