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__); } //agent to delete unconfirmed subscription public 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();"; } }