Merchant Rate Query

Page 1 of 4 1234 LastLast
Results 1 to 15 of 47
  1. #1
    #Yummi.sql Caipi is offline
    True MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    information Merchant Rate Query

    PHP Code:
    DECLARE @NewQuot FLOAT                    -- @ SRO_VT_SHARD //by Caipi
    DECLARE @NewPrice INT
    DECLARE @NewStack INT
    DECLARE @NewSellPrice INT
    SET 
    @NewQuot 99.9            -- Doubles the profit trough "2.0" (e.g2.6 is also possible)
    SET @NewPrice 9999            -- Goods Price the Shop
    SET 
    @NewStack 9999            -- Increases/Decreases the maximum Stack, Default = 40
    SET 
    @NewSellPrice 999        -- Goods Price if you sell them directly again without trading.

    -- 
    Profit %

    UPDATE [dbo].[_ItemQuotation]
    SET BaseQuot BaseQuot*@NewQuot
    WHERE RefItemID BETWEEN 2147 
    AND 2158

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_LB Quot_LB*@NewQuot
    WHERE RefItemID BETWEEN 2147 
    AND 2158

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_UB Quot_UB*@NewQuot
    WHERE RefItemID BETWEEN 2147 
    AND 2158

    UPDATE 
    [dbo].[_ItemQuotation]
    SET BaseQuot BaseQuot*@NewQuot
    WHERE RefItemID BETWEEN 10394 
    AND 10401

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_LB Quot_LB*@NewQuot
    WHERE RefItemID BETWEEN 10394 
    AND 10401

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_UB Quot_UB*@NewQuot
    WHERE RefItemID BETWEEN 10394 
    AND 10401

    UPDATE 
    [dbo].[_ItemQuotation]
    SET BaseQuot BaseQuot*@NewQuot
    WHERE RefItemID BETWEEN 24671 
    AND 24672

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_LB Quot_LB*@NewQuot
    WHERE RefItemID BETWEEN 24671 
    AND 24672

    UPDATE 
    [dbo].[_ItemQuotation]
    SET Quot_UB Quot_UB*@NewQuot
    WHERE RefItemID BETWEEN 24671 
    AND 24672

    -- Price SellPrice

    UPDATE 
    [dbo].[_RefObjCommon]
    SET Price = @NewPrice
    WHERE ID BETWEEN 2147 
    AND 2158

    UPDATE 
    [dbo].[_RefObjCommon]
    SET SellPrice = @NewSellPrice
    WHERE ID BETWEEN 2147 
    AND 2158

    UPDATE 
    [dbo].[_RefObjCommon]
    SET Price = @NewPrice
    WHERE ID BETWEEN 10394 
    AND 10401

    UPDATE 
    [dbo].[_RefObjCommon]
    SET SellPrice = @NewSellPrice
    WHERE ID BETWEEN 10394 
    AND 10401

    UPDATE 
    [dbo].[_RefObjCommon]
    SET Price = @NewPrice
    WHERE ID BETWEEN 24671 
    AND 24672

    UPDATE 
    [dbo].[_RefObjCommon]
    SET SellPrice = @NewSellPrice
    WHERE ID BETWEEN 24671 
    AND 24672

    -- MaxStack

    UPDATE 
    [dbo].[_RefObjItem]
    SET MaxStack = @NewStack
    WHERE ID BETWEEN 1926 
    AND 1937

    UPDATE 
    [dbo].[_RefObjItem]
    SET MaxStack = @NewStack
    WHERE ID BETWEEN 5881 
    AND 5888

    UPDATE 
    [dbo].[_RefObjItem]
    SET MaxStack = @NewStack
    WHERE ID BETWEEN 11159 
    AND 11160

    -- Price

    UPDATE 
    [dbo].[_RefPricePolicyOfItem]
    SET Cost = @NewPrice
    Where RefPackageItemCodeName like 
    '%ITEM_ETC_TRADE%' 
    Old trash..
    Spoiler:

    To adjust the necessary Exp for the Joblevels (bigint)..
    PHP Code:
    DECLARE @NewEXPQuot INT    -- At first _RefLevel and Dependencies -> Design -> JobExp_Trader/JobExp_Hunter/Job_Exp_Robber -> bigintCause Exp Max INT value
    SET 
    @NewEXPQuot 999   -- Currently999x more necessary Exp


    UPDATE 
    [dbo].[_RefLevel]
    SET JobExp_Trader JobExp_Trader*NewEXPQuot
    WHERE JobExp_Trader 
    0

    UPDATE 
    [dbo].[_RefLevel]
    SET JobExp_Hunter JobExp_Hunter*NewEXPQuot
    WHERE JobExp_Hunter 
    0

    UPDATE 
    [dbo].[_RefLevel]
    SET JobExp_Robber JobExp_Robber*NewEXPQuot
    WHERE JobExp_Robber 


    Have fun :)
    Last edited by Caipi; 18-03-12 at 07:01 PM.
    I dun like Signatures, they're always confusing me while reading a thread!


  2.  
  3. #2
    Member ktkoti is offline
    MemberRank
    Oct 2011 Join Date
    52Posts

    Re: Merchant Rate Query

    thx so much bro

  4. #3
    #Yummi.sql Caipi is offline
    True MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    Re: Merchant Rate Query

    My pleasure, but don't forget to change those values also @ the pk2! @Itemdata etc.
    I dun like Signatures, they're always confusing me while reading a thread!

  5. #4
    Member shukamu is offline
    MemberRank
    Sep 2011 Join Date
    67Posts

    Re: Merchant Rate Query

    this config is good?
    or i need change it?

  6. #5
    #Yummi.sql Caipi is offline
    True MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    Re: Merchant Rate Query

    I put randomly values in it, you shouldn't keep them.



    Okay I accidentaly tried it out with those values and I made with a 1* from Alexandria to Jangan 4b+ Gold. You shouldn't take those, for real ;)
    Last edited by Caipi; 16-11-11 at 06:52 PM.
    I dun like Signatures, they're always confusing me while reading a thread!

  7. #6
    Banned peter0010 is offline
    BannedRank
    Sep 2011 Join Date
    40Posts

    Re: Merchant Rate Query

    thanks for that script !

    but i think those are only for hunter / trader or ?? my thief rates are still the same

  8. #7
    Banned kraLoqe is offline
    BannedRank
    Oct 2011 Join Date
    15Posts

    Re: Merchant Rate Query

    bump, caipi do u have a solution for thief rewards ?

    thanks

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

    Re: Merchant Rate Query

    Aw well I can't try it out at the moment, since I left my last pServer :) Track the NPC ID of the Thief Sellers and look at the _ItemQuotation if there's the ID under AssocNPC - shud work then too, theoretical ^^
    I dun like Signatures, they're always confusing me while reading a thread!

  10. #9
    Account Inactive zieon is offline
    InactiveRank
    Nov 2011 Join Date
    17Posts

    Re: Merchant Rate Query

    explain to us how we add this to database

  11. #10
    #Yummi.sql Caipi is offline
    True MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    Re: [Release] Merchant Rate Query

    Right Click on Shard, New Query, Copy Pasta, Run it - ready :)

    Keep in mind to choose your desired values:

    SET @NewQuot = xx.xx
    SET @NewPrice = xx
    SET @NewStack = xx
    SET @NewSellPrice = xx
    I dun like Signatures, they're always confusing me while reading a thread!

  12. #11
    Member enis1994 is offline
    MemberRank
    Sep 2011 Join Date
    28Posts

    Re: [Release] Merchant Rate Query

    How add avatar in game?

  13. #12
    Member shukamu is offline
    MemberRank
    Sep 2011 Join Date
    67Posts

    Re: [Release] Merchant Rate Query

    how to set max SAFE TRADE?
    i need only 3 not 8 safe trades...

  14. #13
    Account Inactive asi41 is offline
    InactiveRank
    Sep 2011 Join Date
    102Posts

    Re: [Release] Merchant Rate Query

    lchemy how will rise nad where change 2x for ?

    11 DG Sox Rates where change drop ?

    thank you

  15. #14
    Account Inactive SL1MSH4DY is offline
    InactiveRank
    Dec 2011 Join Date
    USALocation
    418Posts

    Re: [Release] Merchant Rate Query

    Anyone ever tell you your queries are awesome?

  16. #15
    (*..:: RaGeZONER ::..*) 3d2000 is offline
    True MemberRank
    Nov 2011 Join Date
    462Posts

    Re: [Release] Merchant Rate Query

    you are the maaaaaaaaaaaaaan :DD thanks :)
    [SIGPIC][/SIGPIC]


  17.  

    Latest Gaming Releases

Page 1 of 4 1234 LastLast

Advertisement