TimRef

@brian! @Kian Hi, sir , Can I ask you a question here ? I hope to list the dedicated or domain in the admin invoices.php list .could you please let me know whether AdminAreaHeaderOutput can be used for this . like this , Thanks in advanced. thanks .

Done . we tried another way to pay . when this case is solved . will buy more . anyway , thanks a lot . I will try to fix this take some time . Also hope can get your help . @pRieStaKos

BTW, when I try to buy coffee , show me Failed to verify captcha. do you have any other way to do this ? like paypal

if one invoice have more than 1 products , we can only use the top one of it . but currently , only 1 product invoice , also not showing the ip. I am thinking maybe the pass or connection of field not correct ? Thanks for your time in advance

tried this ,all invoice dedicated ip shown '-' , see the photo , sometimes one invoice have more than 1 server or hosting . maybe we should add a judge ? but , only one in the invoice , also not shown .only can see '- ' is the ‘ClientAreaPageInvoices’ we used right ? seems didnt get the dedicated ip to pass .

thanks , I will try , and update you soon , also , i tried reset password via cubric, didnt get anything, thanks anyway

sorry, but i didnt get any email , ang also dont know the ticket link

Thanks a lot , I have sent the mail .

Hi, @pRieStaKos , thanks for your help . Do you offer this type of compensable service to get this done ? I have tried long time , I really have no ability to resolve this . Do you have a email to talk ?

hi, @pRieStaKoscan we use this way to connect with the database tables? select * from tblinvoices t1 left join tblinvoiceitems t2 on t1.id=t2.invoiceid left join tblhosting t3 on t2.relid=t3.id WHERE t3.dedicatedIP = value then we use dedicated IP . if get this to Hook , do you have any idea . can we use this type : <?php if (!defined("WHMCS")) { die("This file cannot be accessed directly"); } use WHMCS\Database\Capsule as DB; add_hook('ClientAreaPageInvoices', 1, function($vars) { if (isset($vars['invoices'])) { $csVals = []; foreach ($vars['invoices'] as $invoices) { $fieldVal = ''; $data = DB::table('tblinvoices AS t1') ->leftJoin('tblinvoiceitems AS t2', 't1.id', '=', 't2.invoiceid') ->leftJoin('tblhosting AS t3', 't2.relid', '=', 't3.id') ->select('t3.dedicatedip') ->where('t1.id', $fieldId)->where('t2.type', 'hosting')->where('t3.domain', $invoices['id']) ->first(); if (!is_null($data)) { $fieldVal = $data->value; } $csVals[$invoice['id']] = $fieldVal; } return ['dedicatedip' => $csVals]; } }); //and add {$dedicatedip} to .tpl page / I'm not good at this , sorry to take you any inconveniences.

maybe I also need add a Hook file to connect the invoice and services table , or else maybe cannot resolve this case .

how can we use two tablename in the .tpl file ? {include file="$template/includes/tablelist.tpl" tableName="InvoicesList" filterColumn="4"} like {include file="$template/includes/tablelist.tpl" tableName="InvoicesList" filterColumn="4"} {include file="$template/includes/tablelist.tpl" tableName="ServicesList" filterColumn="4"}

maybe clientareaproducts.tpl can be a reference . but can we use 2 tablelist in one .tpl file ? {include file="$template/includes/tablelist.tpl" tableName="ServicesList" filterColumn="4" noSortColumns="0"} <script type="text/javascript"> jQuery(document).ready( function () { var table = jQuery('#tableServicesList').removeClass('hidden').DataTable(); {if $orderby == 'product'} table.order([1, '{$sort}'], [4, 'asc']); {elseif $orderby == 'amount' || $orderby == 'billingcycle'} table.order(2, '{$sort}'); {elseif $orderby == 'nextduedate'} table.order(3, '{$sort}'); {elseif $orderby == 'domainstatus'} table.order(4, '{$sort}'); {/if} table.draw(); jQuery('#tableLoading').addClass('hidden'); }); </script> <div class="table-container clearfix"> <table id="tableServicesList" class="table table-list hidden"> <thead> <tr> <th></th> <th>{$LANG.orderproduct}</th> <th>{$LANG.clientareaaddonpricing}</th> <th>{$LANG.clientareahostingnextduedate}</th> <th>{$LANG.clientareastatus}</th> <th class="responsive-edit-button" style="display: none;"></th> </tr> </thead> <tbody> {foreach key=num item=service from=$services} <tr onclick="clickableSafeRedirect(event, 'clientarea.php?action=productdetails&amp;id={$service.id}', false)"> <td class="text-center{if $service.sslStatus} ssl-info{/if}" data-element-id="{$service.id}" data-type="service"{if $service.domain} data-domain="{$service.domain}"{/if}> {if $service.sslStatus} <img src="{$service.sslStatus->getImagePath()}" data-toggle="tooltip" title="{$service.sslStatus->getTooltipContent()}" class="{$service.sslStatus->getClass()}"/> {elseif !$service.isActive} <img src="{$BASE_PATH_IMG}/ssl/ssl-inactive-domain.png" data-toggle="tooltip" title="{lang key='sslState.sslInactiveService'}"> {/if} </td> <td><strong>{$service.product}</strong>{if $service.domain}<br /><a href="http://{$service.domain}" target="_blank">{$service.domain}</a>{/if}</td> <td class="text-center" data-order="{$service.amountnum}">{$service.amount}<br />{$service.billingcycle}</td> <td class="text-center"><span class="hidden">{$service.normalisedNextDueDate}</span>{$service.nextduedate}</td> <td class="text-center"><span class="label status status-{$service.status|strtolower}">{$service.statustext}</span></td> <td class="responsive-edit-button" style="display: none;"> <a href="clientarea.php?action=productdetails&amp;id={$service.id}" class="btn btn-block btn-info"> {$LANG.manageproduct} </a> </td> </tr> {/foreach} </tbody> </table> <div class="text-center" id="tableLoading"> <p><i class="fas fa-spinner fa-spin"></i> {$LANG.loading}</p> </div> </div>

Hi, @pRieStaKos sorry for another question , the clientareainvoices.tpl file use the mysql table ‘tblinvoices’ ， and in that table have no 'hostname' or 'dedicted IP' . As I know whmcs should use 'userid' Column to connect the table 'tblinvoices' and 'tblhosting' , so in this way we can try to connect with them , and get the specified tblinvoices . invoicenum.userid ------ > tblhosting.userid.dedicatedip or domain . I don't know whether this is right . And how to connect with them in the clientareainvoices.tpl page, or have they already connected by default? Relly appreciate for your help .

OK , thanks @pRiestaKos . will try and update . so happy to get reply .