Determine Product ID from ShoppingCartCheckoutCompletePage Hook?

[CrimsonGT]

I am currently hooking "ShoppingCartCheckoutCompletePage" and sending a notification e-mail to our admins when it occurs. However, I only want to send a notification when a certain Product is ordered, and I assume I will need to query this from the Database directly, but not sure the best way.

 

How can I determine what Product ID an order is for?

[jclarke]

You need to query the tblhosting table based on the orderid that is given by the hook, if they ordered more than one item then this could be multiple items. You can then just loop through the results and look at the packageid of each item.