Very tough question-

[phphelp]

Hi all, I just wanted to get some info from the expert's on how I should go about doing this script. What im looking to do is have the ftp script connect to a ftp host which contains many .log files. From there, each log file contains information I would like put in the db. The question is not really how to insert it into the db but more along the lines of how to seperate the information from the log file.

for example..

TOST: TOST TOP3 Support: Latest client version is 113
Warning: Failed to load 'NULL': Can't resolve package name
Warning: Failed to load 'Class None.': Can't resolve package name
ScriptLog: s_Player::FixMapProblems() GetURLMap(): TO-BLISTER.UNR
ScriptLog: s_Player::FixMapProblems() Retrieved mapname: TO-BLISTER.UNR
Log: Possessed PlayerPawn: TOSTPlayer TO-Blister.TOSTPlayer0
ScriptLog: Login info: Player
TOST: TOST Protect: PlayerName- client has logged in - 2.2 - IP IP:PORT

Strip everthing but

TOST: TOST Protect: PlayerName- client has logged in - 2.2 - IP IP😛ORT

I know this is a tough one. I hope someone can answer me.

[LordShryku]

Well, you need to be more specific. Will this line always be the same? Will some of it change? If so, are there any specific keywords that will narrow down the search? Maybe this is always on the same line?

[phphelp]

sry, I was going to add that but though maybe I wouldnt need to.

It wont remain on the same line, charector posistion.

TOST: TOST Protect: PlayerName- client has logged in - 2.2 - IP IP😛ORT

If someway I could keep only lines that begin with TOST: TOST Protect: Cut out the excess.

[goldbug]

Filter the lines of the a regular expression match loop.

[phphelp]

Originally posted by goldbug
Filter the lines of the a regular expression match loop.

I dont know how to. Thats why I was asking :/

[sidney]

simple sub str comparison

  <?php
$file="TOST: TOST TOP3 Support: Latest client version is 113
Warning: Failed to load 'NULL': Can't resolve package name
Warning: Failed to load 'Class None.': Can't resolve package name
ScriptLog: s_Player::FixMapProblems() GetURLMap(): TO-BLISTER.UNR
ScriptLog: s_Player::FixMapProblems() Retrieved mapname: TO-BLISTER.UNR
Log: Possessed PlayerPawn: TOSTPlayer TO-Blister.TOSTPlayer0
ScriptLog: Login info: Player
TOST: TOST Protect: PlayerName- client has logged in - 2.2 - IP IP:PORT";
$line=explode("\n",$file);
foreach($line as $val)
	{
	if(substr_count($val,"TOST: TOST Protect:")==1)
		{
		echo "can insert into sql here line is - ".$val;
		}
	}
?> 

[phphelp]

Thanks Sid, Appriciate the help. Sorry for long reply but been afk.

The method did not work right since I cant specify what $file= becasue it will change every .log.

This is what I have so far. Again.. its not working. Just a blank page.

$ftp = ftp_connect("domain") or die ("could not open ftp");
ftp_login($ftp, "user", "pass") or die ("could not open with user/pass");
$filelist = ftp_nlist($ftp, "/Logs")or die ("could not open dir");


$handle = (opendir('./Logs')) or die ("could not open logs dir");

	while  ($filename = readdir($handle)) 
	{


		if ( stristr($filename, ".log") )
		{




$logcontent = fopen($filename, 'r');



foreach ( $logcontent as $line ) 
{ 
    $words = explode (" ", $line); 
    if ( $words[2] . $words[3] == "loggedin" ) 

$nickname= $words[1]; 
$ip = $words[6];     
echo "Nick = $nickname :: Ip = $ip<br />"; 
} 
}
}

I have also attatched a simple .txt file of the .log. I just basically need the name and ip's from each log file.

Thanks again guys.

[sidney]

hope this helps

$logcontent = file("$filename"); // may need to add folder to

foreach ( $logcontent as $line )  

{ 
if( substr_count ( $line, "l o g g e d   i n   f r o m   I P")==1)
	{
    $words = explode (":", $line);
	$bits = explode ("l o g g e d   i n   f r o m   I P", trim($words[1]));  

    $nickname= trim($bits[0]);  //this still leaves spaces in names and ip may want to str_replace
    $ip = trim(end($bits));      

    echo "Nick = $nickname :: Ip = $ip<br />"; 
	} 
}  

 

edit/

you may want to use a for loop as then you could skip all the blank lines, saving time on script execution

[phphelp]

$ftp = ftp_connect("host") or die ("could not open ftp");
ftp_login($ftp, "user", "pass") or die ("could not open with user/pass");
$filelist = ftp_nlist($ftp, "/Logs")or die ("could not open dir");


$handle = (opendir('./Logs')) or die ("could not open logs dir"); 

    while  ($filename = readdir($handle))  
    { 


        if ( stristr($filename, ".log") ) 
        { 

$logcontent = file("$filename") or die ("could not get file"); //Script is halting here, tried ($ftp, "$filename"), ($ftp, "/Logs/$filename")


foreach ( $logcontent as $line )   

{  

if( substr_count ( $line, "l o g g e d   i n   f r o m   I P")==1) 
    { 
    $words = explode (":", $line); 
    $bits = explode ("l o g g e d   i n   f r o m   I P", trim($words[1]));   

    $nickname= trim($bits[0]);  //this still leaves spaces in names and ip may want to str_replace 
    $ip = trim(end($bits));       

    echo "Nick = $nickname :: Ip = $ip<br />";  

    }  

}}}

script halting, see $filename part comment.

[sidney]

you need to get your ftp file and download it on to server before you can open it

somthing like below

 <?php
$ftp = ftp_connect("domain") or die ("could not open ftp");
 ftp_login($ftp, "*****", "*****") or die ("could not open with user/pass");
$filelist = ftp_nlist($ftp, "Logs")or die ("could not open dir");
//ftp_close($ftp);
foreach($filelist as $filename)
	{
	if(substr($filename,-4,4)==".log")
		{
		$file = "temp.txt";
		$fp = fopen($file, 'w');
		ftp_chdir($ftp, "Logs"); 
		if (ftp_fget($ftp, $fp, $filename, FTP_ASCII)) 
			{
			fclose($fp);
			$logcontent = file($file); 
			foreach ( $logcontent as $line )  

				{ 
				if( substr_count ( $line, "l o g g e d   i n   f r o m   I P")==1)
					{
    				$words = explode (":", $line);
					$bits = explode ("l o g g e d   i n   f r o m   I P", trim($words[1]));  

    				$nickname= trim($bits[0]);  

    				$ip = str_replace(" ","",end($bits));      

    				echo "Nick = $nickname :: Ip = $ip<br />"; 
					} 
				} 
		 } else {
		 	fclose($fp);				
   			echo "There was a problem\n";
			}
		}
	}
 ftp_close($ftp);