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

<?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'] .";");
        
        $registered_ids = array();
        $_DUPLICATE = array();
        
        foreach ($_POST['results'] AS $i => $data) {
                if (!in_array($data['image_id'], $registered_ids)) {
                        $registered_ids[] = $data['image_id'];
                        
                        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'] . "'
                                );");
                
                } else {
                        $_DUPLICATE[] = $data;
                }
        }
        
        if (isset($_GET['redirect']) AND $_GET['redirect'] == 'page') {
                redirect(CR_PUBLIC . $_GET['contest_id'] . '-' . str2url(trigger_event('render_CR_content', get_contest_name($_GET['contest_id']))) . '#results');
        } else if (!isset($_DUPLICATE)) {
                $page['infos'][] = l10n('CR_results_saved');
        }
}

// +-----------------------------------------------------------------------+
//                              Affichage des résultats
// +-----------------------------------------------------------------------+

if (!get_contest_name($_GET['contest_id'])) {
        redirect(CR_ADMIN .'-manage&amp;msg=errors.notavailable');
        
} else {
        // 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 en double
        if (isset($_DUPLICATE)) {
                foreach ($_DUPLICATE AS $result) {
                        $data = array(
                                'RANK' => 0,
                                'IMAGE_ID' => $result['image_id'],
                                'AUTHOR' => $result['author'],
                                'COMMENT' => $result['comment'],
                                'ERROR' => true,
                        );
                        
                        // 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';            
                        } 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'];
                        }
                        
                        $page['errors'][] = l10n_dec('CR_duplicate_result %d', 'CR_duplicate_result %d', $result['image_id']);
                        $template->append('results', $data);
                }
        }

        // Résultats enregistrés
        $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';
                        $data['ERROR'] = true;
                        $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');
}

?>