Account txt to SQL

[Koroshiya]

I've had an idea to build an "Armory" for GR. The problem is, I don't think you can with the current setup. If we were still using SQL to store accounts, I could probably finagle something relatively easily. But, they aren't so here are my questions:

1) Is it possible to query the account text files in PHP?
2) Is there such a program or script that could automatically add and/or refresh all account text files into an SQL table?

[HandupOnYoHip]

What exactly is this armory you want to make? Are you trying to edit certain accounts from a website?

[Cadavre]

1) Is it possible to query the account text files in PHP?
2) Is there such a program or script that could automatically add and/or refresh all account text files into an SQL table?
1) Possibly, but you would have to script it yourself.
2) Not yet, there's an old SQLite to TXT though, but we're probably going to have to make one of these programs since GServer v2 will have the support of TXT/MySQL/SQLite account/weapon/whatever database.

What is it that you're trying to accomplish? Just wondering.

[Koroshiya]

It's a player database that allows users to search for the stats of the other players.

Basically, it will translate the information contained in the account.txt into something like this:

http://www.wowarmory.com/character-sheet.xml?r=Ravenholdt&n=Zeromus

[Dangerless]

New gserver will support many different types of storage engines. Unfortunately, the old one doesn't so you may have to hack it up a bit.

Would 1.39 storage engine work?..if so, Koroshiya, I have a few files I could send your way that shows the stats of rupees, kills, assuming if you can edit it so it works that is.

[Koroshiya]

Apparently, my reply to Cadavre never posted. Oh, well. I'll catch up, anyway.

Essentially, the Armory is like this:

http://www.wowarmory.com/character-sheet.xml?r=Ravenholdt&n=Zeromus

It shows complete stats of a player. I want to have the text files dump into SQL automatically so I can build a PHP search feature to access and display that information. Even for weapons and certain flags (Like, my server's currency script).

@Nalin
I look forward to that release. Until then, I've already set up the table, so I'll input some dummy accounts to build the Armory script off of. And I'll be glad to share the code when it's finished. Although, assistance from anyone with knowledge is more than welcome to lend a hand. Just hit me up on AIM.

@Dangerless
Unfortunately, it sounds like I would actually have to run my server with that version for immediate updates to take affect. Thanks, anyway.

[Cadavre]

Essentially, the Armory is like this:

http://www.wowarmory.com/character-sheet.xml?r=Ravenholdt&n=Zeromus

This will most likely be doable with the new information storage system. If you could hold on to that thought until next GServer version it'll be much easier for you.

[Koroshiya]

Ok. I've worked out how I want the end result to look. This is just a basic 2-hour design. Over time, I'm going to go in and add background textures to make it look nice. Mouse over the items to see descriptions of them.

http://keldraga.vndv.com/armorytest.htm

Note: The search function doesn't work. This is just a sample result page. I'm, now, going to start work on search and display function.

:Edit:
Ok, now my posts in this section don't have to be moderated. lol. Could someone accept my other posts so people get my replies?