How to display Dedicated IP in viewinvoice.tpl and invoicepdf.tpl

[JacksonT]

How to display Dedicated IP in viewinvoice.tpl and invoicepdf.tpf?

I try to use {php}{/php} to query out the product details but it doesn't work anymore.

Please help.

[AffordableDomainsCanada]

$dedicatedip will work on the Client Area >> Product Details page, but will NOT work with the invoice.tpl and invoicepdf.tpl

 

Im guessing that you will need to have a custom hook created for this to work

[brian!]

How to display Dedicated IP in viewinvoice.tpl and invoicepdf.tpf?

I try to use {php}{/php} to query out the product details but it doesn't work anymore.

i'm surprised {php} didn't work in the viewinvoice.tpl template - you'd need to enable the feature in general settings, but it should work... having said that, you shouldn't really be using {php} in templates nowadays.

 

Im guessing that you will need to have a custom hook created for this to work

only for viewinvoice.tpl, and as invoicepdf.tpl is basically a PHP file anyway and can't use hooks, you can add sql queries directly to the code.

 

for viewinvoice, they'd be a number of ways to do a hook... you could query tblinvoiceitems and join on tblhosting (which is the table that stores the dedicated IP value for that product), or as the template already knows the relid values, you could create an array of dedicatedIP values for that specific invoice and then query that in the template output.

 

for the pdf invoice, it's should be slightly easier as one option would be to query the database for the specific dedicatedIP value in the foreach loop.