/** * Method used to remove reminders by using the administrative * interface of the system. * * @access public * @return boolean */ function remove() { global $HTTP_POST_VARS; $items = @implode(", ", Misc::escapeInteger($HTTP_POST_VARS["items"])); $stmt = "DELETE FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "reminder_level\n WHERE\n rem_id IN ({$items})"; $res = $GLOBALS["db_api"]->dbh->query($stmt); if (PEAR::isError($res)) { Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__); return false; } else { Reminder::removeAllAssociations($HTTP_POST_VARS["items"]); $stmt = "SELECT\n rma_id\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "reminder_action\n WHERE\n rma_rem_id IN ({$items})"; $actions = $GLOBALS["db_api"]->dbh->getCol($stmt); if (count($actions) > 0) { Reminder_Action::remove($actions); } return true; } }