Classic ASP Discussion

Print Page | Close Window

ASP RPG

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5890
Printed Date: 30 March 2026 at 11:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP RPG

Posted By: genmud
Subject: ASP RPG
Date Posted: 22 September 2003 at 9:36am

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 - 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:

TBL_Items
ID	Name	Points	Type	Description
1	Sword	200	1	This is a medieval Sword, it is nicely crafted and has a had crafted grip.
2	Shield	150	2	This is a Defensive weapon that is mainly used when the user cannot find cover, this is the defenders last defence
3	Magic	215	3	This is a magic item, it hides your soldiers from the enemy.

TBL_Users
ID	Username	Password	Group_ID	E-Mail	D_Weaps	O_Weps	Items	Cash
1	genmud	password	1	genmud@cox.net	1,1,1	2,2		19097
2	genmud2	password	2	jim@blackproject.org	1,1,1	2,2,2	3	10983

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.

-------------
---A Sig :P---

Replies:

Posted By: genmud
Date Posted: 23 September 2003 at 12:07am

FINE! BE THAT WAY!

DONT HELP!

lol

-------------
---A Sig :P---

Posted By: Bluefrog
Date Posted: 23 September 2003 at 7:46am

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...

Posted By: genmud
Date Posted: 23 September 2003 at 9:45am

ic...

do you know where i coud get a D&D sheet or whatever... I never played D&D, so i dont really know.

where can i get the Hero Sheet?

I am planning on doing this on a SQL server, so I dont think im gonna have any problems until I get like 20 thousand characters... lol

I really want to do this though. I want to have an asp-based RPG for peeps to download. I was thinking of like making a good site for the actual RPG & then have a actual site for the code and stuff... I DONT KNOW! heh, also, what would you suggest I do to make the SP's? I mean, should I have the stats and ranks stored procedures? I know I am going to have the abalities and points in stored procedures.

-------------
---A Sig :P---

Posted By: Gullanian
Date Posted: 24 September 2003 at 10:46am

Even if it is on a SQL database normalisation is important for future improvements and developments, plus it should make coding the game a lot easier.