Changeset 4428 for extensions/ConcoursPhoto/publish.php

Timestamp:

Dec 5, 2009, 4:17:17 PM (14 years ago)

Author:

tiico

Message:

[ConcoursPhoto] Correct some bugs. Add audit and user audit page.

File:

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

extensions/ConcoursPhoto/publish.php

@@ -25 +25 @@
 $category = $concours->concours_infos['category'];
 
+if (!(isset($concours->concours_infos['method'])))
+        $concours->concours_infos['method'] = 1;
+
 $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'
@@ -31 +34 @@
                 .' INNER JOIN '.CATEGORIES_TABLE.' AS cat ON ic.category_id = cat.id'
                 .' INNER JOIN '.CONCOURS_RESULT_TABLE.' AS conc ON conc.img_id = img.id'
-                .' WHERE ic.category_id = '.$concours->concours_infos['category']
-                .' ORDER by note DESC;';
+                .' WHERE ic.category_id = '.$concours->concours_infos['category'];
+
+if ($concours->concours_infos['method'] == 1)   // total
+        $query .= ' ORDER BY note DESC';
+elseif ($concours->concours_infos['method'] == 2)       // moyenne
+        $query .= ' ORDER BY moyenne DESC';
+
+$query .=';';
+//              .' ORDER by note DESC;';
 $result = pwg_query($query);
 $rang = 1;