Register for your free account! | Forgot your password?

You last visited: Today at 09:08

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Trade don't Give Gold !

Discussion on Trade don't Give Gold ! within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2016
Posts: 111
Received Thanks: 51
Trade don't Give Gold !

Hello
am use this query
Code:
DECLARE [MENTION=351728]new[/MENTION]Quot FLOAT -- @ SRO_VT_SHARD 
DECLARE [MENTION=1077328]newp[/MENTION]rice INT 
DECLARE [MENTION=5687268]newsta[/MENTION]ck INT 
DECLARE [MENTION=363717]news[/MENTION]ellPrice INT 
SET [MENTION=351728]new[/MENTION]Quot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) 
SET [MENTION=1077328]newp[/MENTION]rice = 9999 -- Goods Price @ the Shop 
SET [MENTION=5687268]newsta[/MENTION]ck = 9999 -- Increases/Decreases the maximum Stack, Default = 40 
SET [MENTION=363717]news[/MENTION]ellPrice = 999 -- Goods Price if you sell them directly again - without trading. 

-- Profit % 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_ItemQuotation] 
SET BaseQuot = BaseQuot [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_LB = Quot_LB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_ItemQuotation] 
SET Quot_UB = Quot_UB [MENTION=351728]new[/MENTION]Quot 
WHERE RefItemID BETWEEN 24671 AND 24672 

-- Price / SellPrice 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 2147 AND 2158 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 10394 AND 10401 

UPDATE [dbo].[_RefObjCommon] 
SET Price = [MENTION=1077328]newp[/MENTION]rice 
WHERE ID BETWEEN 24671 AND 24672 

UPDATE [dbo].[_RefObjCommon] 
SET SellPrice = [MENTION=363717]news[/MENTION]ellPrice 
WHERE ID BETWEEN 24671 AND 24672 

-- MaxStack 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 1926 AND 1937 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 5881 AND 5888 

UPDATE [dbo].[_RefObjItem] 
SET MaxStack = [MENTION=5687268]newsta[/MENTION]ck 
WHERE ID BETWEEN 11159 AND 11160 

-- Price 

UPDATE [dbo].[_RefPricePolicyOfItem] 
SET Cost = [MENTION=1077328]newp[/MENTION]rice 
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'
and if am make trade don't give me gold ?
help
Mr.Bedo is offline  
Old 02/11/2017, 21:20   #2
 
Dracula Untold's Avatar
 
elite*gold: 247
Join Date: Feb 2014
Posts: 1,815
Received Thanks: 495
maybe it will give u love
Dracula Untold is offline  
Thanks
1 User
Old 02/12/2017, 01:31   #3
 
DevilArrow's Avatar
 
elite*gold: 0
Join Date: May 2010
Posts: 250
Received Thanks: 8
look in refobjcommon and refpricepolicyofitem
DevilArrow is offline  
Old 02/14/2017, 12:37   #4
 
kotsh's Avatar
 
elite*gold: 0
Join Date: May 2007
Posts: 360
Received Thanks: 27
3'by
use google baby
kotsh is offline  
Reply


Similar Threads Similar Threads
How Can i make Trade Give Gold and Expen.
12/16/2015 - SRO Private Server - 0 Replies
How Can i make Trade Give Gold and Expen. at my Server When i Go Trade and Go another Town Dont need Give me Gold and Expen any one Can help me please ?? my Face :https://www.facebook.com/gmroske
Want to trade us gold for eu gold(I will give double amount)
10/01/2012 - Diablo 3 Trading - 0 Replies
Today I am offering to give 2 mil on us server for 1 mil on eu servers.
when trade limit off i give all this for rs gold!!
01/15/2011 - Runescape Trading - 0 Replies
silkroad account farmer server titan have 200ksp euro char you can choose what build.Archlord account lvl 43 with full unique +9 and nice accesory got 3 pair of wings well skilled and i give by paypal 10$ for godl in rs add me msn [email protected] add me fast lets make deal :P



All times are GMT +2. The time now is 09:08.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.