Forum

<?php
require_once('clans_begin.php');
 
function last_matchs_mini($position, $block)
{
 global $Cache, $Template,$Sql,$CLANS_LANG;
 load_module_lang('clans');
    $Cache->load('clans'); //Chargement du cache
$tpl = new Template('clans/last_matchs_mini.tpl');
    import('core/menu_service');
    MenuService::assign_positions_conditions($tpl, $position);
 
$result = $Sql->query_while("SELECT id, opponent, match_date, game, match_type, our_score, opp_score
FROM " . DB_TABLE_CHALLENGES . " WHERE state = 2 ORDER BY match_date DESC LIMIT 0,5", __LINE__, __FILE__);
 
$result2 = $Sql->query_while("SELECT our_score, opp_score
FROM ".DB_TABLE_CHALLENGES." WHERE state = 2 ORDER BY match_date DESC", __LINE__, __FILE__);
 
$nbr_lwars = $Sql->num_rows($result2 , "SELECT COUNT(*) FROM " . DB_TABLE_CHALLENGES . "", __LINE__, __FILE__);
 
if ($nbr_lwars >= 1)
{
// Initiating variables for further use
/*$wins = 0;
$losts = 0;
$draws = 0;
 
for ( $i = 1; $i <= $nbr_lwars; $i++)
{
while ( $row2 = $Sql->fetch_assoc($result2) )
{
if ($row2['our_score'] > $row2['opp_score'])
$wins++;
elseif ($row2['our_score'] < $row2['opp_score'])
$losts++;
else ($row2['our_score'] = $row2['opp_score'])
$draws++;
}
}
 
while( $row = $Sql->fetch_assoc($result) )
{
if ($row['our_score'] > $row['opp_score'])
$backgroundcolor = 'wins';
elseif ($row['our_score'] < $row['opp_score'])
$backgroundcolor = 'losts';
else ($row['our_score'] = $row['opp_score'])
$backgroundcolor = 'draws';
 
$score = $row['our_score'] . "/" . $row['opp_score'];
 
$Template->assign_block_vars('lastmatchs', array(
'ID' => url('.php?id=' . $row['id'], '-' . $row['id'] . '.php'), // To modify
'BACKGROUNDCOLOR' => $backgroundcolor,
'DATE' => date("d/m/Y", $row['match_date']),
'OPPONENT' => $row['opponent'],
'SCORE' => $score,
'MATCHTYPE' => $row['match_type'],
'GAME' => $row['game'],
));
}*/
 
$tpl->assign_vars(array(
'C_LAST_WARS' => true,
'L_ALL_WARS' => $CLANS_LANG['matchs_allchallenges'],
'L_REPORT' => $CLANS_LANG['report'],
'CLANS' => $Template->get_module_data_path('clans'),
'WINS' => (!empty($wins) ? $wins : '0'),
'LOSTS' => (!empty($losts) ? $losts : '0'),
'DRAWS' => (!empty($draws) ? $draws : '0')
));
}
else
$tpl->assign_vars(array(
'C_NO_RESULT' => true,
'L_NO_RESULT' => $CLANS_LANG['mini_no_result'],
));
 
$tpl->assign_vars(array('L_LAST_WARS' => $CLANS_LANG['mini_last_wars']));
 
    //On retourne le contenu du bloc
    return $tpl->parse(TEMPLATE_STRING_MODE);
}
?>

$Template->assign_block_vars('lastmatchs', array(
    ...
));

$tpl->assign_block_vars('lastmatchs', array(
    ...
));