[Request]Shaiya Item Mall Price Mod Help

10/29/2009 07:57 trimlink#1
I am trying to figure out how to change item mall prices or even add items to the mall but simply changing the database doesn't work. Is this info in the data.sah file?

Issue Solved mostly. Still working on AP item sell price to NPC can't change from 1000G
10/29/2009 13:18 lilprohacker#2
Quote:
Originally Posted by trimlink View Post
Solved the issue :D
Please refrain from double posting. Instead, you the edit button the bottom right corner to edit your last post. Thanks.
10/30/2009 02:24 charmingwolf1979#3
Quote:
Originally Posted by trimlink View Post
I am trying to figure out how to change item mall prices or even add items to the mall but simply changing the database doesn't work. Is this info in the data.sah file?
If I am correct... you have to change the databases... then reboot the servers... but how did you fix it?
10/30/2009 06:43 trimlink#4
Quote:
Originally Posted by charmingwolf1979 View Post
If I am correct... you have to change the databases... then reboot the servers... but how did you fix it?
did I double post o.O sorry about that was on a shitty wifi spot.

Anyway I kept messing with db until it worked.

My method:

go to GameDefs.dbo.ProductList then modify cell: BuyCost restart sql server and Shaiya server.

Now, if I could just get the AP items to sell at NPCs for what I want.

I tried modifying GameDefs.dbo.Items scroll to ItemID from ProductList scroll right through the table to cell: Sell ; modify then reboot all but they don't change in game. AP items remain selling for 1k gold.

Also does anyone have the ItemID for the actual game gold. I have yet to find it :(
10/31/2009 01:12 charmingwolf1979#5
Quote:
Originally Posted by trimlink View Post
did I double post o.O sorry about that was on a shitty wifi spot.

Anyway I kept messing with db until it worked.

My method:

go to GameDefs.dbo.ProductList then modify cell: BuyCost restart sql server and Shaiya server.

Now, if I could just get the AP items to sell at NPCs for what I want.

I tried modifying GameDefs.dbo.Items scroll to ItemID from ProductList scroll right through the table to cell: Sell ; modify then reboot all but they don't change in game. AP items remain selling for 1k gold.

Also does anyone have the ItemID for the actual game gold. I have yet to find it :(
Reason you can't change what NPC's are selling... is because clients have that in them... you have to modify the client side
Gold is not an item.... if you want to change someone's gold...
do
/set [charname] money [amount of gold given]
10/31/2009 01:29 trimlink#6
Quote:
Originally Posted by charmingwolf1979 View Post
Reason you can't change what NPC's are selling... is because clients have that in them... you have to modify the client side
Gold is not an item.... if you want to change someone's gold...
do
/set [charname] money [amount of gold given]
Thank you Charmingwolf, I figured out what I need to do for NPCs and the Gold command is helpful.
07/22/2010 16:49 rafael1mc#7
So..how do i change the item mall products?..because i don't have the productcode list, and in game..when i try to buy something.... it apears no item located on that sopt..

thx for now.
07/24/2010 00:13 rafael1mc#8
how do i change ap itens? ( i already edited the price).... some itens i try to buy apears no item located on that spot...some itens i can buy but i can't change them..