<?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']);
?>