competitive ladder system for games
Posted: Tue Jan 12, 2010 10:50 pm
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
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