eduVPN / vpn-server-api

     *

     * @param int $timeStamp the unix timestamp before which to remove all log entries

     */

    public function housekeeping($timeStamp)

    {

        $stmt = $this->db->prepare(

            sprintf(

                'DELETE FROM %s 

                    WHERE disconnect_time_unix < :time_stamp',

                $this->prefix.'connections'

            )

        );

        $stmt->bindValue(':time_stamp', $timeStamp, PDO::PARAM_INT);

        $stmt->execute();

        return $stmt->rowCount();

    }

    public function initDatabase()

    {

        return true;

    }

    public function housekeeping($timeUnix)

    {

        $stmt = $this->db->prepare(

            sprintf(

                'DELETE FROM %s 

                    WHERE time_unix < :time_unix',

                $this->prefix.'otp_log'

            )

        );

        $stmt->bindValue(':time_unix', $timeUnix, PDO::PARAM_INT);

        $stmt->execute();

    }

    public static function createTableQueries($prefix)

    {