Mastery Max level offsets ?

[MeGaMaX]

thanks alot but im greedy and will ask youu for some more guides

Let me google that for you =.=

[SnapPop]

androw
do you mean that euro mastery is dynamic but it can't exceed lvl 120 so it need new binaries via Code-Cave ?
actually i didn't understand why you mentioned Code-Caving just a bit clarify will be awesome :-)

[MeGaMaX]

androw
do you mean that euro mastery is dynamic but it can't exceed lvl 120 so it need new binaries via Code-Cave ?
actually i didn't understand why you mentioned Code-Caving just a bit clarify will be awesome :-)

no , its dynamic , its time generated something like multiply * number + number = eu mastery based on chinese mastery so its have more than 4 checks in the game server , nothing to do for the client , so you have to bypass the 4 checks , and make it same chinese one change able with code cave cuz if you try to change it more than 120 i think its will be negative value

Greetings MeGaMaX

[NourAyman]

Guys , i think itz a site which the dev share the tut to learn the newbies

I think any dev now was a noob , so itz time to learn the new newbies :D

[TryToMakeServer]

I guess no one is going to share that offset.
Anyway, then its time to create a procedure which levels up the mastery for free, lvl by lvl, or take once 100k sp or any other setted number.
Since its for any pserver made, wouldnt hurt that much.

Some of you may didnt understand me well, my theorie,like below:
1.Procedure checks level of char, lets say char is lvl 121.
2.Procedure checks mastery level of that char, if its 120.
3.Mastery is lvl 120,procedure will update the lvl of 120 to 121.
-- 4a.Procedure takes some sp away.
4b.User have to teleport.

With option 4a, it would be very unsecured, since the player may still recieve sp while killing mobs, his sp wouldnt decrease just by editing the database trough some queries.

Regards

[bdeniz]

I guess no one is going to share that offset.
Anyway, then its time to create a procedure which levels up the mastery for free, lvl by lvl, or take once 100k sp or any other setted number.
Since its for any pserver made, wouldnt hurt that much.

Some of you may didnt understand me well, my theorie,like below:
1.Procedure checks level of char, lets say char is lvl 121.
2.Procedure checks mastery level of that char, if its 120.
3.Mastery is lvl 120,procedure will update the lvl of 120 to 121.
-- 4a.Procedure takes some sp away.
4b.User have to teleport.

With option 4a, it would be very unsecured, since the player may still recieve sp while killing mobs, his sp wouldnt decrease just by editing the database trough some queries.

Regards

its good idea. i can make sql scripts for it but i cant understand gameserver assembly.

i'll create a sp but for realize this ( if char level 120, mastery ups to 121 auto.) , gameserver should run the stored procedure every second.

but i dont have any solutions to execute a sp every second in gameserver.

-- wait 10 mins. i am writing sp.

[kankorezis]

why u guys aint taking sro_client.exe from myth online? aint they having 125 cap fixed?

[InsaneDev]

why u guys aint taking sro_client.exe from myth online? aint they having 125 cap fixed?

beside asking go see it and unpack

[TryToMakeServer]

its good idea. i can make sql scripts for it but i cant understand gameserver assembly.

i'll create a sp but for realize this ( if char level 120, mastery ups to 121 auto.) , gameserver should run the stored procedure every second.

but i dont have any solutions to execute a sp every second in gameserver.

-- wait 10 mins. i am writing sp.

Can be done trough other queries.
Like in account db, there is a procedure which writes most likely every second to the shard current user table, how many users are online.
You can modify the procedure and create a custom procedure.
Would be like this:
1. Shard current user procedure gets excuted.
2. The procedure got modfied and excuting CUSTOM_MASTERY_LEVEL_UP procedure.
3. Thats all.

Edit:

USE [ACCOUNT_DB_TEST_LOCAL]
GO
/****** Object:  StoredProcedure [dbo].[_AddCurrentUserCount]    Script Date: 09/30/2012 15:30:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[_AddCurrentUserCount]
    @nShardID     INT,
    @nUserCount     INT,
    @dLogDate    DATETIME
AS

-- Custom queries --
EXEC [dbo].CUSTOM_MASTERY_LEVEL_UP 

Regards

[kankorezis]

beside asking go see it and unpack

im aint asking if you suppose suggestion to be an asking.

[bdeniz]

Can be done trough other queries.
Like in account db, there is a procedure which writes most likely every second to the shard current user table, how many users are online.
You can modify the procedure and create a custom procedure.
Would be like this:
1. Shard current user procedure gets excuted.
2. The procedure got modfied and excuting CUSTOM_MASTERY_LEVEL_UP procedure.
3. Thats all.

Edit:

USE [ACCOUNT_DB_TEST_LOCAL]
GO
/****** Object:  StoredProcedure [dbo].[_AddCurrentUserCount]    Script Date: 09/30/2012 15:30:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[_AddCurrentUserCount]
    @nShardID     INT,
    @nUserCount     INT,
    @dLogDate    DATETIME
AS

-- Custom queries --
EXEC [dbo].CUSTOM_MASTERY_LEVEL_UP 

Regards

is it most used sp? are u sure?

[bdeniz]

Can be done trough other queries.
Like in account db, there is a procedure which writes most likely every second to the shard current user table, how many users are online.
You can modify the procedure and create a custom procedure.
Would be like this:
1. Shard current user procedure gets excuted.
2. The procedure got modfied and excuting CUSTOM_MASTERY_LEVEL_UP procedure.
3. Thats all.

Edit:

USE [ACCOUNT_DB_TEST_LOCAL]
GO
/****** Object:  StoredProcedure [dbo].[_AddCurrentUserCount]    Script Date: 09/30/2012 15:30:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[_AddCurrentUserCount]
    @nShardID     INT,
    @nUserCount     INT,
    @dLogDate    DATETIME
AS

-- Custom queries --
EXEC [dbo].CUSTOM_MASTERY_LEVEL_UP 

Regards

and u MUST write this to the last line of sp;

EXEC SRO_VT_SHARD.dbo._MASTERY_UP

cuz this sp in another db

[bdeniz]

hm i can increase mastery level but i cant select multiple.

only 1 chars masterys upping.

[Riask]

guys you must learn to know everything instead of asking every time , learn how to edit the eu mastery cuz its dynamic , fix exploits etc , dont wait the answer from other you have to learn , understand , fix , dev , you will be happy from what you have did truth me

and here is the the code caved eu mastery

lol for what do you need code cave?
not that hard to change it without this.

[Chern0byl]

No codecave needed... just one byte mod & few 0x00/0x90 :). Already added to paid version of Eva.