viewing reports also shows disabled reports (+fix)

When viewing all reports (not admin), the dropdown also shows all disabled reports.
The simple fix, in exports-and-reports.php, line 1170 and following change the sql from (removed the backticks in the code):

$sql = '
                SELECT *
                FROM ' . EXPORTS_REPORTS_TBL . 'reports
                WHERE group = %d
                ORDER BY weight, name
        ';

to

$sql = '
                SELECT *
                FROM ' . EXPORTS_REPORTS_TBL . 'reports
                WHERE group = %d AND disabled=0
                ORDER BY weight, name
        ';

• This topic was modified 3 years, 5 months ago by Franky.
• This topic was modified 3 years, 5 months ago by Franky.