Anonymous

<?php/**  * Awards MOD * * @package		phpBB3 * @subpackage	awards_mod * @version		$Id$ * @copyright	(c) 2007 Dean Newman * @license		http://opensource.org/licenses/gpl-license.php GNU Public License  *//*** @ignore*/define('IN_PHPBB', true);$phpbb_root_path = './';$phpEx = substr(strrchr(__FILE__, '.'), 1);include($phpbb_root_path . 'common.' . $phpEx);include($phpbb_root_path . 'includes/functions_awards.' . $phpEx);// Start session management$user->session_begin();$auth->acl($user->data);$user->setup('awards');//// Start Page Proper//$mode		= request_var('mode', '');$award_id	= request_var(POST_AWARDS_URL, '');$cat_id		= request_var(POST_CAT_URL, '');$template->assign_block_vars('navlinks', array(	'U_VIEW_FORUM'	=> append_sid("awards.{$phpEx}"),	'FORUM_NAME'	=> $user->lang['L_AWARDS']));$template->assign_vars($user->lang);switch ( $mode ){	default:		$template->set_filenames(array(			'body' => 'awards_body.html')		);				$template->assign_var('S_DISPLAY_CATS', true);		$sql = $db->sql_build_query('SELECT', array(			'SELECT'	=> 'c.cat_id, c.cat_name, c.cat_desc',			'FROM'		=> array(AWARDS_CATS_TABLE => 'c'),			'WHERE'		=> ($cat_id) ? 'c.cat_id = ' . (int) $cat_id : '',			'ORDER_BY'	=> 'c.cat_order ASC',			'GROUP_BY'	=> 'c.cat_id')		);		$result = $db->sql_query($sql);				$cat_rowset = $cat_ids = $award_rowset = array();		while ( $row = $db->sql_fetchrow($result) )		{			$cat_rowset[]	= $row;			$cat_ids[]		= $row['cat_id'];			$award_rowset[ $row['cat_id'] ] = array();		}				$db->sql_freeresult($result);				if ( sizeof($cat_ids) < 1 )		{			($cat_id) ? trigger_error('L_CAT_NOT_FOUND') : trigger_error('L_NO_CATEGORIES');		}		if ( $cat_id )		{			$template->assign_block_vars('navlinks', array(				'U_VIEW_FORUM'	=> append_sid("awards.{$phpEx}?" . POST_CAT_URL . '=' . (int) $cat_id),				'FORUM_NAME'	=> $cat_rowset[0]['cat_name'])			);		}		if ( sizeof($cat_ids) > 0)		{			$sql = $db->sql_build_query('SELECT', array(				'SELECT'	=> 'a.award_id, a.award_name, a.award_desc, a.award_image, a.cat_id, ( COUNT(u.user_id) + COUNT(m.user_id) ) AS award_users',				'FROM'		=> array(AWARDS_TABLE => 'a'),				'LEFT_JOIN'	=> array(					array(						'FROM'	=> array(AWARDS_USERS_TABLE => 'u'),						'ON'	=> 'a.award_id = u.award_id'),					array(						'FROM'	=> array(AWARDS_MODS_TABLE => 'm'),						'ON'	=> 'a.cat_id = m.cat_id'),				),				'WHERE'		=> 'a.cat_id IN (' . implode(',', $cat_ids) . ')',				'ORDER_BY'	=> 'a.award_name ASC',				'GROUP_BY'	=> 'a.award_name')			);			$result = $db->sql_query($sql);			while ( $row = $db->sql_fetchrow($result) )			{				$award_rowset[ $row['cat_id'] ][]	= $row;			}						$db->sql_freeresult($result);		}		for ( $i = 0 ; $i < sizeof($cat_rowset) ; $i++ )		{			$template->assign_block_vars('catrow', array(				'CAT_ID'		=> $cat_rowset[$i]['cat_id'],				'CAT_NAME'		=> $cat_rowset[$i]['cat_name'],				'CAT_DESC'		=> $cat_rowset[$i]['cat_desc'],				'CAT_AWARDS'	=> sizeof($award_rowset[$cat_rowset[$i]['cat_id']]),								'U_VIEW_CAT'	=> append_sid('awards.' . $phpEx . '?' . POST_CAT_URL . '=' . $cat_rowset[$i]['cat_id']))			);						for ( $j = 0 ; $j < sizeof($award_rowset[$cat_rowset[$i]['cat_id']]) ; $j++ )			{				$awardrow =& $award_rowset[$cat_rowset[$i]['cat_id']][$j];				$template->assign_block_vars('catrow.awardrow', array(					'AWARD_ID'		=> $awardrow['award_id'],					'AWARD_NAME'	=> $awardrow['award_name'],					'AWARD_DESC'	=> $awardrow['award_desc'],					'AWARD_IMG'		=> '<img src="' . $awardrow['award_image'] . '" alt="' . $awardrow['award_name'] . '" />',					'AWARD_USERS'	=> $awardrow['award_users'],										'U_AWARD'		=> append_sid("awards.{$phpEx}?mode=users&amp;" . POST_AWARDS_URL . '=' . $awardrow['award_id']))				);			}		}				break;}page_header();page_footer();?>