JalaVill
-
Posts
2 -
Joined
-
Last visited
Posts posted by JalaVill
-
-
Hello!
I am new in PHP, and need some help.
I have two files: day1.txt and day2.txt
Each file have 20-100+ lines, and every line include the following information: FINISHING_PLACE:PLAYER_NAME:PLAYER_COUNTRY:PLAYER_POINTS:PERCENT.
Example for day1.txt
202:Player3:Canada:566.35:0.047% 297:Player4:Canada:412.41:0.047% 318:Player1:Canada:366.39:0.047% 400:Player5:Canada:287.20:0.047% 403:Player2:Canada:154.43:0.047% ... etc
I receive similar file every day with the same data, but players position (finishing place) and player points are different. I want to combine all files, and make overall ranking. E.g. if PlayerX gets 200 points Day1. Then total he have 200 points. If next day he gets another 150 points, then his total points is 350 (200+150 = 350)
Why I need that? Its videogame, where lots of player, and need to make Canadian ranking. So, I made PHP array for Day1.txt, which looks like the following:Array ( [Player3] => Array ( [0] => 202 [1] => Player3 [2] => Canada [3] => 566.35 ) [Player4] => Array ( [0] => 297 [1] => Player4 [2] => Canada [3] => 412.41 ) ... etc. array for every player
So, my question is, how I can sum up specific player points from different days (files)? I need it because I want to make overall ranking. Actually players have real name, but to protect innocent and make easier sample, replaced names by Player1, Player2 etc.
Need to sum up arrays, if the same mainkey appear different files
in PHP Coding Help
Posted · Edited by JalaVill
Sorry for delayd reply, but your comment was very helpful, and now script is ready.
Again, thank you very much.
EDIT:
Just in case I add my code line, if someone have similar problem and find this thread through google.
$query = "SELECT player, country, SUM(points), COUNT(player) FROM YOUR_TABLE GROUP BY player ORDER BY SUM(points) DESC";