Jump to content


Regular Collector
  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About leeyondking

  • Rank
    Junior Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. leeyondking

    MySQL Workbench remote database

    I don't have much of saying, but it was due to port 3306 not enabled for public remote access. Have it turned on and now it is accessible.
  2. Hello, I have a question on how to connect to hosted website whmcs database on my local pc, I am using MySQL Workbench, MySQL Query Browser to connect to cPanel database. Usually for a normal website database I am able to connect peacefully, but for whmcs it's on the other way round. For WHMCS, I filled in the hostname based on ip, username, password, and database name correctly but still doesn't let me. Is there a specific encryption or accessibility to grant user to connect whmcs database? Thank you!
  3. Very true! I will take note on this 🤣 The text "Dedicated IP:" floating around with no value in web hosting.
  4. Thanks for the courage trying the others ! I've intentionally use others as well Hook : ICPE, InvoiceCreation, and InvoiceCreated. [I get the idea of them are being triggered by cron] These InvoiceCreation and InvoiceCreated are for having for when a cron generate and update the description having an IP for next coming invoice [Renewal]. *will remove one of them They're working.. Both having the same codes and appended an dedicated IP onto invoices description in WHMCS. [Results : two IPs appended in description] Here's the code : However, when it comes to an Invoice of two/multiple items, the dedicated IP of item 1 will be shown on item 2's description as well. Basically there's involve loop of array here and my variable $relidno doesn't get to fetch the next one. So I comes up with a another code with a loop structure fetching for next relid. The no ip shown hmmmm interesting in this case.
  5. Sorry for dumb question. Is InvoiceCreationPreEmail not related to viewinvoice.tpl ? Such that viewinvoice.tpl carry a array variable $invoiceitems... https://developers.whmcs.com/hooks-reference/invoices-and-quotes/#invoicecreationpreemail I am not sure where I can debug for InvoiceCreationPreEmail
  6. I've finally adapted laravel db query syntax other than standard sql. 😁 I get to update the tblinvoiceitems->description However, in this case. It just a normal viewinvoice event hook. I might change to InvoiceCreationPreEmail as youve mentioned. Here's my code unoptimized version : 1. Beforehand, pls create new db table, tblflagPaid (id (Primary Key Auto Increment) , relid (int), status (varchar) ) tblflagPaid consist of column named 'relid' where in tblhosting is named (id) and tblinvoiceitems is named (relid). [ id in tblhosting == relid ] For status, it's up to you for what datatype to be kept. In my case I just leave it varchar holds an empty value. Hope someone can optimized it
  7. May I assume that this can be done using the following hook as in https://docs.whmcs.com/Billing_Logic#Renewal_Invoices ? I am confused for which add_hook type for this purpose. Plus that I am not sure which www.yourdomain.com/system/templatefile.tpl I can debug with to verify. Could it still be viewinvoice.tpl ? Thanks ❤️
  8. So far I've hooked dedicated ip from tblhosting to viewinvoice.tpl and is assigned to paid services accordingly. What I'm trying to figure out : -> To show dedicated ip assigned in WHMCS Billing for -> Where you can view dedicated ip in the description as well. ( To help our billing member search for dedicated ip to be cancelled at ease by looking at customer's invoice items in WHMCS->Billing) For example : What is in my mind : How do I query the database tblhosting [dedicatedip] into WHMC->Billing->Invoices->Any customer's Invoice id description as shown above ? As far as I know, WHMCS admin .php file is encoded where we do not able to edit. Hopefully and I believe there is a way to append to show the dedicated ip !
  9. Welcome to WHMCS.Community leeyondking! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.


Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated