Hello & Welcome to our community. Is this your first visit? Register

Page 1 of 4 1234 LastLast
Results 1 to 15 of 47
  1. #1
    #Yummi.sql Caipi's Avatar

    Rank
    True Member
    Join Date
    Sep 2011
    Location
    Germany
    Posts
    403

    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. # ADS
    HyperFilter
    RaGEZONE Sponsor

    Rank
      Sponsor  
    Join Date
    Sep 2013
    Posts
    9000


     

  3. #2
    Member

    Rank
    Member
    Join Date
    Oct 2011
    Posts
    53

    Re: Merchant Rate Query

    thx so much bro

  4. #3
    #Yummi.sql Caipi's Avatar

    Rank
    True Member
    Join Date
    Sep 2011
    Location
    Germany
    Posts
    403

    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

    Rank
    Member
    Join Date
    Sep 2011
    Posts
    67

    Re: Merchant Rate Query

    this config is good?
    or i need change it?

  6. #5
    #Yummi.sql Caipi's Avatar

    Rank
    True Member
    Join Date
    Sep 2011
    Location
    Germany
    Posts
    403

    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

    Rank
    Banned
    Join Date
    Sep 2011
    Posts
    40

    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

    Rank
    Banned
    Join Date
    Oct 2011
    Posts
    15

    Re: Merchant Rate Query

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

    thanks

  9. #8
    #Yummi.sql Caipi's Avatar

    Rank
    True Member
    Join Date
    Sep 2011
    Location
    Germany
    Posts
    403

    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
    Registered

    Rank
    Member
    Join Date
    Nov 2011
    Posts
    17

    Re: Merchant Rate Query

    explain to us how we add this to database

  11. #10
    #Yummi.sql Caipi's Avatar

    Rank
    True Member
    Join Date
    Sep 2011
    Location
    Germany
    Posts
    403

    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

    Re: [Release] Merchant Rate Query

    How add avatar in game?

  13. #12
    Member

    Rank
    Member
    Join Date
    Sep 2011
    Posts
    67

    Re: [Release] Merchant Rate Query

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

  14. #13
    Hardcore Member

    Rank
    Member
    Join Date
    Sep 2011
    Posts
    102

    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
    Capped Online Owner SL1MSH4DY's Avatar

    Rank
    True Member
    Join Date
    Dec 2011
    Location
    USA
    Posts
    418

    Re: [Release] Merchant Rate Query

    Anyone ever tell you your queries are awesome?

  16. #15
    (*..:: RaGeZONER ::..*) 3d2000's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Location
    Egypt
    Posts
    459

    Re: [Release] Merchant Rate Query

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

 

 
Page 1 of 4 1234 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 09:34 PM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.