Jump to content

Recommended Posts

Posted

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.

  • 1 year later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...