Changeset 4472

Timestamp:

06/18/12 14:19:22 (11 months ago)

Author:

oscim

Message:

coquille

Files:

• trunk/catalog/admin/includes/classes/drivers/sqlfeatured.php (modified) (8 diffs)

trunk/catalog/admin/includes/classes/drivers/sqlfeatured.php

@@ -68 +68 @@
                         $res=tep_db_perform(TABLE_FEATURED_DESCRIPTION, $sql_data_array_lg);
                 }
-                
+
 
 
@@ -117 +117 @@
                         $where_lg .= "AND languages_id = '".(int)$lg['id']."' ";
 
-                  $sql_data_array_lg = array(
-                                        'featured_title'=> ((isset($row['title'][$lg['id']])) ? tep_db_prepare_input($row['title'][$lg['id']]) : '' ),
-                        );
-
-                        $res=tep_db_perform(TABLE_FEATURED_DESCRIPTION, $sql_data_array_lg, 'update' , substr($where_lg,3));
+                                if(isset($row['title'][$lg['id']] ) {
+                                                $sql_data_array_lg = array(
+                                                                'featured_title'=> ((!empty($row['title'][$lg['id']])) ? tep_db_prepare_input($row['title'][$lg['id']]) : '' ),
+                                                );
+
+                                                $res=tep_db_perform(TABLE_FEATURED_DESCRIPTION, $sql_data_array_lg, 'update' , substr($where_lg,3));
+                                }
                 }
 
@@ -179 +181 @@
                                 $_query = $DB->query("select languages_id , fd.featured_title  from " . TABLE_FEATURED_DESCRIPTION . " fd where fd.featured_id = '" . (int)$result['row_id'] . "' ");
 
-                                foreach($_query->fetchAllAssoc() as $row) 
+                                foreach($_query->fetchAllAssoc() as $row)
                                         $result['lg'][$row['languages_id']] = ((!$shortkey)? $row : self::CleanKey($row));
 
@@ -198 +200 @@
                                 $_query = $DB->query("select languages_id , fd.featured_title  from " . TABLE_FEATURED_DESCRIPTION . " fd where fd.featured_id = '" . (int)$result['row_id'] . "' ");
 
-                                foreach($_query->fetchAllAssoc() as $row) 
+                                foreach($_query->fetchAllAssoc() as $row)
                                         $result['lg'][$row['languages_id']] = ((!$shortkey)? $row : self::CleanKey($row));
 
@@ -228 +230 @@
     $res = $DB->query("SELECT row_id as id FROM " . TABLE_FEATURED ." WHERE ". substr($where, 3 ).' LIMIT  1' );
                 $result = $res->fetchAssoc();
-                
+
 
                 // childs tables
@@ -287 +289 @@
 
         /**
-                @brief Function link to for contruct link featured vs datatype 
+                @brief Function link to for contruct link featured vs datatype
                 @note normlised methode used in childs datatype
         */
@@ -306 +308 @@
                                                                                                                                 'datatype'=> $datatype,
                                                                                                                                 'datatype_id'=> $id,
-                                                                                                                                ), 
+                                                                                                                                ),
                                                                                                                                 true
                                                                                                                 );
@@ -319 +321 @@
 
         /**
-                @brief Function link to for contruct link featued vs datatype 
+                @brief Function link to for contruct link featued vs datatype
                 @note normlised methode used in childs datatype
         */