One time you have the good friend ID's in the video game you can do whichever you want with it. We applied it to show the checklist of your friend's large scores in Sheep Tycoon.
The video game normally requires the companion ID's from flashvars. When we want to get the higher scores, we pass the exact ID's to our PHP script that does all the database get the job done and then returns the information in XML kind for Flash to read.
Dealing with Substantial Scores
You can display the large scores within the sport or you can exhibit as a PHP web page. I will usually opt to do the latter due to the fact there are a lot less methods involved. PHP will get the info and exhibit the information although Flash has to simply call a PHP script to get the information and then display it. However, displaying the large scores as portion of the video game by itself is a far better practical experience.
The semi-challenging factors with large scores is how to document them and assign international ranks to just about every player. I've used time as a tie-breaker for scores that are identical. If you acquired the score initially, you will stay previously mentioned the individual who received the score 2nd. MySQL has been our database of alternative and you can use Buy BY with a lot more than a person subject so it would be: Order BY score, time.
In FlipCup Problem, each user has a global rank that is determined by their large score. This rank improvements as players get new high scores. Updating everyone's international rank just about every time another person managed to get a new substantial score didn't seem to be like a great thought.
To start with, to determine the world-wide rank, I figured out the quantity of rows that had a score greater than the score we are searching to get a new rank for. With that info, we'll know that the rank will be some thing lower than the row count. We then obtain all the scores that are the same as the score we are employing and then determine where by it fits in there. With these two pieces of information we can determine the right rank.
In buy to make positive the scores are appropriate when anyone goes to seem at the Scoreboard in FlipCup, we also update the ranks of all your pals when your rank changes. Worldwide ranks are also recalculated every single time you see the Scoreboard page. This will ensure that all the world-wide ranks will be right when another person is viewing it.
I am certain there are improved methods for deciding global ranks than this but, for FlipCup's functions, it operates good. The main goal was to make positive the pages loaded swiftly so the code had to do the function promptly.
Experiment
Video game progress on Facebook is still in infancy. I'm not conscious of quite a few web-sites focused to supplying information about video games and Facebook. The game titles themselves are even now rather primitive as most never seriously tap into the prospective of social networks. I believe that social networks are a strong device that can support spread new games and game suggestions.
The video game normally requires the companion ID's from flashvars. When we want to get the higher scores, we pass the exact ID's to our PHP script that does all the database get the job done and then returns the information in XML kind for Flash to read.
Dealing with Substantial Scores
You can display the large scores within the sport or you can exhibit as a PHP web page. I will usually opt to do the latter due to the fact there are a lot less methods involved. PHP will get the info and exhibit the information although Flash has to simply call a PHP script to get the information and then display it. However, displaying the large scores as portion of the video game by itself is a far better practical experience.
The semi-challenging factors with large scores is how to document them and assign international ranks to just about every player. I've used time as a tie-breaker for scores that are identical. If you acquired the score initially, you will stay previously mentioned the individual who received the score 2nd. MySQL has been our database of alternative and you can use Buy BY with a lot more than a person subject so it would be: Order BY score, time.
In FlipCup Problem, each user has a global rank that is determined by their large score. This rank improvements as players get new high scores. Updating everyone's international rank just about every time another person managed to get a new substantial score didn't seem to be like a great thought.
To start with, to determine the world-wide rank, I figured out the quantity of rows that had a score greater than the score we are searching to get a new rank for. With that info, we'll know that the rank will be some thing lower than the row count. We then obtain all the scores that are the same as the score we are employing and then determine where by it fits in there. With these two pieces of information we can determine the right rank.
In buy to make positive the scores are appropriate when anyone goes to seem at the Scoreboard in FlipCup, we also update the ranks of all your pals when your rank changes. Worldwide ranks are also recalculated every single time you see the Scoreboard page. This will ensure that all the world-wide ranks will be right when another person is viewing it.
I am certain there are improved methods for deciding global ranks than this but, for FlipCup's functions, it operates good. The main goal was to make positive the pages loaded swiftly so the code had to do the function promptly.
Experiment
Video game progress on Facebook is still in infancy. I'm not conscious of quite a few web-sites focused to supplying information about video games and Facebook. The game titles themselves are even now rather primitive as most never seriously tap into the prospective of social networks. I believe that social networks are a strong device that can support spread new games and game suggestions.