Hi, I'm using SS 3.1.2 and the Subsites module. I've extended SiteConfig to add several database fields so that each subsite can enter its own data (Contact info, address, Google map coords, etc.). From the main site I would like to be able to retrieve the subsite data from SiteConfig to list in a template, but so far I am unable to do this. Can anyone offer any help or direction?

Thanks in advance!

This works. Putting this in my controller and looping on $Subsites in the template:

public function getSubsites() {
$db = new SQLQuery();
$db->setFrom('SiteConfig');
$db->setWhere('SubsiteID > 0');
$records = $db->execute();
$items = array();
foreach($records as $record){
$items [] = new $record['ClassName']($record);
}
$sites = new ArrayList();
$sites ->merge($items);
return $sites;
}