public static function CleanUpPreview($DOCUMENT_ID = false) { $err_mess = CWorkflow::err_mess() . "<br>Function: CleanUpPreview<br>Line: "; global $DB; if ($DOCUMENT_ID === false) { $strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tP.FILENAME, D.SITE_ID\n\t\t\t\tFROM\n\t\t\t\t\tb_workflow_document D,\n\t\t\t\t\tb_workflow_preview P\n\t\t\t\tWHERE\n\t\t\t\t\tD.STATUS_ID = 1\n\t\t\t\t\tand P.DOCUMENT_ID = D.ID\n\t\t\t\t"; } else { $DOCUMENT_ID = intval($DOCUMENT_ID); $strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tFILENAME\n\t\t\t\tFROM\n\t\t\t\t\tb_workflow_preview\n\t\t\t\tWHERE\n\t\t\t\t\tDOCUMENT_ID = " . $DOCUMENT_ID . "\n\t\t\t\t"; } $z = $DB->Query($strSql, false, $err_mess . __LINE__); while ($zr = $z->Fetch()) { CWorkflow::DeletePreview($zr["FILENAME"], $zr["SITE"]); } }