Parsing a text file

[kingnothing737]

Alright. The text file in question is an online game server's log file (log.log being the file, the game being Halo). It has information in it that I would like to be extracted and put in a table in a php file. It needs to be polled regularly (maybe every 30 minutes). Here is a piece of the log file:

2007-02-16 21:58:42    KILL    "¬ÞØøþ¬"    player 3    KILLED    "MastaSpoofa"    player 5
2007-02-16 21:58:43    CHAT    GLOBAL     [HIV]Cheefa    what map
2007-02-16 21:58:44    CHAT    GLOBAL     MastaSpoofa    LOL
2007-02-16 21:58:46    CHAT    GLOBAL     ¶®ïñ©eÒf¶wñ    lol on the gun
2007-02-16 21:58:52    CHAT    GLOBAL     MastaSpoofa    blood gulch
2007-02-16 21:58:53    CHAT    GLOBAL     MastaSpoofa    go
2007-02-16 21:59:00    CHAT    GLOBAL     MastaSpoofa    ice fields
2007-02-16 21:59:00    CHAT    GLOBAL     MastaSpoofa    go
2007-02-16 21:59:04    SCORE    CTF    player 4    "¬ÞØøþ¬"    team 0
2007-02-16 21:59:04    PCR_TEAM    Team 0    Score    3
2007-02-16 21:59:04    PCR_TEAM    Team 1    Score    0
2007-02-16 21:59:04    PCR_PLAYER    Place 1    Player 4 "¬ÞØøþ¬"    Team 0    Kills 6    Assists 1    Deaths 5    Score 2
2007-02-16 21:59:04    PCR_PLAYER    Place 2    Player 2 "pikachu"    Team 0    Kills 5    Assists 2    Deaths 4    Score 1
2007-02-16 21:59:04    PCR_PLAYER    Place 3    Player 6 "MastaSpoofa"    Team 1    Kills 6    Assists 0    Deaths 4    Score 0
2007-02-16 21:59:04    PCR_PLAYER    Place 4    Player 5 "[HIV]Cheefa"    Team 1    Kills 4    Assists 2    Deaths 3    Score 0
2007-02-16 21:59:04    PCR_PLAYER    Place 5    Player 3 "Isaac"    Team 0    Kills 3    Assists 2    Deaths 5    Score 0
2007-02-16 21:59:04    PCR_PLAYER    Place 6    Player 1 "¶®ïñ©eÒf¶wñ"    Team 1    Kills 2    Assists 3    Deaths 9    Score 0

The information I want to extract are in the lines with "PCR_TEAM" and "PCR_PLAYER," and I want all of the information in those lines which comes after the aforementioned strings to be displayed in tables in a php file (and maybe the date and time on the line, as well). They contain the scores for each team and each player at the end of every game. There are several instances of these in the log file, and I would like each instance to have its own table.

Here's an example of how I would like the information to be displayed in a table:

2007-02-16 
21:59:04
 
Place    Name        Team    Kills    Assists    Deaths    Score
 
1    ¬ÞØøþ¬        0    6    1    5    2
2    pikachu        0    5    2    4    1
3    MastaSpoofa    1    6    0    4    0
4    [HIV]Cheefa    1    4    2    3    0
5    Isaac        0    3    2    5    0
6    ¶®ïñ©eÒf¶wñ    1    2    3    9    0
------------------------------------------------------------------
    Team 0                        3
    Team 1                        0

Would someone be kind enough to write a php file which will do that? I know next to nothing about php, so the code for this would need to be complete (as opposed to being just a certain part of the file) for me to be able to utilize it.

[xwero]

Is there a way a line of the log can have properly seperated columns? now there are columns with five/four spaces in between and other with only one.

This will be needed to extract the data from every line.

[kingnothing737]

Is there a way a line of the log can have properly seperated columns? now there are columns with five/four spaces in between and other with only one.

This will be needed to extract the data from every line.

The deliminators used are tabs. I *think* that's what you're wanting to know.

[xwero]

The deliminators used are tabs. I *think* that's what you're wanting to know.

i'm at work now but i will try to provide you with some code you need this evening.

[kingnothing737]

i'm at work now but i will try to provide you with some code you need this evening.

Thanks, I appreciate it. :)

[xwero]

ok here we go :)

[PHP]
// fetches log files in an array per line
$lines = file('http://example.com/halo.log');
// two arrays to catch the things you need
$teams = array();
$players = array();
// fill the arrays
foreach($lines as $line){
if(preg_match('PCR_TEAM',$line)){ $teams[] = $line; }
if(preg_match('PCR_PLAYER',$line)){ $players[] = $line; }
}
[/PHP]

now whe have to get all the data out of the arrays

[PHP]
// get date from one of the arrays
$temp = $teams[0];
$temparr = split(' ',$temp);
$date = $temparr[0];
$time = $temparr[0];
// get teamdata out the team array
$teamnames = array();
$teamscore = array();
foreach($teams as $team){
$teamarr = split(' ',$team);
// this is a guess if the output isn't right adjust the numbers
$teamnames[] = $teamarr[3].' '.$teamarr[4];
$teamscore[] = $teamarr[6];
}
// get playerdata out of playes array
$playerplace = array();
$playername = array();
$playerteam = array();
$playerkills = array();
$playerassists = array();
$playerdeaths = array();
$playerscore = array();
foreach($players as $player){
$playerarr = split(' ',$player);
// this is a guess if the output isn't right adjust the numbers
$playerplace[] = $playerarr[4];
$playername[] = $playerarr[7];
$playerteam[] = $playerarr[9];
$playerkills[] = $playerarr[11];
$playerassists[] = $playerarr[13];
$playerdeaths[] = $playerarr[15];
$playerscore[] = $playerarr[17];
}
[/PHP]

and the final output

[PHP]
<p><?php echo $date; ?><br><?php echo $time; ?></p>
<table>
<tr><th>place</th><th>name</th><th>and so on</th></tr>
<?php
for($i = 0;$i<count($playerplace);$i++;){
echo '<tr><td>'.$playerplace[$i].'</td><td>'.$playername[$i].'</td><td>and so on</td></tr>';
}
for($i=0;$i<count(teamnames);$i++){
// change colspan if needed
echo '<tr><td colspan="4">'.$teamnames[$i].'</td><td>'.$teamscore.'</td></tr>';
}
?>
</table>

[/PHP]

[kingnothing737]

Thanks. I'm getting this error, though:

Warning: preg_match() [function.preg-match]: Delimiter must not be alphanumeric or backslash in <url> on line 17

Warning: preg_match() [function.preg-match]: Delimiter must not be alphanumeric or backslash in <url> on line 19

It keeps repeating that over and over.

[xwero]

Thanks. I'm getting this error, though:

Warning: preg_match() [function.preg-match]: Delimiter must not be alphanumeric or backslash in <url> on line 17

Warning: preg_match() [function.preg-match]: Delimiter must not be alphanumeric or backslash in <url> on line 19

It keeps repeating that over and over.

sorry about that

[PHP]
foreach($lines as $line){

if(preg_match('PCR_TEAM',$line)){ $teams[] = $line; }

if(preg_match('PCR_PLAYER',$line)){ $players[] = $line; }

}
[/PHP]

should be

[PHP]
foreach($lines as $line){

if(preg_match('/PCR_TEAM/',$line)){ $teams[] = $line; }

if(preg_match('/PCR_PLAYER/',$line)){ $players[] = $line; }

}
[/PHP]

[kingnothing737]

All it's outputting is this:

"place name and so on
Array"

:(

[xwero]

All it's outputting is this:

"place name and so on
Array"

:(

what does it output when you do

[PHP]
// after the first code block
print_r($teams);
// after the seccond code block
print_r($teamnames);
[/PHP]

[kingnothing737]

"Array ( ) Array ( )


place name and so on
Array"

[xwero]

have you got the right link to your file?

[kingnothing737]

have you got the right link to your file?

Yeah, it's right.

[xwero]

Yeah, it's right.

what gives

[PHP]print_r($lines);[/PHP]

as output?

[kingnothing737]

what gives

[PHP]print_r($lines);[/PHP]

as output?

Ok, that worked. It output the entire log file.

Edit: the line breaks are messed up, though.

[xwero]

Ok, that worked. It output the entire log file.

Edit: the line breaks are messed up, though.

Can i see the output so i can catch where it goes wrong.

[kingnothing737]

Can i see the output so i can catch where it goes wrong.

Copying and pasting it isn't working for some reason, so here's a pic of the top piece of it:

[xwero]

try this

[PHP]
foreach($lines as $line){
// this should give you two lines of output
if(preg_match('/PCR_TEAM/',$line)){ $teams[] = $line; echo $line; }

if(preg_match('/PCR_PLAYER/',$line)){ $players[] = $line; }

}
[/PHP]

[kingnothing737]

No luck. It just goes back to:

"place name and so on
Array"

[xwero]

No luck. It just goes back to:

"place name and so on
Array"

can i have the link to the file or to a log file just like that. i will check it later.

[kingnothing737]

can i have the link to the file or to a log file just like that. i will check it later.

php file: http://www.hivclan.org/tests/ (index.php)
log file: http://www.hivclan.org/tests/halo.log

[xwero]

What is the file format of of the log file? I tested it myself and i got strange characters? I checked it in my editor and i got UTF-16

http://xwerocode.110mb.com/halo.php

This is a test where i output the first 12 characters of each line. As you can see it's not 2007-02-17

I converted the log file to UTF-8 and i got this result after a few code changes

http://xwerocode.110mb.com/halo2.php

the code is

[PHP]
<html>
<head>
<title>log test</title>
</head>
<body>
<?php

// fetches log files in an array per line
// i used a converted log file
$lines = file('http://www.hivclan.org/tests/halo.log');


// two arrays to catch the things you need

$teams = array();

// fill the arrays

foreach($lines as $line){
if(preg_match('/PCR_TEAM/',$line)){ $teams[] = $line; }

}

// get teamdata out the team array

$teamnames = array();

$teamscore = array();

foreach($teams as $team){
$teamarr = split(chr(9),$team);
if(trim($teamarr[3]) == 'Score'){

$teamnames[] = $teamarr[2];

$teamscore[] = $teamarr[4];
}
}


?>

<table>

<tr><th>team</th><th>score</th></tr>

<?php

for($i=0;$i<count($teamnames);$i++){

// change colspan if needed

echo '<tr><td>'.$teamnames[$i].'</td><td>'.$teamscore[$i].'</td></tr>';

}

?>

</table>
</body>
</html>
[/PHP]

i noticed there are more than one tables to get generated from the log. this makes it a bit harder. more of a weekend job instead of a between the soup and potatoes job :)