<?php

include('../global.php');

$SourceURL = 'http://www.zdechov.cz/pages/main.php?pg=home&cat=1';
$StartText = '<table width=100% border=0 cellspacing=1 cellpadding=5><tr><td bgcolor=#567069><b>';
$TitleSeparator = '<tr>';
$StartDescription = '<tr><td bgcolor=#567069>';
$StartDate = 'vloženo: ';
$Category = 12;
$Author = 'Automat';

$Content = addslashes(ToUTF8(file_get_contents($SourceURL), 'win1250'));
while(strpos($Content, $StartText) !== false)
{
  $Content = substr($Content, strpos($Content, $StartText) + strlen($StartText));
  $Title = substr($Content, 0, strpos($Content, $TitleSeparator));
  $Content = substr($Content, strpos($Content, $StartDescription) + strlen($StartDescription));
  $Description = substr($Content, 0, strpos($Content, $TitleSeparator));
  $Content = substr($Content, strpos($Content, $StartDate) + strlen($StartDate));
  $Date = substr($Content, 0, strpos($Content, ' '));
  $DateParts = explode('.', $Date);
  $Date = $DateParts[2].'-'.$DateParts[1].'-'.$DateParts[0];
  $Link = 'http://www.zdechov.cz/pages/main.php?pg=home&cat=1';


/*
  echo('Title: '.$Title.'<br>');
  echo('Description: '.$Description.'<br>');
  echo('Date: '.$Date.'<br>');
  echo('Link: '.$Link.'<br><hr>');
*/

  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
  //echo($Database->LastQuery);
  if($DbResult->num_rows == 0)
  {
    $Database->insert('News', array('Title' => $Title, 'Date' => $Date, 'Author' => $Author, 'Category' => $Category, 'Content' => addslashes($Description), 'Link' => $Link));
    echo($Database->insert_id.',');
  }
}

?>
