So I'm in a class that’s having us design an access database solution for any problem we want. Normally I find these sorts of open ended problems to be rather annoying and lazy on the part of the instructor. However this time I happen to be having a problem in an online game that could use a good relational database solution. Seems a bit like two birds with one stone. Except that I'm having a bit of a problem getting the data loaded.
The application I am trying to develop will keep track of various alliance members character's skills, so we can better determine who needs to do what role for player vs. player combat. My particular alliance consists of around 200 to 300 people with over half of those owning more than one account, and each account having up to 3 characters. As you can imagine keeping track of which characters belong to which person and what character can do which role is a bit of a headache.
Given the size and frequency of the imports, doing it manually is out of the question. And even when I tried manually importing some test data via an XML file; massive relationship critical chunks of it went missing........ :banghead::banghead::banghead::banghead::banghead:
I would love to be able to query the following link with a loop dynamically changing the keyID and vCodes from a table and pull the information provided into its own table. Then take that table and use the character IDs in a second query to pull skill information from the second link into a 3rd table. however I am unsure of the syntax needed to make this happen.
https://api.eveonline.com/account/c...UqU3Y5Cg5TuuogEffVXFxhCRlh4pSeY8CkpoZdHxzTlEL
https://api.eveonline.com/char/Char...CRlh4pSeY8CkpoZdHxzTlEL&characterID=137038993
(the relevant data is in the" <rowset name="skills" key="typeID" columns="typeID,skillpoints,level,published">" section)
I have a decent understanding of VB and a decent understanding of access, but I'm discovering that I have no freaking clue how to make the two work together. Whats worse is that access seems to handle XML data like Steven Hawking handles a stuck pickle jar.......
So....... Can anyone help me out?
Here is some documentation provided by the game developers.
For the first data pull: http://wiki.eveonline.com/en/wiki/EVE_API_Account_Characters
And here is the second: http://wiki.eveonline.com/en/wiki/EVE_API_Character_Character_Sheet
The application I am trying to develop will keep track of various alliance members character's skills, so we can better determine who needs to do what role for player vs. player combat. My particular alliance consists of around 200 to 300 people with over half of those owning more than one account, and each account having up to 3 characters. As you can imagine keeping track of which characters belong to which person and what character can do which role is a bit of a headache.
Given the size and frequency of the imports, doing it manually is out of the question. And even when I tried manually importing some test data via an XML file; massive relationship critical chunks of it went missing........ :banghead::banghead::banghead::banghead::banghead:
I would love to be able to query the following link with a loop dynamically changing the keyID and vCodes from a table and pull the information provided into its own table. Then take that table and use the character IDs in a second query to pull skill information from the second link into a 3rd table. however I am unsure of the syntax needed to make this happen.
https://api.eveonline.com/account/c...UqU3Y5Cg5TuuogEffVXFxhCRlh4pSeY8CkpoZdHxzTlEL
https://api.eveonline.com/char/Char...CRlh4pSeY8CkpoZdHxzTlEL&characterID=137038993
(the relevant data is in the" <rowset name="skills" key="typeID" columns="typeID,skillpoints,level,published">" section)
I have a decent understanding of VB and a decent understanding of access, but I'm discovering that I have no freaking clue how to make the two work together. Whats worse is that access seems to handle XML data like Steven Hawking handles a stuck pickle jar.......
So....... Can anyone help me out?
Here is some documentation provided by the game developers.
For the first data pull: http://wiki.eveonline.com/en/wiki/EVE_API_Account_Characters
And here is the second: http://wiki.eveonline.com/en/wiki/EVE_API_Character_Character_Sheet
