Changing price of item

dakota200 · 07/14/2013, 16:11

Hey iv been looking at the guild and everything for changing the price on one item and the original cost is some amount of gold, 1 silk, and donation coins(a drop in game). I have changed the dbo_RefPricePolicyOfItem in the DB to just be an amount of gold and 0 silk and 0 donation coins. I have also changed the media side in the RefPriceofPolicyOfItem in the media.pk2. When i go to buy the item it crashes me... am i missing a step?

Spoiler

also is there a way to turn of my private chats for my gm char? people are really starting to **** me off with all there begging.... i heard is was in the smc but wasnt sure where

~~Anonymous-6723~~ · 07/14/2013, 23:47

Try like dat..

1 15 PACKAGE_ITEM_MALL_GLOBAL_CHATTING 64 0 0 -1 *** -1 *** -1 *** -1 ***

MaDenGo* · 07/15/2013, 00:14

Payment device might help you

1 = Gold
2 = Silk
4 = Gift Silk (Received Silk)
16 = Point (vSRO); Premium Silk (iSRO & kSRO)
32 = Honor Point
64 = Copper Coin
128 = Iron Coin
256 = Silver Coin
512 = Gold Coin
1024 = Arena Coin

[GM]Dix · 07/15/2013, 04:28

so i see that it takes the money from my char but then i get a dc after i buy it and I'm not sure if i got the globals because i had some already lol

~~Anonymous-6723~~ · 07/15/2013, 08:34

Code:

declare @charname varchar(128) = 'CharName'
update _Inventory set ItemID = 0 where CharID = (Select CharID from _Char where charname16 = @charname) and Slot >= 12

That should work ^ to clean your inventory from all items except first slots and also the set should remain too. To the problem you have, got any SR_GameServer or SR_ShardManager errors ? Also pm me your skype

1 = Gold
2 = Silk
4 = Gift Silk (Received Silk)
8 = GuildPoints
16 = Point (vSRO); Premium Silk (iSRO & kSRO)
32 = Honor Point
64 = Copper Coin
128 = Iron Coin
256 = Silver Coin
512 = Gold Coin
1024 = Arena Coin

=)

[GM]Dix · 07/18/2013, 04:23

hey sorry zed for not getting back to you, been really busy. ill get with you tomorrow to see if it fixes the problem
havent had a chance to try it

~~Anonymous-6723~~ · 07/18/2013, 09:01

Sure, no problem.. let me know if there is something wrong