Nier weapon data in XML (and LINQ sample query)

October 16, 2011
James Skemp

Going through the game Nier yet again, I wanted an easier way to track what weapon levels I had already upgraded to, and what items I still needed to unlock weapon items. Phase one towards that goal is creating an XML file with weapon upgrade information which is available online: Nier weapon data. An XML schema document for this information is also available: Nier weapon XSD. Sample LINQ query The following query can be run from LINQPAD, and will either display all items with their counts, or a grouped listing of items with the total quantity needed.

March 27, 2011
James Skemp

I've been playing around with HTML5 quite a bit recently, in particular with offline Web applications. My second experiment (my first is on pause) was with making my video games available, so that I can access the listing when I'm out shopping at used game stores. It's still in progress, but you can see my offline listing of video games now. My main intention is to make this available on my iPod Touch, so I was a bit dismayed when I found that the listing didn't display the title of the game.

March 6, 2011
James Skemp

Ever since I started my Netflix subscription in September 2006 I've been keeping track of what movies I receive and when. Unfortunately, as the years have gone by I've found it more and more difficult to easily look through the listings to see when I last watched a movie. Additionally, I've no longer been keeping track of what ratings I give movies, and why. The initial goal was really to track when Netflix shipped and received movies, as well as when I mailed and received.

September 26, 2010
James Skemp

In a previous article, I had outlined classes in C# and PHP to handle iTunes Playlists to Xml outputs. Having let it sit on the back burner for long enough, I finally went back to the PHP class and finalized the constructor. I also added two functions for sorting. Below I have the current code for the class (a current version of the Track class for PHP will always be available elsewhere) and then an example implementation.

September 26, 2010
James Skemp

One of the things I always forget about when I'm using Microsoft Log Parser is that you can define your SQL query in a file and run it, instead of putting it in the command line. For example, the following will run whatever SQL is defined in strivinglife.robots.sql. logparser -i:w3c -o:xml file:strivinglife.robots.sql Where this comes in handy is for something like the Log Parser query I defined today, that parses IIS logs for requests to the robots.

September 6, 2010
James Skemp

As I continue to look through my old files I found leveling information for Shadow Hearts: Covenant, from December 2005 to January (1st) 2006. I've converted it from an ODS file to XML, and am making it available. Shadow Hearts: Covenant leveling guide. Since I have a leveling guide for Shadow Hearts: From the New World (previously written about), it almost makes sense to go back and play the original Shadow Hearts to get information for that game as well.

September 5, 2010
James Skemp

I have a custom type that I use in a couple of my documents. Unfortunately, in the past I was adding this to each xsd, as I needed it. However, I've now figured out how to import it into xsd files as needed. Original schema Currently I'm adding the following at the top of each xsd: <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="customDateType"> <xs:restriction base="xs:string"> <xs:annotation> <xs:documentation><![CDATA[Allows for a year, a year and a month, or a year, month, and day, to be defined.

September 3, 2010
James Skemp

From the archives, I've created an XML Schema and XML data file for Onimusha: Dawn of Dreams, for the Playstation 2. Currently the data only includes armor leveling information, from level 1 to 100. The data comes from an OpenDocument Spreadsheet (OnimushaDawnofDreams.ods) from way back in May of 2006. My characters and core weapons being completely maxed (not to mention souls), I may decide to replay the game to track this information as well, or just upgrade weapons.

September 3, 2010
James Skemp

As I prepare to create another XML data file, I started looking at the standards I use to create XML files, and what the recommendations are. Elements In the past I've used camel case, but on a recent file used Pascal case instead. I think this was more becauase I've started to using Pascal case for public items (variables), and camel case for private items, as that's fairly standard in development.

August 15, 2010
James Skemp

In part one of this series we covered what we'd be doing, and what data model we'd be using. In part two of this series we used LINQ to XML to query the XML file with the data we want to display. This time we'll be doing the heavy lifting of actually creating the chart and displaying it to the user. For ease, I'll be implementing very basic caching. Preliminary requirement Before you can use the charting functionality you need to have a reference to System.

Older

Search

Links of Note

Support This Site

If my blog was helpful to you, then please consider visiting my Amazon Wishlist.

Nier weapon data in XML (and LINQ sample query)

Interesting feature with parsing XML with jQuery on Safari

Storing watched movies and Netflix shipping/receiving in XML format

Extended iTunes Track class for PHP

The benefits of using a file for Log Parser SQL queries

Shadow Hearts: Covenant leveling information

Importing a custom namespace / custom type into an XSD

Onimusha: Dawn of Dreams data

XML standards - personal suggestions

ASP.NET charts example: Odin Sphere: Part 3 - Creating the chart

Search

Links of Note

Recent Posts

categories

Support This Site