exporting data to external database

[the_master_josh]

I want to build an application that keeps track of all the data regarding what collection quests you have completed (it is inspired by Rippchi's Collection Quest Tracking List). I plan to store what items have been collected in a seperate database for the application, along with other necessary data.

Instead of entering in the data manually through the application everytime I find an item in game, I was wondering if it was possible to create a UI that exported that dynamic data to the application (or at least run a script to run the software). if someone has an idea for another solution as a starting block for my problem solving (other than building a website cause I am not a web developer), I can figure out the nuts and bolts for it.

[lordebon]

Originally Posted by the_master_josh

I want to build an application that keeps track of all the data regarding what collection quests you have completed (it is inspired by Rippchi's Collection Quest Tracking List). I plan to store what items have been collected in a seperate database for the application, along with other necessary data.

Instead of entering in the data manually through the application everytime I find an item in game, I was wondering if it was possible to create a UI that exported that dynamic data to the application (or at least run a script to run the software). if someone has an idea for another solution as a starting block for my problem solving (other than building a website cause I am not a web developer), I can figure out the nuts and bolts for it.

The only "legal" way to do such a thing is to export the data to your log, as any program that would read the game directly would be a violation of the EULA.

I know of two ways to get data out into a log: you either /say it (which is capable of handling multiple lines automatically) or you use beginchatinput and hit "return" and use a fake command. This prevents your character from saying it (and thus people giving you strange looks, hehe...) and it still sends the data to the log.

After you get the data into the log, it's up to you to write a script or program to parse it into something useable you can keep track of.

And another word of caution... this only works well for some things. The beginchatinput method works on some things that the say method chokes on, but I'm not sure how to make it work for more that one line of text at a time. Also, I don't know how the collection tab looks, but I assume it uses a template which may make your job harder.

Good luck, hehe =)

[gm9]

the other legal way is to use a web based database and simply dump it to the browser. much easier, and without the limitation of /say.

[the_master_josh]

I was afraid that was the answer . I read about using the in game web browser and using the /say channel to dump data to the log files. I was just hoping there might be another way.

I was already planning on hosting my database on the internet on a friends server and accessing it through the internet. Could you elaborate on what you mean by dumping it to the browser?

[lordebon]

Originally Posted by gm9

the other legal way is to use a web based database and simply dump it to the browser. much easier, and without the limitation of /say.

True, but I like the permanence of /say or a bad command using beginchatinput. That way you just get it into the log, and you know it's going to be there later.