Hi everyone. I wonder if anyone would know how to query WHMcs to see if a certain product add-on has been added to an order. This would be a very similar query to what is written into invoices.php - that lists hosting add-ons. (although I can't see it because the file is encoded.)
I see that this type of information is stored in table: tblhostingaddons - and there are three identifying columns "id", "orderid", and "hostingid"
However, I am not the best at creating queries.
The goal is to take an action based if on order includes an add-on for Sitebuilder access.
This column name where the add-on is named is "name" and if this column contains text "Sitebuilder Access" - then the query should return positive.
Thank you for your help.