1. Introduction

Back in the day, I used to play a lot of Diablo2. In order to keep track of the

items I had collected, I made a PHP/MySQL website so that both myself as my

friends could see what I still missed (and thus, whether it was worth to pick

up an item or just dispose of it :-)

2. Rewriting the site

However, as this website worked fine, 1.10 came out, which introduced a lot of

classy new items. As the game got a lot harder, I wanted to be able to search

for items with properties (for example, an overview of all items which give

+ to all resistances) - this was not feasible with the old approach (which just

stored item properties in a MySQL TEXT field), so I decided a rewrite was in

order.

3. Implementation

I chose the PostgreSQL database as it's much more feature-complete - and things

like referential integrity and column checks are very useful.

In order to easily import data, I chose to write everything down as XML which

I could then later import into the database using Perl scripts. The XML files

are provided in the xml/ folder, whereas the scripts are in the scripts/

folder.

For ease of use, a complete database dump with all items imported is provided

in sql/diablo2-filled.sql.

4. License

This work is licensed under the GPL license version 2 or up. All item-images

as provided in www/images/items/ are copyright Blizzard Entertainment.