hpk

Hello, I am trying to use new whmcs sql helper functions listed here: http://docs.whmcs.com/SQL_Helper_Functions However including the following directly in page: <?php require_once('/home/acct/public_html/whmcs/vendor/autoload.php'); use Illuminate\Database\Capsule\Manager as Capsule; // Print all client first names using a simple select. /** @var stdClass $client */ foreach (Capsule::table('tblclients')->get() as $client) { echo $client->firstname . PHP_EOL; } // Rename all clients named "John Deo" to "John Doe" using an update statement. try { $updatedUserCount = Capsule::table('tblclients') ->where('firstname', 'John') ->where('lastname', 'Deo') ->update( [ 'lastname' => 'Doe', ] ); echo "Fixed {$updatedUserCount} misspelled last names."; } catch (\Exception $e) { echo "I couldn't update client names. {$e->getMessage()}"; } results in error: Call to a member function connection() on a non-object in /home/acct/public_html/whmcs/vendor/illuminate/database/Illuminate/Database/Capsule/Manager.php on line 110 Any help? Thanks a lot!

Hi all, While using the domain search in whmcs, the .org domain always results in 'Domain already taken' even if the domain is not registered. Upon contacting the whmcs support, they replied that it is caused by whois lookup limit being reached and that I need to contact the whois service providers. Actual error is: WHOIS LIMIT EXCEEDED - SEE http://WWW.PIR.ORG/WHOIS FOR DETAILS Upon contacting the whois service provider, they asked to signup for their zone file access agreement. Their response was not clear so I contacted them again and am waiting on their reply. Has anyone else faced the same issue previously? Thanks for all your inputs. Regards, Israr

Hello again, Does anyone know how to change the menu items in the V6 templates? I need to include some custom menu items and change link for the 'Home' page. However I am unable to find any setting within whmcs or in the template file itself. Please guide. Regards, Israr

Hello all, I am unable to locate the clients credit balance in the client area for the six template. Can someone guide me or if confirm if the balance is even included? Regards, Israr

Hello, I am facing an issue with attached images to the client tickets. When the ticket is opened in whmcs admin portal and we click on the attached image the image is downloaded, however when image is opened in any image viewer it gives error 'no preview is available'. Also the size of that downloaded image will be 0Kb. Kindly help!

Hello, I was wondering if it is possible to use extensionless urls (i.e. without the .php at end) with whmcs. And also if it is possible will it cause any problems with how scripts works e.g. break some functionality etc? I need this because we host an asp.net reselling site and it does not look professional to manage billing with a php based script while you are selling asp.net products. And unfortunately there is no good billing management system like whmcs in asp.net.

Hello all! Actually I am trying to integrate alertpay with my whmcs, however the currency that I have selected (the one that shows in account summary is PKR only - Pakistani Rupees). So the customer sees all the invoices etc in PKR. However when he clicks on the checkout for alertpay payments, the alertpay gives error. As according to alertpay they do not support PKR currency. So I was wondering if there is someway I can still display the currency in PKR however when checkout is clicked, the system automatically detect the equivalent USD price and send it to alertpay API. Thanks in advance.