Is there a way to update your items db?

[Sharpienero]

Title says it, because I seem to be missing a lot of items (equips.)

Is there a way to upgrade mySQL so that I can add those missing items?

[ngek202]

look for txt to sql converter, I remember in eAthena i found a php script for this.

this can convert item_db.txt, item_db2.txt and also mob_db.txt, mob_db2.txt also mob_skill_db

Edited January 27, 2012 by ngek202

[Zac]

What kind of items you lost? custom items? if you lost custom items, you gotta have back up.

if you lost official items, here's the newest item_db.

Pre-Renewal:

http://sourceforge.net/apps/trac/rathena/browser/trunk/db/pre-re/item_db.txt]Item_db.txt[/url]

Renewal:

http://sourceforge.net/apps/trac/rathena/browser/trunk/db/re/item_db.txt

How to add?

Just copy paste the item_db into your old item_db, then @reloaditemdb.

[Amellia sizilia sembiring]

yes, you can

use this syntax

INSERT INTO `item_db2` VALUES ('ID','Name','Name',Type,Price,Sell,Weight,ATK,DEF,Range,Slot,Job,Upper,Gender,Loc,wLV,eLV,Refineable,'View,Script','OnEquip_Script','OnUnequip_Script');

[Sharpienero]

yes, you can

use this syntax

INSERT INTO `item_db2` VALUES ('ID','Name','Name',Type,Price,Sell,Weight,ATK,DEF,Range,Slot,Job,Upper,Gender,Loc,wLV,eLV,Refineable,'View,Script','OnEquip_Script','OnUnequip_Script');

I don't understand. o_o;

What file am I supposed to put this into?

[Arcenciel]

It's an SQL Query. You put it into whatever you use to manage your sql files.