For the last week or so I’ve been absolutely obsessed with my final homework assignment, so other than a little socializing and running reroll or semi-afk golding scripts I haven’t been doing very much on the Realms.<\/p>\n
When last we checked in I had started working on modernizing an item database that I used extensively when I played before. \u00a0This program was originally written by a player named Daltorak (a close friend, I’ll respect his privacy here) and was shared with me when I started playing. \u00a0It didn’t take long before we added a ton of useful features to it. \u00a0One of the most useful modes of this program was the ability to play “Mr. Dressup”. \u00a0Put in your character’s stats and start choosing equipment to dress them in. \u00a0This mode was invaluable for setting goals or planning different builds. \u00a0This program was collaborative, both Warren and I would share databases via ICQ and merge them. \u00a0This was years before Alexian started sharing his database with anyone.<\/p>\n
The fact that I can use this program today and still get tremendous utility out of it is a testament to Daltorak’s original design.<\/p>\n
What else was this great for? \u00a0Oh, any “find the item” type quest. \u00a0With nearly 2,500 entries spanning from old clan to (at the time) current, it was very hard to stump us for an item… foods, drinks, keys, scraps, whatever, we probably had it. \u00a0When we started importing the output of c ‘locate object’ and auction channel the database ballooned (these were the days before donation rooms were no-locate).<\/p>\n
So where am I at? \u00a0I have set up a SQL database with the structure of what I think will model Realms items nicely. \u00a0Today I installed Turbo Pascal 5.5 into a VirtualBox session so that I could convert the existing database out to a comma\u00a0separated\u00a0spreadsheet. \u00a0You don’t appreciate how far OSes have come until you go back and do some serious text manipulation in a DOS editor… I’m telling you!! \u00a0This is almost complete and then I have to try to write an import script to the new database. \u00a0This won’t be too hard, but might be labour intensive and might reveal some flaws in my otherwise perfect plan \ud83d\ude42 \u00a0The item formats are in the pre-Shattering format, that is items might be “anti-good” instead of “allowed: good neutral” so a tremendous amount of verification will be needed to bring it up to a level I’ll be satisfied with it, but for now, not so bad.<\/p>\n
Oh, yes, it is my plan that most of the database features will be available publicly … why wouldn’t I want to share and collaborate? \u00a0Exactly what form that’s going to be in is still to be determined, but feel free to comment and let me know what YOU’d like to see.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"