| | |
Browser based game, database design
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Oct 2006
Posts: 164
Reputation:
Solved Threads: 3
Hey everyone. I am currently in the process of designing a browser based PHP game. I was wondering if anyone had some advice on the databse design. Currently I have 5 tables within one database. They are very basic, used for user monitoring i.e. user, active_users, banned_users, active_guests. THe other table I have is a "family" or clan database that lets people join groups of others in a sort of gang.
Now I'm kind of stuck. I would like to implement features like exploring the map, visiting stores, buying/selling, global market, attacking other players, and each player should have their own inventory. One other idea I have is for people to have their own territories where they can mine, farm, cut down wood, etc. Any acvice on how I should design this database would be more than apprecieated.
Now I'm kind of stuck. I would like to implement features like exploring the map, visiting stores, buying/selling, global market, attacking other players, and each player should have their own inventory. One other idea I have is for people to have their own territories where they can mine, farm, cut down wood, etc. Any acvice on how I should design this database would be more than apprecieated.
![]() |
Similar Threads
- Web game team wanted (Web Development Job Offers)
- Database Design feedback (absolute beginner here :) (Database Design)
- Help with contact/mailing list database design... (Database Design)
- Database design - subtypes and instances of an entity (Database Design)
- Database Design - Supertypes and Subtypes (Database Design)
- Creating a Coordiantion (Grid Based) System for a text-based game. (C)
- Database Design Advice (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: Storing if a user has viewed a post
- Next Thread: noob design help please
| Thread Tools | Search this Thread |





