eduVPN / vpn-server-api

    /**

     * @return array|false

     */

    public function getUserCertificateInfo($commonName)

    {

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

<<< 'SQL'

    SELECT 

        u.user_id AS user_id, 

        u.is_disabled AS user_is_disabled,

        c.display_name AS display_name,

        c.is_disabled AS certificate_is_disabled 

    FROM 

        users u, certificates c 

    WHERE 

        u.user_id = c.user_id AND 

        c.common_name = :common_name

SQL

        );

        $stmt->bindValue(':common_name', $commonName, PDO::PARAM_STR);

        $stmt->execute();

        return true;

    }

    public function cleanConnectionLog(DateTime $dateTime)

    {

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

<<< 'SQL'

    DELETE FROM

        connection_log

    WHERE

        connected_at < :date_time

    AND

        disconnected_at IS NOT NULL

SQL

        );

        $stmt->bindValue(':date_time', $dateTime->format('Y-m-d H:i:s'), PDO::PARAM_STR);

        return $stmt->execute();

    }

        return $stmt->execute();

    }

    public function cleanUserMessages(DateTime $dateTime)

    {

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

<<< 'SQL'

    DELETE FROM

        user_messages

    WHERE

        date_time < :date_time

SQL

        );

        $stmt->bindValue(':date_time', $dateTime->format('Y-m-d H:i:s'), PDO::PARAM_STR);

        return $stmt->execute();

    }

    public function cleanTotpLog(DateTime $dateTime)

    {

        return $stmt->execute();

    }

    public function cleanTotpLog(DateTime $dateTime)

    {

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

<<< 'SQL'

    DELETE FROM 

        totp_log

    WHERE 

        date_time < :date_time

SQL

        );

        $stmt->bindValue(':date_time', $dateTime->format('Y-m-d H:i:s'), PDO::PARAM_STR);

        return $stmt->execute();

    }

    /**

     * @return array

    /**

     * @return array

     */

    public function systemMessages($type)

    {

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

<<< 'SQL'

    SELECT

        id, message, date_time 

    FROM 

        system_messages

    WHERE

        type = :type

SQL

        );

        $stmt->bindValue(':type', $type, PDO::PARAM_STR);

        $stmt->execute();

        return $stmt->fetchAll(PDO::FETCH_ASSOC);

    }

    public function addSystemMessage($type, $message)

    {