Game stats / accumulated wealth table?

I am new to web page design. I am using Microsoft Expression and I am having a lot of fun.

I would like to design an online game along the lines of Torncity and Magical Myth or Monocountry code. Those games are pointless because you have limited choices... the object is to build points through training and then fight and rob others... search for and steal money... educate yourself to have better stats for more job opportunities... but violence and thievery are the bread and butter to the game.

I would like to design a better plot...involving an island... mysteries...caves...forbidden Forrest and sacred burial grounds...aborigines... borrow from the BBC TV Series the prisoner... and Papillon... where people struggle to survive but learn about other customs, learn to improvise using plants, observe and learn from wild life life, discover artifacts from ancient cultures.

I need to learn how to develop the same type of structure of those games mentioned... allowing a person to sign in.. select a job... receive a daily salary... select a course and get stats -credits earned- ( which can be applied to their game IQ quota or stamina or health stat...which also opens up other parts of the game... and helps build defense stats...

in conflict way where two players do combat ... depending on their stats they can win or lose or draw... to receive stats from the outcome..

In a search on the island.. I'd like to set up a way that based on their level, again achieved by their stats, they have a higher or lower chance of discovering items - with values attached to those items, which can be used or sold- or else they encounter a problem or non event...

Markets sell and buy items...
Natural Disasters can occur and based on the individuals stats and living arrangement -hut or cave- they might lose health points or possessions...

Any advice you can give me I appreciate... any direction you can send me in... any features in asp.net or Microsoft expression web/studio or blend I can use please point the way?

I've never built a table before... I do have the moncountry game files... they in php. I'd like to write this island game in aspx. I can send you the mono files in zip so you can see what process I'd trying to borrow or mimic from that game...

Sincerely Naive, Thomas Michael McNulty
[2422 byte] By [Winfidel] at [2007-11-20 11:26:38]
# 1 Re: Game stats / accumulated wealth table?
You're pretty ambitious, going from barely having touched basic client web design (HTML, CSS, JavaScript) to a project that requires thousands of lines of custom-written code (C#, Visual Basic .NET.) I'd recommend you start with smaller projects until you can figure out how to start this project by yourself, because it's only then you'll be able to finish it.

If you still want to try it, you'll need to start with a database for holding the players of the game. This database can be either an Access database (.mdb file) or an SQL Server database. It can also be Oracle, MySQL or other non-Microsoft databases, but they are more difficult to set up together with a .NET application.

Then you need to create a table for holding players. Fields would include ID, Name and Password. Then you can start working on some prototype pages for info about the player and actions he/she can take. For example, a page for selecting a job would involve something such as a list where the player can click a job, and then you need your code to update a field (which you could name 'Job') in the Players table so that the game can remember which job the player has.

But even getting to this point will be a difficult task for someone like you who has not done anything else in this area of development.
andreasblixt at 2007-11-9 11:54:00 >