<?php

include_once(dirname(__FILE__).'/../../Common/Global.php');

$SourceURL = 'http://www.zdechov.cz/';
$StartText = '<tr class="even">';
$StartLink = 'href="';
$StartTitle = '>';
$TitleSeparator = '"';
$StartDescription = '';
$StartDate = '<td align="right">';
$Category = 12;
$Author = 'Automat';
$Content = file_get_contents($SourceURL);
while(strpos($Content, $StartText) !== false)
{
  $Content = substr($Content, strpos($Content, $StartText) + strlen($StartText));
  $Content = substr($Content, strpos($Content, $StartDate) + strlen($StartDate));
  $Date = substr($Content, 0, strpos($Content, '<'));
  $DateParts = explode('.', $Date);
  $Date = $DateParts[2].'-'.$DateParts[1].'-'.$DateParts[0];
  $Content = substr($Content, strpos($Content, $StartLink) + strlen($StartLink));
  $Link = substr($Content, 0, strpos($Content, '"'));
  if(substr($Link, 0, 7) != 'http://') $Link = 'http://www.zdechov.cz/'.$Link;
  $Content = substr($Content, strpos($Content, $StartTitle) + strlen($StartTitle));
  $Title = substr($Content, 0, strpos($Content, '<'));
  $Description = '';
  

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

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