Changeset 9200 for extensions/ContestResults/include/cr_main.php

Timestamp:

Feb 13, 2011, 11:12:58 AM (13 years ago)

Author:

mistic100

Message:

ContestResults :

• Code revision
• Add Letton (lv_LV) language, thanks to Aivars Baldone
• Delete display options
• Fix languages bugs
• Improve public appearence

File:

• extensions/ContestResults/include/cr_main.php (modified) (4 diffs)

extensions/ContestResults/include/cr_main.php

@@ -3 +3 @@
 
 // +-----------------------------------------------------------------------+
-//                      Liste des concours
+//                              Liste des concours
 // +-----------------------------------------------------------------------+
-$query = "SELECT id, name, visible, date_begin, date_end, status, logo, summary FROM " . CR_TABLE_1 . " ORDER BY date_begin DESC;";
-$contests = pwg_query($query);
+$contests = pwg_query("SELECT 
+                id, 
+                name, 
+                visible, 
+                date_begin, 
+                date_end, 
+                status, 
+                logo, 
+                summary 
+        FROM " . CR_TABLE_1 . " 
+        ORDER BY date_begin DESC;");
 
-while($contest = pwg_db_fetch_assoc($contests)){
-        if($contest['visible'] OR is_admin()){
+while ($contest = pwg_db_fetch_assoc($contests)) {
+        if ($contest['visible'] OR is_admin()) {
                 // infos sur le concours
                 $item =  array(
@@ -19 +28 @@
                         'DATE_BEGIN' => format_date($contest['date_begin']),
                         'LOGO' => $contest['logo'],
-                        'SUMMARY' => trigger_event('render_CR_content', $contest['summary']),
+                        'SUMMARY' => CR_cut_string(trigger_event('render_CR_content', $contest['summary']), 350),
                         'URL' => CR_PUBLIC . $contest['id'] . '-' . str2url(trigger_event('render_CR_content', $contest['name'])),
                 );
                 
                 // podium si terminé
-                if($contest['status'] == 'finished'){
-                        $query = "SELECT
+                if ($contest['status'] == 'finished') {
+                        $results = pwg_query("SELECT
                                         i.id,
                                         i.name,
@@ -38 +47 @@
                                 WHERE c.contest_id = " . $contest['id'] . "
                                 ORDER BY c.rank ASC
-                                LIMIT 3 OFFSET 0;";
-                        $results = pwg_query($query);
+                                LIMIT 3 OFFSET 0;");
                         
-                        while($result = pwg_db_fetch_assoc($results)){
+                        while ($result = pwg_db_fetch_assoc($results)) {
                                 $item['RESULTS'][$result['rank']] = array(
                                         'RANK' => $result['rank'],
@@ -50 +58 @@
                 }
 
-                $template->append('contests_'.$contest['status'], $item);
+                $template->append('contests', $item);
         }
 }