Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. All the very best Hardik Joshi for your new website. Wishing you best luck!
  3. apoxe

    invoices.php tpl admin file

    thanks for your help i appreciate, i will not spend more time on this. maybe can you help me with this old post
  4. Today
  5. hello friends, after your all support & learning whmcs we finally launched our new Web Hosting website https://www.hostweby.com in this website we are using HTML (Customized Design) & Worlds Best Billing Software WHMCS Now i need your all Suggestions & reviews Specially Thanks to @brian! @WHMCS ChrisD @WGS Best Regards, Hardik Joshi
  6. hardikjoshi

    Client Account Login Notification Hook

    hey bro is it possible to saw internet provider name in hostname https://prnt.sc/rqkolg
  7. hardikjoshi

    Client Account Login Notification Hook

    yes brother it's also working well
  8. hardikjoshi

    Client Account Login Notification Hook

    thanks you bro it's working fine
  9. Thanks for this code, @Kian! It's been super helpful to me both to use in this form and to see how jquery hooks work.
  10. 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.
  11. 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.

  12. 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? ☠️
  13. 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.
  14. 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)?
  15. 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. 👍
  16. Yesterday
  17. 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
  18. Hi Guys, i'm wondering, if there is anywhere to purchase pre-made cPanel video tutorials?
  19. 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
  20. 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.

  21. 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.
  22. Getting the feeling I'm the only one seeing my posts here. 😉
  23. 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.

  24. 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
  25. 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
  26. dajobeuz101

    Hey Folks! I'm Daniel

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

    Hello from Canada

    Looking forward to taking part in the community and learning the best way to make use of WHMCS. Stay healthy!
  28. 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!
  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