VIPnytt / RobotsTxtParser

     * @param int|null $workerID

     * @return bool

     */

    private function markAsActive($base, $workerID = 0)

    {

        if ($workerID == 0) {

            $query = $this->pdo->prepare(<<<SQL

UPDATE robotstxt__cache1

SET worker = NULL

WHERE base = :base AND worker = 0;

SQL

            );

            $query->bindParam(':base', $base, PDO::PARAM_STR);

            return $query->execute();

        }

        return true;

    }

    /**

     * Update an robots.txt in the database

     * @param int $delay - in seconds

     * @return bool

     */

    public function clean($delay)

    {

        $delay = self::CACHE_TIME + $delay;

        $query = $this->pdo->prepare(<<<SQL

DELETE FROM robotstxt__cache1

WHERE (worker = 0 OR worker IS NULL) AND nextUpdate < (UNIX_TIMESTAMP() - :delay);

SQL

        );

        $query->bindParam(':delay', $delay, PDO::PARAM_INT);

        return $query->execute();

    }

}

     * @param int $delay - in seconds

     * @return bool

     */

    public function clean($delay = 60)

    {

        $query = $this->pdo->prepare(<<<SQL

DELETE FROM robotstxt__delay0

WHERE delayUntil < ((UNIX_TIMESTAMP() - :delay) * 1000000);

SQL

        );

        $query->bindParam(':delay', $delay, PDO::PARAM_INT);

        return $query->execute();

    }

    /**

     * Top X wait time