Okay, here's the basic scoop:
I'm not sure if anyone here has heard of horse "SIM games" but they are online games where people create virtual horses and stables, and train and show them, etc. Sounds corny, but actually, it is pretty awesome because it got me into programming and I have learned so much trying to make these websites and databases and now I'm a database administration major in college.
Unfortunately, I'm still in intro classes
This is where I need some help.
My newest project for my game is to create a member database/bank system. Everyone has virtual money and virtual checks are exchanged. Right now we are using a PHP database created by someone else to keep track of the money (seen at: http://www.hermesmarketing.com/chessie/bank/ ) but we would like to create a new database that can track money, like that database does, and can also track what virtual stable members keep their horses at, how many more virtual horses they can create, and what virtual tack they own. I am sure that DBman can do this, so I was wondering if anyone can help? Obviously the basic member database is very simple, but my problem comes when I try to think of a way to create "checks" that if a member submits a check, it automatically deducts money from their account and adds it to the recipient. So just to sum it up, the database should be able to:
I'm sorry if this seems silly, but actually this is a great learning experience for me, so any help would be SO appreciated
I'm not sure if anyone here has heard of horse "SIM games" but they are online games where people create virtual horses and stables, and train and show them, etc. Sounds corny, but actually, it is pretty awesome because it got me into programming and I have learned so much trying to make these websites and databases and now I'm a database administration major in college.
Unfortunately, I'm still in intro classes
This is where I need some help. My newest project for my game is to create a member database/bank system. Everyone has virtual money and virtual checks are exchanged. Right now we are using a PHP database created by someone else to keep track of the money (seen at: http://www.hermesmarketing.com/chessie/bank/ ) but we would like to create a new database that can track money, like that database does, and can also track what virtual stable members keep their horses at, how many more virtual horses they can create, and what virtual tack they own. I am sure that DBman can do this, so I was wondering if anyone can help? Obviously the basic member database is very simple, but my problem comes when I try to think of a way to create "checks" that if a member submits a check, it automatically deducts money from their account and adds it to the recipient. So just to sum it up, the database should be able to:
- Store member name, email, creation credits, member points, stable, inventory, and bank balance.
- Only allow admins to add new members and directly edit records, BUT
- Regular members can submit a separate form to either take away creation credits, add member points, change their stable, update their inventory, or send a check
- All of these should be separate links and separate forms
- They have to be approved by an admin before added
I'm sorry if this seems silly, but actually this is a great learning experience for me, so any help would be SO appreciated
A type of "check book"