source: extensions/ContestResults/include/cr_comment_picture.php @ 9975

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

// +-----------------------------------------------------------------------+
//              Affichage du commentaire sur la page d'une image participante
// +-----------------------------------------------------------------------+

// Requète simple pour savoir si l'image a participé à des concours 
$participation = pwg_query("SELECT image_id FROM " . CR_TABLE_2 . " WHERE image_id = " . $page['image_id'] . ";");

if(pwg_db_num_rows($participation)){
        // requète complète
        $results = pwg_query("SELECT 
                        i.rank,
                        i.comment,
                        c.name AS contest_name,
                        c.id AS contest_id
                FROM " . CR_TABLE_2 . " AS i
                INNER JOIN " . CR_TABLE_1 . " AS c
                ON i.contest_id = c.id
                WHERE i.image_id = " . $page['image_id'] . "
                ORDER BY c.date_begin DESC;");
        
        // Gère plusieurs participations
        $comment = null;
        while( $result = pwg_db_fetch_assoc($results)) {
                // Rang amélioré
                $result['rank'] = ($result['rank'] <= 3) ? l10n('CR_order_'.$result['rank']) : $result['rank'] . l10n('CR_order_sup');
                
                // Lien vers le concours
                $result['contest_name'] = trigger_event('render_category_name', $result['contest_name']);
                $result['contest_link'] = CR_PUBLIC . $result['contest_id'] . '-' . str2url($result['contest_name']);
                
                // Ajoute le commentaire après la description
                $comment .= '<div class="CR_comment">
                        <b><a href="' . $result['contest_link'] .'">' . $result['contest_name'] . '</a></b> :: <u>' . $result['rank'] . ' ' . l10n('CR_place') . '</u>
                        <p>' . trigger_event('render_category_name', $result['comment']) . '</p>
                </div>';
                
                // Ajoute un lien vers le concours dans les albums
                $template->append('related_categories', '<a href="' . CR_PUBLIC . '">' . l10n('Contests') . '</a>' . $conf['level_separator'] . '<a href="' . $result['contest_link'] . '">' . $result['contest_name'] . '</a>');
        }
        
        // style utilisé pour les blocs des concours
        $css = '<style type="text/css">
                .CR_comment {
                        border:1px solid #404040;
                        padding:10px;
                        margin:10px 20%;
                }
        </style>';

        // +-----------------------------------------------------------------------+
        //                              Template
        // +-----------------------------------------------------------------------+
        $template->assign('COMMENT_IMG', $template->get_template_vars('COMMENT_IMG') . $comment);
        $template->append('footer_elements', $css);
}
?>