7 replies to this topic

[Paul]

i am looking into creating a text based game with a money system, bank system and a housing system for a nightclub / bar based game with missons and upgrades and wodering if anybody can point me in that direction shortly

[JoeyMagz]

I'll just give you some tips on how it should be done using php and a mysql database. The first thing you're going to need to do is create the database tables you're going to need.

Users Table:
id - The users id, this value will be the primary key. This is what is going to connect this table to the other tables in the database.
username - Obvious
password - Obvious
email - Obvious
money - The amount of money the person has.

Bank Table:
uid - The users id. primary key.
money - The amount of money they have in the bank.

House Table:
uid - The users id. primary key.
location - I don't know exactly how you're going to make the game but this could be anything from a town name to coordinates.
value - How much the house is worth. Can go up or down with items the user adds, etc.

Items Table:
id - The id of the store/bar/nightclub item. primary key.
name - The name of the item.
value - The price of the item.
description - A description of the item.

Now that you have all the tables set up, you can make your php scripts. Their are so many options you have here. Especially with the currency and bank systems. You can set up scripts that run on cron jobs that calculate interest on the money users have in the bank, etc. Although it's not really what you're looking for, there are tutorials on pixel2life that show you how to make text based fighting games. You can manipulate those scripts into you're own nightclub game. Hope that helps.

Also, you may find you need more tables or you need to change those tables. It's easy to do and those tables I showed you should make it easier.

Edited by JoeyMagz, 10 August 2008 - 08:20 PM.

[Goon2Goblin]

Having done this before, that is a great layout for getting started.

Just start with a signup/login system, if login is proper then they go to their house.
Then make a central point for the game with links to every place/building/aspect of the game such as settings/stripclub/bank/gym (if you want battles).

Then keep making more and more modules to the game.
IMO: If you get a basic system down for the game engine.. it'll be a breeze.

Good Luck.

[Paul]

this has helped me alot

thanks

[Goon2Goblin]

If you get stuck at all or have any questions about how you should approach a theory, just send me a message and I'll be more than happy to help.

Good luck; again.

[Paul]

cheers

[evertonian7uk]

not sure if this is still open but i have a game exactly like you described, i havent used it for years - its bug free and could be a great place for you to start from if you want to discuss it some more PM me.

basics are:

your a club owner, over the month you have to expand you empire hire girls / bouncers car valets etc....

the game works with crons for time and its quite good

[Paul]

yeah its still open