public static function getCountriesForContinent($continent)
{
/** @var RegionDataProvider $regionDataProvider */
$regionDataProvider = StaticContainer::get('Piwik\\Intl\\Data\\Provider\\RegionDataProvider');
$result = array();
$continent = strtolower($continent);
foreach ($regionDataProvider->getCountryList() as $countryCode => $continentCode) {
if ($continent == $continentCode) {
$result[] = $countryCode;
}
}
return array('SQL' => "'" . implode("', '", $result) . "', ?", 'bind' => '-');
// HACK: SegmentExpression requires a $bind, even if there's nothing to bind
}