Changeset 4368 for extensions/ConcoursPhoto/publish.php

Timestamp:

Nov 26, 2009, 12:57:43 AM (14 years ago)

Author:

tiico

Message:

[ConcoursPhoto] Correct some bug, update database and add audit page (Need to be completed)

File:

• extensions/ConcoursPhoto/publish.php (modified) (2 diffs)

extensions/ConcoursPhoto/publish.php

@@ -13 +13 @@
 $concours = new Concours($id_concours);
 
+                $template->assign( 'CONCOURS', array(
+                                'ID'    => $concours->concours_infos['id'],
+                                'NAME'  => $concours->concours_infos['name'],
+                                'DESCR' => $concours->concours_infos['descr'],
+                                'BEGIN_DATE'    => $concours->concours_infos['begin_date'],
+                                'END_DATE'      => $concours->concours_infos['end_date'],
+                                'METHOD'        => l10n("concours_method".$concours->concours_infos['method'])
+                                ));
+
+
 $category = $concours->concours_infos['category'];
 
-$query = 'SELECT DISTINCT(img.id), img.name, img.file, img.path, img.tn_ext, 
-                  ic.category_id, cat.name AS catname, conc.note'
+$query = 'SELECT DISTINCT(img.id), img.name, img.file, img.path, img.tn_ext,img.author, 
+                  ic.category_id, cat.name AS catname, conc.note, conc.moyenne, conc.nbvotant'
                 .' FROM ' . IMAGES_TABLE.' AS img'
                 .' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON img.id = ic.image_id'
@@ -60 +70 @@
                         'name'  => $row['name'],
                         'file'  => $row['file'],
+                        'author'        => $row['author'],
                         'rang'  => $rang,
                         'thumb' => get_thumbnail_url($row),
                         'url'   => $url,
-                        'note'  => ($row['note'] == 0 ? 'N/A' :$row['note'])
+                        'note'  => ($row['note'] == 0 ? 'N/A' :$row['note']),
+                        'moyenne'       => ($row['moyenne'] == 0 ? 'N/A' :$row['moyenne']),
+                        'nbvotant'      => $row['nbvotant'],
+                        'usernote'      => $concours->get_img_globalnote_user($row['id'])
+                        
                 ));
         $rang ++;