Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: PHP and MySQL: Create-Modify-Reuse ISBN: 978-0-470-19242-9
This is the forum to discuss the Wrox book PHP and MySQL: Create-Modify-Reuse by Timothy Boronczyk, Martin E. Psinas; ISBN: 9780470192429
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: PHP and MySQL: Create-Modify-Reuse ISBN: 978-0-470-19242-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 8th, 2008, 11:39 AM
Registered User
 
Join Date: Nov 2008
Location: , , USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default some help designing my database

I got your book, I read part of it, and I liked it so much I bought a copy. I am going to use it as the basis of an online site/game I am making. The game is a turn based strategy game, played through a web-browser, probably using flash. Im not to the coding of the client yet, but Im trying to integrate as much as I can. When you go to the town square and post on the bulletin board, you are posting in the forum, etc.

 Right now, I'm setting up the login and forum system. Later, I will add more functionality and features. I'm taking a class on PHP/SQL at my college, but I am still pretty new at this.

I want to make sure I do things right, so I am trying to figure out the best way to setup my tables.

I need to discuss this with people, to better understand it.This is where I am so far:

fname, lname
username (unique)
password
B-day
email
referrer
IP
UserID (primary key)
location/timezone
avatar
faction
campaign

I also have units, which have several attributes, and each unit, though made from a template, can have customizations, like new skills, or items equipped. Not to mention the name. Each unit gets a randomly generated name.

There will be mini games, the first involves clicking on a map, and then getting an item based on that location, like a treasure hunt, but you only get one item per day.

I know I am going to need to add a little at a time, right now, I want to get the basics going, and registration and login system, and a forum. Chapters 1 and 2. I downloaded the source code, and I have read through it a couple times, still some things I don't get, but I think I'll be ok. It looks like most of what I need to do, is add columns to the SQL, and fields to the User class.

I was told by someone, that making a table for each user is a bad idea, Im not really sure why. I had thought that way, I could add a row for each unit they recruited, or item they found.

Basically, I have possibly thousands of users, I hope someday, each with numerous units, each unit just needs to be considered unique, and many items, and lots of other information. I also will have locations, each will be an isometric tile map to load in flash, and I will have data on many of those, as users can claim locations, and add fortifications, etc. I want to make sure I have everything planned out as best I can.

Big project, I have pretty much the rest of this year and most if not all of next year to work on this 20-40 hours per week. It wont be that hard if I just do it piece by loving piece. I need some help. I want to get the login system, and the forum by the end of November. So, I just want to make sure I setup the database right, so I don't end up making my users redo anything. Pointers, suggestions, information ?

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
web designing werstyle teen HTML Code Clinic 0 November 22nd, 2006 05:33 AM
database designing mukund SQL Server 2000 1 December 23rd, 2004 12:14 AM
help in designing a database rose77 SQL Server 2000 3 December 7th, 2004 12:38 PM
Database Designing Time Estimation mpradeep SQL Server 2000 3 February 26th, 2004 11:36 AM



All times are GMT -4. The time now is 09:05 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.