CSubscription::CleanUp

static function CleanUp()
{
	global $DB;
	$interval = intval(COption::GetOptionString("subscribe", "subscribe_confirm_period"));
	if($interval > 0)
	{
		$strSql =
			"SELECT ID ".
			"FROM b_subscription ".
			"WHERE CONFIRMED<>'Y' AND DATE_CONFIRM < DATE_ADD(now(), INTERVAL -".$interval." DAY) ";
		$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
		$sIn = "0";
		while($res_arr = $res->Fetch())
			$sIn .= ",".$res_arr["ID"];

		$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 "CSubscription::CleanUp();";
}