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

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

// +-----------------------------------------------------------------------+
//                              Liste des concours
// +-----------------------------------------------------------------------+
$contests = pwg_query("SELECT 
                id, 
                name, 
                visible, 
                date_begin, 
                date_end, 
                logo, 
                summary 
        FROM " . CR_TABLE_1 . " 
        ORDER BY date_begin DESC;");

while ($contest = pwg_db_fetch_assoc($contests)) {
        $contest = array_merge($contest, get_contest_status($contest['date_begin'],$contest['date_end']));
                
        if ($contest['visible'] OR is_admin()) {
                // infos sur le concours
                $item =  array(
                        'ID' => $contest['id'],
                        'NAME' => trigger_event('render_element_name', $contest['name']),
                        'VISIBLE' => $contest['visible'],
                        'STATUS' => $contest['status'],
                        'DATE_END' => format_date($contest['date_end']),
                        'DATE_BEGIN' => format_date($contest['date_begin']),
                        'LOGO' => $contest['logo'],
                        'SUMMARY' => CR_cut_string(trigger_event('render_category_name', $contest['summary']), $conf['ContestResults']['truncate_summary']),
                        'URL' => CR_PUBLIC . $contest['id'] . '-' . str2url(trigger_event('render_category_name', $contest['name'])),
                        'DAYS' => $contest['days'],
                );
                
                // podium si terminé
                if ($contest['status'] == 'finished') {
                        $results = pwg_query("SELECT
                                        i.id,
                                        i.name,
                                        i.file,
                                        i.path,
                                        i.tn_ext,
                                        c.rank,
                                        c.author
                                FROM " . IMAGES_TABLE . " AS i
                                INNER JOIN " . CR_TABLE_2 . " AS c
                                ON c.image_id = i.id
                                WHERE c.contest_id = " . $contest['id'] . "
                                ORDER BY c.rank ASC
                                LIMIT 3 OFFSET 0;");
                        
                        while ($result = pwg_db_fetch_assoc($results)) {
                                $item['RESULTS'][$result['rank']] = array(
                                        'RANK' => $result['rank'],
                                        'AUTHOR' => $result['author'],
                                        'TN_SRC' => get_thumbnail_url($result)
                                );
                        }
                }

                $template->append('contests', $item);
        }
}

$template->set_filenames(array('index'=> dirname(__FILE__).'/../template/cr_main.tpl'));

// +-----------------------------------------------------------------------+
//                              Template
// +-----------------------------------------------------------------------+
if (is_admin()) {
        $template->assign('U_EDIT', CR_ADMIN);
}
$template->assign('CR_PATH', CR_PATH);
$template->assign('SEPARATOR', $conf['level_separator']);
?>