how to make item sellable/dropable/tradeble/destroyable

[EdenEternal]

lets beggin!

Open Navicat->host->l2jdb right-click and select console

 

etcitems

 

for example Coin of Luck(4037)

 

write there:

 

UPDATE etcitem SET `sellable`="true" WHERE `item_id`="4037";
UPDATE etcitem SET `dropable`="true" WHERE `item_id`="4037";
UPDATE etcitem SET `tradeable`="true" WHERE `item_id`="4037";
UPDATE etcitem SET `destroyable`="true" WHERE `item_id`="4037";

 

with this sql query you make coin of luck sellable/dropable/tradeble/destroyable

if you want to make sellable/dropable/tradeble/destroyable other item, just change 4037 to your item id.

 

armor

 

for example Draconic Leather Armor(6379)

 

write there:

 

UPDATE armor SET `sellable`="true" WHERE `item_id`="6379";
UPDATE armor SET `dropable`="true" WHERE `item_id`="6379";
UPDATE armor SET `tradeable`="true" WHERE `item_id`="6379";
UPDATE armor SET `destroyable`="true" WHERE `item_id`="6379";

 

with this sql query you make Draconic Leather Armor sellable/dropable/tradeble/destroyable

if you want to make sellable/dropable/tradeble/destroyable other item, just change 6379 to your item id.

 

weapon

 

for example Arcana Mace(6579)

 

write there:

 

UPDATE weapon SET `sellable`="true" WHERE `item_id`="6579";
UPDATE weapon SET `dropable`="true" WHERE `item_id`="6579";
UPDATE weapon SET `tradeable`="true" WHERE `item_id`="6579";
UPDATE weapon SET `destroyable`="true" WHERE `item_id`="6579";

 

with this sql query you make Arcana Mace sellable/dropable/tradeble/destroyable

if you want to make sellable/dropable/tradeble/destroyable other item, just change 6579 to your item id.

[Onix]

of course good guide for newbie, anyway good work :)

[Matim]

Quite simple subject, but as alway, something useful.

[VictorCrane]

Alway gibi şeyler yararlı.tnx

[EdenEternal]

my pleasure :)

[`iAndre]

thanks

[femalesoulhound]

if u are on h5 server, u just need to re configure it @ xml of item,,, CMIIW