How to populate ItemData table with newest items?

Discussion in 'Help' started by Arcia, Nov 19, 2010.

  1. Arcia

    Arcia AdvExt64 Customers (GF/GE/HF)

    Hi...

    I'm trying to populate the ItemData table in the database with all the items, to help me track items. Thing is, I've been doing it by hand... There must be a way to do it automatically using the itemname-e.dat file.

    I've heard it's done using L2 Script Maker, but I'm not sure.

    Can anyone help me with the process?

    Thanks in advance.
     
  2. Renobizarro

    Renobizarro AdvExt64 Customers (IL)

    l2fileedit + notepad++

    is the easy way to do it :D
     
  3. FidoW

    FidoW AdvExt64 Customers (IL)

    You can create your own php scripts for example... not hard.

    Just extract with itemdata-e to text format, like FileEdit for example, parse the file and insert into database.
     
  4. Arcia

    Arcia AdvExt64 Customers (GF/GE/HF)

    Yes, but any example of the parsing / insert SQL query?

    I've been having errors while trying before, and I don't want to explode the whole thing. (Well, maybe I do, but...)