Changeset 320 for trunk

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.

Location:

trunk

Files:

• aktuality/import_zdechov_cz_aktuality.php (modified) (1 diff)
• database.php (modified) (4 diffs)
• merak.php (deleted)

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);

trunk/database.php

@@ -33 +33 @@
   var $PDO;
   var $Error = '';
+  var $insert_id;
+  var $LastQuery = '';
   
   function __construct($Host, $User, $Password, $Database)
@@ -51 +53 @@
     global $Config;
         
+    $this->LastQuery = $Query;
     if($Config['Web']['ShowSQLQuery'] == true) 
       echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>'."\n");
@@ -85 +88 @@
     $Values = substr($Values, 1);
     $this->PDO->query('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')'); 
+    $this->insert_id = $this->PDO->lastInsertId();
   }
   
@@ -121 +125 @@
   }
   
+  function real_escape_string($Text)
+  {
+    return(addslashes($Text));
+  }
+  
 }