Job System easy for who know it

[kotsh]

Hello Friend thanks cuz you want help me :)
i have small problem with my job system
i have edit my Trade items price like you show there


every thing is Okey
But its make the Rate of Job exp is Crazy
like what you show there


i want to know how to change the rate only cuz after 20,000,000,000
the exp and Contribution going -45512154 and comes down
if you have any idea please i need it :)

Thx :P

[MentaL]

[MaDenGo]

almost it's fine the trader will get his exp with - then back to Lv.7 0% and re-exp again and so on :)
but this because the maximum high rate of the Jop items price :)
but it's not problem btw :)

[kotsh]

almost it's fine the trader will get his exp with - then back to Lv.7 0% and re-exp again and so on :)
but this because the maximum high rate of the Jop items price :)
but it's not problem btw :)

The problem at my site rank i want make rewards for the best of them
So please if you know how to make the exp rate low then thats will be fin :)
Thx for your replay

[Royalblade]

add more joblevels ...
This is for _Reflevel at the db (shard)

1    118    1    0    0    24    70875    70875    70875
2    470    1    0    0    47    2388750    2388750    2388750
3    1058    1    0    0    71    8793750    8793750    8793750
4    1880    2    0    0    94    38745000    38745000    38745000
5    2938    2    0    0    118    91665000    91665000    91665000
6    5640    4    0    0    141    240187500    240187500    240187500
7    9048    5    0    0    165    2147483647    2147483647    2147483647
8    13160    6    0    0    188    2147483647    2147483647    2147483647
9    17978    7    0    0    212    2147483647    2147483647    2147483647
10    23500    9    0    0    235    2147483647    2147483647    2147483647
11    34898    12    0    0    259    2147483647    2147483647    2147483647
12    47940    15    0    0    282    2147483647    2147483647    2147483647
13    62628    18    0    0    306    2147483647    2147483647    2147483647
14    78960    21    0    0    329    2147483647    2147483647    2147483647
15    96938    24    0    0    353    2147483647    2147483647    2147483647
16    127840    30    0    0    376    2147483647    2147483647    2147483647
17    161798    35    0    0    400    2147483647    2147483647    2147483647
18    198810    41    0    0    423    2147483647    2147483647    2147483647
19    238878    47    0    0    447    2147483647    2147483647    2147483647
20    282000    53    0    0    470    2147483647    2147483647    2147483647 

Use SRO_VT_SHARD
GO
Create Table _RoyalTrijob
(
CharID int,
Contribution bigint)  

aand add this to _addlogchar in the log db...

if (@EventID=6) -- Royalblade , Extension for Contribution saving
BEGIN
Declare @Contri int =(Select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID=@CharID )
IF @CharID in (Select charid from _RoyalTrijob)
begin
    Update SRO_VT_SHARD.dbo._RoyalTrijob Set Contribution+=@Contri where Charid=@CharID
    Update SRO_VT_SHARD.dbo._CharTrijob Set Contribution =0 where CharID=@CharID
end
else if (@CharID not in (Select charid from _RoyalTrijob))
begin
    Insert into  SRO_VT_SHARD.dbo._RoyalTrijob (CharID,Contribution) values (@CharID,@Contri)
    Update SRO_VT_SHARD.dbo._CharTrijob Set Contribution =0 where CharID=@CharID
end
END

/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 04/14/2013 14:55:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   procedure [dbo].[_AddLogChar] 
@CharID        int,
@EventID        tinyint,
@Data1        int,
@Data2        int,
@strPos        varchar(64),
@Desc        varchar(128)
as
    declare @len_pos     int
    declare @len_desc    int
    set @len_pos = len(@strPos)
    set @len_desc = len(@Desc)
    
    if (@EventID=6)
    
BEGIN
Declare @Contri int =(Select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID=@CharID )
IF @CharID in (Select charid from _RoyalTrijob)
begin
    Update SRO_VT_SHARD.dbo._RoyalTrijob Set Contribution+=@Contri where Charid=@CharID
    Update SRO_VT_SHARD.dbo._CharTrijob Set Contribution =0 where CharID=@CharID
end
else if (@CharID not in (Select charid from _RoyalTrijob))
begin
    Insert into  SRO_VT_SHARD.dbo._RoyalTrijob (CharID,Contribution) values (@CharID,@Contri)
    Update SRO_VT_SHARD.dbo._CharTrijob Set Contribution =0 where CharID=@CharID
end
END

        
    if (@len_pos > 0 and @len_desc > 0)
    begin    
        insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)    
    end
    else if (@len_pos > 0 and @len_desc = 0)
    begin     
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
    end
    else if (@len_pos = 0 and @len_desc > 0)
    begin     
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
    end
    else
    begin
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
    end  

In case u want the whole procedure

[kotsh]

Thank you very much Royalblade
YOu Great man
but im still dont understand i dont have table calling _AddLogChar in my log db what i do ?:D

There is idea
i can change Contribution design to bigint ?
but when i test it sr_shardmanger craching

[Royalblade]

Thank you very much Royalblade
YOu Great man
but im still dont understand i dont have table calling _AddLogChar in my log db what i do ?:D

There is idea
i can change Contribution design to bigint ?
but when i test it sr_shardmanger craching

Nope you cant change it to bigint.. doesnt work and wont work.

Addlogchar is not a table.. its a procedure.

[kotsh]

i do like what you said but still no thing

[Caosfox]

looks like you have a red line (error) at update sro_blablabla....

yeah, rename table to _RoyalTrijob (with the "_" )
and fox the update RoyalTrijob , you are missing the "_"

[kotsh]

looks like you have a red line (error) at update sro_blablabla....

yeah, rename table to _RoyalTrijob (with the "_" )
and fox the update RoyalTrijob , you are missing the "_"

ok i did it and the same error

[Caosfox]

post pics of the fixed db and procedure, please

[Royalblade]

Kotch check the original stuff above again.. i changed it slightly.