In case you were wondering from my last post, here is how to get a list of all modules by Portal:
SELECT DISTINCT ModuleDefinitions.ModuleDefID, ModuleDefinitions.FriendlyName, Modules.PortalID
FROM ModuleDefinitions CROSS JOIN
Modules LEFT OUTER JOIN
Modules AS Modules_1 ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID
WHERE (Modules.ModuleDefID IS NOT NULL) ORDER BY Modules.PortalID
Here is how to specify a specific portal in the installation:
SELECT DISTINCT ModuleDefinitions.ModuleDefID, ModuleDefinitions.FriendlyName, Modules.PortalID
FROM ModuleDefinitions CROSS JOIN
Modules LEFT OUTER JOIN
Modules AS Modules_1 ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID
WHERE (Modules.ModuleDefID IS NOT NULL) AND (Modules.PortalID = 0)