gctools-outilsgc / gcconnex

 */

function get_subscribers($dbprefix, $user_guid, $entity_guid = '') {

	$subscribed_to = ($entity_guid != '') ? $entity_guid : $user_guid;

	$query = "	SELECT DISTINCT u.guid, u.email, u.username, u.name

				FROM {$dbprefix}entity_relationships r LEFT JOIN {$dbprefix}users_entity u ON r.guid_one = u.guid

				WHERE r.guid_one <> {$user_guid} AND r.relationship = 'cp_subscribed_to_email' AND r.guid_two = {$subscribed_to}";

	return get_data($query);

}

function get_site_subscribers($dbprefix, $user_guid, $entity_guid = '') {

	$subscribed_to = ($entity_guid != '') ? $entity_guid : $user_guid;

	return get_data($query);

}

function get_site_subscribers($dbprefix, $user_guid, $entity_guid = '') {

	$subscribed_to = ($entity_guid != '') ? $entity_guid : $user_guid;

	$query = " SELECT DISTINCT u.guid, u.email, u.username, u.name

	FROM {$dbprefix}entity_relationships r LEFT JOIN {$dbprefix}users_entity u ON r.guid_one = u.guid

	WHERE r.guid_one <> {$user_guid} AND r.relationship = 'cp_subscribed_to_site_mail' AND r.guid_two = {$subscribed_to}";

	return get_data($query);

}

/**