---
- name: RM10252 - PHP EOL Checker
  hosts: all
  gather_facts: false

  tasks:
    - name: Get Info
      plesk_info:
      register: plsk

    - name: Execute PHP EOL checker command
      when: plsk.plesk_found
      ansible.builtin.shell: |
        set -o pipefail
        plesk db -Ne "select d.name,h.php_handler_id
                      from domains d
                      join hosting h on h.dom_id=d.id
                      join sys_users s on s.id=h.sys_user_id" \
        | grep "plesk-php81\|plesk-php80\|plesk-php7\|plesk-php5"
      args:
        executable: /bin/bash
      changed_when: false
      register: php_eol

    - name: Show servers that are still using PHP EOL
      ansible.builtin.debug:
        msg: "{{ php_eol.stdout_lines | default([]) }}"