Changeset 6782 for extensions/ContestResults/admin/results.php

Timestamp:

Aug 20, 2010, 12:33:47 PM (14 years ago)

Author:

mistic100

Message:

Fixs some errors. Add results previews. Code revision.

File:

• extensions/ContestResults/admin/results.php (modified) (2 diffs)

extensions/ContestResults/admin/results.php

@@ -25 +25 @@
 
 // +-----------------------------------------------------------------------+
-//                      Suppression d'un résultat
-// +-----------------------------------------------------------------------+
-if(isset($_GET['delete_result'])){
-        pwg_query('DELETE FROM ' . CR_TABLE_2 . ' WHERE contest_id = ' . $_GET['contest_id'] . ' AND image_id = ' . $_GET['delete_result'] . ';');
-        redirect(CR_ADMIN . '&tab=results&contest_id=' . $_GET['contest_id']);
-}
-
-// +-----------------------------------------------------------------------+
 //                      Affichage des résultats
 // +-----------------------------------------------------------------------+
@@ -46 +38 @@
 
 while($result = pwg_db_fetch_assoc($results)){
-        $template->append('results', array(
+        $data = array(
                 'RANK' => $result['rank'],
-                'ID' => $result['image_id'],
+                'IMAGE_ID' => $result['image_id'],
                 'AUTHOR' => $result['author'],
                 'COMMENT' => $result['comment'],
                 'U_DELETE' => CR_ADMIN . '&tab=results&contest_id=' . $_GET['contest_id'] . '&delete_result=' . $result['image_id'],
-        ));
+        );
+        
+        // Infos de l'image
+        $query = "SELECT id, name, file, path, tn_ext
+                FROM " . IMAGES_TABLE . "
+                WHERE id = " . $result['image_id'] . ";";
+        $image = pwg_query($query);
+        
+        if(!pwg_db_num_rows($image)){
+                $themeconf = $template->get_template_vars('themeconf');
+                $data['TN_SRC'] = $themeconf['admin_icon_dir'] . '/errors.png';
+                $data['IMAGE_NAME'] = 'N/A';
+                $page['errors'][] = l10n_dec('CR_id_unknown %d', 'CR_id_unknown %d', $result['image_id']);
+        }else{
+                $image = pwg_db_fetch_assoc($image);
+                $data['TN_SRC'] = get_thumbnail_url($image);
+                $data['IMAGE_NAME'] = (empty($image['name'])) ? get_name_from_file($image['file']) : $image['name'];
+        }
+        
+        $template->append('results', $data);
 }