"Unauthorized Access Attempt" on Products Details

[kasimme]

Hello,

 

I wanted to get the Active "Products and Services" in the "home (main page of WHMCS)", So i copied the clientareaproducts.tpl to clientareahome.tpl with the following PHP code on the head :-

{php}
$userid = $this->_tpl_vars['clientsdetails']['id'];
$result = mysql_query("SELECT * FROM tblhosting,tblproducts WHERE userid =$userid AND tblhosting.packageid= tblproducts.id");
$services = array();
while ($data = mysql_fetch_array($result)) {
array_push($services, $data);
}
$this->_tpl_vars['services'] = $services;
{/php}

 

Now, I am able to get the data on the "home" but when i click on the "View Details" which redirects to /clientarea.php?action=productdetails give me an "Unauthorized Access Attempt" , I think i have missed something in the PHP? I dont understand it.

 

Please give me patch for this issue.

It will be really helpful for me.

 

Thanks a lot

 

Kind Regards