<?php
include "../include/confignovini.php";
include"../include/session.php";
$xmlfile = fopen("http://www.kaldata.com/rosebud/rss.php?catid=3", "r");
if(!$xmlfile)die("cannot open the xml file");
$readfile = fread($xmlfile ,4000000);
$searchfile = eregi("<item>(.*)</item>", $readfile ,$arrayreg);
$filechunks = explode("<item>", $arrayreg[0]);
$count = count($filechunks);
for($i=1 ; $i<=$count-1 ;$i++)
{
ereg("<title>(.*)</title>",$filechunks[$i], $title);
ereg("<link>(.*)</link>",$filechunks[$i], $links);
ereg("<description>(.*)</description",$filechunks[$i],$desc);
ereg("<img a href '(.*)'</a>",$filechunks[$i],$media);
$zaglavie = $title[1];
$linkche = $links[1];
$tekst = $desc[1];
$media = $media[1];
$data=time();
mysql_connect($server, $dbusername, $dbpassword)or die("error1");
@mysql_select_db($db_name) or die("error2");
$query="SELECT * FROM novini WHERE zaglavie LIKE '$zaglavie'";
$result=mysql_query($query);
$num=mysql_numrows($result);
if($num==0)
{
mysql_connect($server, $dbusername, $dbpassword)or die("error3");
@mysql_select_db($db_name) or die("error4");
$query = "INSERT INTO `novini` ( `id` , `zaglavie` , `linkche` , `tekst`, `data`,`media`)
VALUES ( 'NULL', '$zaglavie', '$linkche', '$tekst', '$data', '$media')";
$ok = mysql_query($query);
}
}
?>
