CSubscriptionGeneral::OnUserDelete

static function OnUserDelete($user_id)
{
	//clear user subscriptions on user deletion
	global $DB;
	$user_id = intval($user_id);

	$strSql = "SELECT ID FROM b_subscription WHERE USER_ID = ".$user_id;
	$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
	$arIn = array();
	while($res_arr = $res->Fetch())
		$arIn[] = intval($res_arr["ID"]);

	if(count($arIn) > 0)
	{
		$sIn = implode(",",$arIn);
		if(
			$DB->Query("DELETE FROM b_subscription_rubric WHERE SUBSCRIPTION_ID IN (".$sIn.")", false, "File: ".__FILE__."
Line: ".__LINE__) &&
			$DB->Query("DELETE FROM b_subscription WHERE ID IN (".$sIn.")", false, "File: ".__FILE__."
Line: ".__LINE__)
		)
			return true;
		else
			return false;
	}
	else
	{
		return true;
	}
}