CSubscription::GetByEmail

static function GetByEmail($email, $user_id = false)
{
	global $DB;

	if($user_id === false)
		$sWhere = "";
	elseif($user_id > 0)
		$sWhere = "AND S.USER_ID = ".intval($user_id);
	else
		$sWhere = "AND S.USER_ID IS NULL";

	$strSql = "
		SELECT S.*,
			".$DB->DateToCharFunction("S.DATE_UPDATE", "FULL")." AS DATE_UPDATE,
			".$DB->DateToCharFunction("S.DATE_INSERT", "FULL")." AS DATE_INSERT,
			".$DB->DateToCharFunction("S.DATE_CONFIRM", "FULL")." AS DATE_CONFIRM
		FROM
			b_subscription S
		WHERE
			S.EMAIL='".$DB->ForSQL($email)."'
			".$sWhere."
	";

	return $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}