Adding Job Rates

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Valued Member Hean is offline
    MemberRank
    Sep 2011 Join Date
    126Posts

    Adding Job Rates

    Well, that will increase the price also
    (At my opinion more enjoymend for Traders because they get scared of they expensive loot )
    , but it works for Thiefs and Hunters, here is the query.


    Hope you like it ;)

    USE [SRO_VT_SHARD_INIT]
    GO

    UPDATE dbo._RefObjCommon
    SET Price = 383*20
    WHERE Price = 383

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

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

    Change the *20 to your value =)


  2. #2
    I ♥ Coding BlackNova is offline
    MemberRank
    Jan 2010 Join Date
    235Posts

    Re: [TUT] Adding Job Rates

    Nice but this change only the price of item
    So its isro rates ... you pay more and get more

    But its very nice thanks ;)

    EDIT: to chage it in Client i have to edit all 3 files or onply pricepolicitiofitem ?
    Last edited by BlackNova; 16-11-11 at 02:34 PM.

  3. #3
    Valued Member Hean is offline
    MemberRank
    Sep 2011 Join Date
    126Posts

    Re: [TUT] Adding Job Rates

    Quote Originally Posted by BlackNova View Post
    Nice but this change only the price of item
    So its isro rates ... you pay more and get more

    But its very nice thanks ;)

    EDIT: to chage it in Client i have to edit all 3 files or onply pricepolicitiofitem ?

    PriceOfPolicyItem and Itemdatas :P

  4. #4
    I ♥ Coding BlackNova is offline
    MemberRank
    Jan 2010 Join Date
    235Posts

    Re: [TUT] Adding Job Rates

    Why itemdatas ?
    And where in item datas ?

  5. #5
    Valued Member Hean is offline
    MemberRank
    Sep 2011 Join Date
    126Posts

    Re: [TUT] Adding Job Rates

    Quote Originally Posted by BlackNova View Post
    Why itemdatas ?
    And where in item datas ?
    Search for the value 383 and 191 in itemdatas :P You will see wich are the goods.

  6. #6
    I ♥ Coding BlackNova is offline
    MemberRank
    Jan 2010 Join Date
    235Posts

    Re: [TUT] Adding Job Rates

    Hehe works fine
    now i can trade 50 mil and and get in next town 150 with rates x2 :)


    But now my problem iss that the "Total Amount" iss still 2 466 520 gold :(
    Last edited by BlackNova; 16-11-11 at 05:36 PM.

  7. #7
    I ♥ Coding BlackNova is offline
    MemberRank
    Jan 2010 Join Date
    235Posts

    Re: [TUT] Adding Job Rates

    bump ?

  8. #8
    #Yummi.sql Caipi is offline
    MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    Re: [TUT] Adding Job Rates

    Apparently you missed to change the values also at the pk2 - means price. refpricepolicyofitem and itemdata

  9. #9
    I ♥ Coding BlackNova is offline
    MemberRank
    Jan 2010 Join Date
    235Posts

    Re: [TUT] Adding Job Rates

    No i dont if i buy 5* its the right price , only in pet its false price

  10. #10
    Apprentice elmt is offline
    MemberRank
    Oct 2011 Join Date
    12Posts

    Re: [TUT] Adding Job Rates

    Hi, this tutorial its very nice but i have one question for you.
    So, this tutorial only changes the ammount of gold when you finish a trade or it affects the job exp you receive too ?
    Because i dont want to change my trader gold rates if i make a trade 5* and get lvl 7 of job. eheh

  11. #11
    Account Upgraded | Title Enabled! SupremeSRO is offline
    MemberRank
    Apr 2012 Join Date
    326Posts

    Re: [TUT] Adding Job Rates

    so with this i can increase the won gold at the end of a trade?

  12. #12
    Apprentice bigzed is offline
    MemberRank
    Sep 2012 Join Date
    23Posts

    Re: [TUT] Adding Job Rates

    to make only the proft higher i must edit the sale price?ß

  13. #13
    Member mylove0990 is offline
    MemberRank
    Apr 2009 Join Date
    88Posts

    Re: [TUT] Adding Job Rates

    It is only change Gold reward for Trade
    How to edit Exp trade job?
    Please

  14. #14
    Member DieEyes is offline
    MemberRank
    Aug 2012 Join Date
    Inside youLocation
    79Posts

    Re: [TUT] Adding Job Rates

    its exp and gold rate. But thief will get nothing when steal goods. :)

  15. #15
    Always Trolling Around skerdikas is offline
    MemberRank
    Dec 2011 Join Date
    LithuaniaLocation
    504Posts

    Re: Adding Job Rates

    well yea about thiefs but who cares about them ?



Page 1 of 2 12 LastLast

Advertisement