Register for your free account! | Forgot your password?

You last visited: Today at 05:18

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

 

change prices?

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2010
Posts: 1,139
Received Thanks: 632
change prices?

hello iv made an NPC for Gaia cards. i would like to change the price in the whole shop how do i do it want them all to be 5mil each!



gavsta is offline  
Old   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Either ItemResource (UPDATE ItemResource SET price = '5000000' WHERE id = 'skillcard')
Or MarketResource (UPDATE MarketResource SET price_ratio = '500 (for example)' WHERE name = 'gaia_etc')


Xijezu is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Oct 2008
Posts: 10,822
Received Thanks: 8,862
UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = 'ammount here'
WHERE [name] = 'name of npc here'
GO

Example :

UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = '1'
WHERE [name] = 'TH_creature_give_start'
GO
Yunchen is offline  
Thanks
1 User
Old   #4


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Code:
UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = '1'
WHERE [name] = 'TH_creature_give_start'
GO
Auch bei price_ratio die ' ' benutzen
Xijezu is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
[How To]Change Blacksmith Prices
Hi! I'm not sure if this has been already explained here, however if it has, just let me know and I will delete this =). This is not a detailed...
4 Replies - Shaiya PServer Development
%% Compare WoW Gold Prices & CDKey/Timecard Prices (EU/US) %%
Sick of looking around at many WoW Gold sites to find who has the lowest price?... Worried about which seller sites are safe?... Want the fastest...
8 Replies - World of Warcraft Trading
change Shop Prices?
hi i know this question is probably very silly, but is there a way to change the prices from the NPCs? it would be the greatest idea in the world...
2 Replies - Final Fantasy XI
change Shop Prices
hi i know this question is probably very silly, but is there a way to change the prices from the NPCs? it would be the greatest idea in the world...
0 Replies - Final Fantasy XI



All times are GMT +2. The time now is 05:18.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.