About Contribution Table in _CharTrijob

10/14/2016 07:15 kareemeljooe#1
Please someone tell me how Contribution Table in _CharTrijob Work ?
10/14/2016 07:22 MrCatGardens#2
What exactly do you wanna know? Each Jobexp is 1 Contributon as far as i remember
btw... _CharTriJob -> Table / Contribution -> Column
10/14/2016 07:29 kareemeljooe#3
I want to make Job Coin System .. and the system contain this line
IF (@JobType = '1' AND @[Only registered and activated users can see links. Click Here To Register...] 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 :(
10/14/2016 07:37 MrCatGardens#4
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
10/14/2016 07:44 kareemeljooe#5
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 :)
10/14/2016 08:44 MrCatGardens#6
Quote:
Originally Posted by kareemeljooe View Post
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
10/14/2016 09:45 kareemeljooe#7
no .. 1 items price = 383 gives exp 2665 and Contribution 907
i think something in this table in Sro_vt_shard ItemQuotation
10/14/2016 10:13 MrCatGardens#8
Im gonna check this later on my testsystem. IŽll reply then
10/14/2016 10:34 kareemeljooe#9
Sorry ... Fixed
Reason .. Price of item in refobjcommon and refpriceofpolicyitem
thank you
10/18/2016 15:28 Spidy.#10
^
#Closed