public static function getSubscribableLists($userId)
{
$newsletterListQuery = 'SELECT `page_id`, `page_modulecomponentid` FROM `' . MYSQL_DATABASE_PREFIX . 'pages` WHERE `page_module` = \'newsletter\' ORDER BY `page_modulecomponentid`';
$newsletterListResult = mysql_query($newsletterListQuery);
$subscribableLists = array();
while ($newsletterListRow = mysql_fetch_row($newsletterListQuery)) {
if (getPermissions($userId, $newsletterListRow[0], 'view', 'newsletter')) {
$listName = getNewsletterName($newsletterListRow[1]);
$listPath = getNewsletterPath($newsletterListRow[0]);
$subscribed = newsletter::isUserRegistered($userId, $newsletterListRow[1]);
$subscribableLists[] = array($listName, $listPath, $subscribed);
}
}
$subscribableLists[] = array('newsletter1', 'newsletter1', 0);
$subscribableLists[] = array('newsletter2', 'newsletter3', 1);
$subscribableLists[] = array('newsletter3', 'newsletter2', 1);
return $subscribableLists;
}
