[SOLVED] top players from text file

clown[NOR] · January 27, 2008

well ive sorted the read file thing... now i'm facing a new problem and i have no idea at all how to make this work...

this is how the file looks

[2008-01-21 18:03:27] dsr.gnawler killed happyrecall with P90 Silencer Zone:Torso lower Damage:30
[2008-01-21 18:04:47] volatile: driv killed Le Con with Grenade Zone:unkown Damage:152

[2008-01-21 18:04:47] Deadly*DEA killed Le Con with unkown Zone:unkown Damage:180

[2008-01-21 18:04:47] volatile: louie killed Le Con with unkown Zone:unkown Damage:140

[2008-01-21 18:04:55] KolBen_J0cHen killed ApHeX with Grenade Zone:unkown Damage:140

[2008-01-21 18:04:59] Drow killed 3at*DEA with unkown Zone:left legg upper Damage:23

[2008-01-21 18:05:03] InCorpZ|WixXxeR killed Le Con with P90 red dot Zone:left hand Damage:42

[2008-01-21 18:05:19] DeS killed 3at*DEA with Grenade Zone:unkown Damage:150

[2008-01-21 18:05:20] hakkele killed volatile: louie with Grenade Zone:unkown Damage:273

[2008-01-21 18:05:24] volatile: louie killed AntraX with unkown Zone:Headshoot Damage:64

[2008-01-21 18:05:27] happyrecall killed KolBen_J0cHen with m16 Red dot Zone:Torso lower Damage:50

[2008-01-21 18:05:29] volatile: driv killed 3at*DEA with unkown Zone:Torso lower Damage:42

[2008-01-21 18:05:30] KolBen_J0cHen killed 3at*DEA with unkown Zone:Right hand lower Damage:42

[2008-01-21 18:05:31] Deadly*DEA killed AntraX with unkown Zone:Right hand upper Damage:42

[2008-01-21 18:05:32] dsr.darkangel killed Al7 with Grenade Zone:unkown Damage:189

[2008-01-21 18:05:32] Le Con killed Al7 with Grenade Zone:unkown Damage:115

[2008-01-21 18:05:35] InCorpZ|WixXxeR killed 3at*DEA with unkown Zone:Torso lower Damage:42

[2008-01-21 18:05:35] Al7 killed Le Con with unkown Zone:unkown Damage:153

[2008-01-21 18:05:47] AntraX killed no|quixotic* with m4 Red dot Zone:Torso upper Damage:30

[2008-01-21 18:06:11] no|quixotic* killed ApHeX with ak47 Zone:Torso upper Damage:56

[2008-01-21 18:06:49] dsr.gnawler killed Drow with ak47 Red dot Zone:Torso lower Damage:56

[2008-01-21 18:06:52] ApHeX killed Drow with ak47 Red dot Zone:right leg upper Damage:56

[2008-01-21 18:07:22] Drow killed 3at*DEA with unkown Zone:right leg upper Damage:33

[2008-01-21 18:07:37] Al7 killed hakkele with m16 Red dot Zone:right foot Damage:42

[2008-01-21 18:07:40] KolBen_J0cHen killed 3at*DEA with unkown Zone:unkown Damage:142

[2008-01-21 18:07:40] Deadly*DEA killed 3at*DEA with unkown Zone:unkown Damage:130

[2008-01-21 18:07:43] happyrecall killed volatile: louie with m40a3 Zone:Torso upper Damage:107

now what i'm trying to do is to sort out who has most kills the last hour, and sort it from highest to lowest. any one who can guide me in the right direction?

The file is atm about 2.5MB

Thanks In Advance

- Clown

PHP Monkeh · January 27, 2008

Are you going through the file line-by-line or is it all in a single string?

clown[NOR] · January 27, 2008

well atm im going line by line.. but if can go trough it in one string that would be way better =) but the way u see it in the quote that's the way it is in the file.. so prob i got to do it line by line..

resago · January 27, 2008

read line by line, or into an array by line, either way.

{

preg_match('/ (\w+) killed/',$line,$match);

$person=$match[1];

$score["$person"]++;

}

sort ($score);

you will get undefined offset notices, but we are expecting that in this case.

clown[NOR] · January 27, 2008

this code

<?php

$filename = "http://ts.1337gamer.no:28950/cod-server-1/Kills.txt";
$text = file($filename);

foreach ($text as $line) {
preg_match('/ (\w+) killed/',$line,$match);
$person=$match[1];
$score[$person]++;
}

echo sort ($score);

?>

gave me this result

1

resago · January 27, 2008

that would.

clown[NOR] · January 27, 2008

hehe oh ok =)

resago · January 27, 2008

oh, i left out the hour thing. sorry.

clown[NOR] · January 27, 2008

no problem... im not focusing on that part yet =) but i just cant get your code to work as i want... cuz 1 is not the answer i wanted =) hehehe... i want to get the total kills for each person

resago · January 27, 2008

do a

print_r ($score);

clown[NOR] · January 27, 2008

thank you so much for the help resago.. all fixed now.. you just helped me shorten my script down about 20 lines =) and also it's WAY faster now

resago · January 27, 2008

NP

do a

foreach ($score as $key => $value)

echo "$key has $value kills";

to extract the names.

clown[NOR] · January 27, 2008

yeah that one i knew... but looks like something aint right after all... cuz i just took a closer look and there's names missing

resago · January 27, 2008

its in the match statement, you may have to tweak it.

clown[NOR] · January 27, 2008

well i have absolutely no knowledge about regex at all =( been trying to learn it, but i just cant figure out what's going where

resago · January 27, 2008

what is a name that is missing? does it have stupid characters in it?

resago · January 27, 2008

try changing

(\w+) to (.+)

clown[NOR] · January 27, 2008

by doing that.. the the timestamp showed to, so it wasnt able to match anything... so every line showed... not only the nick and number of kills..

except for 1 guy.. and everyone showed with 1 kill =) prob cuz it couldnt match =) here's the complete list

23:21:46] PRoji has 1 kills.
23:21:55] berserker727 has 1 kills.
23:22:13] NIRVANA has 1 kills.
23:22:14] MrMack has 1 kills.
23:22:14] BF_WARRIOR has 1 kills.
23:22:21] Jyrki has 1 kills.
23:22:24] [1337]Rapperen has 1 kills.
23:22:24] berserker727 has 1 kills.
23:22:33] [1337]mentaL has 1 kills.
23:22:39] maukka has 1 kills.
23:22:41] |SLS&Co|'''Pire has 1 kills.
23:22:59] berserker727 has 1 kills.
23:23:06] maukka has 1 kills.
23:23:09] NIRVANA has 1 kills.
23:23:12] [-Z-] has 1 kills.
23:23:13] SatyR has 1 kills.
23:23:15] Alyna has 1 kills.
23:23:21] [1337]Rapperen has 1 kills.
23:23:22] (1337) -Optima- has 1 kills.
23:23:52] |SLS&Co|'''Pire has 1 kills.
23:24:19] PRoji has 1 kills.
23:24:24] Jyrki has 1 kills.
23:24:40] dsr.encke has 1 kills.
23:25:16] [1337]Crazy has 1 kills.
23:25:34] [1337]mentaL has 1 kills.
23:25:36] maukka has 1 kills.
23:25:43] Jyrki has 1 kills.
23:25:43] Alyna has 1 kills.
23:25:43] BF_WARRIOR has 1 kills.
23:25:47] [-Z-] has 1 kills.
23:25:51] lizard- has 1 kills.
23:25:53] SatyR has 1 kills.
23:25:57] (1337) -Optima- has 1 kills.
23:26:24] PRoji has 1 kills.
23:27:02] [1337]Crazy has 1 kills.
23:27:18] maukka has 1 kills.
23:27:18] (1337) -Optima- has 1 kills.
23:27:19] [1337]Rapperen has 1 kills.
23:27:19] Jyrki has 1 kills.
23:27:46] berserker727 has 1 kills.
23:27:51] |SLS&Co|'''Pire has 1 kills.
23:27:57] lizard- has 1 kills.
23:28:10] [-Z-] has 1 kills.
23:28:12] PRoji has 1 kills.
23:28:36] NIRVANA has 1 kills.
23:28:43] Nixn has 1 kills.
23:28:52] [1337]mentaL has 1 kills.
23:29:16] berserker727 has 1 kills.
23:29:17] (1337) -Optima- has 1 kills.
23:29:17] PRoji has 1 kills.
23:29:18] BF_WARRIOR has 1 kills.
23:29:30] [1337]Maximus has 1 kills.
23:29:36] [1337]mentaL has 1 kills.
23:29:36] [1337]Rapperen has 1 kills.
23:29:43] |SLS&Co|'''Pire has 1 kills.
23:29:49] lizard- has 1 kills.
23:30:09] NIRVANA has 1 kills.
23:30:17] [-Z-] has 1 kills.
23:30:34] Jyrki has 1 kills.
23:30:39] Nixn has 1 kills.
23:32:19] PRoji has 1 kills.
23:32:31] SatyR has 1 kills.
23:32:33] [-Z-] has 1 kills.
23:32:37] maukka has 1 kills.
23:32:43] lizard- has 1 kills.
23:32:54] [1337]Maximus has 1 kills.
23:32:58] Jyrki has 1 kills.
23:33:00] (1337) -Optima- has 1 kills.
23:33:34] [1337]Maximus has 1 kills.
23:33:41] [1337]Rapperen has 1 kills.
23:33:41] PRoji has 1 kills.
23:33:59] (1337) -Optima- has 1 kills.
23:34:06] Sniblu has 1 kills.
23:34:15] [1337]mentaL has 1 kills.
23:34:16] lizard- has 1 kills.
23:34:17] Nixn has 1 kills.
23:34:32] Sigh has 1 kills.
23:34:44] NIRVANA has 1 kills.
23:34:50] Jyrki has 1 kills.
23:34:54] jesus has 1 kills.
23:35:08] NIRVANA has 1 kills.
23:35:16] Sniblu has 1 kills.
23:35:25] [1337]Rapperen has 1 kills.
23:35:41] [1337]Maximus has 1 kills.
23:35:47] Jyrki has 1 kills.
23:35:59] [1337]mentaL has 1 kills.
23:36:01] lizard- has 1 kills.
23:36:15] [-Z-] has 1 kills.
23:36:16] Sigh has 1 kills.
23:36:20] jesus has 1 kills.
23:36:28] (1337) -Optima- has 1 kills.
23:36:57] lizard- has 1 kills.
23:37:07] Jyrki has 1 kills.
23:37:07] maukka has 1 kills.
23:37:10] PRoji has 1 kills.
23:37:16] Nixn has 1 kills.
23:37:30] [1337]Maximus has 1 kills.
23:37:39] jesus has 1 kills.
23:37:51] NIRVANA has 1 kills.
23:37:52] Sigh has 1 kills.
23:38:02] SatyR has 1 kills.
23:38:05] [1337]mentaL has 1 kills.
23:38:30] [1337]Rapperen has 1 kills.
23:38:42] Jyrki has 1 kills.
23:38:43] PRoji has 1 kills.
23:38:49] lizard- has 1 kills.
23:38:58] [-Z-] has 1 kills.
23:39:04] (1337) -Optima- has 1 kills.
23:39:18] Sigh has 1 kills.
23:39:23] SatyR has 1 kills.
23:39:52] maukka has 1 kills.
23:40:05] [-Z-] has 1 kills.
23:40:23] -{FsA}-Sadm0on has 1 kills.
23:40:32] PRoji has 1 kills.
23:40:39] [1337]Maximus has 1 kills.
23:40:40] NIRVANA has 1 kills.
23:40:49] Sigh has 1 kills.
23:40:55] lizard- has 1 kills.
23:41:05] Nixn has 1 kills.
23:41:57] [1337]mentaL has 1 kills.
23:42:15] [1337]Maximus has 1 kills.
23:42:16] -{FsA}-Sadm0on has 1 kills.
23:42:32] [1337]mentaL has 1 kills.
23:42:43] GratoQ has 1 kills.
23:42:46] lizard- has 1 kills.
23:42:48] NIRVANA has 1 kills.
23:42:49] Nixn has 1 kills.
23:42:52] (1337) -Optima- has 1 kills.
23:42:59] [-Z-] has 1 kills.
23:43:22] PRoji has 1 kills.
23:43:31] SatyR has 1 kills.
23:43:39] Sigh has 1 kills.
23:43:53] maukka has 1 kills.
23:44:01] lizard- has 1 kills.
23:44:23] [1337]mentaL has 1 kills.
23:44:28] [1337]Maximus has 1 kills.
23:44:31] GratoQ has 1 kills.
23:44:38] Nixn has 1 kills.
23:44:50] PRoji has 1 kills.
23:45:09] Sigh has 1 kills.
23:45:50] (1337) -Optima- has 1 kills.
23:45:53] PRoji has 1 kills.
23:45:59] [1337]mentaL has 1 kills.
23:46:09] SatyR has 1 kills.
23:46:19] [-Z-] has 1 kills.
23:46:19] lizard- has 1 kills.
23:46:28] Sigh has 1 kills.
23:46:29] Nixn has 1 kills.
23:47:08] GratoQ has 1 kills.
23:47:28] [1337]Maximus has 1 kills.
23:47:42] -{FsA}-Sadm0on has 1 kills.
23:47:50] [1337]Maximus has 1 kills.
23:47:52] SatyR has 1 kills.
23:47:55] GratoQ has 1 kills.
23:47:56] [1337]mentaL has 1 kills.
23:48:07] oxfile mariachi has 1 kills.
23:48:21] lizard- has 1 kills.
23:48:46] (1337) -Optima- has 1 kills.
23:48:51] [1337]Rapperen has 1 kills.
23:49:06] PRoji has 1 kills.
23:49:11] Nixn has 1 kills.
23:49:13] [-Z-] has 1 kills.
23:49:35] PRoji has 1 kills.
23:49:41] [-Z-] has 1 kills.
23:49:48] SatyR has 1 kills.
23:49:55] [1337]mentaL has 1 kills.
23:50:10] Sigh has 1 kills.
23:50:34] (1337) -Optima- has 1 kills.
23:50:36] oxfile mariachi has 1 kills.
23:51:09] (1337) -Optima- has 1 kills.
23:51:12] tribe|zwrk has 1 kills.
23:51:18] oxfile mariachi has 1 kills.
23:51:20] Sigh has 1 kills.
23:51:22] -{FsA}-Sadm0on has 1 kills.
23:52:49] tribe|zwrk has 1 kills.
23:53:07] (1337) -Optima- has 1 kills.
23:53:10] PRoji has 1 kills.
23:53:26] [-Z-] has 1 kills.
23:53:51] PRoji has 1 kills.
23:53:53] (1337) -Optima- has 1 kills.
23:53:59] tribe|zwrk has 1 kills.
23:54:13] tribe|DuFFy has 1 kills.
23:54:31] [-Z-] has 1 kills.
23:54:57] tribe|zwrk has 1 kills.
23:54:57] (1337) -Optima- has 1 kills.
23:55:04] [1337]Rapperen has 1 kills.
23:55:05] tribe|DuFFy has 1 kills.
23:55:14] lizard- has 1 kills.
23:55:34] [1337]Rapperen has 1 kills.
23:55:39] (1337) -Optima- has 1 kills.
23:55:48] tribe|zwrk has 1 kills.
23:55:54] lizard- has 1 kills.
23:56:22] lizard- has 1 kills.
23:56:25] [-Z-] has 1 kills.
23:56:38] [1337]Rapperen has 1 kills.
23:56:44] PRoji has 1 kills.
23:57:32] tribe|DuFFy has 1 kills.
23:57:35] (1337) -Optima- has 1 kills.
23:58:01] PRoji has 1 kills.
23:58:02] [1337]Rapperen has 1 kills.
23:58:23] berserker727 has 1 kills.
23:58:30] [-Z-] has 1 kills.
23:58:35] tribe|zwrk has 1 kills.
23:58:39] tribe|DuFFy has 1 kills.
23:59:18] (1337) -Optima- has 1 kills.
23:59:19] [1337]Rapperen has 1 kills.
23:59:36] [-Z-] has 1 kills.
23:59:43] PRoji has 1 kills.
23:59:57] tribe|zwrk has 1 kills.
lizard- has 1 kills.
00:00:30] Falckenberg has 1 kills.
00:01:11] PRoji has 1 kills.
00:01:21] tribe|DuFFy has 1 kills.
00:01:34] (1337) -Optima- has 1 kills.
00:01:37] [-Z-] has 1 kills.
00:01:38] tribe|zwrk has 1 kills.
00:02:16] berserker727 has 1 kills.
00:02:55] lizard- has 1 kills.
00:03:08] [-Z-] has 1 kills.
00:03:33] (1337) -Optima- has 1 kills.
00:03:46] [1337]Rapperen has 1 kills.
00:04:07] [JDG]Brunnen-G has 1 kills.
00:04:14] berserker727 has 1 kills.
00:04:19] (1337) -Optima- has 1 kills.
00:04:20] [1337]Rapperen has 1 kills.
00:04:29] [-Z-] has 1 kills.
00:04:33] tribe|DuFFy has 1 kills.
00:04:40] lizard- has 1 kills.
00:05:36] Falckenberg has 1 kills.
00:06:04] lizard- has 1 kills.
00:06:05] (1337) -Optima- has 1 kills.
00:06:43] Falckenberg has 1 kills.
00:06:48] [1337]Rapperen has 1 kills.
00:07:13] (1337) -Optima- has 1 kills.
00:07:17] lizard- has 1 kills.
00:07:44] [1337]Rapperen has 1 kills.
00:07:49] Falckenberg has 1 kills.

resago · January 27, 2008

preg_match('/\] (.+) killed/',$line,$match);

I don't remember if I am suppose to escape ] or not, so I am.

clown[NOR] · January 27, 2008

that looks better... cant see anyone missing there now =) thanks... now for the final question ... i hope =)

how can i sort it from highest to lowest kills? tried to add the sort($score) but it replaced all the names with 1,2,3,4,5,6 etc

this is how it looks now:

PRoji has 21 kills.
berserker727 has 8 kills.

NIRVANA has 9 kills.

MrMack has 1 kills.

BF_WARRIOR has 3 kills.

Jyrki has 10 kills.

[1337]Rapperen has 17 kills.

[1337]mentaL has 13 kills.

maukka has 8 kills.

|SLS&Co|'''Pire has 4 kills.

[-Z-] has 20 kills.

SatyR has 9 kills.

Alyna has 2 kills.

(1337) -Optima- has 24 kills.

dsr.encke has 1 kills.

[1337]Crazy has 2 kills.

lizard- has 21 kills.

Nixn has 9 kills.

[1337]Maximus has 10 kills.

Sniblu has 2 kills.

Sigh has 10 kills.

jesus has 3 kills.

-{FsA}-Sadm0on has 4 kills.

GratoQ has 4 kills.

oxfile mariachi has 3 kills.

tribe|zwrk has 8 kills.

tribe|DuFFy has 6 kills.

Falckenberg has 4 kills.

[JDG]Brunnen-G has 1 kills.

resago · January 27, 2008

do asort

clown[NOR] · January 27, 2008

omg i'm so sorry for all the question... feel like a bitchy girlfriend =) it sorted from lowest to highest .. i need the highest on top

resago · January 28, 2008

I'm married, I'm used to it

use arsort

clown[NOR] · January 28, 2008

hahaha... yeah im engaged... =) know what i'm talking about hehe

clown[NOR] · January 28, 2008

PERFECT! my hat is off and i bow for you and your patiente... it's solved!

Sign In

[SOLVED] top players from text file

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information