ASP RPG

Hey, i was thinking of this and I was wondering if anyone here would like to help me with this....

I want to base the structure of of KOC(Kings of Chaos)
http://www.kingsofchaos.com

but here is what my idea came out so far,

Some code that will determine statistics: for the stuff, when peeps upgrade we will total their raw attack/defence/spy abilities and then add percentages accordingly...

ex: we will have a table in a database that will look like this:

Mmmm k.... I was thinking of the D_Weaps & O_weaps would be the thing for weapons... I will use the replace() thing to remove the , in the table, and then I will have the 1's and other numbers...

I dont know.
I need some input.

First thing, you'll be better off normalizing your database. Don't keep everything in one place. Put all weapons etc. in another table, then relate them to users (characters). That way users can have an infinite number of items, and you won't incur a performance penalty when you just want the name (or strength, or whatever) of a character.

Best thing, go back to an old AD&D character sheet and normalize that for a database. You'll have everything you need there. (Or a Palladium or Chaosium or Hero character sheet.)

Personally, I think the Hero system is the absolute best if you are going to program for it. It is super complex, and plays very slow in real life, but is far superior to other systems technically. The Palladium is the most playable though.

Also, the Hero system is so well structured that you almost don't even have to think about how to normalize it for a database. It's 90% done. Compared to Palladium or other systems... well... this forum is about ASP and geek stuff... perhaps I digress...