competitive ladder system for games

[insei]

Hi.

 

I recently became obsessed with web developing, and ever since that, i have been following all kinds of tutorials about html, css, php, mysql and other web related stuff like CMS's like joomla wordpress and so on...

 

I choose to write on these forums in hope of guidelines. I dont expect anyone to do my work, but i would love some insight and suggestions from experienced developers about how to proceed and perhaps where to look for relevant tutorials. I am recently trying to develop a competitive ladder system for your typical videogame by using php and mysql.

 

This is what i got so far:

http://www.xgs-gaming.com/tlt/files/ladder_system/

 

 

I am aiming at a website which can

 

- list up the rankings from a database like this page here:

 

http://www.iccup.com/starcraft/ladder/1x1.html

 

- when i press on a player i will see his profile, something like this:

 

(i want to keep things simple, all i want here is to display the characters information: rank country, and a link for a matchlist from his game that have been played)

 

http://www.iccup.com/starcraft/gamingprofile/splog.html

 

- when someone presses the matchlist button a list of his previous matches comes up like this:

 

http://www.iccup.com/starcraft/matchlist/928387/1x1.html

 

- when players are logged in, they get options like:

 

* Report a win.

(From this he will be able to select one of the players in the database he just won against, and a notification will be sent to that player.

In order for the system to compute new points and ranks from functions i make, the other player will need to accept the loss first. )

 

Later i'd like to add features like:

 

* Linking users to groups.

(I'd like the users to get be able to select if they want to join a group or create an existing one)

 

My questions:

 

- How do i link tables togheter? I mean what would be the best way to store played matches? For example a table that consist of played matches linked to that spesific user. Would this require me to automaticly make an extra table each time a user gets created? So that when a player reports a win, the information would be stored there and a notification would be inserted in the other users table, the user that lost.

 

- In this link:

http://www.iccup.com/starcraft/gamingprofile/splog.html

When i press on one of the users, their profile shows up. And when i look at the url bar i can see that it ends with the users name.html. What does this mean? Are html files

getting created for each user? I dont understand this concept.

 

- My lack of experience just put a stop on my project after creating a membership system and displaying users from a database, i have created a couple of functions that

calculate win_ratio and calculate a rank from points and some other stuff. But i dont know where to start from here, i'd like to be able to log in and report a win, and i just

dont know how to do this, if i had some advice that would perhaps be of great help to me.

 

- icant seem to figure out the 2 errors i got from the w3c validation:

http://validator.w3.org/check?uri=http%3A%2F%2Fwww.xgs-gaming.com%2Ftlt%2Ffiles%2Fladder_system%2F&charset=%28detect+automatically%29&doctype=Inline&group=0&user-agent=W3C_Validator%2F1.654

 

I hope this is not too much to ask.

 

best of regards, alex

 

 

 

[ignace]

* Report a win.

(From this he will be able to select one of the players in the database he just won against, and a notification will be sent to that player.

In order for the system to compute new points and ranks from functions i make, the other player will need to accept the loss first. )

 

If your hoping on your player's being honest about this, think again. They will not accept losses (or atleast most of 'em won't).

 

- How do i link tables togheter? I mean what would be the best way to store played matches? For example a table that consist of played matches linked to that spesific user. Would this require me to automaticly make an extra table each time a user gets created? So that when a player reports a win, the information would be stored there and a notification would be inserted in the other users table, the user that lost.

 

You can link tables together with constraints (http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html). You would create a new record (row) for each new player (not an entire table).

 

- In this link:

http://www.iccup.com/starcraft/gamingprofile/splog.html

When i press on one of the users, their profile shows up. And when i look at the url bar i can see that it ends with the users name.html. What does this mean? Are html files

getting created for each user? I dont understand this concept.

 

This is done through .htaccess and mod_rewrite

 

- My lack of experience just put a stop on my project after creating a membership system and displaying users from a database, i have created a couple of functions that

calculate win_ratio and calculate a rank from points and some other stuff. But i dont know where to start from here, i'd like to be able to log in and report a win, and i just

dont know how to do this, if i had some advice that would perhaps be of great help to me.

 

Take a look at session_start and sessions in general http://php.net/manual/en/features.sessions.php

 

- icant seem to figure out the 2 errors i got from the w3c validation:

http://validator.w3.org/check?uri=http%3A%2F%2Fwww.xgs-gaming.com%2Ftlt%2Ffiles%2Fladder_system%2F&charset=%28detect+automatically%29&doctype=Inline&group=0&user-agent=W3C_Validator%2F1.654

 

Remove the p out of the h2

[insei]

Thanks, this was of great help. Btw players will be able to send a complaint if ppl dont accept after a number of complaints they might get banned and so on. ill figure out those things later^^ thanks alot for advice apriciate it

[ignace]

Btw players will be able to send a complaint if ppl dont accept

 

So I can just send a complaint about a few players that they didn't accept there loss altough I never played against them? And who are you going to believe? It's his word against mine?!?