Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. 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.
  3. Today
  4. Welcome to WHMCS.Community wish! 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.

  5. Kian

    invoices.php tpl admin file

    You need to use something that looks very similar to the code I posted here months ago: You have to change the query to retreive datepaid like follows: <?php $Data = Capsule::select(Capsule::raw('SELECT id, datepaid FROM tblinvoices')); $Data = json_encode($Data, true); Replace "Last Caputure Attempt" th with "Date Paid" then iterate each row to replace all your "N/A" with date paid. You can use this HTML as target. <td> <input type="checkbox" name="selectedinvoices[]" value="{USE_ME}" class="checkall"> </td> It's easy but sadly there's a big problem. Invoices page shows 25 to 250 records per page and selecting all records you have in tblinvoices makes no sense. What if you have 50k invoices stored on that table? It's clear that you need to select only the records you're actually seeing on screen. Basically you have to retreive all filters in use on the page (userid, invoicenum, invoicedate, duedate, datepaid...), sort order (ASC, DESC), current page number and of course calculate the right LIMIT to use. It's so damn frustrating and boring that I suggest you to stop working on it. If you need a proof just look at this code... <?php $filters = array_filter(json_decode(base64_decode(urldecode($_COOKIE['WHMCSFD'])), true)['invoices']); That's how you retrieve filters currently in use. Can you imagine the rest? ☠️
  6. Hello, Basically that's me. WHMCS is okay but be careful with Licensing Addon if you plan to use it. It took me years to fix all flaws it has. I also know a fair amount of companies that are using WHMCS for things not related to hosting like for example consulting, support, a couple of SaaS, license selling, dropshipping, marketing and a radio station.
  7. steph.hope

    Disable Automatic CC Processing based on product

    Sorry for resurrecting an old thread, but I'm in a similar situation at present. We have clients who want to be automatically charged for their recurring costs such as hosting, but we don't want to charge automatically when they have larger invoices such as for website development. If we used a cron or invoicecreation hook to turn off the client's auto-cc-processing when the invoice exceeds a certain amount, then turned it back on later so that the smaller invoices would be captured, would WHMCS then try to capture the large invoice (which we don't want)?
  8. Add an option to see the original mail from the client (with the original HTML formatting etc.) https://requests.whmcs.com/topic/add-an-option-to-see-the-original-mail-from-the-client-with-the-original-html-formatting-etc Give your vote to increase chances WHMCS take a look at this. 👍
  9. Yesterday
  10. Hello everyone, I'm considering using WHMCS for my business' online billing and self service account management and was wondering if anyone else was doing that too. We sell software as a subscription service, hardware to accompany it, and also consulting, training, and installation. Basically we have several different subscription services, with options having different billing rates based on user counts and hardware counts, along with one time invoices... All comments appreciated! Best, John
  11. Hi Guys, i'm wondering, if there is anywhere to purchase pre-made cPanel video tutorials?
  12. twhiting9275

    Client Account Login Notification Hook

    changing $results = localAPI($command, $values, $adminuser); to $results = localAPI($command, $values); will do the trick too. I mean, that's the easiest hack to do it. No longer need that adminuser for localAPI
  13. Welcome to WHMCS.Community ccengine! 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.

  14. Hello, I have a problem with whmcs invoices. First, I had these errors: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous in /var/www/clients/vendor/illuminate/database/Connection.php:333 Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from tblinvoices inner join tblinvoiceitems on tblinvoiceitems.invoiceid = tblinvoices.id left join tblaccounts on tblaccounts.invoiceid = tblinvoices.id where tblinvoices.userid = 1 and status = Unpaid and type != Invoice group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713 Then I was advised to do, which now gives these errors: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' in /var/www/clients/vendor/illuminate/database/Connection.php:333 Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from tblinvoices left join tblaccounts on tblaccounts.invoiceid = tblinvoices.id where tblinvoices.userid = 1 and status = Unpaid and 1 = 1 group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713 Does anyone have a solution? Regards.
  15. Getting the feeling I'm the only one seeing my posts here. 😉
  16. Welcome to WHMCS.Community amirveisi! 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.

  17. HardSoftCode

    FREE ADDON: WHMCS Maintenance Mode Plus

    Thank you brian! We have enabled the free modules and they are available on WHMCS Marketplace and our website https://marketplace.whmcs.com/user/HardSoftCode/products https://www.hardsoftcode.com/products.php
  18. HardSoftCode

    FREE ADDON: WHMCS Maintenance Mode Plus

    Hi guys Yes the module was free in 2012 and we decided in 2014 to rewrite the code from scratch and change it from free to commercial
  19. dajobeuz101

    Hey Folks! I'm Daniel

    Hey folks, Daniel Here, i'm a sysadmin starting his career, nice to meet you all of you!!!
  20. TerraUtopia

    Hello from Canada

    Looking forward to taking part in the community and learning the best way to make use of WHMCS. Stay healthy!
  21. I am new to the forums and not sure if this is the correct place to ask my question, but here goes: I am using the WHMCS module provided by NameSilo and I am having issues when registering .ca names. Whenever a client does so, it takes the default profile information in my NameSilo account instead of the one provided by the person registering it. I have a ticket open with NameSilo, but they are not very quick to respond. I have heard they have the same issue with .us domains. So, my question is: Is there an add-on module you have used with NameSilo to register ,ca domains that works properly? Or, have you got the one provided by NameSilo to work? Thanks!
  22. Hi there, i had some issues that will arise now, i have my client portal in the same whm, in other words my client portal is also a client. I would like to know what's your best advice for it. Thanks in advance!
  23. Anyone have an idea to integration contract signature? Need to autofill fields. Electronic signature platform eversign.com or docusign.com
  24. Welcome to WHMCS.Community TerraUtopia! 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.

  25. Welcome to WHMCS.Community dajobeuz101! 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.

  26. In 2012, when this was posted, it was free. Just shy of 8 years later, it isn't. 😉
  27. apoxe

    invoices.php tpl admin file

    thanks, maybe you have a jquery hook with another function so i can check how it works?
  1. Load more activity
×

Important Information

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