Changeset 1090

Timestamp:

09/23/08 19:39:54 (2 months ago)

Author:

Pernod

Message:

Fixed a UTF8 encoding issue when importing TV details from xml sidecar files.

Files:

• trunk/swisscenter/base/xml_sidecar.php (modified) (6 diffs)

trunk/swisscenter/base/xml_sidecar.php

@@ -283 +283 @@
-    
-    $data = $xml->match("/tv[1]/programme");
-$xml->getData($data[0]
+utf8_decode($xml->getData($data[0])
-    $data = $xml->match("/tv[1]/series");
-    if ( !empty($data) ) $columns["SERIES"] = $xml->getData($data[0]);
@@ -289 +289 @@
-    if ( !empty($data) ) $columns["EPISODE"] = $xml->getData($data[0]);
-    $data = $xml->match("/tv[1]/title");
-$xml->getData($data[0]
+utf8_decode($xml->getData($data[0])
-    $data = $xml->match("/tv[1]/synopsis");
-$xml->getData($data[0]
+utf8_decode($xml->getData($data[0])
-    $data = $xml->match("/tv[1]/year");
-    if ( !empty($data) ) $columns["YEAR"] = $xml->getData($data[0]);
@@ -304 +304 @@
-      $data = array();
-      foreach ($actors as $actorpath)
-$xml->getData($actorpath.'/name'
+utf8_decode($xml->getData($actorpath.'/name')
-      scdb_add_tv_actors($file_id,$data);
-    }
@@ -325 +325 @@
-      $data = array();
-      foreach ($genres as $genrepath)
-$xml->getData($genrepath
+utf8_decode($xml->getData($genrepath)
-      scdb_add_tv_genres($file_id,$data);
-    }
@@ -336 +336 @@
-      $data = array();
-      foreach ($directors  as $directorpath)
-$xml->getData($directorpath
+utf8_decode($xml->getData($directorpath)
-      scdb_add_tv_directors($file_id,$data);
-    }
@@ -345 +345 @@
-      foreach ( $viewed as $viewedpath )
-      {
-$xml->getData($viewedpath) 
+utf8_decode($xml->getData($viewedpath))
-        $data = db_value("SELECT user_id FROM users where name='".$name."'");
-        @db_sqlcommand("insert into viewings (user_id, media_type, media_id, last_viewed, total_viewings ) values (".$data.", ".MEDIA_TYPE_TV.", ".$file_id.", now(), 1) ");