Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Questions & Answers
You last visited: Today at 03:08

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

Advertisement



Hi, can someone share with me how to adjust product price in SQL Server?

Discussion on Hi, can someone share with me how to adjust product price in SQL Server? within the SRO PServer Questions & Answers forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2025
Posts: 4
Received Thanks: 0
Post Hi, can someone share with me how to adjust product price in SQL Server?

Hi, can someone share with me how to adjust product price in SQL Server?
qbaolm1 is offline  
Old 05/03/2025, 00:40   #2
 
Worshiper's Avatar
 
elite*gold: 0
Join Date: May 2017
Posts: 1,081
Received Thanks: 224
Quote:
Originally Posted by qbaolm1 View Post
Hi, can someone share with me how to adjust product price in SQL Server?
Price of what item in npc and item mall ?
Worshiper is offline  
Thanks
1 User
Old 05/03/2025, 17:28   #3
 
elite*gold: 0
Join Date: Mar 2025
Posts: 4
Received Thanks: 0
I want to change any number

Quote:
Originally Posted by Worshiper View Post
Price of what item in npc and item mall ?

I want to change any number

Quote:
Originally Posted by Worshiper View Post
Price of what item in npc and item mall ?
I can't use this tool because my database is not standard.
qbaolm1 is offline  
Old 05/03/2025, 19:32   #4
 
elite*gold: 27
Join Date: Jul 2024
Posts: 23
Received Thanks: 80
Update _RefPricePolicyOfItem Set Cost = 500 where RefPackageItemCodeName Like 'PACKAGE_ITEM_CODENAME'
akaSteven. is offline  
Old 05/03/2025, 20:19   #5
 
elite*gold: 0
Join Date: Mar 2025
Posts: 4
Received Thanks: 0
i changed it and it doesn't work

Quote:
Originally Posted by Worshiper View Post
Price of what item in npc and item mall ?
Quote:
Originally Posted by akaSteven. View Post
Update _RefPricePolicyOfItem Set Cost = 500 where RefPackageItemCodeName Like 'PACKAGE_ITEM_CODENAME'
i changed it and it doesn't work

Do you have any specific videos I can watch?
qbaolm1 is offline  
Old 05/07/2025, 16:54   #6
 
Shuma20's Avatar
 
elite*gold: 0
Join Date: Mar 2025
Posts: 366
Received Thanks: 36
To see the effect you need to update your media.pk2 side too ( refpricepolicyofitem.txt ) edit the price same as you done in SQL
Shuma20 is offline  
Old 05/17/2025, 00:40   #7

 
Xero1993's Avatar
 
elite*gold: 3
Join Date: Jul 2019
Posts: 215
Received Thanks: 175
database _RefPricePolicyOfItem

and media RefPricePolicyOfItem.txt
Xero1993 is offline  
Reply


Similar Threads Similar Threads
Can I adjust the alchemy rate on the server I'm playing on?
10/24/2023 - Silkroad Online Trading - 2 Replies
Can I adjust the alchemy rate on the server I'm playing on? Or can anyone do it wisely? I would pay a lot :rolleyes:
[S] PSN-Share [B] egold, PSN-Share [S] PSN-Share [B] egold, PSN-Share
05/24/2012 - elite*gold Trading - 0 Replies
Hallo, ich suche nach den PS-Spielen: Red Dead Redemption(+ alle dlc's) + Dark Souls Bieten kann ich egold und diverse PS-Titel im Gegenzug. Kontakt per PN oder Skype
[Help]How can i adjust the droprates in patch 5017?
05/21/2009 - CO2 Private Server - 4 Replies
How can i adjust the droprates in patch 5017? Help me asap!
Did someone hav bot for cabal sea or can crack the cabal rider? can share plz thx
05/31/2008 - Cabal Hacks, Bots, Cheats, Exploits & Macros - 5 Replies
im realy need the bot can sum1 help?



All times are GMT +1. The time now is 03:10.


Powered by vBulletin®
Copyright ©2000 - 2025, 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 ©2025 elitepvpers All Rights Reserved.