I am not sure if this question belongs here but I found this subforum to be the closest one to my question.
I am going to start a video games related website soon and the first thing I want to finalize is its file/folder and URL structure. The website will have different sections for each game with detailed info, each game section will have different homepages and different styles. And there will be a main homepage with its own style that gives general information and news about gaming world. Here is what I am thinking, please let me know if you think there is a better way to handle this or if you have any suggestions.
1. I don't want to create a subdomain for each game such as http://game1.mysite.com/. Instead of this, I want to create a subdirectory for each game such as http://www.mysite.com/game1/. Which one would you prefer and why?
2. I want to store all the content in the database but since each game will have different and extensive content, I decided to create one database for each game and categorize its content into tables. What do you think about having multiple databases?
3. Since each game section will have different layout and styles, I will put core files for each game into one folder "games" to better organize things:
/games/game1/ (files that belong to game 1)
/games/game2/ (files that belong to game 2)
4. When I use the above folder structure, my URLs will be like
However, I don't want them to be like this. I want the URLs to be
Is this possible with htaccess rewrites? Or else I will need to get rid of the "games" folder and put all game folders into the root.
This is the first time I will be creating a large-scale website hence I wanted to hear your opinion before I continue. Thanks for any ideas.