source: extensions/ContestResults/admin/results.php @ 9419

<?php
if(!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

// +-----------------------------------------------------------------------+
//                              Modification des résultats
// +-----------------------------------------------------------------------+
if (isset($_POST['results_modify'])) {
        pwg_query("DELETE FROM " . CR_TABLE_2 . " WHERE `contest_id` = " . $_GET['contest_id'] .";");
        
        foreach ($_POST['results'] AS $i => $data) {
                pwg_query("INSERT INTO " . CR_TABLE_2 . "
                        (
                                image_id, 
                                contest_id, 
                                rank,
                                comment, 
                                author
                        )
                        VALUES(
                                '" . $data['image_id'] ."',
                                '" . $_GET['contest_id'] ."',
                                '" . $data['rank'] ."',
                                '" . $data['comment'] ."',
                                '" . $data['author'] . "'
                        );");
        }
        
        redirect(CR_ADMIN . '&amp;tab=results&amp;msg=saved&amp;contest_id=' . $_GET['contest_id']);
}

// +-----------------------------------------------------------------------+
//                              Affichage des résultats
// +-----------------------------------------------------------------------+
if (isset($_GET['msg']) AND $_GET['msg'] == 'saved')
        array_push($page['infos'], l10n('CR_results_saved'));
        
        
// Nom du concours
$query = "SELECT name FROM " . CR_TABLE_1 . " WHERE id = " . $_GET['contest_id'] . ";";
$contest = pwg_db_fetch_assoc(pwg_query($query));

$template->assign(array(
        'NAME' => trigger_event('render_CR_content', $contest['name']),
        'CONTEST_ID' => $_GET['contest_id']
));

// Résultats
$results = pwg_query("SELECT * FROM " . CR_TABLE_2 . " WHERE contest_id = " . $_GET['contest_id'] . " ORDER BY rank;");

while ($result = pwg_db_fetch_assoc($results)) {
        $data = array(
                'RANK' => $result['rank'],
                'IMAGE_ID' => $result['image_id'],
                'AUTHOR' => $result['author'],
                'COMMENT' => $result['comment'],
        );
        
        // Infos de l'image
        $image = pwg_query("SELECT id, name, file, path, tn_ext
                FROM " . IMAGES_TABLE . "
                WHERE id = " . $result['image_id'] . ";");
        
        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);
}

// +-----------------------------------------------------------------------+
//                              Template
// +-----------------------------------------------------------------------+
$template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/template/results.tpl'));
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
?>