<?php

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

$SourceURL = 'http://www.zdechov.cz/pages/main.php?pg=ou-usneseni-zapisy&ax=arx';
$StartText = '<b>Dokument:</b>&nbsp;&nbsp;';
$TitleSeparator = '<br>&nbsp;';
$StartLink = '<a href=..';
$Category = 11;
$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));
  $Date = substr($Title, strrpos($Title, ' ') + 1);
  $DateParts = explode('-', $Date);
  $Date = $DateParts[2].'-'.$DateParts[1].'-'.$DateParts[0];
  $Content = substr($Content, strpos($Content, $StartLink) + strlen($StartLink));
  $Link = 'http://www.zdechov.cz'.substr($Content, 0, strpos($Content, ' '));
  $Link = substr($Link, 0, strpos($Link, '?')); // Remove URL parameters
  $Link = substr($Link, 0, strrpos($Link, '/')).$DateParts[1].substr($Link, strrpos($Link, '/')); // Insert month between folder and filename
  $Description = '';

/*
  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' => $Automat, 'Category' => $Category, 'Content' => $Description), 'Link' => $Link);
    echo($Database->insert_id.',');
  }
}

?>
