Changeset 9572 for extensions/ContestResults/admin/manage.php

Timestamp:

Mar 8, 2011, 1:19:06 PM (13 years ago)

Author:

mistic100

Message:

[extensions] ContestResults 1.3

• Add error and success messages on admin page
• Add Spain (es_ES) thanks to jpr928
• Contest status is automatic and shows remaining days
• More flexibility for description fields
• Compatibility with Piwigo 2.2.0

File:

• extensions/ContestResults/admin/manage.php (modified) (1 diff)

extensions/ContestResults/admin/manage.php

@@ -18 +18 @@
 //                              Affichage des concours
 // +-----------------------------------------------------------------------+
-foreach (array('pending','finished') AS $status) {
-        $result = pwg_query("SELECT id, name, visible, date_begin, date_end, logo
-                FROM " . CR_TABLE_1 . "
-                WHERE status = '" . $status . "'
-                ORDER BY date_begin DESC;");
+$contests = pwg_query("SELECT 
+                id, 
+                name, 
+                visible, 
+                date_begin, 
+                date_end, 
+                logo
+        FROM " . CR_TABLE_1 . "
+        ORDER BY date_begin DESC;");
 
-        while ($contest = pwg_db_fetch_assoc($result)) {
-                $template->append('contests_'.$status, array(
-                        'NAME' => trigger_event('render_CR_content', $contest['name']),
-                        'VISIBLE' => $contest['visible'],
-                        'DATE_BEGIN' => format_date($contest['date_begin']),
-                        'DATE_END' => format_date($contest['date_end']),
-                        'LOGO' => $contest['logo'],
-                        'U_RESULTS' => CR_ADMIN . '&tab=results&contest_id=' . $contest['id'],
-                        'U_EDIT' => CR_ADMIN . '&tab=edit&contest_id=' . $contest['id'],
-                        'U_DELETE' => CR_ADMIN . '&delete_contest=' . $contest['id'],
-                        'URL' => CR_PUBLIC . $contest['id'] . '-' . str2url(trigger_event('render_CR_content', $contest['name'])),
-                ));
+while ($contest = pwg_db_fetch_assoc($contests)) {
+        if (is_date_passed($contest['date_end'])) {
+                $contest['status'] = 'finished';
+        } else { 
+                $contest['status'] = 'pending';
         }
+        $template->append('contests_'.$contest['status'], array(
+                'NAME' => trigger_event('render_CR_content', $contest['name']),
+                'VISIBLE' => $contest['visible'],
+                'DATE_BEGIN' => format_date($contest['date_begin']),
+                'DATE_END' => format_date($contest['date_end']),
+                'LOGO' => $contest['logo'],
+                'U_RESULTS' => CR_ADMIN . '&tab=results&contest_id=' . $contest['id'],
+                'U_EDIT' => CR_ADMIN . '&tab=edit&contest_id=' . $contest['id'],
+                'U_DELETE' => CR_ADMIN . '&delete_contest=' . $contest['id'],
+                'URL' => CR_PUBLIC . $contest['id'] . '-' . str2url(trigger_event('render_CR_content', $contest['name'])),
+                'DAYS' => DateDiff($contest['date_end'],date('Y-m-d')),
+        ));
 }