About Contribution Table in _CharTrijob

[kareemeljooe]

Please someone tell me how Contribution Table in _CharTrijob Work ?

[MrCatGardens]

What exactly do you wanna know? Each Jobexp is 1 Contributon as far as i remember
btw... _CharTriJob -> Table / Contribution -> Column

[kareemeljooe]

I want to make Job Coin System .. and the system contain this line
IF (@JobType = '1' AND @ BETWEEN '2420' And '48400')
and 1 star for me is more than 48400 .. i want reduce it or change this line to my Contribution .
sorry for my bad English .. and i can't explain it good
hope you understand

[MrCatGardens]

I don´t know how your system works but...
The easiest way would be:
1. update _Chartrijob set contribution = 0 where [your id]
2. do a testtrade (e.g. 1* from jg to dw -> easy with 2nd char and /movetouser)
3. after you have sold your goods, reload the chartrijob table
4. you´ll see your gained contribution
5. use this value to calculate your exchangerate contribution -> jobcoins
6. insert your desired value into the procedure

If you only want to edit the line: just insert your value and press F5. Relogg and test

[kareemeljooe]

i tested ...
Just 1 item i get 3628 Contribution
All i want to know HOW IT Become 3628 .. it is connected with item price ?
thanks for helping

[MrCatGardens]

Originally Posted by kareemeljooe

i tested ...
Just 1 item i get 3628 Contribution
All i want to know HOW IT Become 3628 .. it is connected with item price ?
thanks for helping

Yes, as far as i remember -> 1 Gold -> 1 Job Exp -> 1 Contribution Point

[kareemeljooe]

no .. 1 items price = 383 gives exp 2665 and Contribution 907
i think something in this table in Sro_vt_shard ItemQuotation

[MrCatGardens]

Im gonna check this later on my testsystem. I´ll reply then

[kareemeljooe]

Sorry ... Fixed
Reason .. Price of item in refobjcommon and refpriceofpolicyitem
thank you

[Spidy.]

^
#Closed