<?
@include("inc/mysql.inc.php");
@include("inc/funkcje.inc.php");

$r1 = mysql_query("SELECT * FROM rssy ORDER BY rand() LIMIT 40");
while($r2 = mysql_fetch_array($r1)){
$link = trim($r2['link']);
$rid = $r2['rid'];
$kat = $r2['kat'];
//echo $link."<br>\n";

//pobieram dane z każdego

$user_agent = "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0)";
$go = $link;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $go);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_USERAGENT, $user_agent);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_TIMEOUT, '2');
$buffer=curl_exec ($ch);
curl_close ($ch);


@preg_match_all("/<item>(.*?)<\/item>/is", $buffer, $outter, PREG_PATTERN_ORDER);



$licz = count($outter[1]);
$i = 0;



// zaczynam przerabianie każdego z bazy
while($i<= $licz){


@preg_match_all("/<title>(.*?)<\/title>/i", $outter[1][$i], $out1, PREG_PATTERN_ORDER);
@preg_match_all("/<description>(.*?)<\/description>/i", $outter[1][$i], $out2, PREG_PATTERN_ORDER);
@preg_match_all("/<link>(.*?)<\/link>/i", $outter[1][$i], $out3, PREG_PATTERN_ORDER);






$tytul = @my_iconv("WINDOWS-1250", htmlspecialchars(strip_tags(trim($out1[1][0]))),ENT_QUOTES);
$opis = @my_iconv("WINDOWS-1250",strip_tags(trim($out2[1][0])));
$link = @strip_tags(trim($out3[1][0]));
$czas = time();

$search = '/<img.*?>/i';
$replace = '';
$output = preg_replace ($search, $replace, $opis );

//przeprowadzam test
$m1 = @mysql_query("SELECT artid FROM artykuly WHERE link = '$link'");
if(@mysql_num_rows($m1) == 0){
$test = 0;
}else{
$test = 1;
}
$opis = str_replace("ł","n",$opis);
$opis = str_replace("ą","a",$opis);
$opis = htmlspecialchars($opis);
if($tytul != NULL and $link != NULL and strlen($opis) >= 100 and strlen($opis)<=500 and $test != 1){
mysql_query("INSERT INTO artykuly VALUES (\"\",$kat,\"$tytul\",'".$opis."',\"$link\",\"$czas\")")or dir(mysql_error());
}




$i++;
}


}

// czyszczenie

$teraz = time();
$dwatygodnie = 60*60*24*14;
$starsze = $teraz-$dwatygodnie;

// kasujemy
mysql_query("DELETE FROM artykuly WHERE czas < $starsze");


?>