Untitled

<head>
<meta http-equiv="Refresh" content="20">
</head>
<?
$startScan = microtime(true);
//TU DODAJE PARAMETRY DO BAZY MAZOVII

$dbhost = '58915.m.tld.pl';
$database = 'baza58915_wynik';
$dbusername = 'admin58915_wynik';
$dbpassword = 'pj3U060H';

//TU DODAJE POLACZENIE Z FTP - MOŻE SIĘ NIE ZJEBIE

$ftp_server = '94.152.132.115';
$ftp_user_name = 'mazovia_ftp';
$ftp_user_pass = 'mazovia';

// set up basic connection
$conn_id = ftp_connect($ftp_server);

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// get contents of the current directory
$files = ftp_nlist($conn_id, "./sts_foto/upload_photo");


$dont_index_last_files = 4; // nie indexuj ostatnich 4 plikow bo moga nie byc zaladowane do konca

try {
	$db = new PDO('mysql:host='.$dbhost.';charset=utf8;dbname='.$database, $dbusername, $dbpassword);
}
catch (PDOException $e)
{
	print "Błąd połączenia z bazą!: " . $e->getMessage() . "<br/>";
	die();
}
$db->exec("set names utf8");

echo 'Indeksuję zdjęcia:<br><br>';
$stamp = imagecreatefrompng('images/TEST.png');


// get last indexed filename
$last_file = false;
$insert_to_db = false;
$statement = $db->query('SELECT * FROM photo ORDER BY date DESC LIMIT 1');
foreach($statement as $last)
{
    $last_file = $last['filename'];
}
$statement->closeCursor();
$array_size = sizeof($files);

foreach($files as $key=>$filename) {

	// dont index last file might not be uploaded fully
	if(($key+$dont_index_last_files) >= $array_size) continue;

	if($filename != '.' && $filename != '..' && $filename != 'test') {
		//echo $filename.'<br>';
		$filename = basename($filename);
		list($pre,$pre2,$filetime,$post) = explode('_', $filename);
		if($insert_to_db || $last_file == false) {
			$date = DateTime::createFromFormat('YmdHisu', $filetime);
			echo($filetime);
			$filedate = $date->format('Y-m-d H:i:s');
			echo $filetime.' '.$filename.' - '.$filedate.'<br>';

			$stmt = $db->prepare("INSERT INTO photo (date, filename) VALUES (:date, :filename)");
			$stmt->bindValue(':date', $filedate, PDO::PARAM_STR);
			$stmt->bindValue(':filename', $filename, PDO::PARAM_STR);
			$stmt->execute();
			$stmt->closeCursor();
		}
		if($last_file == $filename)
			$insert_to_db = true;
	}
}

$endScan = microtime(true);
echo "Czas indeksowania: " . ($endScan-$startScan) . "\n";

//PRZYPISYWANIE ZDJĘĆ DO ZAWODNIKÓW
	$day = '2018-09-23';
	$foto_seconds_add = 0;
	$foto_seconds_substract = 0;

	$stmt = ("SELECT cz1, numer FROM zawodnik_inne WHERE cz1 > '00:00:00' AND photo1 = ''");
	$stmt->execute();
	if($stmt->rowCount() > 0 ) {
		while($zawodnik = $stmt->fetchObject())
			echo("Przypisywanie zdjec - zawodnik numer: $zawodnik->numer");
			$zawodnik_czas = $zawodnik->cz1;
			$start =
			$photos[] = $obj->filename;
	}


?>