Changeset 3663 for extensions/Flash_Gallery/generate-xml.php

Timestamp:

Jul 22, 2009, 12:34:42 AM (15 years ago)

Author:

tiico

Message:

Some corrections
Add EN translation (only for the core, not for modules)
Add comment options (%ID)

File:

• extensions/Flash_Gallery/generate-xml.php (modified) (4 diffs)

extensions/Flash_Gallery/generate-xml.php

@@ -233 +233 @@
         foreach ($pictures as $row)
         {
-//      echo "prev=".$prev_catid;
-//      echo "catid=".$row['CATID'];
                 // Alimentation des variables pour la constitution du flux xml
                 foreach ($module_data['datas'] as $keydata => $valuedata)
                 {
                         if ($valuedata) // == true
-                                $picture[$keydata] =  parse($module['datas'][$keydata], $row);
+                                $picture[$keydata] =  parse($module['datas'][$keydata], $row, $module['maxcomment']);
                         else
                                 $picture[$keydata] = '';
@@ -274 +272 @@
 unset_make_full_url();
 
-function parse($data, $row)
-{
+function parse($data, $row, $nb_comment = 0)
+{
+        // Eviter de charger les commentaires (appels base) si ils ne sont pas affichés
+        if (strpos($data, '%ID') === false)
+                $nb_comment = 0;
+
         include (FLASHGAL_PATH.'include/config_param.inc.php');
 
@@ -282 +284 @@
         foreach ($flashgal_parse as $key => $value)
         {
-//              echo "key=".$key."  value=".$value."\n";
                 array_push($patterns, $key); 
                 array_push($replacements, $value);
@@ -288 +289 @@
 
         return str_replace($patterns, $replacements, $data);
-//      echo "output=".$output;
-//      return $output;
+}
+
+// Return the last comments of an image id
+function get_comment($img_id, $nb_comment = 0)
+{
+        $commentstring = '';
+
+        if ($nb_comment != 0)
+        {
+                $query = '
+                SELECT id,author,date,image_id,content
+                  FROM '.COMMENTS_TABLE.'
+                  WHERE image_id = '.$img_id.'
+                        AND validated = \'true\'
+                  ORDER BY date ASC
+                  LIMIT 0,'.$nb_comment.'
+                ;';
+                $result = pwg_query( $query );
+                $first = true;
+
+                while ($row = mysql_fetch_array($result))
+                {
+                
+                // Format : "Commentaire (Utilisateur - Date)"
+                        $commentstring .= ($first ?  '' : " / \n")
+                                        .trigger_event('render_comment_content',$row['content'])
+                                        .' ('. trigger_event('render_comment_author',
+                                                                empty($row['author'])
+                                                                ? l10n('guest')
+                                                                : $row['author'])
+                                        .' - '
+                                        .format_date( $row['date'], false)
+                                        .")";
+                                        
+                        $first = false;
+
+                }
+        }
+        return $commentstring;  
 }