The House of Black Star

I need again the help of the uber HoBS developers

My project (check here http://www.blackstaruo.com/e107_plugins ... c.php?2016) is 90% complete. The only problem I have is that I'm using a DB that miss some data ,so I can't complete it until I find a good database.

I've tried AODB resource tool (ectracted all the data to XML) and then used AODBC to convert xml to MySQL script. AODBC ends with an error. Also , the sql that AODB resource tool outputs is not suitable for mySQL.

another solution I saw is AOPPA ,but its source only and written for linux.

So, my question is : How can I extract the AO nano database from windows.
Can you guys post any guide to help me? The AOmainframe database doesn't work also.

Thanks in advance

the tool i use is AODBXMLParser it is written entirely in php, and uses modular templates for output, so all you really need is the string you want, and i can help you build that (complete template is what i originally sent you)

Thanks again for the help parf.
I'm looking to the xml that the AODBResourceTool has extracted from my AO installation and I can't find the "Quality" field. All the old SQL scripts I had had the same problem : I couldn't find the QL of the nano. I want the ql of the nanos mainly to be able to sort them.
Any idea on why I'm doing wrong?

I found a partial solution. The ql in the XML appears only if I export both nanos&items. Not only the nanos...

the AODBXMLparser doesn't parses all the items. I must look into it a bit more

the 'nano' mode output are exactly that; installed and in-use nano formulas... those don't have a QL because they are no longer an item, what you need to do is go back through with the name (or a variation in the terms of weird looking and other sl nanos) and pull up the QL of the nano crystal that the program goes to

Hi again. I'm reopening that post because I tried again to extract the AO db to MySQL with no luck.

So far my tests are run with a file that Parfet gave me (it was an SQL file with the 17.0.x database).

I tried all the (windows) programs but I had no luck..
I found in the internet an extract of the 18.x.x database but it's a 400MB file with all the items of AO. it's huge and in my local xampp installation it took ages to import
The closest I've managed to get is an SQL script for AOmainframe (I think it's for mssql) where there is only 1 table with anything in it... and I can't import it in MySQL.
AODBXMLParser does not creates output (maybe I have the wrong input ???)

also,I'm trying to see if Xyphos parser exports SQL but so far I see only xml output...

So, I'm asking again the help of the wisest people here...
Can you post a step by step guide on how to extract only the nanos of the AO database to an MySQL script?

Thanks again...