function getSubscribers(&$subs)
{
global $db;
if (!empty($this->_dbo->category_parent)) {
$category = new Category($this->_dbo->category_parent);
$category->getSubscribers(&$subs);
}
$q = $db->prepare("SELECT s.user_id, s.category_id, u.user_email, u.user_name, u.user_login, c.category_name FROM phph_subscriptions s INNER JOIN phph_users u ON s.user_id = u.user_id INNER JOIN phph_categories c ON c.category_id = s.category_id WHERE s.category_id = ?");
$res = $db->execute($q, array($this->_cid));
while ($row = $res->fetchRow()) {
$subs[$row['user_id']]['user_login'] = $row['user_login'];
$subs[$row['user_id']]['user_name'] = $row['user_name'];
$subs[$row['user_id']]['user_email'] = $row['user_email'];
$subs[$row['user_id']]['cids'][$row['category_id']]['category_name'] = $row['category_name'];
}
}
