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.

Read More

Interesting feature with parsing XML with jQuery on Safari

  • 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.

Read More

Storing watched movies and Netflix shipping/receiving in XML format

  • 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.

Read More

Extended iTunes Track class for PHP

  • 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.

Read More

The benefits of using a file for Log Parser SQL queries

  • 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.

Read More

Shadow Hearts: Covenant leveling information

  • 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.

Read More

Importing a custom namespace / custom type into an XSD

  • 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.

Read More

Onimusha: Dawn of Dreams data

  • 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.

Read More

XML standards - personal suggestions

  • 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.

Read More

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

  • 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.

Read More