{"id":994,"date":"2008-04-30T05:04:00","date_gmt":"2008-04-30T05:04:00","guid":{"rendered":"https:\/\/isplotchy.com\/blog\/?p=994"},"modified":"2013-05-04T01:42:19","modified_gmt":"2013-05-04T01:42:19","slug":"dungeons-and-databases","status":"publish","type":"post","link":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/","title":{"rendered":"Dungeons And Databases"},"content":{"rendered":"

It’s been a couple months since I last provided you with an update as to my brother’s progress on World of Warcraft (WoW).<\/p>\n

My brother has a little problem. He’s got a little something I’m going to call “organizational mania”. It’s probably more correctly identified as a strain of your garden-variety anal-retentiveness, but lemme just call it what I want to call it.<\/p>\n

In WoW, one’s character (or as they say in WoW, “toon”) has lots of different body parts that can be festooned with gear, and a variety of weapons that can be wielded as well. For someone playing multiple toons, it can get rather confusing as to what toon is wearing what equipment.<\/p>\n

When I was playing WoW’s predecessor Diablo II, I would occasionally scribble down some of the belongings of my various characters. This is not a valid approach for my brother.<\/p>\n

So, enter a new Microsoft Access Database application called Toon!<\/span><\/span>. My brother wrote Toon!<\/span><\/span> to keep track of all his characters’ gear.<\/p>\n

In my brother’s words:<\/p>\n

I created it was so I could check to see if any new item that dropped would be an improvement in equipment on any of my characters. In order to complete the database I had to overcome the following challenges:<\/p>\n

1. I needed to concatenate all modifications into one line because MS Access does not permit nesting sub forms.
2. I needed to be able to minimize the application window to use as little screen space as possible (allowing me to easily enter data while having the game running).
3. Also wanted a “nice to have”, that any new modification type encountered (strength, intelligence, attack power, etc.) would be automatically added to the modifications table.<\/p>\n

Originally I was planning on using the report as a paper print-out and marking it up with updates, but I’ve since streamlined by making updates directly to the database. Still, the report is useful to have as an “at a glance” tool while playing.<\/p><\/blockquote>\n

So, please enjoy these screenshots of Toon!<\/span><\/span>, a database application written by my crazy-organized brother.<\/p>\n

Please note that in some of the thumbnails only a partial view of an application screen is displayed. Click on an image to view the app in its full screen glory.<\/p>\n

Main screen<\/span> (it’s more functional than fancy-looking)
\"\"<\/a><\/p>\n

Screen to add a new toon: <\/span>
\"\"<\/a><\/p>\n

Screen to edit an existing toon (can update toon data and edit equipment carried or worn by toon):<\/span>
\"\"<\/a><\/p>\n

Screen to edit an individual piece of equipment on a toon:<\/span>
\"\"<\/a><\/p>\n

Report of all items worn by toon:<\/span>
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

It’s been a couple months since I last provided you with an update as to my brother’s progress on World of Warcraft (WoW). My brother has a little problem. He’s got a little something I’m going to call “organizational mania”. It’s probably more correctly identified as a strain of your garden-variety anal-retentiveness, but lemme just … Continue reading Dungeons And Databases<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14,99],"tags":[],"class_list":["post-994","post","type-post","status-publish","format-standard","hentry","category-computers","category-world-of-warcraft"],"yoast_head":"\nDungeons And Databases - SPLOTCHY<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dungeons And Databases - SPLOTCHY\" \/>\n<meta property=\"og:description\" content=\"It’s been a couple months since I last provided you with an update as to my brother’s progress on World of Warcraft (WoW). My brother has a little problem. He’s got a little something I’m going to call “organizational mania”. It’s probably more correctly identified as a strain of your garden-variety anal-retentiveness, but lemme just … Continue reading Dungeons And Databases →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"SPLOTCHY\" \/>\n<meta property=\"article:published_time\" content=\"2008-04-30T05:04:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-05-04T01:42:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/splotchy.com\/images\/blog\/wow\/switchboard.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Dungeons And Databases\",\"datePublished\":\"2008-04-30T05:04:00+00:00\",\"dateModified\":\"2013-05-04T01:42:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/\"},\"wordCount\":435,\"commentCount\":5,\"image\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/isplotchy.com\\\/images\\\/blog\\\/wow\\\/switchboard.jpg\",\"articleSection\":[\"computers\",\"world of warcraft\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/\",\"url\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/\",\"name\":\"Dungeons And Databases - SPLOTCHY\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/isplotchy.com\\\/images\\\/blog\\\/wow\\\/switchboard.jpg\",\"datePublished\":\"2008-04-30T05:04:00+00:00\",\"dateModified\":\"2013-05-04T01:42:19+00:00\",\"author\":{\"@id\":\"\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/isplotchy.com\\\/images\\\/blog\\\/wow\\\/switchboard.jpg\",\"contentUrl\":\"https:\\\/\\\/isplotchy.com\\\/images\\\/blog\\\/wow\\\/switchboard.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/2008\\\/04\\\/dungeons-and-databases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dungeons And Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/\",\"name\":\"SPLOTCHY\",\"description\":\"jung vf fcybgpul?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"\",\"url\":\"https:\\\/\\\/isplotchy.com\\\/blog\\\/author\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dungeons And Databases - SPLOTCHY","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/","og_locale":"en_US","og_type":"article","og_title":"Dungeons And Databases - SPLOTCHY","og_description":"It’s been a couple months since I last provided you with an update as to my brother’s progress on World of Warcraft (WoW). My brother has a little problem. He’s got a little something I’m going to call “organizational mania”. It’s probably more correctly identified as a strain of your garden-variety anal-retentiveness, but lemme just … Continue reading Dungeons And Databases →","og_url":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/","og_site_name":"SPLOTCHY","article_published_time":"2008-04-30T05:04:00+00:00","article_modified_time":"2013-05-04T01:42:19+00:00","og_image":[{"url":"https:\/\/splotchy.com\/images\/blog\/wow\/switchboard.jpg","type":"","width":"","height":""}],"twitter_misc":{"Written by":"","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#article","isPartOf":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/"},"author":{"name":"","@id":""},"headline":"Dungeons And Databases","datePublished":"2008-04-30T05:04:00+00:00","dateModified":"2013-05-04T01:42:19+00:00","mainEntityOfPage":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/"},"wordCount":435,"commentCount":5,"image":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/isplotchy.com\/images\/blog\/wow\/switchboard.jpg","articleSection":["computers","world of warcraft"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/","url":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/","name":"Dungeons And Databases - SPLOTCHY","isPartOf":{"@id":"https:\/\/isplotchy.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#primaryimage"},"image":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/isplotchy.com\/images\/blog\/wow\/switchboard.jpg","datePublished":"2008-04-30T05:04:00+00:00","dateModified":"2013-05-04T01:42:19+00:00","author":{"@id":""},"breadcrumb":{"@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#primaryimage","url":"https:\/\/isplotchy.com\/images\/blog\/wow\/switchboard.jpg","contentUrl":"https:\/\/isplotchy.com\/images\/blog\/wow\/switchboard.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/isplotchy.com\/blog\/2008\/04\/dungeons-and-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/isplotchy.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dungeons And Databases"}]},{"@type":"WebSite","@id":"https:\/\/isplotchy.com\/blog\/#website","url":"https:\/\/isplotchy.com\/blog\/","name":"SPLOTCHY","description":"jung vf fcybgpul?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/isplotchy.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"","url":"https:\/\/isplotchy.com\/blog\/author\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3gWlt-g2","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/posts\/994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/comments?post=994"}],"version-history":[{"count":1,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/posts\/994\/revisions"}],"predecessor-version":[{"id":3080,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/posts\/994\/revisions\/3080"}],"wp:attachment":[{"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/media?parent=994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/categories?post=994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isplotchy.com\/blog\/wp-json\/wp\/v2\/tags?post=994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}