Changeset 310

Timestamp:

Feb 6, 2011, 7:07:14 PM (14 years ago)

Author:

george

Message:

• Opraveno: V importech aktualit opraveno lomítkování.

Location:

trunk/aktuality

Files:

• import_kino_vatra.php (modified) (2 diffs)
• import_obec_hovezi.php (modified) (2 diffs)
• import_tv_beskyd.php (modified) (1 diff)
• import_zdechov_cz_aktuality.php (modified) (1 diff)
• import_zdechov_cz_zapisy.php (modified) (1 diff)

trunk/aktuality/import_kino_vatra.php

@@ -20 +20 @@
   $Date = $node->getElementsByTagName('pubDate')->item(0)->nodeValue;
   
-  $Title = $Database->real_escape_string($Title);
   $Description = strip_tags($Description);
   $Description = str_replace("\r", '', $Description);
   $Description = str_replace("\n", '<br>', $Description);
-  $Description = $Database->real_escape_string($Description);
-  $Link = $Database->real_escape_string($Link);
   //if(($CommaPos = strpos($Date, ',')) !== FALSE)
   //  $Date = substr($Date, $CommaPos + 1);
   $Date = TimeToMysqlDateTime(strtotime($Date));
   
-  
-  $DbResult = $Database->select('News', 'Id', '(`Title`="'.$Title.'") AND (`Category`='.$Category.') AND (`Content` = "'.$Description.'") AND (`Link` = "'.$Link.'")');
-  //echo($Database->LastQuery);
+  $Query = 'SELECT Id FROM News WHERE (`Title`="'.$Database->real_escape_string($Title).'") AND (`Category`='.$Category.') AND (`Content` = "'.$Database->real_escape_string($Description).'") AND (`Link` = "'.$Database->real_escape_string($Link).'")';
+  $DbResult = $Database->query($Query);
   if($DbResult->num_rows == 0)
   {
@@ -40 +36 @@
 }
 
-/*
-//$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, strpos($Content, $TitleSeparator) + strlen($TitleSeparator));
-  $Title = substr($Title, 0, strpos($Title, '<'));
-
-  $Description = substr($Content, strpos($Content, $DescriptionSeparator) + strlen($DescriptionSeparator));
-  $Description = trim(substr($Description, 0, strpos($Description, '</')));
-  
-  $Content = substr($Content, strpos($Content, $StartLink) + strlen($StartLink));
-  $Link = substr($Content, 0, strpos($Content, '<'));
-//  $Link = substr($Link, 0, strpos($Link, '?')); // Remove URL parameters
-//  $Link = substr($Link, 0, strrpos($Link, '/')).substr($Link, strrpos($Link, '/')); // Insert month between folder and filename
-//  $Description .= '<br><a href="'.$Link.'">Video</a>';
-
-  //echo('Title: '.$Title.'<br>');
-  //echo('Description: '.$Description.'<br>');
-  //echo('Link: '.$Link.'<br><hr>');
-  
-  $Link = $Database->real_escape_string($Link);
-  $Title = $Database->real_escape_string($Title);
-  $Description = strip_cdata($Description);
-  $Description = strip_tags($Description);
-  
-  $Description = str_replace("\n", '<br>', $Description);
-  $Description = str_replace("\r", '', $Description);
-  $Description = $Database->real_escape_string($Description);
-  
-  $DbResult = $Database->select('News', 'Id', '(`Title`="'.$Title.'") AND (`Category`='.$Category.') AND (`Content` = "'.$Description.'") AND (`Link` = "'.$Link.'")');
-  //echo($Database->LastQuery);
-  if($DbResult->num_rows == 0)
-  {
-    $Database->insert('News', array('Title' => $Title, 'Date' => 'NOW()', 'Author' => $Author, 'Category' => $Category, 'Content' => $Description, 'Link' => $Link));
-    echo($Database->insert_id.',');
-  }
-} 
-*/
-
 ?>

trunk/aktuality/import_obec_hovezi.php

@@ -20 +20 @@
   $Date = $node->getElementsByTagName('pubDate')->item(0)->nodeValue;
   
-  $Title = $Database->real_escape_string($Title);
   $Description = strip_tags($Description);
   $Description = str_replace("\r", '', $Description);
   $Description = str_replace("\n", '<br>', $Description);
-  $Description = $Database->real_escape_string($Description);
-  $Link = $Database->real_escape_string($Link);
   //if(($CommaPos = strpos($Date, ',')) !== FALSE)
   //  $Date = substr($Date, $CommaPos + 1);
@@ -31 +28 @@
   
   
-  $DbResult = $Database->select('News', 'Id', '(`Title`="'.$Title.'") AND (`Category`='.$Category.') AND (`Content` = "'.$Description.'") AND (`Link` = "'.$Link.'")');
+  $DbResult = $Database->select('News', 'Id', '(`Title`="'.$Database->real_escape_string($Title).'") AND (`Category`='.$Category.') AND (`Content` = "'.$Database->real_escape_string($Description).'") AND (`Link` = "'.$Database->real_escape_string($Link).'")');
   //echo($Database->LastQuery);
   if($DbResult->num_rows == 0)

trunk/aktuality/import_tv_beskyd.php

@@ -31 +31 @@
   //echo('Link: '.$Link.'<br><hr>');
   
-  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Category`='.$Category);
+  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Database->real_escape_string($Title).'" AND `Category`='.$Category);
   //echo($Database->LastQuery);
   if($DbResult->num_rows == 0)

trunk/aktuality/import_zdechov_cz_aktuality.php

@@ -32 +32 @@
 */
 
-  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
+  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Database->real_escape_string($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));
+    $Database->insert('News', array('Title' => $Title, 'Date' => $Date, 'Author' => $Author, 'Category' => $Category, 'Content' => $Description, 'Link' => $Link));
     echo($Database->insert_id.',');
   }

trunk/aktuality/import_zdechov_cz_zapisy.php

@@ -31 +31 @@
 */
 
-  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Title.'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
+  $DbResult = $Database->select('News', 'Id', '`Title`="'.$Database->real_escape_string($Title).'" AND `Date`="'.$Date.'" AND `Category`='.$Category);
   //echo($Database->LastQuery);
   if($DbResult->num_rows == 0)