vpcvishnu

Bro you have to include the below provided code at the top of your hook file use WHMCS\Database\Capsule; The full code block for the hook will be, <?php use WHMCS\Database\Capsule; add_hook('ShoppingCartCheckoutCompletePage', 1, function($vars) { $ordernumber = $vars['ordernumber']; $orderid = $vars['orderid']; $invoiceid = $vars['invoiceid']; $productid = Capsule::table('tblinvoiceitems') ->join('tblhosting', 'tblinvoiceitems.relid', '=', 'tblhosting.id') ->where('tblinvoiceitems.invoiceid','=', $invoiceid) ->where('tblinvoiceitems.type', '=', 'Hosting') ->select('tblhosting.packageid') ->get(); return $productid; }); And you can get the productid in the tpl using json_decode. An example is provided below {foreach $addons_html as $addon_html} <div class="order-confirmation-addon-output"> {$array = json_decode($addon_html,1)} {foreach $array as $key=>$item} {if $key == 0} <p>{$item['packageid']}</p> {/if} {/foreach} </div> {/foreach}

I am also having the same issue. double confirmed the installation files. But still getting the error. /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php(805): ReflectionClass->__construct() #1 /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php(687): Illuminate\Container\Container->build() #2 /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php(633): Illuminate\Container\Container->resolve() #3 /www/wwwroot/*****.cloud/vendor/illuminate/support/Facades/Facade.php(261): Illuminate\Container\Container->make() #4 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/User/User.php(0): Illuminate\Support\Facades\Facade::__callStatic() #5 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/Authentication/AuthManager.php(0): WHMCS\User\User->runPostLoginEvents() #6 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/Authentication/AuthManager.php(0): WHMCS\Authentication\AuthManager->login() #7 /www/wwwroot/*****.cloud/vendor/illuminate/support/Facades/Facade.php(261): WHMCS\Authentication\AuthManager->user() #8 /www/wwwroot/*****.cloud/includes/functions.php(0): Illuminate\Support\Facades\Facade::__callStatic() #9 /www/wwwroot/*****.cloud/install/install.php(0): logActivity() #10 {main} Next Illuminate\Contracts\Container\BindingResolutionException: Target class [remoteAuth] does not exist. in /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php:807 Stack trace: #0 /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php(687): Illuminate\Container\Container->build() #1 /www/wwwroot/*****.cloud/vendor/illuminate/container/Container.php(633): Illuminate\Container\Container->resolve() #2 /www/wwwroot/*****.cloud/vendor/illuminate/support/Facades/Facade.php(261): Illuminate\Container\Container->make() #3 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/User/User.php(0): Illuminate\Support\Facades\Facade::__callStatic() #4 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/Authentication/AuthManager.php(0): WHMCS\User\User->runPostLoginEvents() #5 /www/wwwroot/*****.cloud/vendor/whmcs/whmcs-foundation/lib/Authentication/AuthManager.php(0): WHMCS\Authentication\AuthManager->login() #6 /www/wwwroot/*****.cloud/vendor/illuminate/support/Facades/Facade.php(261): WHMCS\Authentication\AuthManager->user() #7 /www/wwwroot/*****.cloud/includes/functions.php(0): Illuminate\Support\Facades\Facade::__callStatic() #8 /www/wwwroot/*****.cloud/install/install.php(0): logActivity() #9 {main} [] There are no entries in the tblupdatelog table as well