SQL query to retrieve whole list of items for a json file.

[LordFede]

I need this for a friend, he's using igcn s8e3 files, and I need to make a website for him.
I'm trying to build a items.json file out of item.xml file but it will take ages for me to do it by hand, so.. Is there any way I can get the whole list of items from DB? So I can build a json file later.
I was thinking about querying database once it loads the config files.. but dunno how :D :D

Example:

{name: 'Kris', Type: '1', 'Index': '1', 'Slot': '1', 'Skill': '1', 'X': '1', 'Y': '2', 'Option': '1', 'level': '1', 'DmgMin': '1', 'DmgMax': '2', 'ASpeed': '1', 'Dur': '1', 'MagDur': '1', 'MagPW': '1', 'ReqLvl': '1', 'ReqStr': '1', 'ReqDex': 1'', 'ReqEne': '1', 'ReqVit': '1', 'ReqCmd': '0', 'SetA': '0', 'DW': '1', 'DK': '1', 'Elf': '1', 'MG': '1', 'DL': '', 'SUM': '1', 'RF': ''}

[MentaL]

[cryy]

Item info is not saved in database so you should parse xml file.

[LordFede]

Item info is not saved in database so you should parse xml file.

Thank you Cryy! I managed to parse the xml file successfully :D