<?php

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('arcadeoa');
$user->setup();



$team_id = $request->variable('team', 0);
$cat_id = $request->variable('cat', 0);




$rank_player = Array();

$best_score_first = 0;

//CONFIG
$sql_array = array(
	'SELECT'	=> 'a.config_name, a.config_value',
	'FROM'		=> array(ARCADE_TABLE => 'a'
));

$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);

$config = array();

while( $row = $db->sql_fetchrow($result) )
{
	$config[$row['config_name']] = $row['config_value'];
}
$db->sql_freeresult($result);
//CONFIG




$sql_array2 = array(
	'SELECT'	=> 'g.id',
	'FROM'		=> array(GAMES_TABLE	=> 'g',)
);
$sql2 = $db->sql_build_query('SELECT', $sql_array2);
$result2 = $db->sql_query_limit($sql2, (int)$limit, 0);

while ($row2 = $db->sql_fetchrow($result2))
{
	if($cat_id == 0)
	{
		$sql_array = array(
			'SELECT'	=> 's.id, s.points, s.score_comment, u.username, u.user_colour, u.user_id',
			'FROM'		=> array(SCORES_TABLE	=> 's',),
			'WHERE'		=> 's.game_id = '.$row2['id'],
			'LEFT_JOIN' => array(
				array(
					'FROM' => array(USERS_TABLE => 'u'),
					'ON' => 's.gamer_id = u.user_id ')
				),
			'ORDER_BY' => 's.points'.(($best_score_first) ? '' : ' DESC'),
		);
	}
	else
	{
		$sql_array = array(
			'SELECT'	=> 's.id, s.points, s.score_comment, u.username, u.user_colour, u.user_id',
			'FROM'		=> array(SCORES_TABLE	=> 's',),
			'WHERE'		=> 's.game_id = '.$row2['id'].' and s.cat_id = '.$cat_id,
			'LEFT_JOIN' => array(
				array(
					'FROM' => array(USERS_TABLE => 'u'),
					'ON' => 's.gamer_id = u.user_id ')
				),
			'ORDER_BY' => 's.points'.(($best_score_first) ? '' : ' DESC'),
		);
	}

	$sql = $db->sql_build_query('SELECT', $sql_array);
	$result = $db->sql_query_limit($sql, (int)$limit, 0);

	$rank = 0;
	$top_gamer = array();
	while ($row = $db->sql_fetchrow($result))
	{
		$top_gamer[(int)$row['id']] = $row;
	}
	$db->sql_freeresult($result);

	$rowsNbr = sizeof($top_gamer);

	$i = 0;
	foreach ($top_gamer AS $sid => $score)
	{
		if($i == 0){$rank_player[$score['user_id']] += $config['champ-number_1'];}
		if($i == 1){$rank_player[$score['user_id']] += $config['champ-number_2'];}
		if($i == 2){$rank_player[$score['user_id']] += $config['champ-number_3'];}
		if($i == 3){$rank_player[$score['user_id']] += $config['champ-number_4'];}
		if($i == 4){$rank_player[$score['user_id']] += $config['champ-number_5'];}
		if($i == 5){$rank_player[$score['user_id']] += $config['champ-number_6'];}
		if($i == 6){$rank_player[$score['user_id']] += $config['champ-number_7'];}
		if($i == 7){$rank_player[$score['user_id']] += $config['champ-number_8'];}
		if($i == 8){$rank_player[$score['user_id']] += $config['champ-number_9'];}
		if($i == 9){$rank_player[$score['user_id']] += $config['champ-number_10'];}
		if($i == 10){$rank_player[$score['user_id']] += $config['champ-number_11'];}
		if($i == 11){$rank_player[$score['user_id']] += $config['champ-number_12'];}
		if($i == 12){$rank_player[$score['user_id']] += $config['champ-number_13'];}
		if($i == 13){$rank_player[$score['user_id']] += $config['champ-number_14'];}
		if($i == 14){$rank_player[$score['user_id']] += $config['champ-number_15'];}
		if($i == 15){$rank_player[$score['user_id']] += $config['champ-number_16'];}
		if($i == 16){$rank_player[$score['user_id']] += $config['champ-number_17'];}
		if($i == 17){$rank_player[$score['user_id']] += $config['champ-number_18'];}
		if($i == 18){$rank_player[$score['user_id']] += $config['champ-number_19'];}
		if($i == 19){$rank_player[$score['user_id']] += $config['champ-number_20'];}

		$i++;
	}
}
$db->sql_freeresult($result2);




require("camembert.php");

$camembert = new camembert();
$sql_array = array(
	'SELECT'	=> 'ug.user_id, u.username',
	'FROM'		=>
	array(
	USER_GROUP_TABLE	=> 'ug',
	USERS_TABLE	=> 'u',
	),
	'WHERE'	=> 'ug.user_id = u.user_id and ug.group_id = '.$team_id
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$camembert->add_tab( $rank_player[$row['user_id']], $row['username'] );
}
$db->sql_freeresult($result);

$camembert->trier_tab();


$camembert->stat2png($config['champpos_teamsstat']+1, 15);