Mad Props!

Omniscience is just a Google-search away.
Welcome to Mad Props! Sign in | Join | Help
in Search

More Thoughts on the Online Database

Last post 09-22-2006 7:25 PM by Dream_Knight. 10 replies.
Page 1 of 1 (11 items)
Sort Posts: Previous Next
  • 09-21-2006 8:56 AM

    More Thoughts on the Online Database

    Just thought I'd share some thoughts and plans for our new online system.

    User Levels

    The first thing I've thought about implementing is "user levels". For example, a number from 0 to 100 representing your "authority" in Comicster's online database. Any new user would start at level 0, and yours truly would be level 100.

    Level 0 users would have the ability to submit new items, and edit anything that they submitted.

    If a level 0 user attempted to edit an item that had been submitted or edited by a level 1 user, it would not overwrite the details. Instead, an email would be fired off to the level 1 user letting them know that the changes have been requested. It would then be up to the level 1 user to make the changes.

    The same applies for any level. For example, if a level 17 user attempts to replace the details of an item last updated by a level 53 user, it would send an email instead of overwriting.

    This would solve a lot of problems with "good" data from a trusted source being overwritten with "bad" data from a new user. It doesn't, however, solve the "detail wars" we discussed in another thread where two people keep updating the same item ping-pong style.

    Solving the Detail Wars

    If user "bob" attempts to update an item that was last updated by another user of the same level, the item isn't updated. The same thing happens as if "bob" is a lower level - an email is sent to the other user.

    User Promotion

    This just leaves the question of how a user gets "promoted" to a higher level.

    I'm starting to think that this could be based on the amount of information you add to the database (that's add, not update). The level could go up by one every time you double the amount of data you've submitted. Like this:

    • 1 item submitted - level 0
    • 2 items - level 1
    • 4 items - level 2
    • 8 items - level 3
    • 16 items - level 4

    ... etc etc. That means you'd have to submit over a million items before you hit level 20, unless I arbitrarily bumped you up a level because I like you. Wink

    Friendly Names

    To ensure that no-one ever actually knows someone else's email address, I think I should implement "friendly names" in Comicster. So when you submit your email address to register as a new user, you would also have to submit a nickname (or even your real name). That way we'll have a way to publish the updater of an item without having to somehow obfuscate their email address.

    Your Thoughts?

    What do you guys think of this idea? Would we end up with a more trustworthy database? Would people get annoyed if they kept receiving email asking them to update an issue that they submitted?

    mabster
    Filed under:
  • 09-21-2006 9:49 AM In reply to

    Re: More Thoughts on the Online Database

    More thoughts and questions:

    Database Moderation

    What abilities would you want if you were given a special program to "moderate" (ie edit and delete) data in the online database? Let me list out the things I think are a no-brainer:

    • Update information in Publishers, Titles, Trades, Issues, Characters and Creators
    • Globally replace one character's appearances with another (to effectively isolate that character so you can delete them if they're a duplicate)
    • Likewise with creators and their jobs (crew members)
    • Delete information provided it's not used elsewhere. For example, it should be possible to delete an issue if it's only part of one title and not also collected in a trade. It should be possible to delete a character if they're not a cast-member in any issue. You get the idea.

    What about "locking" items so that they're read-only, if you're satisfied that the data is complete and accurate? It would still be possible to edit them using the moderation tool, but not from Comicster. Conversely, it should be possible to "unlock" an item if you think Comicster users should be able to change it again.

    What else would you like/need to be able to do?

    Forums

    Should we have a subforum dedicated to the online database? I can move the existing posts into it.

    mabster
    Filed under:
  • 09-21-2006 2:45 PM In reply to

    Re: More Thoughts on the Online Database

    Attached is a little teaser screenshot of the online moderation tool I've been working on.
    mabster
  • 09-21-2006 3:00 PM In reply to

    Re: More Thoughts on the Online Database

    VERY nice! I'm totally loving it. :)  Great work Mabs!

     
    Chung 

    The RPG Consortium - Forging a New Era in Roleplaying
  • 09-21-2006 3:12 PM In reply to

    Re: More Thoughts on the Online Database

    Dream_Knight:
    VERY nice! I'm totally loving it. :)  Great work Mabs!

    Thanks Chung!

    I'd be interested in hearing your (and everyone's) thoughts on the stuff I posted at the top of this thread. Do you agree? Disagree? What have I not thought of?

    mabster
  • 09-21-2006 8:28 PM In reply to

    Re: More Thoughts on the Online Database

    Behold the glory!!!

    Anyone want some duplicate characters deleted? Smile This, of course, is the new database and not the one that Comicster currently uses.

    Deleting a Character

    mabster
    Filed under:
  • 09-21-2006 9:56 PM In reply to

    • Venomous
    • Top 25 Contributor
    • Joined on 11-27-2005
    • Wesley Chapel, Florida
    • Posts 65

    Re: More Thoughts on the Online Database

    Surprise Holy crap, that's awesome! I like your idea of administrating entries too, though emails could get annoying. Forum would be nice to discuss issues and you could have the final say. I'm liking the changes A LOT!Yes
  • 09-21-2006 10:09 PM In reply to

    Re: More Thoughts on the Online Database

    Venomous:
    Surprise Holy crap, that's awesome! I like your idea of administrating entries too, though emails could get annoying. Forum would be nice to discuss issues and you could have the final say. I'm liking the changes A LOT!Yes

    Thanks Ven. I agree about the potential for email-bombardment ... particularly if someone wants an item updated and you're ignoring them 'coz you don't agree. Smile

    Anyway - I am preparing a beta version of Comicster for the weekend that will point to the new database. Once that's live, I'll get all the beta-testers to scrutinize the database and find duplicates etc. That'll be a good test of my moderation program (which I'll keep to myself for now, until I'm more confident that it works ok).

    The 'delete and replace with someone else' feature is rocking my world right now though. Wink

    mabster
  • 09-21-2006 11:23 PM In reply to

    • JohnP
    • Top 10 Contributor
      Male
    • Joined on 03-11-2005
    • TX
    • Posts 249

    Re: More Thoughts on the Online Database

    Will this pertain to issue titles too?

    Or is this just the character database at the moment?

    Looks good so far though. Have you thought about just using forum names for people/users of this new tool, or is it the option of the user? 

     

    On a slightly related note, any chance for a slight update for the character section in Comicster? I have 1800+ characters, if they could be put/sorted into folders of letters of the alphabet, that would make it _much_ easier to scroll up on that left side. Another option, if possible, would be to have a tab at the bottom next to 'search' for characters (and eventually creators).

    Heck, I would take a hot key for closing the character/creator folders. 

    My other vehicle is a police box.
  • 09-22-2006 6:45 AM In reply to

    Re: More Thoughts on the Online Database

    JohnP:
    Will this pertain to issue titles too?

    Or is this just the character database at the moment?

    Right now you can edit almost anything. You can't change the issue number (doesn't really make sense to do that), and I don't have a way yet to change the publisher for a title or trade. Other than that it's open season.

    JohnP:
    Looks good so far though. Have you thought about just using forum names for people/users of this new tool, or is it the option of the user?

    I'd prefer not to rely on Community Server's usernames for now. I think I'll add a box to Comicster so that when it asks you for an email address (to get your user key) it also asks for an optional friendly name.

    JohnP:
    Heck, I would take a hot key for closing the character/creator folders.

    Until I get folders for characters and creators in there (I want to), you can quickly close the folder by hitting left-arrow twice, provided you are currently sitting on a character or creator. Hope that helps!

    mabster
  • 09-22-2006 7:25 PM In reply to

    Re: More Thoughts on the Online Database

    mabster:

    Dream_Knight:
    VERY nice! I'm totally loving it. :)  Great work Mabs!

    Thanks Chung!

    I'd be interested in hearing your (and everyone's) thoughts on the stuff I posted at the top of this thread. Do you agree? Disagree? What have I not thought of?

    I don't have very much detailed thoughts about what you posted. :)  I just love the whole idea of bring some control into what's being submitted.  Everything sounds pretty damn good to me right now.

     
    Chung 

    The RPG Consortium - Forging a New Era in Roleplaying
Page 1 of 1 (11 items)
Powered by Community Server (Non-Commercial Edition), by Telligent Systems