competitive ladder system for games

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
insei
Forum Newbie
Posts: 5
Joined: Mon Jan 11, 2010 9:57 pm

competitive ladder system for games

Post by 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/matchlis ... 7/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% ... or%2F1.654

I hope this is not too much to ask.

best of regards, alex
Post Reply