SubscriptionSection::GetNumSections PHP Method

    public static function GetNumSections($p_subscriptionId, $p_sectionId = null, $p_languageId = null)
    {
        global $g_ado_db;
        $queryStr = "SELECT count(*) FROM SubsSections WHERE IdSubscription = {$p_subscriptionId}";
        if (!is_null($p_sectionId)) {
            if (is_array($p_sectionId)) {
                $queryStr .= " AND SectionNumber IN (" . implode(", ", $p_sectionId) . ")";
            } else {
                $queryStr .= " AND SectionNumber = {$p_sectionId}";
            }
        }
        if (!is_null($p_languageId)) {
            if (is_array($p_languageId)) {
                $queryStr .= " AND IdLanguage IN (" . implode(", ", $p_languageId) . ")";
            } else {
                $queryStr .= " AND IdLanguage = {$p_languageId}";
            }
        } else {
            $queryStr .= " AND IdLanguage != 0";
        }
        $total = $g_ado_db->GetOne($queryStr);
        return $total;
    }

$manageUser = new User($f_user_id);

$sections = Section::GetUniqueSections($f_publication_id);
$sectionsByLanguage = Section::GetUniqueSections($f_publication_id, true);

$optionsAllLang = array();
foreach ($sections as $section) {
	if (SubscriptionSection::GetNumSections($f_subscription_id, $section['id'], 0) > 0) {
		continue;
	}
	$optionsAllLang[$section['id']] = $section['id'] . ' - ' . $section['name'];
}

$optionsIndividualLang = array();
foreach ($sectionsByLanguage as $section) {
	if (SubscriptionSection::GetNumSections($f_subscription_id, $section['id'], $section['IdLanguage']) > 0) {
		continue;
	}
	$id = $section['id'] . '_' . $section['IdLanguage'];
	$display = $section['id'] . ' - ' . $section['name']
		. ' (' . $section['LangName'] . ')';
	$optionsIndividualLang[$id] = $display;
}

$crumbs = array();
$crumbs[] = array(getGS("Configure"), "");
$crumbs[] = array(getGS("Subscribers"), "/$ADMIN/users/?uType=Subscribers");
$crumbs[] = array(getGS("Account") . " '".$manageUser->getUserName()."'",
			"/$ADMIN/users/edit.php?User=$f_user_id&uType=Subscribers");
$crumbs[] = array(getGS("Subscriptions"), "/$ADMIN/users/subscriptions/?f_user_id=$f_user_id");
$crumbs[] = array(getGS("Subscribed sections").": ".$publicationObj->getName(), "/$ADMIN/users/subscriptions/sections/?f_user_id=$f_user_id&f_subscription_id=$f_subscription_id&f_publication_id=$f_publication_id");