Help with page display based on DB query

[MTKBillH]

I would like to set up video tutorial pages for my clients.

 

I would like the coding needed to control access to these pages.

 

Essentially:

IF the user is logged in && the user has purchased the product => Display Page

ELSE Display the product sales page that is visible to the public

 

I would like to do all of this on public facing page templates, however if it an only be accomplished using client area page templates, that would be ok as well.

 

This is what I have been told needs to be done to make this happen:

 

1. Create a product for non-hosting clients and let them buy it. Now query your database joining tblclients, tblhosting and tblpackages tables so that you are able to tell for all logged clients if they have right to view your custom page with training videos or not.
   
2. Yes, simply have your custom WHMCS page check for an Active tblhosting record of packageid IN (list)
   
3. 
   

 

I am ok with basic pages, however, what they mention is currently beyond my abilities.

 

I am willing to pay for:

1. the code that I would need to add to the video pages to control access
   
2. Instructions on where on a page to insert the code on the video pages as I set them up.
   
3. 
   

 

Thanks in advance,

 

Bill.. .. .

[sentq]

You may contact us here for Quote and ETA