So I'm pretty much trying to develop a local plugin for moodle that consists of a bulk command: to change the certificates of the users selected to status 4 - expired(certificates present in the Course Category selected)
So I was thinking I should first show a List of all Course Categories / a simple textbox for entering the course category ID.
Followed by a page where I would show a Multiple Selector( the one with (Add <) and (Remove >) which moves the users from the right column to the left column)-- example at /admin/roles/admins.php
Therefore as I'm really new to moodle development but got about 4 years in PHP and different programing languages, I'd really enjoy some tips/ideas/code demonstrations on how should I approach this.
I could do a simple SQL query to get all the course categories but I'm really not sure on how does the certificates match the course IDs(what table, what column)
Would appreciate some help, thank you!