query("SELECT a.*,c.name category FROM articles a LEFT JOIN article_categories c ON c.id=a.category_id WHERE a.status='published' ORDER BY a.published_at DESC,a.id DESC LIMIT 3")->fetchAll();
$events=$pdo->query("SELECT e.*,m.max_players,m.registration_required FROM events e LEFT JOIN clan_calendar_meta m ON m.event_id=e.id WHERE e.event_date IS NOT NULL AND e.event_date>=NOW() ORDER BY e.event_date LIMIT 4")->fetchAll();
$photos=$pdo->query("SELECT * FROM gallery_images ORDER BY id DESC LIMIT 5")->fetchAll();
$articlesDemo=false;
$eventsDemo=false;
$clanName=site_setting('site_name','Les Tontons Flingueurs');
$clanTag=site_setting('site_tag','LTF_1');
$community=site_setting('site_community','FR');
$clanFounded=site_setting('clan_founded','2026');
$wotClanUrl=site_setting('wot_clan_url','https://worldoftanks.eu/fr/clanwars/');
$discordUrl=site_setting('discord_url','https://discord.com/');
require __DIR__.'/inc/header.php';
?>
)?>){kind=icon}
DERNIÈRES ACTUALITÉS)?>){kind=icon}
NOS SOUVENIRS)?>){kind=icon}
REJOINDRE LE CLAN →)?>){kind=icon}
DÉCOUVRIR LE CLAN →)?>){kind=icon}
)?>){kind=icon}
)?>){kind=icon}
)?>){kind=icon}
)?>){kind=icon}
)?>){kind=icon}
)?>)
)?>){kind=icon}
REJOINDRE LE SERVEUR →