Changeset 320 for trunk/aktuality/import_zdechov_cz_aktuality.php

Timestamp:

Nov 27, 2011, 6:31:35 PM (13 years ago)

Author:

chronos

Message:

• Opraveno: Do třídy databáze doplněny další funkce z dřívější mysqli.
• Upraveno: Přepracován import aktualit zděchova.

File:

• trunk/aktuality/import_zdechov_cz_aktuality.php (modified) (1 diff)

trunk/aktuality/import_zdechov_cz_aktuality.php

@@ -3 +3 @@
 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: ';
+$SourceURL = 'http://www.zdechov.cz/';
+$StartText = '<tr class="even">';
+$StartLink = 'href="';
+$StartTitle = '>';
+$TitleSeparator = '"';
+$StartDescription = '';
+$StartDate = '<td align="right">';
 $Category = 12;
 $Author = 'Automat';
-
-$Content = addslashes(ToUTF8(file_get_contents($SourceURL), 'win1250'));
+$Content = file_get_contents($SourceURL);
 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, ' '));
+  $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';
+  $Content = substr($Content, strpos($Content, $StartLink) + strlen($StartLink));
+  $Link = substr($Content, 0, strpos($Content, '"'));
+  if(substr($Link, 0, 7) != 'http://') $Link = 'http://'.$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 = $Database->select('News', 'Id', '`Title`="'.$Database->real_escape_string($Title).'" AND `Date`="'.$Date.'" AND `Category`='.$Category);