_scripts.php

<?php

require_once( dirname(__FILE__).'/vendor/actarus/Config.php' );


// config
$config = Config::getInstance();
$config->actarusPath = dirname(__FILE__);
$config->appPath     = $config->actarusPath.'/app';
$config->consolePath = $config->actarusPath.'/app/console';
$config->configPath  = $config->appPath.'/config';
$config->logPath     = $config->appPath.'/logs';
$config->loadParameters( $config->configPath.'/parameters.yml', 'parameters' );
$config->loadParameters( $config->configPath.'/myparameters.yml', 'parameters' );
//var_dump( $config );
//exit();

$db = $config->db = mysqli_connect( $config->parameters['database_host'], $config->parameters['database_user'], $config->parameters['database_password'], $config->parameters['database_name'] );


/*
	function createSign( $url )
	{
	    $url = urldecode( trim($url,' /') );
	    
	    $sign = '';
	    $t_params = [];
	    $t_parse = parse_url( $url );
	    //var_dump( $t_parse );
	    
	    if( isset($t_parse['query']) ) {
	        $t_query = explode( '&', $t_parse['query'] );
	        foreach( $t_query as $q ) {
	            if( strstr($q,'=') ) {
	                $tmp = explode( '=', $q );
	                $t_params[ $tmp[0] ] = $tmp[1];
	            } else {
	                $t_params[ $q ] = '';
	            }
	        }
	        ksort( $t_params );
	    }
	    //var_dump( $t_parse );
	    //var_dump( $t_params );
	
	    $str = str_replace( 's', '', $t_parse['scheme'] );
	    $str .= $t_parse['host'];
	    $str .= $t_parse['path'];
	
	    foreach( $t_params as $k=>$v ) {
	        $str .= $k;
	        $str .= $v;
	    }
	    
	    //echo $str."\n";
	    $sign = md5( $str );
	    
	    return $sign;
	}

$q = "SELECT * FROM arus_request";
$r = $db->query( $q );

while( ($t=$r->fetch_object()) )
{
	$sign = createSign($t->url);
	$q = "UPDATE arus_request SET sign='".$sign."' WHERE id='".$t->id."'";
	echo $q."\n";
	$rr = $db->query( $q );
}
*/
	

/*
//$q = "SELECT * FROM arus_entity_task AS t WHERE command like 'nmap%' LIMIT 0,2";
$q = "SELECT * FROM arus_entity_task AS t WHERE command like 'nmap%'";
$r = $db->query( $q );

while( ($t=$r->fetch_object()) )
{
	var_dump( $t->id );
	
	$m = preg_match_all( '#([0-9]+)/([^\s]*)[\s]+open[\s]+([^\s]*)[\s]+(.*)\n#', $t->output, $matches );
	if( !$m ) {
		continue;
	}
	
	//var_dump( $matches );
	$cnt = count( $matches[0] );
	if( !$cnt ) {
		continue;
	}
	
	$q = "SELECT * FROM arus_server AS s WHERE entity_id='".$t->entity_id."'";
	$rr = $db->query( $q );
	if( !$r || !$r->num_rows ) {
		continue;
	}
	
	$s = $rr->fetch_object();
	
	for( $i=0 ; $i<$cnt ; $i++ ) {
		if( stristr($matches[4][$i],'service unrecognized') ) {
			$matches[4][$i] = '';
		}
		$q = "INSERT INTO arus_server_service (server_id,port,type,service,version,created_at,updated_at) VALUES ('".$s->id."','".(int)$matches[1][$i]."','".$matches[2][$i]."','".$matches[3][$i]."','".$matches[4][$i]."',NOW(),NOW())";
		echo $q."\n";
		$db->query( $q );
	}
}
*/


/*
$q = "SELECT * FROM arus_server AS s WHERE project_id='3' AND created_at>='2017-03-23 00:00:00'";
$r = $db->query( $q );

while( ($s=$r->fetch_object()) )
{
	$cmd = $config->consolePath.' arus:task:create -t 23 -i '.$s->entity_id;
	echo $cmd."\n";
	system( $cmd );
}
*/

/*
$q = "SELECT h.* FROM arus_host as h left join arus_entity_task as t on h.entity_id=t.entity_id where t.command like 'testhttp%' and t.output like '%443:OK%'";
$r = $db->query( $q );

while( ($s=$r->fetch_object()) )
{
	$cmd = $config->consolePath.' arus:task:create -t 42 -i '.$s->entity_id;
	echo $cmd."\n";
	system( $cmd );
}
*/

/*
$q = "SELECT h.* FROM arus_host as h WHERE h.project_id='331'";
$r = $db->query( $q );

while( ($s=$r->fetch_object()) )
{
	$cmd = $config->consolePath.' arus:task:create -t 42 -i '.$s->entity_id;
	echo $cmd."\n";
	system( $cmd );
	$cmd = $config->consolePath.' arus:task:create -t 40 -i '.$s->entity_id;
	echo $cmd."\n";
	system( $cmd );
}
*/

/*
$t_buckets = file( '/home/gwen/Sécurité/bug-bounty/h1-s3-buckets.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES );
var_dump( count($t_buckets) );

foreach( $t_buckets as $b )
{
	$tmp = explode( '-', $b );
	
	$q_select = "SELECT * FROM arus_project WHERE name LIKE '".$tmp[0]."'";
	$r = $db->query( $q_select );
	if( !$r || !$r->num_rows ) {
		continue;
	}
	
	$project = $r->fetch_object();
	
	$q_insert = "INSERT INTO arus_bucket (project_id,name,status,created_at,updated_at) VALUES ('".$project->id."','".$b."','0',NOW(),NOW())";
	echo $q_insert."\n";
	$db->query( $q_insert );
}
*/




$db->close();

exit( 0 );

?>