[Release] Advanced JOB Reward SQL

Page 1 of 2

05/20/2017 09:49 KingDollar#1

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

05/20/2017 13:37 SubZero**#2

wow best gift for me

05/20/2017 15:11 B1Q#3

wow best gift for haitham adil hh

05/20/2017 15:31 MeteorSro#4

ARE THERE IS COMMAND IN ADDLOGCHAR OR SOME THING ?

05/20/2017 15:53 Damitsu#5

Good job, keep going!

05/20/2017 19:20 Ernesto_#6

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

05/20/2017 19:21 Ryotic#7

thanks

Quote:

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

05/20/2017 19:32 Ernesto_#8

Quote:

Originally Posted by legendworld

thanks

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

can u tell me how

05/20/2017 19:55 KingDollar#9

Quote:

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

Quote:

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

Quote:

Originally Posted by Exo

test

???????

05/20/2017 20:24 Kai�#10

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).

05/21/2017 00:48 ILowe#11

hello
What should be the exp gold for this system?

sample

Code:

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?

05/21/2017 05:12 Ryotic#12

Quote:
Originally Posted by ILowe
hello
What should be the exp gold for this system?

sample
Code:
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

05/21/2017 08:11 Laag#82#13

Never Work good ^_^

System bad

:facepalm::facepalm:

WoW :D :D

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]

ٍ

05/21/2017 11:09 KingDollar#14

Quote:
Originally Posted by ILowe
hello
What should be the exp gold for this system?

sample
Code:
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

05/21/2017 14:00 elmagico321#15

Quote:

Originally Posted by khaleed2010

Never Work good ^_^

System bad

:facepalm::facepalm:

WoW :D :D

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 fucking free school did you go to learn that pure Egliz

Page 1 of 2