[Release] Advanced JOB Reward SQL

[KingDollar]

Hello silkroad community, since there is no any good job reward procedures released and some friends asked me to create for him a simple on
so i decided to share it

procedures

 Spoiler

tables

 Spoiler

table values example

 Spoiler

You can add execution as you want,you can create a trigger then execute -- or execute it while eventid = 6

also you can change Contribution to level as your db setting

[SubZero**]

wow best gift for me

[B1Q]

wow best gift for haitham adil hh

[MeteorSro]

ARE THERE IS COMMAND IN ADDLOGCHAR OR SOME THING ?

[Damitsu]

Good job, keep going!

[Ernesto_]

not working i do every thing and i make trade 5 star and i done take any reward.

[Ryotic]

thanks

Originally Posted by Ernesto_

not working i do every thing and i make trade 5 star and i done take any reward.

because you have to begin the event 6 and procadur in log

[Ernesto_]

Originally Posted by legendworld

thanks



because you have to begin the event 6 and procadur in log

can u tell me how

[KingDollar]

Originally Posted by MeteorSro

ARE THERE IS COMMAND IN ADDLOGCHAR OR SOME THING ?

you can do it like

IF @EventID = 4
EXEC _Job_Reward @CharID

Originally Posted by Ernesto_

not working i do every thing and i make trade 5 star and i done take any reward.

well you should add execution from _addlogchar

Originally Posted by ​Exo

test

???????

[Kai·]

For those who are facing problems with distributing rewards according to stars count
you have to change those fixed contribution values in this procedure to suit your current contribution (in case you have a different items quotation).

[ILowe]

hello
What should be the exp gold for this system?

sample

USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon
SET Price = 383*15
WHERE Price = 383


UPDATE dbo._RefObjCommon
SET SellPrice = 191*15
WHERE SellPrice = 191


UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*15
WHERE Cost = 383

WHEN Contribution BETWEEN 10920960 AND 12640000 THEN 1
WHEN Contribution BETWEEN 12640010 AND 18960000 THEN 2
WHEN Contribution BETWEEN 18960010 AND 38425600 THEN 3
WHEN Contribution BETWEEN 38425610 AND 57512000 THEN 4
WHEN Contribution BETWEEN 57512010 AND 725680000 THEN 5

To reach these values?

[Ryotic]

Originally Posted by ILowe

hello
What should be the exp gold for this system?

sample

USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon
SET Price = 383*15
WHERE Price = 383


UPDATE dbo._RefObjCommon
SET SellPrice = 191*15
WHERE SellPrice = 191


UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*15
WHERE Cost = 383

WHEN Contribution BETWEEN 10920960 AND 12640000 THEN 1
WHEN Contribution BETWEEN 12640010 AND 18960000 THEN 2
WHEN Contribution BETWEEN 18960010 AND 38425600 THEN 3
WHEN Contribution BETWEEN 38425610 AND 57512000 THEN 4
WHEN Contribution BETWEEN 57512010 AND 725680000 THEN 5

To reach these values?

Hello Contact me in zizoelnigm4@skype

[Laag#82]

Never Work good ^_^

System bad



WoW

PHP Code:


 SELECT @TradeStar = CASE
        WHEN Contribution BETWEEN 10920960 AND 12640000 THEN 1
        WHEN Contribution BETWEEN 12640010 AND 18960000 THEN 2
        WHEN Contribution BETWEEN 18960010 AND 38425600 THEN 3
        WHEN Contribution BETWEEN 38425610 AND 57512000 THEN 4
        WHEN Contribution BETWEEN 57512010 AND 725680000 THEN 5
    END 


this Best

20 % from Code

PHP Code:


declare @intMinContribution INT

SELECT @intMinContribution = CASE @JobType
        WHEN 1 THEN xxxx --(1 = Trader)
        WHEN 2 THEN xxxx --(2 = Thief)
        WHEN 3 THEN xxxx --(3 = Hunter) 
END 


Sell trade 5 Star get to Contribution * 10 = xxx [WHEN 1 THEN [Here]]

and

PHP Code:

declare @JobType tinyINT
declare @intContribution int

select @JobType=JobType,@intContribution=Contribution from SRO_VT_SHARD.._CharTrijob where CharID =  --add here @CharID or you CharID :D 


[Sorry No add Full Code]






ٍ

[KingDollar]

Originally Posted by ILowe

hello
What should be the exp gold for this system?

sample

USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon
SET Price = 383*15
WHERE Price = 383


UPDATE dbo._RefObjCommon
SET SellPrice = 191*15
WHERE SellPrice = 191


UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*15
WHERE Cost = 383

WHEN Contribution BETWEEN 10920960 AND 12640000 THEN 1
WHEN Contribution BETWEEN 12640010 AND 18960000 THEN 2
WHEN Contribution BETWEEN 18960010 AND 38425600 THEN 3
WHEN Contribution BETWEEN 38425610 AND 57512000 THEN 4
WHEN Contribution BETWEEN 57512010 AND 725680000 THEN 5

To reach these values?

You can change this values to yours

[elmagico321]

Originally Posted by khaleed2010

Never Work good ^_^

System bad



WoW



this Best

20 % from Code


[Sorry No add Full Code]


ٍ

Waow you just reached the Smart @SS lv 100 with 20% Exp give us a favor kido please don't talk too much once you open your mouth everyone start to wonder which ******* free school did you go to learn that pure Egliz