I need to show a page with content for registered customers with active subscription only!

[clasil]

HI guys,

 

I need to show a custom page with content for our registered customers with active subscription only!

 

in this page we show coupon code from our partners so our customer get the benefit from it.

 

how can accomplish this custom page...?

 

Thanks for you help

CS

[Kian]

First of all create a page and make a query in your database (or an action hook) to verify that the current client has an active subscription. If he has one show him your content otherwise a big error message or something similar.

[sentq]

use this documentation to create your page, now you need to limit access to this page for clients with active product/services only, we will query database to check if current logged-in client has active services, here is the query we need to run

 

SELECT COUNT(`id`) FROM `tblhosting` WHERE `userid`= $_SESSION['uid'] AND `domainstatus` = "Active"

 

now based on this SQL result we allow client to see content of this page, display error message or redirect him to another page.