splitlines.php 1.15 KB
<?php
set_time_limit (0);
ini_set("memory_limit","1024M");

$file = file_get_contents("v1.2_slow-query.log");
$lines = explode("\n", $file);
$exclude = array();
foreach ($lines as $line) {
// if (strpos($line, '`accesslogs`') !== FALSE || strpos($line, '`sessions`') !== FALSE || strpos($line, '# User@Host:') || strpos($line, '# Thread_id:') !== FALSE || strpos($line, '`crmcalls`') !== FALSE || strpos($line, '`userlogs`') !== FALSE || strpos($line, '# User@Host:') !== FALSE|| strpos($line, '# Time:') !== FALSE || strpos($line, '`fullremark`') !== FALSE || strpos($line, '`diallines`') !== FALSE ||  strpos($line, 'sipids') !== FALSE ||  strpos($line, '# Query_time:') !== FALSE ||  strpos($line, 'SET timestamp=') !== FALSE) {
//       	continue;
//     }
	// if ( strpos($line, '`accesslogs`') === FALSE && (strpos($line, 'records') !== FALSE || strpos($line, '`records`') !== FALSE)) {
 //      	$exclude[] = $line;
 //    }

    if ( strpos($line, '`accesslogs`') === FALSE && strpos($line, 'diallines') !== FALSE) {
      	$exclude[] = $line;
    }
    // $exclude[] = $line;

}
$log = implode("\n", $exclude);
file_put_contents("v1.2_diallines.log", $log);

die;
?>