How to Lock Hard Mode and Ultimate Mode?

mervinray29 · 07/21/2018, 23:25

I've Been trying to modify my PS_GameData[dbo].[usp_Read_User_MaxGrow_R]. but i have no success to modify the modes ( Lock the Hard mode and Ultimate mode )

{Skrillex} · 07/22/2018, 10:17

Quote:

Originally Posted by mervinray29

I've Been trying to modify my PS_GameData[dbo].[usp_Read_User_MaxGrow_R]. but i have no success to modify the modes ( Lock the Hard mode and Ultimate mode )

Hi,
should be easy done with cheat engine. There is no way to deactivate with a good way over the database.

Regards.

[MXD]Takeshi · 07/22/2018, 12:55

Quote:

Originally Posted by mervinray29

I've Been trying to modify my PS_GameData[dbo].[usp_Read_User_MaxGrow_R]. but i have no success to modify the modes ( Lock the Hard mode and Ultimate mode )

easy to find and edit....
i think you are looking this solution for ep 5.4

open game.exe with any debug {cheat engine, ollydbg, x32dbg, etc}
now, find this address and replace the code:

Code:

00466FA5                - je game.exe+66FDF --ultimate
00466F5B                - je game.exe+66F90 --hard

the code that will be replace is JE in JMP

now Ultimate and Hard button are blocked ^^

mervinray29 · 07/22/2018, 13:43

sorry for my bad english, what im asking is plwyers need to reach level 40 NM to unlock HM then they need to reach lv 40 HM to unlock UM

[GM]SkyLine.™ · 07/22/2018, 14:39

Please check this thread,you must modify script for your question.If i understood true.

mervinray29 · 07/22/2018, 15:27

Quote:

Originally Posted by [GM]SkyLine.™

Please check this thread,you must modify script for your question.If i understood true.

I already base it on nubness script. but its no good. been modifying that script. you can just give me a hint ?

[GM]SkyLine.™ · 07/22/2018, 17:43

Quote:

Originally Posted by mervinray29

I already base it on nubness script. but its no good. been modifying that script. you can just give me a hint ?

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Read_User_MaxGrow_R]    Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]

 [MENTION=485444]server[/MENTION]ID tinyint,
 [MENTION=2805776]UserU[/MENTION]ID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 2 AND Level >= 40) -> Grow 2 = HM change it to 1
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 3) -> its check UM change it to 2
	UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if upper codes match set to grow UM
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if not match leave it HM(you can change here too with 1)

SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID [MENTION=2805776]UserU[/MENTION]ID

SET NOCOUNT OFF
GO

Im not sql expert but i understood this its not hard

mervinray29 · 07/22/2018, 19:45

Quote:

Originally Posted by [GM]SkyLine.™

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Read_User_MaxGrow_R]    Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]

   [MENTION=485444]server[/MENTION]ID tinyint,
   [MENTION=2805776]UserU[/MENTION]ID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID AND Grow = 2 AND Level >= 40) -> Grow 2 = HM change it to 1
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID AND Grow = 3) -> its check UM change it to 2
	UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID // if upper codes match set to grow UM
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID // if not match leave it HM(you can change here too with 1)

SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID   [MENTION=2805776]UserU[/MENTION]ID

SET NOCOUNT OFF
GO

Im not sql expert but i understood this its not hard

Ill try it. thanks

Quote:

Originally Posted by [GM]SkyLine.™

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Read_User_MaxGrow_R]    Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]

   [MENTION=485444]server[/MENTION]ID tinyint,
   [MENTION=2805776]UserU[/MENTION]ID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID AND Grow = 2 AND Level >= 40) -> Grow 2 = HM change it to 1
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID AND Grow = 3) -> its check UM change it to 2
	UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID // if upper codes match set to grow UM
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID =   [MENTION=2805776]UserU[/MENTION]ID // if not match leave it HM(you can change here too with 1)

SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID   [MENTION=2805776]UserU[/MENTION]ID

SET NOCOUNT OFF
GO

Im not sql expert but i understood this its not hard

It should be like this right
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]

@

ID tinyint,
@

ID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = @

ID AND Grow = 1 AND Level >= 40)
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = @

ID AND Grow = 2)
UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = @

ID
ELSE UPDATE UserMaxGrow SET MaxGrow = 1 WHERE UserUID = @

ID

SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID @

ID

SET NOCOUNT OFF
GO
--
i tried but not working

@GM Skyline its not working.

[GM]SkyLine.™ · 07/23/2018, 18:01

Spoiler

mervinray29 · 07/23/2018, 19:00

Still not working GM Skyline, i just tried it just now + been modifying the procedure 3days ago same as that.

mervinray29 · 07/25/2018, 17:34

i'm still looking for an answer. thanks

SnickQ · 07/25/2018, 22:45

Spoiler

[gm]noob · 07/28/2018, 13:04

you want unlock UL first login?
not usp_Read_User_MaxGrow_R

mervinray29 · 08/06/2018, 05:54

Quote:

Originally Posted by [gm]noob

you want unlock UL first login?
not usp_Read_User_MaxGrow_R

i want to lock hm until nm reaches lv 40, and hm reaches lv40 to unlock um

Quote:

Originally Posted by [GM]SkyLine.™

Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]

@ID tinyint,
@ID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = @ID AND Grow = 1 AND Level >= 40)
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = @ID AND Grow = 2)
UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = @ID
ELSE UPDATE UserMaxGrow SET MaxGrow = 1 WHERE UserUID = @ID

IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = @ID AND Grow = 2 AND Level >= 40)
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = @ID AND Grow = 3)
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID = @ID
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = @ID

SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID @ID

SET NOCOUNT OFF
GO

Still not working