[3905] | 1 | <?php |
---|
| 2 | if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); |
---|
| 3 | |
---|
| 4 | global $template; |
---|
| 5 | |
---|
| 6 | // Publish the result on a global page. |
---|
| 7 | // Mode global ==> simply display global result |
---|
| 8 | // Mode full ==> display global result and user notations |
---|
| 9 | |
---|
| 10 | $ap_id = explode('concours/' , $_SERVER['REQUEST_URI']); |
---|
| 11 | $id_concours = $ap_id[1]; |
---|
| 12 | |
---|
| 13 | $concours = new Concours($id_concours); |
---|
| 14 | |
---|
| 15 | $category = $concours->concours_infos['category']; |
---|
| 16 | |
---|
| 17 | $query = 'SELECT DISTINCT(img.id), img.name, img.file, img.path, img.tn_ext, |
---|
| 18 | ic.category_id, cat.name AS catname, conc.note' |
---|
| 19 | .' FROM ' . IMAGES_TABLE.' AS img' |
---|
| 20 | .' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON img.id = ic.image_id' |
---|
| 21 | .' INNER JOIN '.CATEGORIES_TABLE.' AS cat ON ic.category_id = cat.id' |
---|
| 22 | .' INNER JOIN '.CONCOURS_RESULT_TABLE.' AS conc ON conc.img_id = img.id' |
---|
| 23 | .' WHERE ic.category_id = '.$concours->concours_infos['category'] |
---|
| 24 | .' ORDER by note DESC;'; |
---|
| 25 | $result = pwg_query($query); |
---|
| 26 | $rang = 1; |
---|
| 27 | while ($row = mysql_fetch_assoc($result)) |
---|
| 28 | { |
---|
| 29 | // link on picture.php page |
---|
| 30 | set_make_full_url(); |
---|
| 31 | if ( isset($row['category_id']) & isset($row['catname']) ) |
---|
| 32 | { |
---|
| 33 | $url = duplicate_picture_url( |
---|
| 34 | array( |
---|
| 35 | 'image_id' => $row['id'], |
---|
| 36 | 'image_file' => $row['file'], |
---|
| 37 | 'category' => array( |
---|
| 38 | 'id' => $row['category_id'], |
---|
| 39 | 'name' => $row['catname'], |
---|
| 40 | 'permalink' => '' |
---|
| 41 | ) |
---|
| 42 | ), |
---|
| 43 | array('start') |
---|
| 44 | ); |
---|
| 45 | } |
---|
| 46 | else |
---|
| 47 | { |
---|
| 48 | $url = duplicate_picture_url( |
---|
| 49 | array( |
---|
| 50 | 'image_id' => $row['id'], |
---|
| 51 | 'image_file' => $row['file'] |
---|
| 52 | ), |
---|
| 53 | array('start') |
---|
| 54 | ); |
---|
| 55 | } |
---|
| 56 | unset_make_full_url(); |
---|
| 57 | |
---|
| 58 | $template->append( 'concours_note', array( |
---|
| 59 | 'img_id' => $row['id'], |
---|
| 60 | 'name' => $row['name'], |
---|
| 61 | 'file' => $row['file'], |
---|
| 62 | 'rang' => $rang, |
---|
| 63 | 'thumb' => get_thumbnail_url($row), |
---|
| 64 | 'url' => $url, |
---|
| 65 | 'note' => ($row['note'] == 0 ? 'N/A' :$row['note']) |
---|
| 66 | )); |
---|
| 67 | $rang ++; |
---|
| 68 | |
---|
| 69 | } |
---|
| 70 | // Envoi de la page |
---|
| 71 | $template->assign(array( |
---|
| 72 | 'TITLE' => "Concours : ".$concours->concours_infos['name'])); |
---|
| 73 | |
---|
| 74 | $template->assign('IMG_URL', CONCOURS_IMG_PATH); |
---|
| 75 | |
---|
| 76 | $template->set_filenames(array('concours_result' => CONCOURS_ROOT.'/template/result.tpl')); |
---|
| 77 | $template->concat('PLUGIN_INDEX_CONTENT_BEGIN', $template->parse('concours_result', true)); |
---|
| 78 | |
---|
| 79 | |
---|
| 80 | $template->assign('PLUGIN_INDEX_ACTIONS' , ' |
---|
| 81 | <li><a href="' . make_index_url() . '" title="' . l10n('return to homepage') . '"> |
---|
| 82 | <img src="' . $template->get_themeconf('icon_dir') . '/home.png" class="button" alt="' . l10n('home') . '"/></a> |
---|
| 83 | </li>'); |
---|
| 84 | |
---|
| 85 | if (is_admin()) |
---|
| 86 | { |
---|
| 87 | $template->assign('U_EDIT', PHPWG_ROOT_PATH . 'admin.php?page=plugin&section=' . CONCOURS_DIR . '%2Fadmin%2Fadd_concours.php&concours=' . $id_concours.'&action=edit'); |
---|
| 88 | } |
---|
| 89 | |
---|
| 90 | $template->clear_assign(array('U_MODE_POSTED', 'U_MODE_CREATED')); |
---|
| 91 | |
---|
| 92 | ?> |
---|