Log in

No account? Create an account

D&D Database.

« previous entry | next entry »
Aug. 3rd, 2007 | 01:26 pm

As a few may know, I have a D&D database of sorts at http://www.imarvintpa.com/dndlive/

I've been contemplating adding a character tracker for some time. I've also been trying to get Class data added.

I've stumbled a bit on the Class portion, mostly by spell casting. However, my paper prototyping of how to work with Characters may have helped me decide what to do.

Which leads me to my real question:

  1. Do I let anybody sign into my site and edit anything?

  2. Do I create a clone of my site and remove all the non OGL things and let anybody sign in and edit anything (If I do, it'll be at ../dndwild/)?

  3. Do I let anybody sign in, but only let them edit characters and spell books?

The programming work between the choices is nearly identical. On the wild clone, purging the database of the NON-OGL things would be sad and time-consuming. And it wouldn't really prevent anybody from adding it back in.

Long-term, the character tracker would calculate most things. Initially, you'd have to manually enter almost all the numbers or modify with special bonuses.

The inventory tracker would also be fairly interesting.

Check out http://www.imarvintpa.com/dndlive/Yerrij.html to see an example of what I would want it to generate. I would add in support for additional character sheet outputs over time. (Money and a template would speed those up.)

I have my preference, but I'll keep it to myself until later.


Link | Leave a comment |

Comments {6}

Character tracking

from: ext_58126
date: Aug. 3rd, 2007 06:31 pm (UTC)

I've been wanting to write an online character creation/management tool for a while. The problem is we have a highly functional implementation in Excel that has so much logic in it, duplicating it in something else is a daunting task.

Of course, the trouble with an Excel spreadsheet is that it's hard to manage. When I was conceiving the idea for my character website, I wanted to have the accounts based around campaigns. So a user creates a campaign and invites other users into it. The DM chooses which books are in play. The players sign in and create their characters according to the valid rules, and fun ensues. Finally, the DM can see all of the character sheets for secret rolls.

I was going to post a link to our Excel character sheet but it appears to be down, if you're interested I can email it to you separately, it's very feature rich.

In regards to your question, I would choose option C with a twist. I would allow users to create their own spellbooks (you already have this concept for your own spells), and when they create a character I would have the choose which books are in play, so they don't have to dig through bunches of irrelevant spells.

When I started my version of this project I only got as far as a the database schema, and some vague notions of a UI (AJAX!), but I always had the notion of leveraging your spell database, it's good work.


Reply | Thread


Re: Character tracking

from: imarvintpa
date: Aug. 3rd, 2007 07:27 pm (UTC)

For daunting tasks, I've learned that this quote is very true: "A complex system that works is invariably found to have evolved from a simple system that works." -John Gaule.

So, I have to start somewhere.
Your modified option C was just an oversight in my original posting on what could be edited.

I also agree about the campaign features. I figured a minor feature would be to keep a character private, specific friends only (DM), friends (party), and public.

My UI will start off with my classic HTML table of labels and input widgets. Although I do have some interesting improved pop-ups. I have a basic concept on how to make feats and items automatically update other aspects of your character (check out my monster skill calculator). So, weird interactions have a basic functionality established. And everything has a manual override. I'm not assuming any hard limits, that way if your DM says, create a 1st level character, you get 3 bonus feats instead of 1 for first level, you can just do it.

But first, I need to finish my "Create an Account" feature. I just got the passwords encrypted for the first time since I switched from ASP. Then I have to test to see what normal users can currently do and implement proper lock-downs. (If I go with Option A, I'll just give everybody the basic editing privilege.)

Reply | Parent | Thread

Character sheet link

from: ext_58126
date: Aug. 3rd, 2007 07:07 pm (UTC)

Here's the link to the excel character sheet.

Reply | Thread


Spell List

from: ray20886
date: Aug. 8th, 2007 11:13 am (UTC)

You have not listed this charters known Spells.

Reply | Thread


Re: Spell List

from: imarvintpa
date: Aug. 8th, 2007 12:21 pm (UTC)

I keep that somewhere else. Look for Yerrij's book at http://www.imarvintpa.com/dndlive/Index_Books.php


Reply | Parent | Thread

The Son of the last of a long line of thinkers.

Re: Spell List

from: delascabezas
date: Jul. 21st, 2008 01:56 am (UTC)

i'm running a version of rpg web profiler which, though not perfect, is a pretty good online character sheet tracker, with export capabilities!

Reply | Thread