Devs, is this possible?

05/19/2017 05:14 Nova1337#1
If I wanted to disable any and all item trading between players would it be possible?
I know its possible to disable exchange, stall and guild storage but Im not sure about stopping item dropping on the floor.

Would that be somehow possible to achieve in silkroad? To disable item dropping? Or is that simply impossible?
05/19/2017 05:52 EdwardTeach+-#2
ya possible its simple can be done with a query

Code:
Update _RefObjCommon SET CanDrop = 0 Where CodeName128 like '%item code%'
05/19/2017 14:00 B1Q#3
Quote:
Originally Posted by EdwardTeach+- View Post
ya possible its simple can be done with a query

Code:
Update _RefObjCommon SET CanDrop = 0 Where CodeName128 like '%item code%'
why are you using LIKE for a single row update? :)
05/19/2017 14:42 blapanda#4
Quote:
Originally Posted by B1QB0SS :3 View Post
why are you using LIKE for a single row update? :)
You mean, "why are you using a WHERE statement with CodeName128 for a simple switch-all task?"!
05/19/2017 20:06 leo2111#5
dafuq, attention seekers? o.o
whats wrong with the querry?
05/19/2017 20:56 Snow*#6
_refobjcommon table, this columns
CanTrade 0 disable exchange, 1 enable the exchange
CanSell 0 can't sell the item to npc, 1 can sell the item
CanBorrow (idr the values but setting it to 0 will stop the players from storing the item in pet, storage and guild storage)
CanDrop 0 can't drop, 1 can drop
CanPick 0 can't pick the item from the ground, 1 can pick the item