PHP/MySQL Database for a game

MatttWithOneT

I'm creating a game and of course I'm going to have a database to store all of the character/user info. What I'm asking is advice or just a "DO THIS" for how to let people access stuff.

I have no clue what I should do once people submit all they're info, how to make it so that they can only access their table and stuff. I have my own server and webspace and stuff and it came with a database, so I'm guessing I just use multiple tables for all of this. I know, I'm new, I'm rushing it, but how else am I supposed to learn quick 😃 .

cschotch

What kind of game is it?....is it multiplayer on line game through your website or something like Medal of honor and its a clan you have that you want to host on your website????

MatttWithOneT

It's NOT for a clan, :-P.. sorry, LOL... I'm making an actual game. It's a text-based RPG/Fighting game online where you can choose from 7 different races, multiple abilities etc... Then you're character is created and you can challenge other players in chat rooms to fights where your moves are determined by "dice" (random num generator) whether it be 2d15, or whatever.. I'm also going to be making an engine so you can rummage around in "caves" and "forests" and fight the computer to help gain experience and level up and stuff...

I'm not sure about the user/pass thing cause I'm new to PHP/MySQL, but I've done this before with C++ and networking, so I know what I'm doing 😉

planetsim

Nice to know you have some idea at one thing.
well PHP should be farily easy to learn for you if you've had experince with C++

the basics of a user login script which is password protected.

-password should be encrypted
-password and username a specific length. (Try 12max for username and must be no larger or less then 8 for password)

once thats out of the way. You need to get people to register
so they register username and password

you process it.
encrypt the password and then check if the username is not existant if it is. Send them back and tell them there error. Try to keep the users information there. As it makes there life easier.

Then if they have registered and its ok. Insert the information to the database.

After that they may wanna login.
So we gotta do a login form

when the user submits the form
You must check the username and password
but before you do
encrypt the password
then check username and password against the database.
if theres a match there in
if not direct them to login with error.

For this i suggest reading on

Mysql
-Insert
-Select

PHP
-if else
-md5

MatttWithOneT

I don't mean to seem not generous, but I pretty much knew all of that. I understand I should have said what I knew. What I'm confused about:

The password is encrypted.. What? Is it encrypted in the table I insert the information into? How do I encrypt? What is it?

Do I stick into a table and say like,

$user = "Select * from users where name = '$name'";
mysql_query($user);

$pass = blah blah blah...

if(($user == $name) && ($pass = $password))
// let them in or whatever?

is that the general idea?

sigh I rush myself with these things, but I really want to start doing this, and I have to know everything before I can really start.

Just so you know, I only have one database. I don't know why, but I'm new at the site administrator stuff, and I guess that's all anyone has. I don't know. But it does say that's all I'm allowed.

planetsim

I told you somethings to look up. md5 was one of those.
Im not gonna give you the code. Its not extremely hard.

Ryan_Sanders

md5("julian");

that encrypts julian so no one would be able to tell what the password was.. it would like like 0sf0sd78s9d7fsf or something.

MatttWithOneT

thanks planet! i totally overlooked that, hehe.. md5, modify.. LOL.. how clever. I got one question, is there something that converts a md5ied string back to the original string? If not, that's ok, cause I finally got this figured out! hehe thanks a lot