/** * Fetches user action logs of link_publishers type that are not yet processed in given environment * @param eZDB $db * @param string $environment * @return array */ function fetchNotProcessedLinkPublishersUserActionLogs( eZDB $db, $environment ) { $query = <<<'EOT' SELECT id, datetime, user_action_log.change, user_id, action, done FROM user_action_log WHERE action = '%s' AND done IN (%s) EOT; $environmentsToProcess = UserActionLog::getEnvironmentCodesToProcess( $environment ); $query = sprintf( $query, UserActionLog::ACTION_LINK_PUBLISHER, implode( $environmentsToProcess, ',' ) ); $result = $db->arrayQuery( $query ); return $result; }