SQL db.Item || hp & ap bar

[dupetion]

1) dbo.Item || dbo.ItemDeteils :: convert
================================
so i knew that i was gonna bump into that one day . . . in 1.5 u need as we all know to add from zItems.xml all the information to db.Item and it's item description to all the other dbo.ItemDetail now of course if u adding like 3 items that for sure wont be a problem but i wanted more ^.^ so i add to the zItem around 30~60 items :P now i knew of a person at this forum that posted a software that was made to convert from zItem.xml to SQL. so if anyone know or has that program that would be great to post it .
if there any other way to do it please tell me like
if i remove the key from the dbo for item would it fix my problem and dbo.ChercterItem wont request for that table?

so if someone can help me or find me a way to fast convert items to the table or just remove the option to freely add items that would be great

2) hp || ap :: bar
================
i started using and getting into learning the code and it's way with Gunz source and it was working great for me so far and i was adding staff | commands | emoji | Room[Tags] | but no matter witch code i use or how i type it it wont show the hp | ap %d in the game no matter what @_@

im almost sure that the problem is in the ZGameInerface.cpp but not sure. . .
( the source is compiling normally without any errors including the debug mode{Make sense} )

so if anyone could help me with that that would be great


hope to get help soon cause i just cant get to fix any of these problems that would be great *.*

[MentaL]

[tyke98]

Here you go:
http://forum.ragezone.com/f245/zitem-2-sql-tool-959024/

[dupetion]

Thanks that was a great help and saving me a lot of time
i was trying to search for it myself but didend find anything :P

funny about your timing hehe cause i just started inserting code id by id. lel