source: extensions/ConcoursPhoto/publish.php @ 6650

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

global $template;

// Publish the result on a global page.
// Mode global ==> simply display global result
// Mode full ==> display global result and user notations

$ap_id = explode('concours/' , $_SERVER['REQUEST_URI']);
$id_concours = $ap_id[1];

$concours = new Concours($id_concours);

                $template->assign( 'CONCOURS', array(
                                'ID'    => $concours->concours_infos['id'],
                                'NAME'  => $concours->concours_infos['name'],
                                'DESCR' => $concours->concours_infos['descr'],
                                'BEGIN_DATE'    => $concours->concours_infos['begin_date'],
                                'END_DATE'      => $concours->concours_infos['end_date'],
                                'METHOD'        => l10n("concours_method".$concours->concours_infos['method'])
                                ));


$category = $concours->concours_infos['category'];

if (!(isset($concours->concours_infos['method'])))
        $concours->concours_infos['method'] = 1;

$query = 'SELECT DISTINCT(img.id), img.name, img.file, img.path, img.tn_ext,img.author, 
                  ic.category_id, cat.name AS catname, conc.note, conc.moyenne, conc.nbvotant'
                .' FROM ' . IMAGES_TABLE.' AS img'
                .' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON img.id = ic.image_id'
                .' INNER JOIN '.CATEGORIES_TABLE.' AS cat ON ic.category_id = cat.id'
                .' INNER JOIN '.CONCOURS_RESULT_TABLE.' AS conc ON conc.img_id = img.id'
                .' WHERE ic.category_id = '.$concours->concours_infos['category'];

if ($concours->concours_infos['method'] == 1)   // total
        $query .= ' ORDER BY note DESC';
elseif ($concours->concours_infos['method'] == 2)       // moyenne
        $query .= ' ORDER BY moyenne DESC';

$query .=';';
//              .' ORDER by note DESC;';
$result = pwg_query($query);
$rang = 1;
while ($row = mysql_fetch_assoc($result))
{
        // link on picture.php page
        set_make_full_url();
        if ( isset($row['category_id']) & isset($row['catname']) ) 
        {
                $url = duplicate_picture_url(
                array(
                'image_id' => $row['id'],
                'image_file' => $row['file'],
                'category' => array(
                                                'id' => $row['category_id'],
                                                'name' => $row['catname'],
                                                'permalink' => ''
                                          )
                ),
                array('start')
                );
        }
        else
        {
                $url = duplicate_picture_url(
                  array(
                        'image_id' => $row['id'],
                        'image_file' => $row['file']
                  ),
                  array('start')
                );
        }       
        unset_make_full_url();

        $template->append( 'concours_note', array(
                        'img_id' => $row['id'],
                        'name'  => $row['name'],
                        'file'  => $row['file'],
                        'author'        => $row['author'],
                        'rang'  => $rang,
                        'thumb' => get_thumbnail_url($row),
                        'url'   => $url,
                        'note'  => ($row['note'] == 0 ? 'N/A' :$row['note']),
                        'moyenne'       => ($row['moyenne'] == 0 ? 'N/A' :$row['moyenne']),
                        'nbvotant'      => $row['nbvotant'],
                        'usernote'      => $concours->get_img_globalnote_user($row['id'])
                        
                ));
        $rang ++;

}
// Envoi de la page
$template->assign(array(
  'TITLE' => "Concours : ".$concours->concours_infos['name']));

$template->assign('IMG_URL', CONCOURS_IMG_PATH);

$template->set_filenames(array('concours_result' =>  CONCOURS_ROOT.'/template/result.tpl'));
$template->concat('PLUGIN_INDEX_CONTENT_BEGIN', $template->parse('concours_result', true));
  
  
  $template->assign('PLUGIN_INDEX_ACTIONS' , '
    <li><a href="' . make_index_url() . '" title="' . l10n('return to homepage') . '">
      <img src="' . $template->get_themeconf('icon_dir') . '/home.png" class="button" alt="' . l10n('home') . '"/></a>
    </li>');

if (is_admin())
{
  $template->assign('U_EDIT', PHPWG_ROOT_PATH . 'admin.php?page=plugin&amp;section=' . CONCOURS_DIR . '%2Fadmin%2Fadd_concours.php&amp;concours=' . $id_concours.'&amp;action=edit');
}

$template->clear_assign(array('U_MODE_POSTED', 'U_MODE_CREATED'));

?>